[Libpki-users] Error while storing CA cert to dB!

[Esteban L. <el...@so...>]

Hi everyone

Openca fail when try to generate caCert or more exactly when try to 
insert the certificate info in database.

Web Error
Error while storing CA cert to dB!

openca log

DBD::Pg::st execute failed: ERROR:  invalid input syntax for integer: "" 
at /etc/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3345.
doQuery: query: insert into openca.ca_certificate ( ca_cert_key, data, 
format , status, notbefore, notafter, dn, cn, email, public_key) VALUES 
( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Postgres log
dbdpg_p3691_2: insert into openca.ca_certificate ( ca_cert_key, data, 
format , status, notbefore, notafter, dn, cn, email, public_key) VALUES 
( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10)
2013-10-18 16:20:43 CDT [3692]: [20-1] db=atmCerts,user=openca 
LOCATION:  exec_parse_message, postgres.c:1385
2013-10-18 16:20:43 CDT [3692]: [21-1] db=atmCerts,user=openca ERROR:  
22P02: invalid input syntax for integer: ""

Certificates exist in
/etc/openca/var/openca/crypto

But there is and error because of a null parameter in DBI.pm

version openca-base-1.5.0 and openca-tools-1.3.0

Any advice is welcome