Hi, I am having some problems with accessing my Oracle database. I am using the "namespace" feature that was recently introduced in order to access tables created by other database users than the one OpenCA is using. DBI.pm is from CVS head.
I imported the contents of a MySQL database using an SQL dump and the corresponding var/ stuff via a tar archive. When I try to get a list of the issued certificates for example, I get the correct number of entries, but I do not see any certificate data. For each entry the serial "(0x0)", CN "---", email "---" and Role "n/a" is displayed. Same for CSRs. Viewing CRLs does produce a "real" error. See below for debug output. However, the DBI module seems to be able to access the data correctly. Have a look at sample invocations of getResultItem() after this message (PEM stuff was truncated). The data seems to be OK, and the $item can also be created correctly at least for the certificate. I can't find the error here, perhaps anybody got an idea? Could it be a problem with the OpenSSL executable not being able to parse the PEM coded stuff? cheers Martin View "all certificates", first DB query only, truncated output: DEBUG: OpenCA::DBI->doQuery: entering function DEBUG: OpenCA::DBI->doQuery: query: select * from ( select * from pkiscop1.certificate where (status like ?) and (notafter > 20040816143400) order by cert_key ) where rownum <= 20 DEBUG: OpenCA::DBI->doQuery: bind_values: VALID DEBUG: OpenCA::DBI->doQuery: prepare statement DEBUG: OpenCA::DBI->doQuery: statement nr.: 3 DEBUG: OpenCA::DBI->doQuery: execute statement DEBUG: OpenCA::DBI->doQuery: execute succeeded (leaving function - 0E0) DEBUG: OpenCA::DBI->Entering set_error ... DEBUG: OpenCA::DBI->errno: gettext is defined DEBUG: OpenCA::DBI->errno: old errno 11111 is present DEBUG: OpenCA::DBI->errno: new errorcode is 11111 DEBUG: OpenCA::DBI->getResultItem: entering function DEBUG: OpenCA::DBI->getResultItem: all params present DEBUG: OpenCA::DBI->getResultHash: entring function DEBUG: OpenCA::DBI->getResultHash: column: CERTIFICATE_SERIAL DEBUG: OpenCA::DBI->getResultHash: value: 1 DEBUG: OpenCA::DBI->getResultHash: column: FORMAT DEBUG: OpenCA::DBI->getResultHash: value: PEM DEBUG: OpenCA::DBI->getResultHash: column: DATA DEBUG: OpenCA::DBI->getResultHash: value: -----BEGIN HEADER-----\nPIN=3e...fbe\nCSR_SERIAL=288\nPIN_SIGNATURE=\nROLE_SIGNATURE=\nROLE=...\n-----END HEADER-----\n\n-----BEGIN CERTIFICATE-----\nMIIE4DC...5\nykPwFA==\n-----END CERTIFICATE-----\n-----BEGIN ENCRYPTED PRIVATE KEY-----\nMII...4YrM=\n-----END ENCRYPTED PRIVATE KEY----- DEBUG: OpenCA::DBI->getResultHash: column: DN DEBUG: OpenCA::DBI->getResultHash: value: CN=dca01.de.example.com,O=Dummy Ltd,DC=dummy,DC=com DEBUG: OpenCA::DBI->getResultHash: column: CN DEBUG: OpenCA::DBI->getResultHash: value: dca01.de.example.com DEBUG: OpenCA::DBI->getResultHash: column: EMAIL DEBUG: OpenCA::DBI->getResultHash: value: DEBUG: OpenCA::DBI->getResultHash: column: STATUS DEBUG: OpenCA::DBI->getResultHash: value: VALID DEBUG: OpenCA::DBI->getResultHash: column: ROLE DEBUG: OpenCA::DBI->getResultHash: value: MQ Manager DEBUG: OpenCA::DBI->getResultHash: column: PUBKEY DEBUG: OpenCA::DBI->getResultHash: value: Modulus (1024 bit):\n 00:ec:47:6b:3c:19:c8:15:88:e2:e6:30:68:0a:9a:\n ... 17:e8:b8:5d:e3:14:0a:a1:c0:fb:06:5d:36:0b:2c:\n 66:1c:cb:61:77:59:15:a6:63\nExponent: 65537 (0x10001)\n DEBUG: OpenCA::DBI->getResultHash: column: NOTAFTER DEBUG: OpenCA::DBI->getResultHash: value: 20050720162923 DEBUG: OpenCA::DBI->getResultHash: column: CSR_SERIAL DEBUG: OpenCA::DBI->getResultHash: value: 288 DEBUG: OpenCA::DBI->getResultHash: column: LOA DEBUG: OpenCA::DBI->getResultHash: value: DEBUG: OpenCA::DBI->getResultHash: leaving function DEBUG: OpenCA::DBI->getResultItem: data: -----BEGIN HEADER-----\nPIN=3e49...c05fbe\nCSR_SERIAL=288\nPIN_SIGNATURE=\nROLE_SIGNATURE=\nROLE=...\n-----END HEADER-----\n\n-----BEGIN CERTIFICATE-----\nMIIE...wFA==\n-----END CERTIFICATE-----\n-----BEGIN ENCRYPTED PRIVATE KEY-----\nMIIC...\nAH04YrM=\n-----END ENCRYPTED PRIVATE KEY----- DEBUG: OpenCA::DBI->getResultItem: format: PEM DEBUG: OpenCA::DBI->getResultItem: have all data DEBUG: OpenCA::DBI->getResultItem: return item DEBUG: OpenCA::DBI->Entering set_error ... DEBUG: OpenCA::DBI->errno: gettext is defined DEBUG: OpenCA::DBI->errno: new errorcode is 0 DEBUG: OpenCA::DBI->listItems: added item to result DEBUG: OpenCA::DBI->getResultItem: entering function View all CRLs: DEBUG: OpenCA::DBI->getResultItem: entering function DEBUG: OpenCA::DBI->getResultItem: all params present DEBUG: OpenCA::DBI->getResultHash: entring function DEBUG: OpenCA::DBI->getResultHash: column: CRL_SERIAL DEBUG: OpenCA::DBI->getResultHash: value: 20040802162939 DEBUG: OpenCA::DBI->getResultHash: column: STATUS DEBUG: OpenCA::DBI->getResultHash: value: VALID DEBUG: OpenCA::DBI->getResultHash: column: FORMAT DEBUG: OpenCA::DBI->getResultHash: value: PEM DEBUG: OpenCA::DBI->getResultHash: column: DATA DEBUG: OpenCA::DBI->getResultHash: value: -----BEGIN HEADER-----\n-----END HEADE R-----\n-----BEGIN X509 CRL-----\nMIIBn....zazlYboaI=\n-----END X509 CRL-----\n DEBUG: OpenCA::DBI->getResultHash: column: LAST_UPDATE DEBUG: OpenCA::DBI->getResultHash: value: Aug 2 16:29:39 2004 GMT DEBUG: OpenCA::DBI->getResultHash: column: NEXT_UPDATE DEBUG: OpenCA::DBI->getResultHash: value: Sep 1 16:29:39 2004 GMT DEBUG: OpenCA::DBI->getResultHash: leaving function DEBUG: OpenCA::DBI->getResultItem: data: -----BEGIN HEADER-----\n-----END HEADER -----\n-----BEGIN X509 CRL-----\nMIIB....boaI=\n-----END X509 CRL-----\n DEBUG: OpenCA::DBI->getResultItem: format: PEM DEBUG: OpenCA::DBI->getResultItem: have all data DEBUG: OpenCA::DBI->getItem: try to create crl DEBUG: OpenCA::DBI->ResultItem: crl failed DEBUG: OpenCA::DBI->getResultItem: cannot build object return void DEBUG: OpenCA::DBI->Entering set_error ... DEBUG: OpenCA::DBI->errno: gettext is defined DEBUG: OpenCA::DBI->errno: new errorcode is 0 DEBUG: OpenCA::DBI->rollback: entering function DEBUG: OpenCA::DBI->errno: returning local errorcode 10060 OpenCA: General error trapped 700: The compilation of the command cmdCrlList fai led. Can't call method "getSerial" on an undefined value at /home/cmn090/lib/perl5/OpenCA/DBI.pm line 2074.<br ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ OpenCA-Devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-devel
