Hi Richard,
[EMAIL PROTECTED] wrote:
I'm not sure if my problem belongs to devel list so I'm sorry if not.
Such exact descriptions (nearly patches) are definitely the right thing for this list.
I'm getting: Error 700 (Database failed with errorcode 20032. SELECT_FAILED) when I want to request first certificate for CA Operator during initialization. DB is set up correctly and user openca is owner and has all permissions on tables.
I found out that problem is everywhere where is this code in DBI.pm: $self->{STH}[scalar (@{$self->{STH}}) -1]->state
When it returns '00000' Perl takes it as TRUE and author of the code took it as FALSE.
Uups, I'm the author. The DBI documentation defines that ->state returns '' if the state is '00000'. Therefore I expect a false value if the returncode is '00000' (please see "man DBI"). If state return '00000' then this is a bug in DBI or the Pg driver.
If I use $self->{STH}[scalar (@{$self->{STH}}) -1]->state ne '00000' everywhere in DBI.pm it is functioning OK and I can continue in initialization.
My system: Debian unstable (kernel 2.6.8-1) perl 5.8.4-8 libdbi-perl 1.46-6
My DBI version is 1.32. Can you please check you DBI manual for the documentation of the state function. Perhaps the guys changed the specification. This would require that we/I code a mapping for OpenCA which can tolerate both return values.
I know that problem is somewhere between keyboard of my PC and back of
my chair, but I spent one day with debugging and searching problem in
database or access rights and found only this solution. Can someone tell me what I'm doing wrong?
If state really returns '00000' then this is a real problem for OpenCA (sometimes called bug) which must be fixed in HEAD and production code.
Thanks for your time
Michael -- _______________________________________________________________
Michael Bell Humboldt-Universitaet zu Berlin
Tel.: +49 (0)30-2093 2482 ZE Computer- und Medienservice Fax: +49 (0)30-2093 2704 Unter den Linden 6 [EMAIL PROTECTED] D-10099 Berlin _______________________________________________________________
smime.p7s
Description: S/MIME Cryptographic Signature
