Hi Max,
On Mar 30, 2010, at 4:52 PM, Massimiliano Pala wrote:
> 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 ?
Yes I've applied the patches, DBI.pm has revision 1.39.
As the serials are random, your certificate could have a serial that is not
causing this problem.
For example: I've got two certificates, number 2 works, number 1 actually
causes the problem:
mysql> select rowid, cert_key from certificate;
+-------+--------------------------+
| rowid | cert_key |
+-------+--------------------------+
| 1 | 403586350459196298236820 |
| 2 | 496779211446872691162175 |
+-------+--------------------------+
2 rows in set (0.00 sec)
Selecting certificate 2: passing cert_key as string (as OpenCA does).
works
mysql> select rowid, cert_key, role from certificate where
cert_key='496779211446872691162175';
+-------+--------------------------+-------------+
| rowid | cert_key | role |
+-------+--------------------------+-------------+
| 2 | 496779211446872691162175 | CA Operator |
+-------+--------------------------+-------------+
1 row in set (0.00 sec)
Selecting certificate: passing cert_key as string (as OpenCA does).
doesn't work. if somebody has a explanation, I'm really interested. ;-)
mysql> select rowid, cert_key, role from certificate where
cert_key='403586350459196298236820';
Empty set (0.00 sec)
Selecting certificate 1: passing cert_key as decimal, so mysql doesn't have to
typecast
works
mysql> select rowid, cert_key, role from certificate where
cert_key=403586350459196298236820;
+-------+--------------------------+-------------+
| rowid | cert_key | role |
+-------+--------------------------+-------------+
| 1 | 403586350459196298236820 | CA Operator |
+-------+--------------------------+-------------+
1 row in set (0.00 sec)
Cheers
Sam
------------------------------------------------------------------------------
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
