Hi Michael, I checked docs for my perl DBI and it states that: specific success code 00000 is converted to an empty string (false)
I use libdbd-pg-perl (1.41-1) to use DBI over Postgres and documentation states that it returns state "00000" in success. Seems that DBI is not converting "00000" to "" or my system is somehow misconfigured. Do you think that I should contact DBI dev team and ask them about it? Richard ______________________________________________________________ > Od: Michael Bell <[EMAIL PROTECTED]> > Komu: [email protected] > CC: > Datum: Sat, 30 Apr 2005 20:32:09 +0200 > Predmet: Re: [OpenCA-Devel] DBI.pm problem with state '00000' (OpenCA > 0.9.2.2, with Postgres) > > 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 > _______________________________________________________________ > --------------------------------------------------------- http://www.morfeo.sk/ - Morfeo.sk - Špecialista na vyhľadávanie na Slovensku! ------------------------------------------------------- This SF.Net email is sponsored by: NEC IT Guy Games. Get your fingers limbered up and give it your best shot. 4 great events, 4 opportunities to win big! Highest score wins.NEC IT Guy Games. Play to win an NEC 61 plasma display. Visit http://www.necitguy.com/?r _______________________________________________ OpenCA-Devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openca-devel
