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
> Openca-Users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/openca-users
>
------------------------------------------------------------------------------
Sell apps to millions through the Intel(R) Atom(Tm) Developer Program
Be part of this innovative community and reach millions of netbook users
worldwide. Take advantage of special opportunities to increase revenue and
speed time-to-market. Join now, and jumpstart your future.
http://p.sf.net/sfu/intel-atom-d2d
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users
