hi I am on the latest version of the DBI but when I go to click on view valid ca certificate I get nothing. here is the out put of the DBI debug Debugging is activated! defining the class parameters checking the configuration for enough data preparing the database (vendor dependent) Pg detected DB: dbi:Pg:dbname=rootca091;host=box176.pki.irm.vt.edu;port=5432 connecting to database try to connect Checking AutoCommit to be off ... AutoCommit is off OpenCA::DBI should now complete Content-type: text/html ### new function call ### Entering getArguments OpenCA::DBI->getArguments: TABLE:CA_CERTIFICATE OpenCA::DBI->getArguments: MODE: OpenCA::DBI->getArguments: attribute: KEY OpenCA::DBI->getArguments: value: 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: PUBKEY OpenCA::DBI->getArguments: value: ### new function call ### Entering getStatus no status given using datatype: VALID_CA_CERTIFICATE given mode is now: "VALID" legal status ### leaving function successful ### OpenCA::DBI->getArguments: status: VALID completed successful ### leaving function getArguments ### ### new function call ### Entering function elements ### new function call ### Entering sub doQuery query: select count(*) from ca_certificate where status like ? and (notafter > 20021115204419) bind_values: VALID prepare statement statement nr.: 1 execute statement execute succeeded ### leaving function doQuery successfully ### state: $rv= elements comleted successful ### leaving function elements ### ### new function call ### Entering function listItems ### new function call ### Entering getArguments OpenCA::DBI->getArguments: TABLE:CA_CERTIFICATE OpenCA::DBI->getArguments: MODE: OpenCA::DBI->getArguments: attribute: KEY OpenCA::DBI->getArguments: value: 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: PUBKEY OpenCA::DBI->getArguments: value: ### new function call ### Entering getStatus no status given using datatype: VALID_CA_CERTIFICATE given mode is now: "VALID" legal status ### leaving function successful ### OpenCA::DBI->getArguments: status: VALID completed successful ### leaving function getArguments ### OpenCA::DBI->listItems: query: select * from ca_certificate where (status like ?) and (notafter > 20021115204419) OpenCA::DBI->listItems: limited query: select * from ca_certificate where (status like ?) and (notafter > 20021115204419) LIMIT 20 ### new function call ### Entering sub doQuery query: select * from ca_certificate where (status like ?) and (notafter > 20021115204419) LIMIT 20 bind_values: VALID prepare statement statement nr.: 2 execute statement execute succeeded ### leaving function doQuery successfully ### OpenCA::DBI->getResultItem: ### new function call ### OpenCA::DBI->getResultItem: Entering sub getResultItem OpenCA::DBI->getResultItem: all params present ### new function call ### Entering function getResultHash column:CA_CERTIFICATE_SERIAL value:93018fc600841d5c5214328d82d236d9 column:FORMAT value:PEM column:DATA value:-----BEGIN CERTIFICATE----- MIIDzTCCArWgAwIBAgIBADANBgkqhkiG9w0BAQUFADBNMRMwEQYKCZImiZPyLGQB GRMDZWR1MRIwEAYKCZImiZPyLGQBGRMCdnQxIjAgBgNVBAMTGURFViBWaXJnaW5p YSBUZWNoIFJvb3QgQ0EwHhcNMDIxMTA2MTYzNjA2WhcNMjIxMTAxMTYzNjA2WjBN MRMwEQYKCZImiZPyLGQBGRMDZWR1MRIwEAYKCZImiZPyLGQBGRMCdnQxIjAgBgNV BAMTGURFViBWaXJnaW5pYSBUZWNoIFJvb3QgQ0EwggEiMA0GCSqGSIb3DQEBAQUA A4IBDwAwggEKAoIBAQDsAI9DZd4OgoPVFq2HlE8gzLjY7m5RRcSLcZNb6Dbz3OD4 WNAbx2QwD0r3GA8mHNBdQ2bXLo59w/8jAtYRI5hnp5kwvInSW5lI7Jg/6h7pIG6t C4PIEVHUAfPTkhUCxY0agAg6Qzk6UvRAXJBLu00B01/qoXGl+IWDcju/2nuBE/73 ApOVZzLOscEJoUVQKZj0cz0zhwcB+RV6fUjsHduMafjIGqeW3PqV9GcyufdxdQ5K 2ug+FwcAMWglK8pX2dNiEZ3lBMUTBsvSXaPm0drcKv/yE8LNViTyYCGM0EpN7kJy pYQdmvmsZgpVhtkhKWTdgIDwjHAXc40wz9AIhDh5AgMBAAGjgbcwgbQwDwYDVR0T AQH/BAUwAwEB/zAdBgNVHQ4EFgQUjDxn3sb7XdYA3T1OWEamU9NWWugwdQYDVR0j BG4wbIAUjDxn3sb7XdYA3T1OWEamU9NWWuihUaRPME0xEzARBgoJkiaJk/IsZAEZ EwNlZHUxEjAQBgoJkiaJk/IsZAEZEwJ2dDEiMCAGA1UEAxMZREVWIFZpcmdpbmlh IFRlY2ggUm9vdCBDQYIBADALBgNVHQ8EBAMCAQYwDQYJKoZIhvcNAQEFBQADggEB ACOx9Sw4regm98PO9JC0wIqqX2mt1IBCku8bG3OEQYRBdQeJWIWmczWHwgsMaexH UECFzrcHU9nRnvsOafwxRcj7GwEAeS52RhFG2xdmFV7RIswT2mVcx6y2RSVjBEe/ Ylu6dieLZkYZTY/PnOb4aVJDO/iWdikBCHzGeYAJ2KIFKiLrw1gF7rBzQjfLiqzE wnSkX+OwM+yRm1Ekn+A9GcJsycz6Xvzpqlf2jCy4rYj3gOUPJchcyZCeWq4zmn5P P8EFNui1PVXSOO5LyeFbKyQM5M5kyDMMNyhLbGW98Lduw/xOoGK7ZAymfRUNDuiy GIZweiI9OMdhKXnTkgvoHRg= -----END CERTIFICATE----- column:DN value:CN=DEV Virginia Tech Root CA,DC=vt,DC=edu column:CN value:DEV Virginia Tech Root CA column:EMAIL value: column:STATUS value:VALID column:PUBKEY value:-----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA7ACPQ2XeDoKD1Rath5RP IMy42O5uUUXEi3GTW+g289zg+FjQG8dkMA9K9xgPJhzQXUNm1y6OfcP/IwLWESOY Z6eZMLyJ0luZSOyYP+oe6SBurQuDyBFR1AHz05IVAsWNGoAIOkM5OlL0QFyQS7tN AdNf6qFxpfiFg3I7v9p7gRP+9wKTlWcyzrHBCaFFUCmY9HM9M4cHAfkVen1I7B3b jGn4yBqnltz6lfRnMrn3cXUOStroPhcHADFoJSvKV9nTYhGd5QTFEwbL0l2j5tHa 3Cr/8hPCzVYk8mAhjNBKTe5CcqWEHZr5rGYKVYbZISlk3YCA8IxwF3ONMM/QCIQ4 eQIDAQAB -----END PUBLIC KEY----- column:NOTAFTER value:20221101163606 ### leaving function getResultHash ### OpenCA::DBI->getResultItem: data: -----BEGIN CERTIFICATE----- MIIDzTCCArWgAwIBAgIBADANBgkqhkiG9w0BAQUFADBNMRMwEQYKCZImiZPyLGQB GRMDZWR1MRIwEAYKCZImiZPyLGQBGRMCdnQxIjAgBgNVBAMTGURFViBWaXJnaW5p YSBUZWNoIFJvb3QgQ0EwHhcNMDIxMTA2MTYzNjA2WhcNMjIxMTAxMTYzNjA2WjBN MRMwEQYKCZImiZPyLGQBGRMDZWR1MRIwEAYKCZImiZPyLGQBGRMCdnQxIjAgBgNV BAMTGURFViBWaXJnaW5pYSBUZWNoIFJvb3QgQ0EwggEiMA0GCSqGSIb3DQEBAQUA A4IBDwAwggEKAoIBAQDsAI9DZd4OgoPVFq2HlE8gzLjY7m5RRcSLcZNb6Dbz3OD4 WNAbx2QwD0r3GA8mHNBdQ2bXLo59w/8jAtYRI5hnp5kwvInSW5lI7Jg/6h7pIG6t C4PIEVHUAfPTkhUCxY0agAg6Qzk6UvRAXJBLu00B01/qoXGl+IWDcju/2nuBE/73 ApOVZzLOscEJoUVQKZj0cz0zhwcB+RV6fUjsHduMafjIGqeW3PqV9GcyufdxdQ5K 2ug+FwcAMWglK8pX2dNiEZ3lBMUTBsvSXaPm0drcKv/yE8LNViTyYCGM0EpN7kJy pYQdmvmsZgpVhtkhKWTdgIDwjHAXc40wz9AIhDh5AgMBAAGjgbcwgbQwDwYDVR0T AQH/BAUwAwEB/zAdBgNVHQ4EFgQUjDxn3sb7XdYA3T1OWEamU9NWWugwdQYDVR0j BG4wbIAUjDxn3sb7XdYA3T1OWEamU9NWWuihUaRPME0xEzARBgoJkiaJk/IsZAEZ EwNlZHUxEjAQBgoJkiaJk/IsZAEZEwJ2dDEiMCAGA1UEAxMZREVWIFZpcmdpbmlh IFRlY2ggUm9vdCBDQYIBADALBgNVHQ8EBAMCAQYwDQYJKoZIhvcNAQEFBQADggEB ACOx9Sw4regm98PO9JC0wIqqX2mt1IBCku8bG3OEQYRBdQeJWIWmczWHwgsMaexH UECFzrcHU9nRnvsOafwxRcj7GwEAeS52RhFG2xdmFV7RIswT2mVcx6y2RSVjBEe/ Ylu6dieLZkYZTY/PnOb4aVJDO/iWdikBCHzGeYAJ2KIFKiLrw1gF7rBzQjfLiqzE wnSkX+OwM+yRm1Ekn+A9GcJsycz6Xvzpqlf2jCy4rYj3gOUPJchcyZCeWq4zmn5P P8EFNui1PVXSOO5LyeFbKyQM5M5kyDMMNyhLbGW98Lduw/xOoGK7ZAymfRUNDuiy GIZweiI9OMdhKXnTkgvoHRg= -----END CERTIFICATE----- OpenCA::DBI->getResultItem: format: PEM OpenCA::DBI->getResultItem: have all data OpenCA::DBI->getResultItem: data of item: -----BEGIN CERTIFICATE----- MIIDzTCCArWgAwIBAgIBADANBgkqhkiG9w0BAQUFADBNMRMwEQYKCZImiZPyLGQB GRMDZWR1MRIwEAYKCZImiZPyLGQBGRMCdnQxIjAgBgNVBAMTGURFViBWaXJnaW5p YSBUZWNoIFJvb3QgQ0EwHhcNMDIxMTA2MTYzNjA2WhcNMjIxMTAxMTYzNjA2WjBN MRMwEQYKCZImiZPyLGQBGRMDZWR1MRIwEAYKCZImiZPyLGQBGRMCdnQxIjAgBgNV BAMTGURFViBWaXJnaW5pYSBUZWNoIFJvb3QgQ0EwggEiMA0GCSqGSIb3DQEBAQUA A4IBDwAwggEKAoIBAQDsAI9DZd4OgoPVFq2HlE8gzLjY7m5RRcSLcZNb6Dbz3OD4 WNAbx2QwD0r3GA8mHNBdQ2bXLo59w/8jAtYRI5hnp5kwvInSW5lI7Jg/6h7pIG6t C4PIEVHUAfPTkhUCxY0agAg6Qzk6UvRAXJBLu00B01/qoXGl+IWDcju/2nuBE/73 ApOVZzLOscEJoUVQKZj0cz0zhwcB+RV6fUjsHduMafjIGqeW3PqV9GcyufdxdQ5K 2ug+FwcAMWglK8pX2dNiEZ3lBMUTBsvSXaPm0drcKv/yE8LNViTyYCGM0EpN7kJy pYQdmvmsZgpVhtkhKWTdgIDwjHAXc40wz9AIhDh5AgMBAAGjgbcwgbQwDwYDVR0T AQH/BAUwAwEB/zAdBgNVHQ4EFgQUjDxn3sb7XdYA3T1OWEamU9NWWugwdQYDVR0j BG4wbIAUjDxn3sb7XdYA3T1OWEamU9NWWuihUaRPME0xEzARBgoJkiaJk/IsZAEZ EwNlZHUxEjAQBgoJkiaJk/IsZAEZEwJ2dDEiMCAGA1UEAxMZREVWIFZpcmdpbmlh IFRlY2ggUm9vdCBDQYIBADALBgNVHQ8EBAMCAQYwDQYJKoZIhvcNAQEFBQADggEB ACOx9Sw4regm98PO9JC0wIqqX2mt1IBCku8bG3OEQYRBdQeJWIWmczWHwgsMaexH UECFzrcHU9nRnvsOafwxRcj7GwEAeS52RhFG2xdmFV7RIswT2mVcx6y2RSVjBEe/ Ylu6dieLZkYZTY/PnOb4aVJDO/iWdikBCHzGeYAJ2KIFKiLrw1gF7rBzQjfLiqzE wnSkX+OwM+yRm1Ekn+A9GcJsycz6Xvzpqlf2jCy4rYj3gOUPJchcyZCeWq4zmn5P P8EFNui1PVXSOO5LyeFbKyQM5M5kyDMMNyhLbGW98Lduw/xOoGK7ZAymfRUNDuiy GIZweiI9OMdhKXnTkgvoHRg= -----END CERTIFICATE----- OpenCA::DBI->getResultItem: return item OpenCA::DBI->listItems: added item 93018fc600841d5c5214328d82d236d9 to result listItems completed successful ### leaving function successfully ### ### new function call ### Entering getArguments OpenCA::DBI->getArguments: TABLE:CA_CERTIFICATE OpenCA::DBI->getArguments: MODE: OpenCA::DBI->getArguments: attribute: KEY OpenCA::DBI->getArguments: value: . 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: PUBKEY OpenCA::DBI->getArguments: value: ### new function call ### Entering getStatus no status given using datatype: VALID_CA_CERTIFICATE given mode is now: "VALID" legal status ### leaving function successful ### OpenCA::DBI->getArguments: status: VALID completed successful ### leaving function getArguments ### OpenCA::DBI->getNextItem: query: select MIN(ca_cert_key) from ca_certificate where (ca_cert_key > ? ) and (status like ?) and (notafter > 20021115204419) ### new function call ### Entering sub doQuery query: select MIN(ca_cert_key) from ca_certificate where (ca_cert_key > ? ) and (status like ?) and (notafter > 20021115204419) bind_values: . bind_values: VALID prepare statement statement nr.: 3 execute statement execute succeeded ### leaving function doQuery successfully ### OpenCA::DBI->getItem: ### new function call ### OpenCA::DBI->getItem: Entering sub getItem ### new function call ### Entering getArguments OpenCA::DBI->getArguments: TABLE:CA_CERTIFICATE OpenCA::DBI->getArguments: MODE: OpenCA::DBI->getArguments: attribute: KEY OpenCA::DBI->getArguments: value: 93018fc600841d5c5214328d82d236d9 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: PUBKEY OpenCA::DBI->getArguments: value: ### new function call ### Entering getStatus no status given using datatype: CA_CERTIFICATE given mode is now: "CA" illegal status or no status ### leaving function unsuccessful but without error ### completed successful ### leaving function getArguments ### OpenCA::DBI->getItem: data complete OpenCA::DBI->getItem: query: 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: 93018fc600841d5c5214328d82d236d9 prepare statement statement nr.: 4 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->getResultItem: ### new function call ### OpenCA::DBI->getResultItem: Entering sub getResultItem OpenCA::DBI->getResultItem: all params present ### new function call ### Entering function getResultHash column:CA_CERTIFICATE_SERIAL value:93018fc600841d5c5214328d82d236d9 column:FORMAT value:PEM column:DATA value:-----BEGIN CERTIFICATE----- MIIDzTCCArWgAwIBAgIBADANBgkqhkiG9w0BAQUFADBNMRMwEQYKCZImiZPyLGQB GRMDZWR1MRIwEAYKCZImiZPyLGQBGRMCdnQxIjAgBgNVBAMTGURFViBWaXJnaW5p YSBUZWNoIFJvb3QgQ0EwHhcNMDIxMTA2MTYzNjA2WhcNMjIxMTAxMTYzNjA2WjBN MRMwEQYKCZImiZPyLGQBGRMDZWR1MRIwEAYKCZImiZPyLGQBGRMCdnQxIjAgBgNV BAMTGURFViBWaXJnaW5pYSBUZWNoIFJvb3QgQ0EwggEiMA0GCSqGSIb3DQEBAQUA A4IBDwAwggEKAoIBAQDsAI9DZd4OgoPVFq2HlE8gzLjY7m5RRcSLcZNb6Dbz3OD4 WNAbx2QwD0r3GA8mHNBdQ2bXLo59w/8jAtYRI5hnp5kwvInSW5lI7Jg/6h7pIG6t C4PIEVHUAfPTkhUCxY0agAg6Qzk6UvRAXJBLu00B01/qoXGl+IWDcju/2nuBE/73 ApOVZzLOscEJoUVQKZj0cz0zhwcB+RV6fUjsHduMafjIGqeW3PqV9GcyufdxdQ5K 2ug+FwcAMWglK8pX2dNiEZ3lBMUTBsvSXaPm0drcKv/yE8LNViTyYCGM0EpN7kJy pYQdmvmsZgpVhtkhKWTdgIDwjHAXc40wz9AIhDh5AgMBAAGjgbcwgbQwDwYDVR0T AQH/BAUwAwEB/zAdBgNVHQ4EFgQUjDxn3sb7XdYA3T1OWEamU9NWWugwdQYDVR0j BG4wbIAUjDxn3sb7XdYA3T1OWEamU9NWWuihUaRPME0xEzARBgoJkiaJk/IsZAEZ EwNlZHUxEjAQBgoJkiaJk/IsZAEZEwJ2dDEiMCAGA1UEAxMZREVWIFZpcmdpbmlh IFRlY2ggUm9vdCBDQYIBADALBgNVHQ8EBAMCAQYwDQYJKoZIhvcNAQEFBQADggEB ACOx9Sw4regm98PO9JC0wIqqX2mt1IBCku8bG3OEQYRBdQeJWIWmczWHwgsMaexH UECFzrcHU9nRnvsOafwxRcj7GwEAeS52RhFG2xdmFV7RIswT2mVcx6y2RSVjBEe/ Ylu6dieLZkYZTY/PnOb4aVJDO/iWdikBCHzGeYAJ2KIFKiLrw1gF7rBzQjfLiqzE wnSkX+OwM+yRm1Ekn+A9GcJsycz6Xvzpqlf2jCy4rYj3gOUPJchcyZCeWq4zmn5P P8EFNui1PVXSOO5LyeFbKyQM5M5kyDMMNyhLbGW98Lduw/xOoGK7ZAymfRUNDuiy GIZweiI9OMdhKXnTkgvoHRg= -----END CERTIFICATE----- column:DN value:CN=DEV Virginia Tech Root CA,DC=vt,DC=edu column:CN value:DEV Virginia Tech Root CA column:EMAIL value: column:STATUS value:VALID column:PUBKEY value:-----BEGIN PUBLIC KEY----- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA7ACPQ2XeDoKD1Rath5RP IMy42O5uUUXEi3GTW+g289zg+FjQG8dkMA9K9xgPJhzQXUNm1y6OfcP/IwLWESOY Z6eZMLyJ0luZSOyYP+oe6SBurQuDyBFR1AHz05IVAsWNGoAIOkM5OlL0QFyQS7tN AdNf6qFxpfiFg3I7v9p7gRP+9wKTlWcyzrHBCaFFUCmY9HM9M4cHAfkVen1I7B3b jGn4yBqnltz6lfRnMrn3cXUOStroPhcHADFoJSvKV9nTYhGd5QTFEwbL0l2j5tHa 3Cr/8hPCzVYk8mAhjNBKTe5CcqWEHZr5rGYKVYbZISlk3YCA8IxwF3ONMM/QCIQ4 eQIDAQAB -----END PUBLIC KEY----- column:NOTAFTER value:20221101163606 ### leaving function getResultHash ### OpenCA::DBI->getResultItem: data: -----BEGIN CERTIFICATE----- MIIDzTCCArWgAwIBAgIBADANBgkqhkiG9w0BAQUFADBNMRMwEQYKCZImiZPyLGQB GRMDZWR1MRIwEAYKCZImiZPyLGQBGRMCdnQxIjAgBgNVBAMTGURFViBWaXJnaW5p YSBUZWNoIFJvb3QgQ0EwHhcNMDIxMTA2MTYzNjA2WhcNMjIxMTAxMTYzNjA2WjBN MRMwEQYKCZImiZPyLGQBGRMDZWR1MRIwEAYKCZImiZPyLGQBGRMCdnQxIjAgBgNV BAMTGURFViBWaXJnaW5pYSBUZWNoIFJvb3QgQ0EwggEiMA0GCSqGSIb3DQEBAQUA A4IBDwAwggEKAoIBAQDsAI9DZd4OgoPVFq2HlE8gzLjY7m5RRcSLcZNb6Dbz3OD4 WNAbx2QwD0r3GA8mHNBdQ2bXLo59w/8jAtYRI5hnp5kwvInSW5lI7Jg/6h7pIG6t C4PIEVHUAfPTkhUCxY0agAg6Qzk6UvRAXJBLu00B01/qoXGl+IWDcju/2nuBE/73 ApOVZzLOscEJoUVQKZj0cz0zhwcB+RV6fUjsHduMafjIGqeW3PqV9GcyufdxdQ5K 2ug+FwcAMWglK8pX2dNiEZ3lBMUTBsvSXaPm0drcKv/yE8LNViTyYCGM0EpN7kJy pYQdmvmsZgpVhtkhKWTdgIDwjHAXc40wz9AIhDh5AgMBAAGjgbcwgbQwDwYDVR0T AQH/BAUwAwEB/zAdBgNVHQ4EFgQUjDxn3sb7XdYA3T1OWEamU9NWWugwdQYDVR0j BG4wbIAUjDxn3sb7XdYA3T1OWEamU9NWWuihUaRPME0xEzARBgoJkiaJk/IsZAEZ EwNlZHUxEjAQBgoJkiaJk/IsZAEZEwJ2dDEiMCAGA1UEAxMZREVWIFZpcmdpbmlh IFRlY2ggUm9vdCBDQYIBADALBgNVHQ8EBAMCAQYwDQYJKoZIhvcNAQEFBQADggEB ACOx9Sw4regm98PO9JC0wIqqX2mt1IBCku8bG3OEQYRBdQeJWIWmczWHwgsMaexH UECFzrcHU9nRnvsOafwxRcj7GwEAeS52RhFG2xdmFV7RIswT2mVcx6y2RSVjBEe/ Ylu6dieLZkYZTY/PnOb4aVJDO/iWdikBCHzGeYAJ2KIFKiLrw1gF7rBzQjfLiqzE wnSkX+OwM+yRm1Ekn+A9GcJsycz6Xvzpqlf2jCy4rYj3gOUPJchcyZCeWq4zmn5P P8EFNui1PVXSOO5LyeFbKyQM5M5kyDMMNyhLbGW98Lduw/xOoGK7ZAymfRUNDuiy GIZweiI9OMdhKXnTkgvoHRg= -----END CERTIFICATE----- OpenCA::DBI->getResultItem: format: PEM OpenCA::DBI->getResultItem: have all data OpenCA::DBI->getResultItem: data of item: -----BEGIN CERTIFICATE----- MIIDzTCCArWgAwIBAgIBADANBgkqhkiG9w0BAQUFADBNMRMwEQYKCZImiZPyLGQB GRMDZWR1MRIwEAYKCZImiZPyLGQBGRMCdnQxIjAgBgNVBAMTGURFViBWaXJnaW5p YSBUZWNoIFJvb3QgQ0EwHhcNMDIxMTA2MTYzNjA2WhcNMjIxMTAxMTYzNjA2WjBN MRMwEQYKCZImiZPyLGQBGRMDZWR1MRIwEAYKCZImiZPyLGQBGRMCdnQxIjAgBgNV BAMTGURFViBWaXJnaW5pYSBUZWNoIFJvb3QgQ0EwggEiMA0GCSqGSIb3DQEBAQUA A4IBDwAwggEKAoIBAQDsAI9DZd4OgoPVFq2HlE8gzLjY7m5RRcSLcZNb6Dbz3OD4 WNAbx2QwD0r3GA8mHNBdQ2bXLo59w/8jAtYRI5hnp5kwvInSW5lI7Jg/6h7pIG6t C4PIEVHUAfPTkhUCxY0agAg6Qzk6UvRAXJBLu00B01/qoXGl+IWDcju/2nuBE/73 ApOVZzLOscEJoUVQKZj0cz0zhwcB+RV6fUjsHduMafjIGqeW3PqV9GcyufdxdQ5K 2ug+FwcAMWglK8pX2dNiEZ3lBMUTBsvSXaPm0drcKv/yE8LNViTyYCGM0EpN7kJy pYQdmvmsZgpVhtkhKWTdgIDwjHAXc40wz9AIhDh5AgMBAAGjgbcwgbQwDwYDVR0T AQH/BAUwAwEB/zAdBgNVHQ4EFgQUjDxn3sb7XdYA3T1OWEamU9NWWugwdQYDVR0j BG4wbIAUjDxn3sb7XdYA3T1OWEamU9NWWuihUaRPME0xEzARBgoJkiaJk/IsZAEZ EwNlZHUxEjAQBgoJkiaJk/IsZAEZEwJ2dDEiMCAGA1UEAxMZREVWIFZpcmdpbmlh IFRlY2ggUm9vdCBDQYIBADALBgNVHQ8EBAMCAQYwDQYJKoZIhvcNAQEFBQADggEB ACOx9Sw4regm98PO9JC0wIqqX2mt1IBCku8bG3OEQYRBdQeJWIWmczWHwgsMaexH UECFzrcHU9nRnvsOafwxRcj7GwEAeS52RhFG2xdmFV7RIswT2mVcx6y2RSVjBEe/ Ylu6dieLZkYZTY/PnOb4aVJDO/iWdikBCHzGeYAJ2KIFKiLrw1gF7rBzQjfLiqzE wnSkX+OwM+yRm1Ekn+A9GcJsycz6Xvzpqlf2jCy4rYj3gOUPJchcyZCeWq4zmn5P P8EFNui1PVXSOO5LyeFbKyQM5M5kyDMMNyhLbGW98Lduw/xOoGK7ZAymfRUNDuiy GIZweiI9OMdhKXnTkgvoHRg= -----END CERTIFICATE----- OpenCA::DBI->getResultItem: return item ### new function call ### Entering getArguments OpenCA::DBI->getArguments: TABLE:CA_CERTIFICATE OpenCA::DBI->getArguments: MODE: OpenCA::DBI->getArguments: attribute: KEY OpenCA::DBI->getArguments: value: } 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: PUBKEY OpenCA::DBI->getArguments: value: ### new function call ### Entering getStatus no status given using datatype: VALID_CA_CERTIFICATE given mode is now: "VALID" legal status ### leaving function successful ### OpenCA::DBI->getArguments: status: VALID completed successful ### leaving function getArguments ### ### new function call ### Entering sub doQuery query: select MAX(ca_cert_key) from ca_certificate where (ca_cert_key< ? ) and (status=?) and (notafter > 20021115204419) bind_values: } bind_values: VALID prepare statement statement nr.: 5 execute statement execute succeeded ### leaving function doQuery successfully ### OpenCA::DBI->getItem: ### new function call ### OpenCA::DBI->getItem: Entering sub getItem ### new function call ### Entering getArguments OpenCA::DBI->getArguments: TABLE:CA_CERTIFICATE OpenCA::DBI->getArguments: MODE: OpenCA::DBI->getArguments: attribute: KEY OpenCA::DBI->getArguments: value: 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: PUBKEY OpenCA::DBI->getArguments: value: ### new function call ### Entering getStatus no status given using datatype: CA_CERTIFICATE given mode is now: "CA" illegal status or no status ### leaving function unsuccessful but without error ### completed successful ### leaving function getArguments ### OpenCA::DBI automatic rollback by destructor DESTROY OpenCA::DBI->rollback -- Bahaaldin Al-amood [EMAIL PROTECTED] Operations Specialist Virginia Polytechnic Institute And State University AISB 1700 Pratt Drive Blacksburg, VA, 24060 (540)231-2630
------------------------------------------------------- This sf.net email is sponsored by: To learn the basics of securing your web site with SSL, click here to get a FREE TRIAL of a Thawte Server Certificate: http://www.gothawte.com/rd524.html _______________________________________________ Openca-Users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-users
