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

  • 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.

Resolution

Please contact Odin Technical Support for assistance.

See also

Renewal order not generated for an SSL certificate

Search Words

SSL subscription not terminating/expiring

ssl subscription not expiring

called with 2 bind variables when 0 are needed at /usr/local/share/perl5/HSPC/WebDB.pm

624ca542e40215e6f1d39170d8e7ec75 caea8340e2d186a540518d08602aa065 400e18f6ede9f8be5575a475d2d6b0a6 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF