Re: [Openca-Users] problem with autos

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Hi Max,

Sorry for the late reply.
The version is 1.1.0 from Binary Deb on Ubuntu 9.10.

I Have install all fixes as described in the Wiki and upgrade the DB
(running on Mysql 5.1.37),
restarted OpenCA but it is still not working .

Bellow are the logs after applying the fixes.

Logs generated when upgrading the DB.
---------------------------------------
DBD::mysql::st execute failed: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'DECIMAL (60, 0)' at line 1 at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Can't create table 'openca.#sql-dfd_3d5'
(errno: 150) at /opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm
line 3220.
DBD::mysql::st execute failed: Can't create table 'openca.#sql-dfd_3d5'
(errno: 150) at /opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm
line 3220.
DBD::mysql::st execute failed: Can't create table 'openca.#sql-dfd_3d5'
(errno: 150) at /opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm
line 3220.
DBD::mysql::st execute failed: Duplicate column name 'rowid' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'notbefore' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'suspended_after'
at /opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'revoked_after' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '' at line 1 at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'rowid' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'rowid' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'notbefore' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'notafter' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'approved_after' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'deleted_after' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'archivied_after'
at /opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'owner' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'rowid' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'notbefore' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'notafter' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'approved_after' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'deleted_after' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'archivied_after'
at /opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'owner' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'ca_cert_key' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'rowid' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'rowid' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'rowid' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'notbefore' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'suspended_after'
at /opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'revoked_after' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'invalidity_reason'
at /opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'owner' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
DBD::mysql::st execute failed: Duplicate column name 'rowid' at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.

Logs generated when enabling AutoCrl Issuing
---------------------------------------

CRL::Found Entry -> 0517A14DA96FF6429ECB (1)
CRL::Found Entry -> 4EDF5F6B3F957D313A95 (3)
CRL::Found Entry -> 97C3FF26F184FDD73C77 (5)
CRL::Found Entry -> 0517A14DA96FF6429ECB (1)
CRL::Found Entry -> 4EDF5F6B3F957D313A95 (3)
CRL::Found Entry -> 97C3FF26F184FDD73C77 (5)
CRL::Found Entry -> 0517A14DA96FF6429ECB (1)
CRL::Found Entry -> 4EDF5F6B3F957D313A95 (3)
CRL::Found Entry -> 97C3FF26F184FDD73C77 (5)
DBD::mysql::st execute failed: MySQL server has gone away at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3220.
autoCRLProcess()::ERROR::Can not store CRL in DB!
DBD::mysql::db commit failed: MySQL server has gone away at
/opt/openca/lib/openca/perl_modules/perl5/OpenCA/DBI.pm line 3460.
CRL::Found Entry -> 0517A14DA96FF6429ECB (1)
CRL::Found Entry -> 4EDF5F6B3F957D313A95 (3)
CRL::Found Entry -> 97C3FF26F184FDD73C77 (5)
CRL::Found Entry -> 0517A14DA96FF6429ECB (1)
CRL::Found Entry -> 4EDF5F6B3F957D313A95 (3)
CRL::Found Entry -> 97C3FF26F184FDD73C77 (5)
CRL::Found Entry -> 0517A14DA96FF6429ECB (1)
CRL::Found Entry -> 4EDF5F6B3F957D313A95 (3)
CRL::Found Entry -> 97C3FF26F184FDD73C77 (5)

---------------------------------------

Thank you.

--
Fred.

On 08/21/2010 04:57 PM, Massimiliano Pala wrote:
> Hi Fred,
>
> the issue has been fixed some time ago - which version of OpenCA are
> you using ?
> It is important that you apply all the patches available for your
> version. Also,
> can you send me the errlog file ?
>
> Later,
> Max
>
>
> On 08/21/2010 06:30 AM, Frederic d'Huart wrote:
>> Hi Massimiliano,
>>
>> Regarding the following discussion:
>>
>> http://sourceforge.net/mailarchive/forum.php?thread_name=4B835C8B.7060107%40cs.dartmouth.edu&forum_name=openca-users
>>
>>
>> I'm also having the same issue with the Autos not starting and
>> exactly the same log is generated.
>>
>> I try to update DBI.pm using this fix :
>> http://ftp.openca.org/openca-base/fixes/v1.1.0/dbi_issues/DBI.pm
>> I Restarted OpenCA But still the same issue.
>>
>> Concerning the "three different db handles", did you eventually
>> already released a fix ?
>> Would be really appreciated.
>>
>>
>> Thank you.
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by 
>
> Make an app they can't live without
> Enter the BlackBerry Developer Challenge
> http://p.sf.net/sfu/RIM-dev2dev 
>
>
> _______________________________________________
> Openca-Users mailing list
> Ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openca-users
>   

Re: [Openca-Users] problem with autos

Open Source PKI solutions

Re: [Openca-Users] problem with autos