[Openca-Users] CRR import failed

alexandru matei Wed, 04 Sep 2002 02:42:35 -0700

Hi, I use a version from development (between 0.8 and 0.9, mostly
0.9)with mysql as the database. When I do the import CRR (approved with
pkcs#7 signature) with debug switched on I get the attached messages.
Also, I notice that it seems to get import correctely but  there is no
CRR in the CRR table after that. Moreover, If I look with an editor in
the database file crr.db there are some strings as they belong to the
CRRs. Can somebody help???
Alex

Title: Requests Exporting Page

Importing all requests from RAServer ...
(Please wait until operation completes)

Importing approved crr ...### new function call ###
Entering function searchItems
### new function call ###
Entering getArguments
OpenCA::DBI->getArguments: TABLE:CRR
OpenCA::DBI->getArguments: MODE:
OpenCA::DBI->getArguments: attribute: KEY
OpenCA::DBI->getArguments: value: 1
OpenCA::DBI->getArguments: attribute: STATUS
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: REVOKE_CERTIFICATE_SERIAL
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: REVOKE_CERTIFICATE_DN
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: CN
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: EMAIL
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: RA
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: OPERATOR
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: SUBMIT_DATE
OpenCA::DBI->getArguments: value:
### new function call ###
Entering getStatus
no status given using datatype: PENDING_CRR
given mode is now: "PENDING"
legal status
### leaving function successful ###
OpenCA::DBI->getArguments: status: PENDING
completed successful
### leaving function getArguments ###
dbi-status:PENDING
query now:select * from crr
scan attribute: KEY
attribute's content: 1
scan attribute: STATUS
attribute's content: PENDING
scan attribute: REVOKE_CERTIFICATE_SERIAL
scan attribute: REVOKE_CERTIFICATE_DN
scan attribute: CN
scan attribute: EMAIL
scan attribute: RA
scan attribute: OPERATOR
scan attribute: SUBMIT_DATE
query:select * from crr where (crr_key=?) and (status like ?) order by crr_key
### new function call ###
Entering sub doQuery
query: select * from crr where (crr_key=?) and (status like ?) order by crr_key
bind_values: 1
bind_values: PENDING
prepare statement
statement nr.: 1
execute statement
execute succeeded
### leaving function doQuery successfully ###
state(false is OK):
rows (this is buggy in DBD::DB2 and DBD::Oracle)): 0
function searchItems completed successful
### leaving function searchItems ###
### new function call ###
Entering function storeItem
### new function call ###
Entering storeItem_getArguments
storeItem_getArguments: no direct insert into log
storeItem_getArguments: table: CRR
storeItem_getArguments: attribute: KEY
storeItem_getArguments: value:
storeItem_getArguments: attribute: STATUS
storeItem_getArguments: value:
storeItem_getArguments: attribute: REVOKE_CERTIFICATE_SERIAL
storeItem_getArguments: value: 9
storeItem_getArguments: attribute: REVOKE_CERTIFICATE_DN
storeItem_getArguments: value: SN=09, CN=spate exploderXXX, OU=Internet, O=qbit, C=RO
storeItem_getArguments: attribute: CN
storeItem_getArguments: value:
storeItem_getArguments: attribute: EMAIL
storeItem_getArguments: value:
storeItem_getArguments: attribute: RA
storeItem_getArguments: value:
storeItem_getArguments: attribute: OPERATOR
storeItem_getArguments: value:
storeItem_getArguments: attribute: SUBMIT_DATE
storeItem_getArguments: value: Tue Sep 3 11:47:53 2002 GMT
### new function call ###
Entering getStatus
no status given using datatype: APPROVED_CRR
given mode is now: "APPROVED"
legal status
### leaving function successful ###
storeItem_getArguments: status: APPROVED
storeItem_getArguments: inform: PEM
storeItem_getArguments: KEY:1
storeItem_getArguments: format: CRR with PKCS#7 Signature
storeItem_getArguments: converted: -----BEGIN HEADER----- TYPE = CRR SERIAL = 1 SSL_CERT_SERIAL = 04 SSL_CERT_DN = SN=04, CN=spate iexplorer, OU=Internet, O=qbit, C=RO SSL_CERT_ISSUER = [EMAIL PROTECTED], CN=qbit CA, OU=pki, O=qbit, C=RO -----END HEADER----- SUBMIT_DATE = Tue Sep 3 11:47:53 2002 GMT APPROVED_DATE = Tue Sep 3 11:49:24 2002 GMT CRIN = e17b81b285cf9043f2bcd290cecb3811335882fe REVOKE_REASON = REVOKE_CERTIFICATE_DN = SN=09, CN=spate exploderXXX, OU=Internet, O=qbit, C=RO REVOKE_CERTIFICATE_NOTBEFORE = Sep 3 02:56:27 2002 GMT REVOKE_CERTIFICATE_NOTAFTER = Nov 22 02:56:27 2002 GMT REVOKE_CERTIFICATE_SERIAL = 9 REVOKE_CERTIFICATE_ISSUER_DN = [EMAIL PROTECTED], CN=qbit CA, OU=pki, O=qbit, C=RO REVOKE_CERTIFICATE_KEY_DIGEST = 2a633775ce5e0af82889faeba699c6ef -----BEGIN PKCS7----- MIIGdQYJKoZIhvcNAQcCoIIGZjCCBmICAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3 DQEHAaCCBIcwggSDMIIDa6ADAgECAgEBMA0GCSqGSIb3DQEBBQUAMFcxGTAXBgkq hkiG9w0BCQEWCnJhb3BAcWIucm8xEDAOBgNVBAMTB3FiaXQgQ0ExDDAKBgNVBAsT A3BraTENMAsGA1UEChMEcWJpdDELMAkGA1UEBhMCUk8wHhcNMDIwODMwMDczNTQx WhcNMDIxMTE4MDczNTQxWjBTMQswCQYDVQQFEwIwMTESMBAGA1UEAxMJcWJpdCB0 ZWFtMRQwEgYDVQQLEwtUcnVzdGNlbnRlcjENMAsGA1UEChMEcWJpdDELMAkGA1UE BhMCUk8wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBANRH0s7taTQdln3FZov0 zPBgNASxtssbER+coIW1QiS5AD7+KL0jHhQGVvK9+1LGxRCnyrZgxDqnGkEq+A04 6c7qhiqk+eVy7X3sAxgPfE9ea6QToRDFf8aCRB/QKUHeSkc8MiqciTYX9BKsBTFH oVLKvMaJNf6oaKQk5tQqhHcBAgMBAAGjggHgMIIB3DAJBgNVHRMEAjAAMBEGCWCG SAGG+EIBAQQEAwIEsDALBgNVHQ8EBAMCBeAwNgYJYIZIAYb4QgENBCkWJ1JlZ2lz dHJhdGlvbiBBdXRob3JpdHkgT3BlcmF0b3Igb2YgcWJpdDAdBgNVHQ4EFgQUhJqe Li/GMNvX+AxN+3A01qbW/iMwfwYDVR0jBHgwdoAUJw7kxlydl48hSxA+N+XFJeEN LBGhW6RZMFcxGTAXBgkqhkiG9w0BCQEWCnJhb3BAcWIucm8xEDAOBgNVBAMTB3Fi aXQgQ0ExDDAKBgNVBAsTA3BraTENMAsGA1UEChMEcWJpdDELMAkGA1UEBhMCUk+C AQAwFQYDVR0RBA4wDIEKcmFvcEBxYi5ybzAVBgNVHRIEDjAMgQpyYW9wQHFiLnJv MDkGCWCGSAGG+EIBBAQsFipodHRwczovL3B1Yi5yYS5xYi5yby9jZ2ktYmluL2Ny bC9jYWNybC5jcmwwOQYJYIZIAYb4QgEDBCwWKmh0dHBzOi8vcHViLnJhLnFiLnJv L2NnaS1iaW4vY3JsL2NhY3JsLmNybDAzBgNVHR8ELDAqMCigJqAkhiJodHRwczov L3B1Yi5yYS5xYi5yby9jcmwvY2FjcmwuY3JsMA0GCSqGSIb3DQEBBQUAA4IBAQCT vw52rEWn35yiUW6P27/yOISw5pYiryMZ0RzBwLSn88cjHso266NubtIoXPkyye9B ax64aWcykOGIi7189zY14FUFDelGgPEfkucpphsNm2zbnyVm5qvTniLZHan0aVUc LKzEcdeX1wqNvZxRNJlvFjMBSCorDPO2xDLgTk3UcwKu5ekp7soc/GyVPpX61hpn JT2r2/ONCLdsq4QOHRj334DoQWUrcP1Ox90cK4n4c9TDcO2e5S1RaNmx4NMIk0v6 6SnQh92X2ITBjQQ4ZQm+U+DH4Y0K7+I2JoEPiMF8N/3lgbW26lDJgV6mdAR8utkI nR0xGr6cxOpJAXWnFU20MYIBtjCCAbICAQEwXDBXMRkwFwYJKoZIhvcNAQkBFgpy YW9wQHFiLnJvMRAwDgYDVQQDEwdxYml0IENBMQwwCgYDVQQLEwNwa2kxDTALBgNV BAoTBHFiaXQxCzAJBgNVBAYTAlJPAgEBMAkGBSsOAwIaBQCggbEwGAYJKoZIhvcN AQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDIwOTAzMTE0OTU5WjAj BgkqhkiG9w0BCQQxFgQUekvSrsncvR2lAMXu8BtEOUvvYzowUgYJKoZIhvcNAQkP MUUwQzAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwBwYFKw4DAgcwDQYIKoZI hvcNAwICAUAwDQYIKoZIhvcNAwICASgwDQYJKoZIhvcNAQEBBQAEgYC/uXUlbskn QGwCFcwi0mu/K7SYWx9HfgFWPq4xVbUiBFqJvFJyiQNyMJSPVGB5XS0kA8POf9r5 jeNHWvbA4UrtjSLfgz2I1Lgs96EQ1sjoD/mtwVKKyFZ4wdyUKX3UdQFupl3EhUgP zX4sKjz+AvV6BCTmtkqxFDlNbl8kCr6ucQ== -----END PKCS7-----
storeItem_getArguments: object->getParsed hash:
storeItem_getArguments: object-attribute:ITEM
storeItem_getArguments: object-value:-----BEGIN HEADER----- TYPE = CRR SERIAL = 1 SSL_CERT_SERIAL = 04 SSL_CERT_DN = SN=04, CN=spate iexplorer, OU=Internet, O=qbit, C=RO SSL_CERT_ISSUER = [EMAIL PROTECTED], CN=qbit CA, OU=pki, O=qbit, C=RO -----END HEADER----- SUBMIT_DATE = Tue Sep 3 11:47:53 2002 GMT APPROVED_DATE = Tue Sep 3 11:49:24 2002 GMT CRIN = e17b81b285cf9043f2bcd290cecb3811335882fe REVOKE_REASON = REVOKE_CERTIFICATE_DN = SN=09, CN=spate exploderXXX, OU=Internet, O=qbit, C=RO REVOKE_CERTIFICATE_NOTBEFORE = Sep 3 02:56:27 2002 GMT REVOKE_CERTIFICATE_NOTAFTER = Nov 22 02:56:27 2002 GMT REVOKE_CERTIFICATE_SERIAL = 9 REVOKE_CERTIFICATE_ISSUER_DN = [EMAIL PROTECTED], CN=qbit CA, OU=pki, O=qbit, C=RO REVOKE_CERTIFICATE_KEY_DIGEST = 2a633775ce5e0af82889faeba699c6ef -----BEGIN PKCS7----- MIIGdQYJKoZIhvcNAQcCoIIGZjCCBmICAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3 DQEHAaCCBIcwggSDMIIDa6ADAgECAgEBMA0GCSqGSIb3DQEBBQUAMFcxGTAXBgkq hkiG9w0BCQEWCnJhb3BAcWIucm8xEDAOBgNVBAMTB3FiaXQgQ0ExDDAKBgNVBAsT A3BraTENMAsGA1UEChMEcWJpdDELMAkGA1UEBhMCUk8wHhcNMDIwODMwMDczNTQx WhcNMDIxMTE4MDczNTQxWjBTMQswCQYDVQQFEwIwMTESMBAGA1UEAxMJcWJpdCB0 ZWFtMRQwEgYDVQQLEwtUcnVzdGNlbnRlcjENMAsGA1UEChMEcWJpdDELMAkGA1UE BhMCUk8wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBANRH0s7taTQdln3FZov0 zPBgNASxtssbER+coIW1QiS5AD7+KL0jHhQGVvK9+1LGxRCnyrZgxDqnGkEq+A04 6c7qhiqk+eVy7X3sAxgPfE9ea6QToRDFf8aCRB/QKUHeSkc8MiqciTYX9BKsBTFH oVLKvMaJNf6oaKQk5tQqhHcBAgMBAAGjggHgMIIB3DAJBgNVHRMEAjAAMBEGCWCG SAGG+EIBAQQEAwIEsDALBgNVHQ8EBAMCBeAwNgYJYIZIAYb4QgENBCkWJ1JlZ2lz dHJhdGlvbiBBdXRob3JpdHkgT3BlcmF0b3Igb2YgcWJpdDAdBgNVHQ4EFgQUhJqe Li/GMNvX+AxN+3A01qbW/iMwfwYDVR0jBHgwdoAUJw7kxlydl48hSxA+N+XFJeEN LBGhW6RZMFcxGTAXBgkqhkiG9w0BCQEWCnJhb3BAcWIucm8xEDAOBgNVBAMTB3Fi aXQgQ0ExDDAKBgNVBAsTA3BraTENMAsGA1UEChMEcWJpdDELMAkGA1UEBhMCUk+C AQAwFQYDVR0RBA4wDIEKcmFvcEBxYi5ybzAVBgNVHRIEDjAMgQpyYW9wQHFiLnJv MDkGCWCGSAGG+EIBBAQsFipodHRwczovL3B1Yi5yYS5xYi5yby9jZ2ktYmluL2Ny bC9jYWNybC5jcmwwOQYJYIZIAYb4QgEDBCwWKmh0dHBzOi8vcHViLnJhLnFiLnJv L2NnaS1iaW4vY3JsL2NhY3JsLmNybDAzBgNVHR8ELDAqMCigJqAkhiJodHRwczov L3B1Yi5yYS5xYi5yby9jcmwvY2FjcmwuY3JsMA0GCSqGSIb3DQEBBQUAA4IBAQCT vw52rEWn35yiUW6P27/yOISw5pYiryMZ0RzBwLSn88cjHso266NubtIoXPkyye9B ax64aWcykOGIi7189zY14FUFDelGgPEfkucpphsNm2zbnyVm5qvTniLZHan0aVUc LKzEcdeX1wqNvZxRNJlvFjMBSCorDPO2xDLgTk3UcwKu5ekp7soc/GyVPpX61hpn JT2r2/ONCLdsq4QOHRj334DoQWUrcP1Ox90cK4n4c9TDcO2e5S1RaNmx4NMIk0v6 6SnQh92X2ITBjQQ4ZQm+U+DH4Y0K7+I2JoEPiMF8N/3lgbW26lDJgV6mdAR8utkI nR0xGr6cxOpJAXWnFU20MYIBtjCCAbICAQEwXDBXMRkwFwYJKoZIhvcNAQkBFgpy YW9wQHFiLnJvMRAwDgYDVQQDEwdxYml0IENBMQwwCgYDVQQLEwNwa2kxDTALBgNV BAoTBHFiaXQxCzAJBgNVBAYTAlJPAgEBMAkGBSsOAwIaBQCggbEwGAYJKoZIhvcN AQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDIwOTAzMTE0OTU5WjAj BgkqhkiG9w0BCQQxFgQUekvSrsncvR2lAMXu8BtEOUvvYzowUgYJKoZIhvcNAQkP MUUwQzAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwBwYFKw4DAgcwDQYIKoZI hvcNAwICAUAwDQYIKoZIhvcNAwICASgwDQYJKoZIhvcNAQEBBQAEgYC/uXUlbskn QGwCFcwi0mu/K7SYWx9HfgFWPq4xVbUiBFqJvFJyiQNyMJSPVGB5XS0kA8POf9r5 jeNHWvbA4UrtjSLfgz2I1Lgs96EQ1sjoD/mtwVKKyFZ4wdyUKX3UdQFupl3EhUgP zX4sKjz+AvV6BCTmtkqxFDlNbl8kCr6ucQ== -----END PKCS7-----
storeItem_getArguments: object-attribute:DNS
storeItem_getArguments: object-value:ARRAY(0x85b6c1c)
storeItem_getArguments: object-attribute:HEADER
storeItem_getArguments: object-value:HASH(0x85b6a90)
storeItem_getArguments: object-attribute:REVOKE_CERTIFICATE_NOTBEFORE
storeItem_getArguments: object-value:Sep 3 02:56:27 2002 GMT
storeItem_getArguments: object-attribute:REVOKE_CERTIFICATE_KEY_DIGEST
storeItem_getArguments: object-value:2a633775ce5e0af82889faeba699c6ef
storeItem_getArguments: object-attribute:EXPONENT
storeItem_getArguments: object-value:
storeItem_getArguments: object-attribute:REVOKE_CERTIFICATE_NOTAFTER
storeItem_getArguments: object-value:Nov 22 02:56:27 2002 GMT
storeItem_getArguments: object-attribute:SUBMIT_DATE
storeItem_getArguments: object-value:Tue Sep 3 11:47:53 2002 GMT
storeItem_getArguments: object-attribute:TYPE
storeItem_getArguments: object-value:CRR with PKCS#7 Signature
storeItem_getArguments: object-attribute:SIGNATURE
storeItem_getArguments: object-value:-----BEGIN PKCS7----- MIIGdQYJKoZIhvcNAQcCoIIGZjCCBmICAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3 DQEHAaCCBIcwggSDMIIDa6ADAgECAgEBMA0GCSqGSIb3DQEBBQUAMFcxGTAXBgkq hkiG9w0BCQEWCnJhb3BAcWIucm8xEDAOBgNVBAMTB3FiaXQgQ0ExDDAKBgNVBAsT A3BraTENMAsGA1UEChMEcWJpdDELMAkGA1UEBhMCUk8wHhcNMDIwODMwMDczNTQx WhcNMDIxMTE4MDczNTQxWjBTMQswCQYDVQQFEwIwMTESMBAGA1UEAxMJcWJpdCB0 ZWFtMRQwEgYDVQQLEwtUcnVzdGNlbnRlcjENMAsGA1UEChMEcWJpdDELMAkGA1UE BhMCUk8wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBANRH0s7taTQdln3FZov0 zPBgNASxtssbER+coIW1QiS5AD7+KL0jHhQGVvK9+1LGxRCnyrZgxDqnGkEq+A04 6c7qhiqk+eVy7X3sAxgPfE9ea6QToRDFf8aCRB/QKUHeSkc8MiqciTYX9BKsBTFH oVLKvMaJNf6oaKQk5tQqhHcBAgMBAAGjggHgMIIB3DAJBgNVHRMEAjAAMBEGCWCG SAGG+EIBAQQEAwIEsDALBgNVHQ8EBAMCBeAwNgYJYIZIAYb4QgENBCkWJ1JlZ2lz dHJhdGlvbiBBdXRob3JpdHkgT3BlcmF0b3Igb2YgcWJpdDAdBgNVHQ4EFgQUhJqe Li/GMNvX+AxN+3A01qbW/iMwfwYDVR0jBHgwdoAUJw7kxlydl48hSxA+N+XFJeEN LBGhW6RZMFcxGTAXBgkqhkiG9w0BCQEWCnJhb3BAcWIucm8xEDAOBgNVBAMTB3Fi aXQgQ0ExDDAKBgNVBAsTA3BraTENMAsGA1UEChMEcWJpdDELMAkGA1UEBhMCUk+C AQAwFQYDVR0RBA4wDIEKcmFvcEBxYi5ybzAVBgNVHRIEDjAMgQpyYW9wQHFiLnJv MDkGCWCGSAGG+EIBBAQsFipodHRwczovL3B1Yi5yYS5xYi5yby9jZ2ktYmluL2Ny bC9jYWNybC5jcmwwOQYJYIZIAYb4QgEDBCwWKmh0dHBzOi8vcHViLnJhLnFiLnJv L2NnaS1iaW4vY3JsL2NhY3JsLmNybDAzBgNVHR8ELDAqMCigJqAkhiJodHRwczov L3B1Yi5yYS5xYi5yby9jcmwvY2FjcmwuY3JsMA0GCSqGSIb3DQEBBQUAA4IBAQCT vw52rEWn35yiUW6P27/yOISw5pYiryMZ0RzBwLSn88cjHso266NubtIoXPkyye9B ax64aWcykOGIi7189zY14FUFDelGgPEfkucpphsNm2zbnyVm5qvTniLZHan0aVUc LKzEcdeX1wqNvZxRNJlvFjMBSCorDPO2xDLgTk3UcwKu5ekp7soc/GyVPpX61hpn JT2r2/ONCLdsq4QOHRj334DoQWUrcP1Ox90cK4n4c9TDcO2e5S1RaNmx4NMIk0v6 6SnQh92X2ITBjQQ4ZQm+U+DH4Y0K7+I2JoEPiMF8N/3lgbW26lDJgV6mdAR8utkI nR0xGr6cxOpJAXWnFU20MYIBtjCCAbICAQEwXDBXMRkwFwYJKoZIhvcNAQkBFgpy YW9wQHFiLnJvMRAwDgYDVQQDEwdxYml0IENBMQwwCgYDVQQLEwNwa2kxDTALBgNV BAoTBHFiaXQxCzAJBgNVBAYTAlJPAgEBMAkGBSsOAwIaBQCggbEwGAYJKoZIhvcN AQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDIwOTAzMTE0OTU5WjAj BgkqhkiG9w0BCQQxFgQUekvSrsncvR2lAMXu8BtEOUvvYzowUgYJKoZIhvcNAQkP MUUwQzAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwBwYFKw4DAgcwDQYIKoZI hvcNAwICAUAwDQYIKoZIhvcNAwICASgwDQYJKoZIhvcNAQEBBQAEgYC/uXUlbskn QGwCFcwi0mu/K7SYWx9HfgFWPq4xVbUiBFqJvFJyiQNyMJSPVGB5XS0kA8POf9r5 jeNHWvbA4UrtjSLfgz2I1Lgs96EQ1sjoD/mtwVKKyFZ4wdyUKX3UdQFupl3EhUgP zX4sKjz+AvV6BCTmtkqxFDlNbl8kCr6ucQ== -----END PKCS7-----
storeItem_getArguments: object-attribute:KEY
storeItem_getArguments: object-value:
storeItem_getArguments: object-attribute:CRIN
storeItem_getArguments: object-value:e17b81b285cf9043f2bcd290cecb3811335882fe
storeItem_getArguments: object-attribute:REVOKE_CERTIFICATE_ISSUER_DN
storeItem_getArguments: object-value:[EMAIL PROTECTED], CN=qbit CA, OU=pki, O=qbit, C=RO
storeItem_getArguments: object-attribute:SIG_ALGORITHM
storeItem_getArguments: object-value:
storeItem_getArguments: object-attribute:VERSION
storeItem_getArguments: object-value:1
storeItem_getArguments: object-attribute:PK_ALGORITHM
storeItem_getArguments: object-value:
storeItem_getArguments: object-attribute:REVOKE_CERTIFICATE_DN
storeItem_getArguments: object-value:SN=09, CN=spate exploderXXX, OU=Internet, O=qbit, C=RO
storeItem_getArguments: object-attribute:OU
storeItem_getArguments: object-value:ARRAY(0x85b6c04)
storeItem_getArguments: object-attribute:KEYSIZE
storeItem_getArguments: object-value:
storeItem_getArguments: object-attribute:DN
storeItem_getArguments: object-value:
storeItem_getArguments: object-attribute:APPROVED_DATE
storeItem_getArguments: object-value:Tue Sep 3 11:49:24 2002 GMT
storeItem_getArguments: object-attribute:REVOKE_CERTIFICATE_SERIAL
storeItem_getArguments: object-value:9
storeItem_getArguments: object-attribute:REVOKE_REASON
storeItem_getArguments: object-value:
storeItem_getArguments: object-attribute:BODY
storeItem_getArguments: object-value:SUBMIT_DATE = Tue Sep 3 11:47:53 2002 GMT APPROVED_DATE = Tue Sep 3 11:49:24 2002 GMT CRIN = e17b81b285cf9043f2bcd290cecb3811335882fe REVOKE_REASON = REVOKE_CERTIFICATE_DN = SN=09, CN=spate exploderXXX, OU=Internet, O=qbit, C=RO REVOKE_CERTIFICATE_NOTBEFORE = Sep 3 02:56:27 2002 GMT REVOKE_CERTIFICATE_NOTAFTER = Nov 22 02:56:27 2002 GMT REVOKE_CERTIFICATE_SERIAL = 9 REVOKE_CERTIFICATE_ISSUER_DN = [EMAIL PROTECTED], CN=qbit CA, OU=pki, O=qbit, C=RO REVOKE_CERTIFICATE_KEY_DIGEST = 2a633775ce5e0af82889faeba699c6ef
### function storeItem_getArguments succesfully finished ###
storeItem: table: CRR
### new function call ###
Entering storeItem_checkData
OpenCA::DBI->storeItem_checkData: check for existence of item
OpenCA::DBI->storeItem_checkData: doQuery: select * from crr where crr_key=?
### new function call ###
Entering sub doQuery
query: select * from crr where crr_key=?
bind_values: 1
prepare statement
statement nr.: 2
execute statement
execute succeeded
### leaving function doQuery successfully ###
data is complete
### leaving function storeItem_checkData successfully ###
### new function call ###
Entering storeItem_insert
prepare query
try to parse header
attr: STATUS attr: REVOKE_CERTIFICATE_SERIAL attr: REVOKE_CERTIFICATE_DN attr: CN attr: EMAIL attr: RA attr: OPERATOR attr: SUBMIT_DATE bind_values: 1 bind_values: -----BEGIN HEADER----- TYPE = CRR SERIAL = 1 SSL_CERT_SERIAL = 04 SSL_CERT_DN = SN=04, CN=spate iexplorer, OU=Internet, O=qbit, C=RO SSL_CERT_ISSUER = [EMAIL PROTECTED], CN=qbit CA, OU=pki, O=qbit, C=RO -----END HEADER----- SUBMIT_DATE = Tue Sep 3 11:47:53 2002 GMT APPROVED_DATE = Tue Sep 3 11:49:24 2002 GMT CRIN = e17b81b285cf9043f2bcd290cecb3811335882fe REVOKE_REASON = REVOKE_CERTIFICATE_DN = SN=09, CN=spate exploderXXX, OU=Internet, O=qbit, C=RO REVOKE_CERTIFICATE_NOTBEFORE = Sep 3 02:56:27 2002 GMT REVOKE_CERTIFICATE_NOTAFTER = Nov 22 02:56:27 2002 GMT REVOKE_CERTIFICATE_SERIAL = 9 REVOKE_CERTIFICATE_ISSUER_DN = [EMAIL PROTECTED], CN=qbit CA, OU=pki, O=qbit, C=RO REVOKE_CERTIFICATE_KEY_DIGEST = 2a633775ce5e0af82889faeba699c6ef -----BEGIN PKCS7----- MIIGdQYJKoZIhvcNAQcCoIIGZjCCBmICAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3 DQEHAaCCBIcwggSDMIIDa6ADAgECAgEBMA0GCSqGSIb3DQEBBQUAMFcxGTAXBgkq hkiG9w0BCQEWCnJhb3BAcWIucm8xEDAOBgNVBAMTB3FiaXQgQ0ExDDAKBgNVBAsT A3BraTENMAsGA1UEChMEcWJpdDELMAkGA1UEBhMCUk8wHhcNMDIwODMwMDczNTQx WhcNMDIxMTE4MDczNTQxWjBTMQswCQYDVQQFEwIwMTESMBAGA1UEAxMJcWJpdCB0 ZWFtMRQwEgYDVQQLEwtUcnVzdGNlbnRlcjENMAsGA1UEChMEcWJpdDELMAkGA1UE BhMCUk8wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBANRH0s7taTQdln3FZov0 zPBgNASxtssbER+coIW1QiS5AD7+KL0jHhQGVvK9+1LGxRCnyrZgxDqnGkEq+A04 6c7qhiqk+eVy7X3sAxgPfE9ea6QToRDFf8aCRB/QKUHeSkc8MiqciTYX9BKsBTFH oVLKvMaJNf6oaKQk5tQqhHcBAgMBAAGjggHgMIIB3DAJBgNVHRMEAjAAMBEGCWCG SAGG+EIBAQQEAwIEsDALBgNVHQ8EBAMCBeAwNgYJYIZIAYb4QgENBCkWJ1JlZ2lz dHJhdGlvbiBBdXRob3JpdHkgT3BlcmF0b3Igb2YgcWJpdDAdBgNVHQ4EFgQUhJqe Li/GMNvX+AxN+3A01qbW/iMwfwYDVR0jBHgwdoAUJw7kxlydl48hSxA+N+XFJeEN LBGhW6RZMFcxGTAXBgkqhkiG9w0BCQEWCnJhb3BAcWIucm8xEDAOBgNVBAMTB3Fi aXQgQ0ExDDAKBgNVBAsTA3BraTENMAsGA1UEChMEcWJpdDELMAkGA1UEBhMCUk+C AQAwFQYDVR0RBA4wDIEKcmFvcEBxYi5ybzAVBgNVHRIEDjAMgQpyYW9wQHFiLnJv MDkGCWCGSAGG+EIBBAQsFipodHRwczovL3B1Yi5yYS5xYi5yby9jZ2ktYmluL2Ny bC9jYWNybC5jcmwwOQYJYIZIAYb4QgEDBCwWKmh0dHBzOi8vcHViLnJhLnFiLnJv L2NnaS1iaW4vY3JsL2NhY3JsLmNybDAzBgNVHR8ELDAqMCigJqAkhiJodHRwczov L3B1Yi5yYS5xYi5yby9jcmwvY2FjcmwuY3JsMA0GCSqGSIb3DQEBBQUAA4IBAQCT vw52rEWn35yiUW6P27/yOISw5pYiryMZ0RzBwLSn88cjHso266NubtIoXPkyye9B ax64aWcykOGIi7189zY14FUFDelGgPEfkucpphsNm2zbnyVm5qvTniLZHan0aVUc LKzEcdeX1wqNvZxRNJlvFjMBSCorDPO2xDLgTk3UcwKu5ekp7soc/GyVPpX61hpn JT2r2/ONCLdsq4QOHRj334DoQWUrcP1Ox90cK4n4c9TDcO2e5S1RaNmx4NMIk0v6 6SnQh92X2ITBjQQ4ZQm+U+DH4Y0K7+I2JoEPiMF8N/3lgbW26lDJgV6mdAR8utkI nR0xGr6cxOpJAXWnFU20MYIBtjCCAbICAQEwXDBXMRkwFwYJKoZIhvcNAQkBFgpy YW9wQHFiLnJvMRAwDgYDVQQDEwdxYml0IENBMQwwCgYDVQQLEwNwa2kxDTALBgNV BAoTBHFiaXQxCzAJBgNVBAYTAlJPAgEBMAkGBSsOAwIaBQCggbEwGAYJKoZIhvcN AQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDIwOTAzMTE0OTU5WjAj BgkqhkiG9w0BCQQxFgQUekvSrsncvR2lAMXu8BtEOUvvYzowUgYJKoZIhvcNAQkP MUUwQzAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwBwYFKw4DAgcwDQYIKoZI hvcNAwICAUAwDQYIKoZIhvcNAwICASgwDQYJKoZIhvcNAQEBBQAEgYC/uXUlbskn QGwCFcwi0mu/K7SYWx9HfgFWPq4xVbUiBFqJvFJyiQNyMJSPVGB5XS0kA8POf9r5 jeNHWvbA4UrtjSLfgz2I1Lgs96EQ1sjoD/mtwVKKyFZ4wdyUKX3UdQFupl3EhUgP zX4sKjz+AvV6BCTmtkqxFDlNbl8kCr6ucQ== -----END PKCS7-----


      bind_values: CRR with PKCS#7 Signature
      bind_values: APPROVED
      bind_values: 9
      bind_values: SN=09, CN=spate exploderXXX, OU=Internet, O=qbit, C=RO
      bind_values: 
      bind_values: 
      bind_values: 
      bind_values: 
      bind_values: Tue Sep  3 11:47:53 2002 GMT
    query complete, call doQuery
