Robert Olson wrote:
>
> 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'
This is normal and not an error!!!
The first line (DBD::Pg::st execute failed ...) is a test to determine
the existence of the table because the initialization doesn't run in
FORCE-mode. Please look into the script generateCADB. The second line
(NOTICE: ...) is only a warning that the database creates an own primary
key where it is not established by the "create table"-statement. So no
real error occurs.
> 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).
This should be fixed on the cvs since several weeks. I think
Massimiliano uses an old version to build the snap. The debugging output
which shows some variables which are relevant for DB2 are no problem for
other databases.
If you still have problems you can try two different version from the
CVS:
* openca/openca-dbi
* openca/openca-0.9/src/modules/openca-dbi but here you must fix several
things
+ check one of the conf-files in
openca/openca-0.9/src/cgi-bin/cgi-*/conf/DBI.conf.in (new structure)
+ copy the initDBI (openca/openca-0.9/src/cgi-bin/cgi-*/lib/initDBI
OpenCA::DBI uses a debuggingswitch in DBI.conf. So if there are problems
please use the switch and send the output to me. This will help a lot.
Thanks Michael
-------------------------------------------------------------------
Michael Bell Email (private): [EMAIL PROTECTED]
Rechenzentrum - Datacenter Email: [EMAIL PROTECTED]
Humboldt-University of Berlin Tel.: +49 (0)30-2093 2482
Unter den Linden 6 Fax: +49 (0)30-2093 2959
10099 Berlin
Germany [OpenCA Core Developer]
http://openca.sourceforge.net
_______________________________________________
OpenCA-Devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-devel
