The problem exists at DBI.pm , try searching for

 ## binding values to placeholders

and see the code , its easy to patch. if you don't know how, a new release will come out soon because of this error. Also you can try replacing the file with the same file from older version , but i dont know if this will work !

Στις 14/09/2013 21:39, ο/η Andreas Funk έγραψε:
Hello together,

I am facing the same problem as Nicolas. When I am trying to issue the certificate for the admin after initially installing the server, I receive the error

6295035[initServer:314] Cannot load CSR from the database.


As can be seen in the mysql debugs, the correct values are never sent to the database. There are only empty values submitted by openca when the CSR is generated:


130914 19:59:16  80 Connectopenca@localhost on openca
  80 Queryset autocommit=0
  80 QuerySET NAMES 'utf8'
  80 QuerySELECT rowid, req_key from request ORDER BY rowid DESC
  80 Queryselect * from request where req_key=''
80 Queryinsert into request ( req_key, data, format , status, cn, email, ra, role, public_key, notbefore, loa) VALUES ( '', '', '', '', '', '', '', '', '', '', '')
  80 Querycommit
  80 Queryrollback
  80 Quit

There is no entry in the openca stderr.log at that time.
I noticed that the CA certificate is stored in the file system correctly but the entry in the database is also only containing empty/NULL values although no error has been displayed when generating the self-signed certificate for the CA.

I have a fresh Ubuntu server installation set up yesterday and built the latest versions of the openca packages from source:

openca-base-1.5.0.tar.gz
openca-tools-1.3.0.tar.gz

I am using the following package versions:

apache2  2.2.22-6ubuntu5.1
libapache2-mod-perl2              2.0.7-3ubuntu1
libdbd-mysql-perl                      4.021-1
libdbi-perl                                   1.622-1
mysql-server  5.5.32-0ubuntu0.13.04.1
openssl 1.0.1c-4ubuntu8.1
perl                                              5.14.2-21


Ubuntu uname -a:

Linux openX 3.8.0-30-generic #44-Ubuntu SMP Thu Aug 22 20:54:42 UTC 2013 i686 i686 i686 GNU/Linux

Is there anyone who has already solved this problem and could help me/us?

Thank you very much in advance.

Regards,
Andreas





------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13.
http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk


_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users

------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13. 
http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users

Reply via email to