Hm. I'm getting an error that I think I've seen before but I don't remember
the solution.
I've set up the snapshot with DBI. On the CA, I init database (and verify
by hand with pgsql that the tables were created), generate new CA cert,
export cert request.
Upon trying to generate a self-signed certificate, I get the following error:
execute called with 11 bind variables, 12 needed at
/usr/lib/perl5/site_perl/5.6.0/OpenCA/DBI.pm line 3549.
Compilation failed in require at /home/openca/cgi-ca/ca line 169.
With debugging turned on I get the text at the end of this message. This is
with the OpenCA::DBI from the CVS archive; I got the error both with that
version and the one in the snapshot.
Hm, weirder and weirder. I turned on debugging on the backend, and it
appears that the backend got the query okay, and should have processed it.
However, no values showed up in the table. Ah, that is consistent with
transactions being turned on and the transaction being rolled back:
011009.14:02:59.368 [4728] query: select last_value from openca_log_sequence
011009.14:02:59.369 [4728] ProcessQuery
011009.14:02:59.369 [4728] CommitTransactionCommand
011009.14:02:59.374 [4728] StartTransactionCommand
011009.14:02:59.374 [4728] query: rollback
Which might be consistent with the execution failing due to the bind vars
being wrong. Aha again. It appears that the query that is failing is the
one at the end of OpenCA::DBI::storeItem_logging.
doQuery for logging ### new function call ###
Entering sub doQuery
query: update log set moduletype=?, module=?, submit_date=?, mykey=?,
format=?, data=?, info=? , mykey=?, status=?, dn=?, cn=?, email=? where
action_number=6
12 bind variables, and from the end of the dump below there are indeed
only 11 there. I'm guessing 'mykey' is the one that's missing.
thanks,
--bob
defining the class parameters checking the configuration for enough data
checking for the tools preparing the remote and local databases (vendor
dependent) Pg detected for remoteDB remoteDB:
dbi:Pg:dbname=opencasu;host=localhost;port=5432 localDB: try to get a
consistent operationmode set standard and backup databases OpenCA::DBI
should now complete ### new function call ###
Entering function storeItem
### new function call ###
Entering storeItem_getArguments
table: CA_CERTIFICATE
attribute: KEY
value: -----BEGIN PUBLIC
KEY-----MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAuWvhx9NkOwq4rsX8UJ1zS1MLqo72VudflVSRkOzXQD8hmWInBWljDI04cwlbrsDLRlW7xxcMojSLpZk7EZkmaUB1QrdecINZmZGo6yD0yC8rNqa+7BolYWSX4aQU3/eylAIOUZ4rSUxiJ5QdLfJ9OVkzhIwtI6gT8Jlk27Gnbad3rtbk6EbgPBTUbFALz25PoJMAKFLaSQ8z1YCQ8DIkJgWtPxBaYEALIWwx42pjVn+0DQ12RgUnwl3t8y5TxEZPIKsU1YXySdyi1JLdBkQ6X6xLjR3kSTR8jH085hinPjTEOfIQEsu7AnlawwXPr61NHCfW9Wk0bCl7YXyWGrdYXwIDAQAB-----END
PUBLIC KEY-----
attribute: STATUS
value:
attribute: DN
value: [EMAIL PROTECTED]/CN=Access Grid Certificate
Authority/O=Access Grid/C=US
attribute: CN
value: Access Grid Certificate Authority
attribute: EMAIL
value: [EMAIL PROTECTED]
### new function call ###
Entering getStatus
no status given using datatype: VALID_CA_CERTIFICATE
given mode is: "VALID"
legal status
### leaving function successful ###
status: VALID
inform: PEM
format: PEM
converted: -----BEGIN CERTIFICATE-----
MIIEkjCCA3qgAwIBAgIBADANBgkqhkiG9w0BAQQFADBxMSAwHgYJKoZIhvcNAQkB
FhFvbHNvbkBtY3MuYW5sLmdvdjEqMCgGA1UEAxMhQWNjZXNzIEdyaWQgQ2VydGlm
aWNhdGUgQXV0aG9yaXR5MRQwEgYDVQQKEwtBY2Nlc3MgR3JpZDELMAkGA1UEBhMC
VVMwHhcNMDExMDA5MTg0OTMwWhcNMDMxMDA5MTg0OTMwWjBxMSAwHgYJKoZIhvcN
AQkBFhFvbHNvbkBtY3MuYW5sLmdvdjEqMCgGA1UEAxMhQWNjZXNzIEdyaWQgQ2Vy
dGlmaWNhdGUgQXV0aG9yaXR5MRQwEgYDVQQKEwtBY2Nlc3MgR3JpZDELMAkGA1UE
BhMCVVMwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC5a+HH02Q7Criu
xfxQnXNLUwuqjvZW51+VVJGQ7NdAPyGZYicFaWMMjThzCVuuwMtGVbvHFwyiNIul
mTsRmSZpQHVCt15wg1mZkajrIPTILys2pr7sGiVhZJfhpBTf97KUAg5RnitJTGIn
lB0t8n05WTOEjC0jqBPwmWTbsadtp3eu1uToRuA8FNRsUAvPbk+gkwAoUtpJDzPV
gJDwMiQmBa0/EFpgQAshbDHjamNWf7QNDXZGBSfCXe3zLlPERk8gqxTVhfJJ3KLU
kt0GRDpfrEuNHeRJNHyMfTzmGKc+NMQ58hASy7sCeVrDBc+vrU0cJ9b1aTRsKXth
fJYat1hfAgMBAAGjggEzMIIBLzAPBgNVHRMBAf8EBTADAQH/MB0GA1UdDgQWBBSI
wKkr0lLwnf+zxceL0Sbh8ct0kjAfBgNVHSMEGDAWgBSIwKkr0lLwnf+zxceL0Sbh
8ct0kjAOBgNVHQ8BAf8EBAMCAcYwEQYJYIZIAYb4QgEBBAQDAgAHMCEGA1UdEQQa
MBiGFmh0dHA6Ly93d3cub3BlbmNhLm9yZy8wIQYDVR0SBBowGIYWaHR0cDovL3d3
dy5vcGVuY2Eub3JnLzA8BggrBgEFBQcBAQQwMC4wLAYIKwYBBQUHMAKGIGh0dHA6
Ly93d3cub3BlbmNhLm9yZy9jYS9jYS5odG1sMDUGA1UdHwQuMCwwKqAooCaGJGh0
dHA6Ly93d3cub3BlbmNhLm9yZy9jZ2ktYmluL2dldGNybDANBgkqhkiG9w0BAQQF
AAOCAQEApKCMtm8I/neQfVxlLH8xDIT/H16q4pvymMUiW02rrkBnMWFXx1KGn6Ha
QGIS1+E8cVI5+YnX16aQRSJk8Esu+BGOgaNWSKOkB0eafB18nCk2qx/YXf13XG6V
yZqZsyi7ktR2qBP6sah76+k+7ZqCCFkh0pVfjX7XX4S7J2Ot/FkpXo6GqadzwvU0
SDn98QDnEJzz43IFUao8dcFepOJGWiJPGn3/PfE6VCntY5LTxurqvxCOYzjUD9Rn
cIb04x00mD3c0GZt3oR/2mIWGoCFNj7HBrJAcHB0kfy/U7gWJP+0nYI4eA+Ih7xz
+6WTZGkb2N76Z47gKE0cxCBD+sV+5Q== -----END CERTIFICATE-----
object->getParsed hash:
object-attribute:ITEM
object-value:-----BEGIN CERTIFICATE-----
MIIEkjCCA3qgAwIBAgIBADANBgkqhkiG9w0BAQQFADBxMSAwHgYJKoZIhvcNAQkB
FhFvbHNvbkBtY3MuYW5sLmdvdjEqMCgGA1UEAxMhQWNjZXNzIEdyaWQgQ2VydGlm
aWNhdGUgQXV0aG9yaXR5MRQwEgYDVQQKEwtBY2Nlc3MgR3JpZDELMAkGA1UEBhMC
VVMwHhcNMDExMDA5MTg0OTMwWhcNMDMxMDA5MTg0OTMwWjBxMSAwHgYJKoZIhvcN
AQkBFhFvbHNvbkBtY3MuYW5sLmdvdjEqMCgGA1UEAxMhQWNjZXNzIEdyaWQgQ2Vy
dGlmaWNhdGUgQXV0aG9yaXR5MRQwEgYDVQQKEwtBY2Nlc3MgR3JpZDELMAkGA1UE
BhMCVVMwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC5a+HH02Q7Criu
xfxQnXNLUwuqjvZW51+VVJGQ7NdAPyGZYicFaWMMjThzCVuuwMtGVbvHFwyiNIul
mTsRmSZpQHVCt15wg1mZkajrIPTILys2pr7sGiVhZJfhpBTf97KUAg5RnitJTGIn
lB0t8n05WTOEjC0jqBPwmWTbsadtp3eu1uToRuA8FNRsUAvPbk+gkwAoUtpJDzPV
gJDwMiQmBa0/EFpgQAshbDHjamNWf7QNDXZGBSfCXe3zLlPERk8gqxTVhfJJ3KLU
kt0GRDpfrEuNHeRJNHyMfTzmGKc+NMQ58hASy7sCeVrDBc+vrU0cJ9b1aTRsKXth
fJYat1hfAgMBAAGjggEzMIIBLzAPBgNVHRMBAf8EBTADAQH/MB0GA1UdDgQWBBSI
wKkr0lLwnf+zxceL0Sbh8ct0kjAfBgNVHSMEGDAWgBSIwKkr0lLwnf+zxceL0Sbh
8ct0kjAOBgNVHQ8BAf8EBAMCAcYwEQYJYIZIAYb4QgEBBAQDAgAHMCEGA1UdEQQa
MBiGFmh0dHA6Ly93d3cub3BlbmNhLm9yZy8wIQYDVR0SBBowGIYWaHR0cDovL3d3
dy5vcGVuY2Eub3JnLzA8BggrBgEFBQcBAQQwMC4wLAYIKwYBBQUHMAKGIGh0dHA6
Ly93d3cub3BlbmNhLm9yZy9jYS9jYS5odG1sMDUGA1UdHwQuMCwwKqAooCaGJGh0
dHA6Ly93d3cub3BlbmNhLm9yZy9jZ2ktYmluL2dldGNybDANBgkqhkiG9w0BAQQF
AAOCAQEApKCMtm8I/neQfVxlLH8xDIT/H16q4pvymMUiW02rrkBnMWFXx1KGn6Ha
QGIS1+E8cVI5+YnX16aQRSJk8Esu+BGOgaNWSKOkB0eafB18nCk2qx/YXf13XG6V
yZqZsyi7ktR2qBP6sah76+k+7ZqCCFkh0pVfjX7XX4S7J2Ot/FkpXo6GqadzwvU0
SDn98QDnEJzz43IFUao8dcFepOJGWiJPGn3/PfE6VCntY5LTxurqvxCOYzjUD9Rn
cIb04x00mD3c0GZt3oR/2mIWGoCFNj7HBrJAcHB0kfy/U7gWJP+0nYI4eA+Ih7xz
+6WTZGkb2N76Z47gKE0cxCBD+sV+5Q== -----END CERTIFICATE-----
object-attribute:EXTS
object-value:ARRAY(0x8416fa4)
object-attribute:HEADER
object-value:
object-attribute:EXPONENT
object-value:65537
object-attribute:C
object-value:US
object-attribute:SERIAL
object-value:00
object-attribute:ISSUER
object-value:[EMAIL PROTECTED]/CN=Access Grid Certificate
Authority/O=Access Grid/C=US
object-attribute:NOTBEFORE
object-value:Oct 9 18:49:30 2001 GMT
object-attribute:KEY
object-value:-----BEGIN PUBLIC
KEY-----MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAuWvhx9NkOwq4rsX8UJ1zS1MLqo72VudflVSRkOzXQD8hmWInBWljDI04cwlbrsDLRlW7xxcMojSLpZk7EZkmaUB1QrdecINZmZGo6yD0yC8rNqa+7BolYWSX4aQU3/eylAIOUZ4rSUxiJ5QdLfJ9OVkzhIwtI6gT8Jlk27Gnbad3rtbk6EbgPBTUbFALz25PoJMAKFLaSQ8z1YCQ8DIkJgWtPxBaYEALIWwx42pjVn+0DQ12RgUnwl3t8y5TxEZPIKsU1YXySdyi1JLdBkQ6X6xLjR3kSTR8jH085hinPjTEOfIQEsu7AnlawwXPr61NHCfW9Wk0bCl7YXyWGrdYXwIDAQAB-----END
PUBLIC KEY-----
object-attribute:MODULUS
object-value:B96BE1C7D3643B0AB8AEC5FC509D734B530BAA8EF656E75F95549190ECD7403F219962270569630C8D3873095BAEC0CB4655BBC7170CA2348BA5993B11992669407542B75E7083599991A8EB20F4C82F2B36A6BEEC1A25616497E1A414DFF7B294020E519E2B494C6227941D2DF27D395933848C2D23A813F09964DBB1A76DA777AED6E4E846E03C14D46C500BCF6E4FA093002852DA490F33D58090F032242605AD3F105A60400B216C31E36A63567FB40D0D76460527C25DEDF32E53C4464F20AB14D585F249DCA2D492DD06443A5FAC4B8D1DE449347C8C7D3CE618A73E34C439F21012CBBB02795AC305CFAFAD4D1C27D6F569346C297B617C961AB7585F
object-attribute:ALIAS
object-value:
object-attribute:SIG_ALGORITHM
object-value:md5WithRSAEncryption
object-attribute:O
object-value:Access Grid
object-attribute:VERSION
object-value:3
object-attribute:PK_ALGORITHM
object-value:rsaEncryption
object-attribute:OU
object-value:ARRAY(0x84152fc)
object-attribute:CN
object-value:Access Grid Certificate Authority
object-attribute:KEYSIZE
object-value:2048
object-attribute:NOTAFTER
object-value:Oct 9 18:49:30 2003 GMT
object-attribute:EMAIL
object-value:[EMAIL PROTECTED]
object-attribute:DN
object-value:[EMAIL PROTECTED]/CN=Access Grid Certificate
Authority/O=Access Grid/C=US
object-attribute:HASH
object-value:33aeff94
object-attribute:FINGERPRINT
object-value:BD:75:42:03:FD:B4:9D:60:74:DB:46:44:31:6F:01:30
object-attribute:BODY
object-value:-----BEGIN CERTIFICATE-----
MIIEkjCCA3qgAwIBAgIBADANBgkqhkiG9w0BAQQFADBxMSAwHgYJKoZIhvcNAQkB
FhFvbHNvbkBtY3MuYW5sLmdvdjEqMCgGA1UEAxMhQWNjZXNzIEdyaWQgQ2VydGlm
aWNhdGUgQXV0aG9yaXR5MRQwEgYDVQQKEwtBY2Nlc3MgR3JpZDELMAkGA1UEBhMC
VVMwHhcNMDExMDA5MTg0OTMwWhcNMDMxMDA5MTg0OTMwWjBxMSAwHgYJKoZIhvcN
AQkBFhFvbHNvbkBtY3MuYW5sLmdvdjEqMCgGA1UEAxMhQWNjZXNzIEdyaWQgQ2Vy
dGlmaWNhdGUgQXV0aG9yaXR5MRQwEgYDVQQKEwtBY2Nlc3MgR3JpZDELMAkGA1UE
BhMCVVMwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC5a+HH02Q7Criu
xfxQnXNLUwuqjvZW51+VVJGQ7NdAPyGZYicFaWMMjThzCVuuwMtGVbvHFwyiNIul
mTsRmSZpQHVCt15wg1mZkajrIPTILys2pr7sGiVhZJfhpBTf97KUAg5RnitJTGIn
lB0t8n05WTOEjC0jqBPwmWTbsadtp3eu1uToRuA8FNRsUAvPbk+gkwAoUtpJDzPV
gJDwMiQmBa0/EFpgQAshbDHjamNWf7QNDXZGBSfCXe3zLlPERk8gqxTVhfJJ3KLU
kt0GRDpfrEuNHeRJNHyMfTzmGKc+NMQ58hASy7sCeVrDBc+vrU0cJ9b1aTRsKXth
fJYat1hfAgMBAAGjggEzMIIBLzAPBgNVHRMBAf8EBTADAQH/MB0GA1UdDgQWBBSI
wKkr0lLwnf+zxceL0Sbh8ct0kjAfBgNVHSMEGDAWgBSIwKkr0lLwnf+zxceL0Sbh
8ct0kjAOBgNVHQ8BAf8EBAMCAcYwEQYJYIZIAYb4QgEBBAQDAgAHMCEGA1UdEQQa
MBiGFmh0dHA6Ly93d3cub3BlbmNhLm9yZy8wIQYDVR0SBBowGIYWaHR0cDovL3d3
dy5vcGVuY2Eub3JnLzA8BggrBgEFBQcBAQQwMC4wLAYIKwYBBQUHMAKGIGh0dHA6
Ly93d3cub3BlbmNhLm9yZy9jYS9jYS5odG1sMDUGA1UdHwQuMCwwKqAooCaGJGh0
dHA6Ly93d3cub3BlbmNhLm9yZy9jZ2ktYmluL2dldGNybDANBgkqhkiG9w0BAQQF
AAOCAQEApKCMtm8I/neQfVxlLH8xDIT/H16q4pvymMUiW02rrkBnMWFXx1KGn6Ha
QGIS1+E8cVI5+YnX16aQRSJk8Esu+BGOgaNWSKOkB0eafB18nCk2qx/YXf13XG6V
yZqZsyi7ktR2qBP6sah76+k+7ZqCCFkh0pVfjX7XX4S7J2Ot/FkpXo6GqadzwvU0
SDn98QDnEJzz43IFUao8dcFepOJGWiJPGn3/PfE6VCntY5LTxurqvxCOYzjUD9Rn
cIb04x00mD3c0GZt3oR/2mIWGoCFNj7HBrJAcHB0kfy/U7gWJP+0nYI4eA+Ih7xz
+6WTZGkb2N76Z47gKE0cxCBD+sV+5Q== -----END CERTIFICATE-----
KEY:f2355c16dac44c0a2fc4605e3562dff1
### function storeITem_getArguments succesfully finished ###
table: CA_CERTIFICATE
### new function call ###
Entering storeItem_checkData
data is complete
### leaving function storeItem_checkData successfully ###
initializes db_hash
starting DBLOOP
try to connect
### new function call ###
Entering sub doConnect
status: 0
errors: 0
connect never failed so using standard
Databasetype:Pg
dsn stuff: 'dbi:Pg:dbname=opencasu;host=localhost;port=5432', 'opencasu',
'opencasu'
try to connect
function succeeded
### leaving function doConnect successfully ###
Databasetype:Pg
check for existence of item
is not a CRL
doQuery: select * from ca_certificate where ca_cert_key=?
### new function call ###
Entering sub doQuery
query: select * from ca_certificate where ca_cert_key=?
bind_values: f2355c16dac44c0a2fc4605e3562dff1
prepare statement
statement nr.: 1
execute statement
execute succeeded
### leaving function doQuery successfully ###
### new function call ###
Entering storeItem_insert
insert mode prepare query
try to parse header
OpenCA::DBI->hash2txt: record=
Header of the object:
attr: STATUS attr: DN attr: CN attr: EMAIL bind_values:
f2355c16dac44c0a2fc4605e3562dff1 bind_values: -----BEGIN CERTIFICATE-----
MIIEkjCCA3qgAwIBAgIBADANBgkqhkiG9w0BAQQFADBxMSAwHgYJKoZIhvcNAQkB
FhFvbHNvbkBtY3MuYW5sLmdvdjEqMCgGA1UEAxMhQWNjZXNzIEdyaWQgQ2VydGlm
aWNhdGUgQXV0aG9yaXR5MRQwEgYDVQQKEwtBY2Nlc3MgR3JpZDELMAkGA1UEBhMC
VVMwHhcNMDExMDA5MTg0OTMwWhcNMDMxMDA5MTg0OTMwWjBxMSAwHgYJKoZIhvcN
AQkBFhFvbHNvbkBtY3MuYW5sLmdvdjEqMCgGA1UEAxMhQWNjZXNzIEdyaWQgQ2Vy
dGlmaWNhdGUgQXV0aG9yaXR5MRQwEgYDVQQKEwtBY2Nlc3MgR3JpZDELMAkGA1UE
BhMCVVMwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC5a+HH02Q7Criu
xfxQnXNLUwuqjvZW51+VVJGQ7NdAPyGZYicFaWMMjThzCVuuwMtGVbvHFwyiNIul
mTsRmSZpQHVCt15wg1mZkajrIPTILys2pr7sGiVhZJfhpBTf97KUAg5RnitJTGIn
lB0t8n05WTOEjC0jqBPwmWTbsadtp3eu1uToRuA8FNRsUAvPbk+gkwAoUtpJDzPV
gJDwMiQmBa0/EFpgQAshbDHjamNWf7QNDXZGBSfCXe3zLlPERk8gqxTVhfJJ3KLU
kt0GRDpfrEuNHeRJNHyMfTzmGKc+NMQ58hASy7sCeVrDBc+vrU0cJ9b1aTRsKXth
fJYat1hfAgMBAAGjggEzMIIBLzAPBgNVHRMBAf8EBTADAQH/MB0GA1UdDgQWBBSI
wKkr0lLwnf+zxceL0Sbh8ct0kjAfBgNVHSMEGDAWgBSIwKkr0lLwnf+zxceL0Sbh
8ct0kjAOBgNVHQ8BAf8EBAMCAcYwEQYJYIZIAYb4QgEBBAQDAgAHMCEGA1UdEQQa
MBiGFmh0dHA6Ly93d3cub3BlbmNhLm9yZy8wIQYDVR0SBBowGIYWaHR0cDovL3d3
dy5vcGVuY2Eub3JnLzA8BggrBgEFBQcBAQQwMC4wLAYIKwYBBQUHMAKGIGh0dHA6
Ly93d3cub3BlbmNhLm9yZy9jYS9jYS5odG1sMDUGA1UdHwQuMCwwKqAooCaGJGh0
dHA6Ly93d3cub3BlbmNhLm9yZy9jZ2ktYmluL2dldGNybDANBgkqhkiG9w0BAQQF
AAOCAQEApKCMtm8I/neQfVxlLH8xDIT/H16q4pvymMUiW02rrkBnMWFXx1KGn6Ha
QGIS1+E8cVI5+YnX16aQRSJk8Esu+BGOgaNWSKOkB0eafB18nCk2qx/YXf13XG6V
yZqZsyi7ktR2qBP6sah76+k+7ZqCCFkh0pVfjX7XX4S7J2Ot/FkpXo6GqadzwvU0
SDn98QDnEJzz43IFUao8dcFepOJGWiJPGn3/PfE6VCntY5LTxurqvxCOYzjUD9Rn
cIb04x00mD3c0GZt3oR/2mIWGoCFNj7HBrJAcHB0kfy/U7gWJP+0nYI4eA+Ih7xz
+6WTZGkb2N76Z47gKE0cxCBD+sV+5Q== -----END CERTIFICATE----- bind_values: PEM
bind_values: bind_values: VALID bind_values:
[EMAIL PROTECTED]/CN=Access Grid Certificate Authority/O=Access
Grid/C=US bind_values: Access Grid Certificate Authority bind_values:
[EMAIL PROTECTED] query complete, call doQuery ### new function call ###
Entering sub doQuery
query: insert into ca_certificate ( ca_cert_key, data, format, info,
status, dn, cn, email) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?)
bind_values: f2355c16dac44c0a2fc4605e3562dff1
bind_values: -----BEGIN CERTIFICATE-----
MIIEkjCCA3qgAwIBAgIBADANBgkqhkiG9w0BAQQFADBxMSAwHgYJKoZIhvcNAQkB
FhFvbHNvbkBtY3MuYW5sLmdvdjEqMCgGA1UEAxMhQWNjZXNzIEdyaWQgQ2VydGlm
aWNhdGUgQXV0aG9yaXR5MRQwEgYDVQQKEwtBY2Nlc3MgR3JpZDELMAkGA1UEBhMC
VVMwHhcNMDExMDA5MTg0OTMwWhcNMDMxMDA5MTg0OTMwWjBxMSAwHgYJKoZIhvcN
AQkBFhFvbHNvbkBtY3MuYW5sLmdvdjEqMCgGA1UEAxMhQWNjZXNzIEdyaWQgQ2Vy
dGlmaWNhdGUgQXV0aG9yaXR5MRQwEgYDVQQKEwtBY2Nlc3MgR3JpZDELMAkGA1UE
BhMCVVMwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC5a+HH02Q7Criu
xfxQnXNLUwuqjvZW51+VVJGQ7NdAPyGZYicFaWMMjThzCVuuwMtGVbvHFwyiNIul
mTsRmSZpQHVCt15wg1mZkajrIPTILys2pr7sGiVhZJfhpBTf97KUAg5RnitJTGIn
lB0t8n05WTOEjC0jqBPwmWTbsadtp3eu1uToRuA8FNRsUAvPbk+gkwAoUtpJDzPV
gJDwMiQmBa0/EFpgQAshbDHjamNWf7QNDXZGBSfCXe3zLlPERk8gqxTVhfJJ3KLU
kt0GRDpfrEuNHeRJNHyMfTzmGKc+NMQ58hASy7sCeVrDBc+vrU0cJ9b1aTRsKXth
fJYat1hfAgMBAAGjggEzMIIBLzAPBgNVHRMBAf8EBTADAQH/MB0GA1UdDgQWBBSI
wKkr0lLwnf+zxceL0Sbh8ct0kjAfBgNVHSMEGDAWgBSIwKkr0lLwnf+zxceL0Sbh
8ct0kjAOBgNVHQ8BAf8EBAMCAcYwEQYJYIZIAYb4QgEBBAQDAgAHMCEGA1UdEQQa
MBiGFmh0dHA6Ly93d3cub3BlbmNhLm9yZy8wIQYDVR0SBBowGIYWaHR0cDovL3d3
dy5vcGVuY2Eub3JnLzA8BggrBgEFBQcBAQQwMC4wLAYIKwYBBQUHMAKGIGh0dHA6
Ly93d3cub3BlbmNhLm9yZy9jYS9jYS5odG1sMDUGA1UdHwQuMCwwKqAooCaGJGh0
dHA6Ly93d3cub3BlbmNhLm9yZy9jZ2ktYmluL2dldGNybDANBgkqhkiG9w0BAQQF
AAOCAQEApKCMtm8I/neQfVxlLH8xDIT/H16q4pvymMUiW02rrkBnMWFXx1KGn6Ha
QGIS1+E8cVI5+YnX16aQRSJk8Esu+BGOgaNWSKOkB0eafB18nCk2qx/YXf13XG6V
yZqZsyi7ktR2qBP6sah76+k+7ZqCCFkh0pVfjX7XX4S7J2Ot/FkpXo6GqadzwvU0
SDn98QDnEJzz43IFUao8dcFepOJGWiJPGn3/PfE6VCntY5LTxurqvxCOYzjUD9Rn
cIb04x00mD3c0GZt3oR/2mIWGoCFNj7HBrJAcHB0kfy/U7gWJP+0nYI4eA+Ih7xz
+6WTZGkb2N76Z47gKE0cxCBD+sV+5Q== -----END CERTIFICATE-----
bind_values: PEM
bind_values:
bind_values: VALID
bind_values: [EMAIL PROTECTED]/CN=Access Grid Certificate
Authority/O=Access Grid/C=US
bind_values: Access Grid Certificate Authority
bind_values: [EMAIL PROTECTED]
prepare statement
statement nr.: 2
execute statement
execute succeeded
### leaving function doQuery successfully ###
Databasetype:Pg generate sequence number doQuery for generate
new_action_number: insert into log(action_number) VALUES
(NEXTVAL('openca_log_sequence')) ### new function call ###
Entering sub doQuery
query: insert into log(action_number) VALUES (NEXTVAL('openca_log_sequence'))
prepare statement
statement nr.: 3
execute statement
execute succeeded
### leaving function doQuery successfully ###
generate successful getSequence Entering getSequence Pg query:select
last_value from openca_log_sequence ### new function call ###
Entering sub doQuery
query: select last_value from openca_log_sequence
prepare statement
statement nr.: 4
execute statement
execute succeeded
### leaving function doQuery successfully ###
not failed new_action_number: 6 preparing log sequence GENERATE_BY_INSERT
OpenCA::DBI->hash2txt: record=
query: update log set moduletype=?, module=?, submit_date=?, mykey=?,
format=?, data=?, info=? , mykey=?, status=?, dn=?, cn=?, email=? where
action_number=6 doQuery for logging ### new function call ###
Entering sub doQuery
query: update log set moduletype=?, module=?, submit_date=?, mykey=?,
format=?, data=?, info=? , mykey=?, status=?, dn=?, cn=?, email=? where
action_number=6
bind_values: UNKNOWN
bind_values: UNKNOWN MODULETYPE AND UNKNOWN MODULE
bind_values: 2001-09-09 18:49:31
bind_values: PEM
bind_values: -----BEGIN CERTIFICATE-----
MIIEkjCCA3qgAwIBAgIBADANBgkqhkiG9w0BAQQFADBxMSAwHgYJKoZIhvcNAQkB
FhFvbHNvbkBtY3MuYW5sLmdvdjEqMCgGA1UEAxMhQWNjZXNzIEdyaWQgQ2VydGlm
aWNhdGUgQXV0aG9yaXR5MRQwEgYDVQQKEwtBY2Nlc3MgR3JpZDELMAkGA1UEBhMC
VVMwHhcNMDExMDA5MTg0OTMwWhcNMDMxMDA5MTg0OTMwWjBxMSAwHgYJKoZIhvcN
AQkBFhFvbHNvbkBtY3MuYW5sLmdvdjEqMCgGA1UEAxMhQWNjZXNzIEdyaWQgQ2Vy
dGlmaWNhdGUgQXV0aG9yaXR5MRQwEgYDVQQKEwtBY2Nlc3MgR3JpZDELMAkGA1UE
BhMCVVMwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC5a+HH02Q7Criu
xfxQnXNLUwuqjvZW51+VVJGQ7NdAPyGZYicFaWMMjThzCVuuwMtGVbvHFwyiNIul
mTsRmSZpQHVCt15wg1mZkajrIPTILys2pr7sGiVhZJfhpBTf97KUAg5RnitJTGIn
lB0t8n05WTOEjC0jqBPwmWTbsadtp3eu1uToRuA8FNRsUAvPbk+gkwAoUtpJDzPV
gJDwMiQmBa0/EFpgQAshbDHjamNWf7QNDXZGBSfCXe3zLlPERk8gqxTVhfJJ3KLU
kt0GRDpfrEuNHeRJNHyMfTzmGKc+NMQ58hASy7sCeVrDBc+vrU0cJ9b1aTRsKXth
fJYat1hfAgMBAAGjggEzMIIBLzAPBgNVHRMBAf8EBTADAQH/MB0GA1UdDgQWBBSI
wKkr0lLwnf+zxceL0Sbh8ct0kjAfBgNVHSMEGDAWgBSIwKkr0lLwnf+zxceL0Sbh
8ct0kjAOBgNVHQ8BAf8EBAMCAcYwEQYJYIZIAYb4QgEBBAQDAgAHMCEGA1UdEQQa
MBiGFmh0dHA6Ly93d3cub3BlbmNhLm9yZy8wIQYDVR0SBBowGIYWaHR0cDovL3d3
dy5vcGVuY2Eub3JnLzA8BggrBgEFBQcBAQQwMC4wLAYIKwYBBQUHMAKGIGh0dHA6
Ly93d3cub3BlbmNhLm9yZy9jYS9jYS5odG1sMDUGA1UdHwQuMCwwKqAooCaGJGh0
dHA6Ly93d3cub3BlbmNhLm9yZy9jZ2ktYmluL2dldGNybDANBgkqhkiG9w0BAQQF
AAOCAQEApKCMtm8I/neQfVxlLH8xDIT/H16q4pvymMUiW02rrkBnMWFXx1KGn6Ha
QGIS1+E8cVI5+YnX16aQRSJk8Esu+BGOgaNWSKOkB0eafB18nCk2qx/YXf13XG6V
yZqZsyi7ktR2qBP6sah76+k+7ZqCCFkh0pVfjX7XX4S7J2Ot/FkpXo6GqadzwvU0
SDn98QDnEJzz43IFUao8dcFepOJGWiJPGn3/PfE6VCntY5LTxurqvxCOYzjUD9Rn
cIb04x00mD3c0GZt3oR/2mIWGoCFNj7HBrJAcHB0kfy/U7gWJP+0nYI4eA+Ih7xz
+6WTZGkb2N76Z47gKE0cxCBD+sV+5Q== -----END CERTIFICATE-----
bind_values:
bind_values: f2355c16dac44c0a2fc4605e3562dff1
bind_values: VALID
bind_values: [EMAIL PROTECTED]/CN=Access Grid Certificate
Authority/O=Access Grid/C=US
bind_values: Access Grid Certificate Authority
bind_values: [EMAIL PROTECTED]
prepare statement
statement nr.: 5
execute statement
_______________________________________________
OpenCA-Devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-devel
