Hi I am testing OpenCA 0.9.1 and I am using Pg as my back end database. here is one scenario when I go to revoke a cert from the RA I get error 690 and the apache error log has this in it ############################################################################# [Thu Nov 07 08:23:39 2002] [error] [client 128.173.14.37] DBD::Pg::st execute failed: ERROR: Bad int8 external representation "" at /home/rootra-091/OpenCA/modules//perl5/OpenCA/DBI.pm line 3077., referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 [Thu Nov 07 08:23:39 2002] [error] [client 128.173.14.37] SECURITY ALERT BY PKI: database failed during storing a correct CRR which follows, referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 , referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 , referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 , referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 , referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 , referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 , referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 , referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 [Thu Nov 07 08:23:39 2002] [error] [client 128.173.14.37] SUBMIT_DATE = Thu Nov 7 13:23:26 , referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 [Thu Nov 07 08:23:39 2002] [error] [client 128.173.14.37] APPROVED_DATE = Thu Nov 7 13:23:2, referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 , referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 [Thu Nov 07 08:23:39 2002] [error] [client 128.173.14.37] REVOKE_REASON = Private key compro, referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 [Thu Nov 07 08:23:39 2002] [error] [client 128.173.14.37] REVOKE_CERTIFICATE_DN = CN=DEV Vir, referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 [Thu Nov 07 08:23:39 2002] [error] [client 128.173.14.37] REVOKE_CERTIFICATE_NOTBEFORE = Nov, referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 [Thu Nov 07 08:23:39 2002] [error] [client 128.173.14.37] REVOKE_CERTIFICATE_NOTAFTER = Nov , referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 , referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 [Thu Nov 07 08:23:39 2002] [error] [client 128.173.14.37] REVOKE_CERTIFICATE_ISSUER_DN = CN=, referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 [Thu Nov 07 08:23:39 2002] [error] [client 128.173.14.37] REVOKE_CERTIFICATE_KEY_DIGEST = e4, referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3 [Thu Nov 07 08:23:39 2002] [error] [client 128.173.14.37] , referer: http://box176.pki.irm.vt.edu/~rootra-091/cgi-bin//ra/RAServer?cmd=viewCert&dataType=VALID_CERTIFICATE&key=3
###################################################################################################### here is one more scenario: when click on valid ca certificates on the RA side I get nothing and the apache error log has the following ################################################################################ [Thu Nov 07 08:30:28 2002] [error] [client 128.173.14.37] DBD::Pg::st execute failed: ERROR: Unable to identify an operator '>' for types 'text' and 'integer' at /home/rootra-091/OpenCA/modules//perl5/OpenCA/DBI.pm line 3077., referer: http://box176.pki.irm.vt.edu/~rootra-091/htdocs//ra/certs.html ############################################################################### Thanks in advance if you can help me out here -- 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: See the NEW Palm Tungsten T handheld. Power & Color in a compact size! http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en _______________________________________________ Openca-Users mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-users
