Hello,
The machine configuration is the following:
OS: Debian Sarge
OpenCA: 0.9.2.2
perl: 5.8.4
openssl: 0.9.7e
postgresql: 7.4.7
We have a REQUEST_FAILED error while generating the request for a CA Administrator with DBI PostgreSQL backend:
Basic Certificate Request -> Confirm Certificate Request
Error 700 : General Error Database failed with errorcode 20032. SELECT_FAILED
This error doesn't happened with a DB backend or on another Debian Linux machine with the same configuration.
The PostgreSQL configuration and the OpenCA DBI configuration seem to be correct. Here they are below:
$ psql -l
List of databases
Name | Owner | Encoding
-----------+----------+----------
openca-ca | openca | LATIN1
template0 | postgres | LATIN1
template1 | postgres | LATIN1
openca-ca=# \d
List of relations
Schema | Name | Type | Owner
--------+----------------+-------+--------
public | ca_certificate | table | openca
public | certificate | table | openca
public | crl | table | openca
public | crr | table | openca
public | request | table | openca
(5 rows)
<option>
<name>dbmodule</name>
<!-- you can use DB or DBI -->
<value>DBI</value>
</option>
<option>
<name>db_type</name>
<value>Pg</value>
</option>
<option>
<name>db_name</name>
<value>openca-ca</value>
</option>
<option>
<name>db_host</name>
<value>localhost</value>
</option>
<option>
<name>db_port</name>
<value>5432</value>
</option>
<option>
<name>db_user</name>
<value>openca</value>
</option>
<option>
<name>db_passwd</name>
<value>a2d</value>
</option>
<option>
<name>db_namespace</name>
<value></value>
</option>
We have given access to everyone in the pg_hba.conf file and it's possible to do "psql -h localhost -d openca-ca -U openca" without any restrictions.
A GZIP part of the stderr.log is also attached.
Could someone please try to explain what could be wrong?
Thanks,
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez le ici !
stderr.log.gz
Description: 1388319339-stderr.log.gz