### new function call ###

  Entering sub doQuery

  query: insert into crr ( crr_key, data, format , status, cert_key, dn, cn, email, ra, rao, submit_date) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

  bind_values: 1

  bind_values: -----BEGIN HEADER-----
TYPE = CRR
SERIAL = 1
SSL_CERT_SERIAL = 04
SSL_CERT_DN = SN=04, CN=spate iexplorer, OU=Internet, O=qbit, C=RO
SSL_CERT_ISSUER = [EMAIL PROTECTED], CN=qbit CA, OU=pki, O=qbit, C=RO
-----END HEADER-----
SUBMIT_DATE = Tue Sep  3 11:47:53 2002 GMT
APPROVED_DATE = Tue Sep  3 11:49:24 2002 GMT
CRIN = e17b81b285cf9043f2bcd290cecb3811335882fe
REVOKE_REASON = 
REVOKE_CERTIFICATE_DN = SN=09, CN=spate exploderXXX, OU=Internet, O=qbit, C=RO
REVOKE_CERTIFICATE_NOTBEFORE = Sep  3 02:56:27 2002 GMT
REVOKE_CERTIFICATE_NOTAFTER = Nov 22 02:56:27 2002 GMT
REVOKE_CERTIFICATE_SERIAL = 9
REVOKE_CERTIFICATE_ISSUER_DN = [EMAIL PROTECTED], CN=qbit CA, OU=pki, O=qbit, C=RO
REVOKE_CERTIFICATE_KEY_DIGEST = 2a633775ce5e0af82889faeba699c6ef
-----BEGIN PKCS7-----
MIIGdQYJKoZIhvcNAQcCoIIGZjCCBmICAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3
DQEHAaCCBIcwggSDMIIDa6ADAgECAgEBMA0GCSqGSIb3DQEBBQUAMFcxGTAXBgkq
hkiG9w0BCQEWCnJhb3BAcWIucm8xEDAOBgNVBAMTB3FiaXQgQ0ExDDAKBgNVBAsT
A3BraTENMAsGA1UEChMEcWJpdDELMAkGA1UEBhMCUk8wHhcNMDIwODMwMDczNTQx
WhcNMDIxMTE4MDczNTQxWjBTMQswCQYDVQQFEwIwMTESMBAGA1UEAxMJcWJpdCB0
ZWFtMRQwEgYDVQQLEwtUcnVzdGNlbnRlcjENMAsGA1UEChMEcWJpdDELMAkGA1UE
BhMCUk8wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBANRH0s7taTQdln3FZov0
zPBgNASxtssbER+coIW1QiS5AD7+KL0jHhQGVvK9+1LGxRCnyrZgxDqnGkEq+A04
6c7qhiqk+eVy7X3sAxgPfE9ea6QToRDFf8aCRB/QKUHeSkc8MiqciTYX9BKsBTFH
oVLKvMaJNf6oaKQk5tQqhHcBAgMBAAGjggHgMIIB3DAJBgNVHRMEAjAAMBEGCWCG
SAGG+EIBAQQEAwIEsDALBgNVHQ8EBAMCBeAwNgYJYIZIAYb4QgENBCkWJ1JlZ2lz
dHJhdGlvbiBBdXRob3JpdHkgT3BlcmF0b3Igb2YgcWJpdDAdBgNVHQ4EFgQUhJqe
Li/GMNvX+AxN+3A01qbW/iMwfwYDVR0jBHgwdoAUJw7kxlydl48hSxA+N+XFJeEN
LBGhW6RZMFcxGTAXBgkqhkiG9w0BCQEWCnJhb3BAcWIucm8xEDAOBgNVBAMTB3Fi
aXQgQ0ExDDAKBgNVBAsTA3BraTENMAsGA1UEChMEcWJpdDELMAkGA1UEBhMCUk+C
AQAwFQYDVR0RBA4wDIEKcmFvcEBxYi5ybzAVBgNVHRIEDjAMgQpyYW9wQHFiLnJv
MDkGCWCGSAGG+EIBBAQsFipodHRwczovL3B1Yi5yYS5xYi5yby9jZ2ktYmluL2Ny
bC9jYWNybC5jcmwwOQYJYIZIAYb4QgEDBCwWKmh0dHBzOi8vcHViLnJhLnFiLnJv
L2NnaS1iaW4vY3JsL2NhY3JsLmNybDAzBgNVHR8ELDAqMCigJqAkhiJodHRwczov
L3B1Yi5yYS5xYi5yby9jcmwvY2FjcmwuY3JsMA0GCSqGSIb3DQEBBQUAA4IBAQCT
vw52rEWn35yiUW6P27/yOISw5pYiryMZ0RzBwLSn88cjHso266NubtIoXPkyye9B
ax64aWcykOGIi7189zY14FUFDelGgPEfkucpphsNm2zbnyVm5qvTniLZHan0aVUc
LKzEcdeX1wqNvZxRNJlvFjMBSCorDPO2xDLgTk3UcwKu5ekp7soc/GyVPpX61hpn
JT2r2/ONCLdsq4QOHRj334DoQWUrcP1Ox90cK4n4c9TDcO2e5S1RaNmx4NMIk0v6
6SnQh92X2ITBjQQ4ZQm+U+DH4Y0K7+I2JoEPiMF8N/3lgbW26lDJgV6mdAR8utkI
nR0xGr6cxOpJAXWnFU20MYIBtjCCAbICAQEwXDBXMRkwFwYJKoZIhvcNAQkBFgpy
YW9wQHFiLnJvMRAwDgYDVQQDEwdxYml0IENBMQwwCgYDVQQLEwNwa2kxDTALBgNV
BAoTBHFiaXQxCzAJBgNVBAYTAlJPAgEBMAkGBSsOAwIaBQCggbEwGAYJKoZIhvcN
AQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDIwOTAzMTE0OTU5WjAj
BgkqhkiG9w0BCQQxFgQUekvSrsncvR2lAMXu8BtEOUvvYzowUgYJKoZIhvcNAQkP
MUUwQzAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwBwYFKw4DAgcwDQYIKoZI
hvcNAwICAUAwDQYIKoZIhvcNAwICASgwDQYJKoZIhvcNAQEBBQAEgYC/uXUlbskn
QGwCFcwi0mu/K7SYWx9HfgFWPq4xVbUiBFqJvFJyiQNyMJSPVGB5XS0kA8POf9r5
jeNHWvbA4UrtjSLfgz2I1Lgs96EQ1sjoD/mtwVKKyFZ4wdyUKX3UdQFupl3EhUgP
zX4sKjz+AvV6BCTmtkqxFDlNbl8kCr6ucQ==
-----END PKCS7-----


  bind_values: CRR with PKCS#7 Signature

  bind_values: APPROVED

  bind_values: 9

  bind_values: SN=09, CN=spate exploderXXX, OU=Internet, O=qbit, C=RO

  bind_values: 

  bind_values: 

  bind_values: 

  bind_values: 

  bind_values: Tue Sep  3 11:47:53 2002 GMT

  prepare statement

  statement nr.: 3

      execute statement

  execute succeeded

