Hi Sam,

I don't have this problem when using the random serial numbers.. have you
applied the patches for the 1.1.0 version available on the Wiki pages ?

Cheers,
Max


On 03/30/2010 09:40 AM, Samuel Hug wrote:
Hello there,

during the setup of my first OpenCA environment, I've run into problems 
downloading the very first CA Operator Certificate.
[Error 690 Configuration Error. Error 0, unable to get cert from dB! (Success 
(error 11111: Do not commit if the database or the module itself fails.)).]

To me it looks like a bug related to the newly introduced random serial numbers 
(OpenCA release 1.1.0).

The sql statements for selecting attributes from the certificate table are 
causing mysql to do implicit typecasting,
and this obviously has it's limitations with decimals of that size.

Example (my CA Operators Certificate serial 403586350459196298236820):

mysql>  select 403586350459196298236820='403586350459196298236820' \G
*************************** 1. row ***************************
403586350459196298236820='403586350459196298236820': 0
1 row in set (0.00 sec)

Is this bug already known? For the time being I jut disabled random serial 
numbers.

One approach would be to explicitly specify the datatypes for all the bind 
values. So the typecasting would not happen anymore.

Cheers
Sam


--

Best Regards,

        Massimiliano Pala

--o------------------------------------------------------------------------
Massimiliano Pala [OpenCA Project Manager]                   ope...@acm.org
                                                 project.mana...@openca.org

Dartmouth Computer Science Dept               Home Phone: +1 (603) 369-9332
PKI/Trust Laboratory                          Work Phone: +1 (603) 646-8734
--o------------------------------------------------------------------------
People who think they know everything are a great annoyance to those of us
who do.
                                                           -- Isaac Asimov

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Openca-Users mailing list
Openca-Users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openca-users

Reply via email to