What's the right way to set up OpenCA-SNAP-20010818 for DBI use? I don't see an option in the Makefile there, and there doesn't appear anything in the install scripts referring to that. I changed the various .conf files on the caserver, and it seems to have almost worked, but a db initialize left errors in the web server log:
DBD::Pg::st execute failed: ERROR: Relation 'log' does not exist NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'log_pkey' for table 'log' DBD::Pg::st execute failed: ERROR: Relation 'crl' does not exist NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'crl_pkey' for table 'crl' DBD::Pg::st execute failed: ERROR: Relation 'openca_log_sequence' does not exist DBD::Pg::st execute failed: ERROR: Relation 'crr' does not exist NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'crr_pkey' for table 'crr' DBD::Pg::st execute failed: ERROR: Relation 'certificate' does not exist NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'certificate_pkey' for table 'certificate' DBD::Pg::st execute failed: ERROR: Relation 'signature' does not exist NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'signature_pkey' for table 'signature' DBD::Pg::st execute failed: ERROR: Relation 'ca_certificate' does not exist NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'ca_certificate_pkey' for table 'ca_certificate' DBD::Pg::st execute failed: ERROR: Relation 'request' does not exist NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'request_pkey' for table 'request' I also had to comment out hte block of code in OpenCA::DBI that referred to DB2 and used DBD::DB2::Constants, as I don't have a DB2 system (using postgres here). Reason I tried to switch to DBI was that with DB, I was able to create server certs on the CA, export them & install on the RAserver web server. I was also able to create an RA operator cert & export to browser, and set up access control on RAserver. However, when I try to approve a certificate request I get to the "Confirm Request Approval" page, click Approve Request, and the browser (IE) says "Error on page". Hm. On my netscape browser, where I have the RA operator certificate installed, pressing that button gives me a signing dialog. When I say to go ahead with signing the request, the dialog goes away and leaves me back at the same "Confirm Request Approval" page. The request remains in the pending queue. --bob thanks, --bob _______________________________________________ OpenCA-Devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/openca-devel
