Hello,
I face the same problem initializing PostgreSQL database as you did, using
OpenCA PKI Version 1.1.1, OpenCA Tools Version 1.3.0, PostgreSQL- 9, Apache2
on Ubuntu server 11.04.
I saw in openca-base-1.1.1 src folder that the DBD::Pg package used is
DBD-Pg-2.16.1.tar.gz so I downloaded the latest version of DBD::Pg from cpan
(2.18.1). The problem was not solved. I also tried to build openCA from
scratch using DBD-Pg-2.18.1.tar.gz in the place of DBD-Pg-2.16.1.tar.gz in
the sources.
Unfortunately I still get the same mistake when I try to Initialize the
database:
Error Code: 10040
Error while initializing the database. Cannot create the table
ca_certificate. (error 20016: EXECUTE_FAILED (error 11111: Do not commit if
the database or the module itself fails. (error 11111: Do not commit if the
database or the module itself fails. (error 20016: EXECUTE_FAILED (error
11111: Do not commit if the database or the module itself fails. (error
20512: COMMIT_FAILED (error 11111: Do not commit if the database or the
module itself fails. (error 20016: EXECUTE_FAILED (error 11111: Do not
commit if the database or the module itself fails. (error 11111: Do not
commit if the database or the module itself fails. (error 20016:
EXECUTE_FAILED (error 11111: Do not commit if the database or the module
itself fails.))))))))))))
I have created a database openca with owner a superuser openca and a schema
openca and I have used the appropriate values in config.xml including
namespace openca.
<!-- ====================== -->
<!-- database configuration -->
<!-- ====================== -->
<option>
<name>dbmodule</name>
<value>DBI</value>
</option>
<option>
<name>db_type</name>
<value>Pg</value>
</option>
<option>
<name>db_name</name>
<value>openca</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>0p3nc@</value>
</option>
<option>
<name>db_namespace</name>
<value>openca</value>
</option>
Any ideas?
Thanks in advance
Raul Hernandez-3 wrote:
>
> Hello,
>
>
>
> After doing some research reading a lot of threads on different lists, I
> found the solution to my problem. I was using DBD::Pg Version 2.17.1 (the
> one that comes with Debian squeeze), and apparently that version of the
> module does a forking to create the OpenCA database structure, and that
> was
> causing the error. The solution in all lists is to either have the child
> process reconnect to the database with a fresh database handle, or to
> rewrite your application not to use use forking. I downloaded the latest
> version of DBD::Pg from cpan (2.17.2), and problem solved. Hope this can
> help others.
>
>
>
> Best regards,
>
>
>
> Raúl Hernández
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
> Openca-Users mailing list
> Openca-Users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/openca-users
>
>
--
View this message in context:
http://old.nabble.com/Error-initializing-Postgresql-Database---OpenCA-1.1.1-tp31172494p32279237.html
Sent from the openca-users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Get a FREE DOWNLOAD! and learn more about uberSVN rich system,
user administration capabilities and model configuration. Take
the hassle out of deploying and managing Subversion and the
tools developers use with it. http://p.sf.net/sfu/wandisco-d2d-2
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users