### leaving function doQuery successfully ###

    Databasetype:mysql
    generate sequence number
      doQuery for generate new_action_number: update openca_log_sequence set my_identity=LAST_INSERT_ID(my_identity+1)
### new function call ###

  Entering sub doQuery

  query: update openca_log_sequence set my_identity=LAST_INSERT_ID(my_identity+1)

  prepare statement

  statement nr.: 4

      execute statement

  execute succeeded

### leaving function doQuery successfully ###

      generate successful
    getSequence
      Entering getSequence
        mysql
    new_action_number: 0

    preparing log
      sequence not GENERATE_BY_INSERT
      query: insert into log (action_number, datatype, moduletype, module, log_submit_date, format, data, mykey, status, cert_key, dn, cn, email, ra, rao, submit_date) VALUES (0, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
      doQuery for logging
### new function call ###

  Entering sub doQuery

  query: insert into log (action_number, datatype, moduletype, module, log_submit_date, format, data, mykey, status, cert_key, dn, cn, email, ra, rao, submit_date) VALUES (0, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

  bind_values: CRR

  bind_values: UNKNOWN

  bind_values: UNKNOWN MODULETYPE AND UNKNOWN MODULE

  bind_values: 2002-08-04 05:09:07

  bind_values: CRR with PKCS#7 Signature

  bind_values: -----BEGIN HEADER-----
TYPE = CRR
SERIAL = 1
SSL_CERT_SERIAL = 04
SSL_CERT_DN = SN=04, CN=spate iexplorer, OU=Internet, O=qbit, C=RO
SSL_CERT_ISSUER = [EMAIL PROTECTED], CN=qbit CA, OU=pki, O=qbit, C=RO
-----END HEADER-----
SUBMIT_DATE = Tue Sep  3 11:47:53 2002 GMT
APPROVED_DATE = Tue Sep  3 11:49:24 2002 GMT
CRIN = e17b81b285cf9043f2bcd290cecb3811335882fe
REVOKE_REASON = 
REVOKE_CERTIFICATE_DN = SN=09, CN=spate exploderXXX, OU=Internet, O=qbit, C=RO
REVOKE_CERTIFICATE_NOTBEFORE = Sep  3 02:56:27 2002 GMT
REVOKE_CERTIFICATE_NOTAFTER = Nov 22 02:56:27 2002 GMT
REVOKE_CERTIFICATE_SERIAL = 9
REVOKE_CERTIFICATE_ISSUER_DN = [EMAIL PROTECTED], CN=qbit CA, OU=pki, O=qbit, C=RO
REVOKE_CERTIFICATE_KEY_DIGEST = 2a633775ce5e0af82889faeba699c6ef
-----BEGIN PKCS7-----
MIIGdQYJKoZIhvcNAQcCoIIGZjCCBmICAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3
DQEHAaCCBIcwggSDMIIDa6ADAgECAgEBMA0GCSqGSIb3DQEBBQUAMFcxGTAXBgkq
hkiG9w0BCQEWCnJhb3BAcWIucm8xEDAOBgNVBAMTB3FiaXQgQ0ExDDAKBgNVBAsT
A3BraTENMAsGA1UEChMEcWJpdDELMAkGA1UEBhMCUk8wHhcNMDIwODMwMDczNTQx
WhcNMDIxMTE4MDczNTQxWjBTMQswCQYDVQQFEwIwMTESMBAGA1UEAxMJcWJpdCB0
ZWFtMRQwEgYDVQQLEwtUcnVzdGNlbnRlcjENMAsGA1UEChMEcWJpdDELMAkGA1UE
BhMCUk8wgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBANRH0s7taTQdln3FZov0
zPBgNASxtssbER+coIW1QiS5AD7+KL0jHhQGVvK9+1LGxRCnyrZgxDqnGkEq+A04
6c7qhiqk+eVy7X3sAxgPfE9ea6QToRDFf8aCRB/QKUHeSkc8MiqciTYX9BKsBTFH
oVLKvMaJNf6oaKQk5tQqhHcBAgMBAAGjggHgMIIB3DAJBgNVHRMEAjAAMBEGCWCG
SAGG+EIBAQQEAwIEsDALBgNVHQ8EBAMCBeAwNgYJYIZIAYb4QgENBCkWJ1JlZ2lz
dHJhdGlvbiBBdXRob3JpdHkgT3BlcmF0b3Igb2YgcWJpdDAdBgNVHQ4EFgQUhJqe
Li/GMNvX+AxN+3A01qbW/iMwfwYDVR0jBHgwdoAUJw7kxlydl48hSxA+N+XFJeEN
LBGhW6RZMFcxGTAXBgkqhkiG9w0BCQEWCnJhb3BAcWIucm8xEDAOBgNVBAMTB3Fi
aXQgQ0ExDDAKBgNVBAsTA3BraTENMAsGA1UEChMEcWJpdDELMAkGA1UEBhMCUk+C
AQAwFQYDVR0RBA4wDIEKcmFvcEBxYi5ybzAVBgNVHRIEDjAMgQpyYW9wQHFiLnJv
MDkGCWCGSAGG+EIBBAQsFipodHRwczovL3B1Yi5yYS5xYi5yby9jZ2ktYmluL2Ny
bC9jYWNybC5jcmwwOQYJYIZIAYb4QgEDBCwWKmh0dHBzOi8vcHViLnJhLnFiLnJv
L2NnaS1iaW4vY3JsL2NhY3JsLmNybDAzBgNVHR8ELDAqMCigJqAkhiJodHRwczov
L3B1Yi5yYS5xYi5yby9jcmwvY2FjcmwuY3JsMA0GCSqGSIb3DQEBBQUAA4IBAQCT
vw52rEWn35yiUW6P27/yOISw5pYiryMZ0RzBwLSn88cjHso266NubtIoXPkyye9B
ax64aWcykOGIi7189zY14FUFDelGgPEfkucpphsNm2zbnyVm5qvTniLZHan0aVUc
LKzEcdeX1wqNvZxRNJlvFjMBSCorDPO2xDLgTk3UcwKu5ekp7soc/GyVPpX61hpn
JT2r2/ONCLdsq4QOHRj334DoQWUrcP1Ox90cK4n4c9TDcO2e5S1RaNmx4NMIk0v6
6SnQh92X2ITBjQQ4ZQm+U+DH4Y0K7+I2JoEPiMF8N/3lgbW26lDJgV6mdAR8utkI
nR0xGr6cxOpJAXWnFU20MYIBtjCCAbICAQEwXDBXMRkwFwYJKoZIhvcNAQkBFgpy
YW9wQHFiLnJvMRAwDgYDVQQDEwdxYml0IENBMQwwCgYDVQQLEwNwa2kxDTALBgNV
BAoTBHFiaXQxCzAJBgNVBAYTAlJPAgEBMAkGBSsOAwIaBQCggbEwGAYJKoZIhvcN
AQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDIwOTAzMTE0OTU5WjAj
BgkqhkiG9w0BCQQxFgQUekvSrsncvR2lAMXu8BtEOUvvYzowUgYJKoZIhvcNAQkP
MUUwQzAKBggqhkiG9w0DBzAOBggqhkiG9w0DAgICAIAwBwYFKw4DAgcwDQYIKoZI
hvcNAwICAUAwDQYIKoZIhvcNAwICASgwDQYJKoZIhvcNAQEBBQAEgYC/uXUlbskn
QGwCFcwi0mu/K7SYWx9HfgFWPq4xVbUiBFqJvFJyiQNyMJSPVGB5XS0kA8POf9r5
jeNHWvbA4UrtjSLfgz2I1Lgs96EQ1sjoD/mtwVKKyFZ4wdyUKX3UdQFupl3EhUgP
zX4sKjz+AvV6BCTmtkqxFDlNbl8kCr6ucQ==
-----END PKCS7-----


  bind_values: 1

  bind_values: APPROVED

  bind_values: 9

  bind_values: SN=09, CN=spate exploderXXX, OU=Internet, O=qbit, C=RO

  bind_values: 

  bind_values: 

  bind_values: 

  bind_values: 

  bind_values: Tue Sep  3 11:47:53 2002 GMT

  prepare statement

  statement nr.: 5

      execute statement

  execute succeeded

### leaving function doQuery successfully ###

storeItem_logging: doQuery succeeded

  storeItem: succeeded - KEY: 1

1.crr_with_pkcs#7_signature inserted

Importing pending crr ...

No objects are present.

Updating certificates status ...OpenCA::DBI->getItem: ### new function call ###
OpenCA::DBI->getItem: Entering sub getItem
### new function call ###
Entering getArguments
OpenCA::DBI->getArguments: TABLE:CERTIFICATE
OpenCA::DBI->getArguments: MODE:
OpenCA::DBI->getArguments: attribute: KEY
OpenCA::DBI->getArguments: value: 9
OpenCA::DBI->getArguments: attribute: STATUS
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: DN
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: CN
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: EMAIL
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: ROLE
OpenCA::DBI->getArguments: value:
OpenCA::DBI->getArguments: attribute: PUBKEY
OpenCA::DBI->getArguments: value:
### new function call ###
Entering getStatus
no status given using datatype: VALID_CERTIFICATE
given mode is now: "VALID"
legal status
### leaving function successful ###
OpenCA::DBI->getArguments: status: VALID
completed successful
### leaving function getArguments ###
OpenCA::DBI->getItem: data complete OpenCA::DBI->getItem: query: select * from certificate where (cert_key=?) and (status like 'VALID') and (notafter > 20020904050907)
### new function call ###
Entering sub doQuery
query: select * from certificate where (cert_key=?) and (status like 'VALID') and (notafter > 20020904050907)
bind_values: 9
prepare statement
statement nr.: 6
execute statement
execute succeeded
### leaving function doQuery successfully ###
OpenCA::DBI->getItem: query completed
OpenCA::DBI->getItem: check that there is a non-empty result
OpenCA::DBI automatic rollback by destructor DESTROY
call finish on all statement handles to avoid warnings by DBI

[Openca-Users] CRR import failed

Reply via email to