Search Engine: Elastic

Article ID: 129964, created on Dec 6, 2016, last review on Apr 28, 2017

  • Applies to:
  • Odin Business Automation Standard 4.5

Symptoms

Renewal orders are not generated for SSL Certificate subscriptions. The following can be found in hspc.log with DEBUG log level during Recurring payment process along with Invoice and Statements creation procedure task execution:

[2016/11/29 01:45:07] [FATAL] [18733] [HSPC::Exc::Mysql::new] DBD::mysql::st execute failed: called with 2 bind variables when 0 are needed at /usr/local/share/perl5/HSPC/WebDB.pm line 238.
REPLACE INTO `ssl_certificate` (`software_type`,`csr_data`,`subscription_id`,`date_ordered`,`account_id`,`csr`,`certificate_body`,`domain`,`ext_attr`,`date_expired`,`vendor_id`,`approver_email`,`server_count`,`date_issued`,`status`,`private
_key`,`plugin`,`product`) VALUES ('24','^D^G^D1234^D^D^D^H^C^H^@^@^@

^BAU^G^@^@^@country

^@^E^@^@^@state

^ESales^X^@^@^@organizational_unit_name

^Wsales@domain.tld^E^@^@^@email

^HCity^D^@^@^@city

^Uwww.domain.tld^K^@^@^@common_name

^OAdd-On-Earrings^Q^@^@^@organization_name

^D2048^D^@^@^@bits','25835','2016-11-28 14:45:07','1496',?,'','www.domain.tld','BQcDAAAAAhcGNjA2ODA3AAAAB2NlcnRfaWQIgAAAAA1za2lwX3B1cmNoYXNl','0000-00-00 00:00:00','1','admin@domain.tld',NULL,'0000-00-00 00:00:00','ordered',?,
'17','rapidssl')

[2016/11/29 01:45:08] [DEBUG] [18733] [HSPC::Transaction::__logstr] TRANSACTION #1256 [03] autorollback Abstract->save (See /var/log/hspc/rep2016-11-29_01-45-07 for details)

Another symptom of the issue is that SSL certificate subscriptions with passed End date value remain in Active state. The following can be found in hspc.log with DEBUG log level during Subscription expiration procedure task execution:

[2016/11/29 04:29:54] [WARN] [26109] [HSPC::MT::BM::SubscrExpiration::process_subscr_expiration] subscr_expired: can't change status for subscription 25835: No renewal order found, not grace
[2016/11/29 04:29:54] [DEBUG] [26109] [HSPC::MT::BM::SubscrExpiration::process_subscr_expiration] TRACE [04]: . . . -> subscr_expired: switch to grace subscr 25835, end_date=>2016-11-20 12:00:00 =>  failed: No renewal order found, not grace

Cause

Unsafe format of CSR and extended attributes data of certificates initially purchased before OBAS 4.5.2 release.

Such behavior was classified as software issue PBAS-30607 and will be fixed in future OBAS releases.

Please consider watching Odin public sources for information about updates in our products:

Marketing news and important announces

Knowledge base, each product update comes with a corresponding KB article.

Resolution

Please contact Odin Technical Support for assistance.

See also

Renewal order not generated for an SSL certificate

624ca542e40215e6f1d39170d8e7ec75 caea8340e2d186a540518d08602aa065 400e18f6ede9f8be5575a475d2d6b0a6 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF