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 Connect   openca@localhost on openca
                   80 Query     set autocommit=0
                   80 Query     SET NAMES 'utf8'
                   80 Query     SELECT rowid, req_key from request ORDER BY 
rowid DESC
                   80 Query     select * from request where req_key=''
                   80 Query     insert into request ( req_key, data, format , 
status, cn, email, ra, role, public_key, notbefore, loa) VALUES ( '', '', '', 
'', '', '', '', '', '', '', '')
                   80 Query     commit
                   80 Query     rollback
                   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

Reply via email to