Re: [libdbi-devel] libdbi-drivers-0.8.1 to be released soon

[Markus H. <mar...@mh...>]

Hi Christian,

another bit of information. In another desperate attempt to see the
firebird driver run ok I've built the firebird server on FreeBSD from
the sources. The binary package I tried a while ago was broke as you
may recall. The more recent version from the ports tree works ok from
the command line, so I've got something new to play with.

However, there's two bad news:

1) The firebird driver as built from the 0.8.0 sources would crash
   applications that don't even use the firebird driver. The fact that
   the driver is loaded by libdbi is apparently enough to wreak havoc
   on an application even if it uses only e.g. the MySQL driver. This
   appears to be a problem with the FreeBSD pthreads implementation
   (which libfbclient.so depends on). I've changed acinclude.m4 in CVS
   to first try libc_r and then libpthread, this apparently fixes the
   problem. I have not seen this problem on Debian.

2) Using this version of Firebird on FreeBSD, I don't even get as far
   as to the create table failure that I saw on Debian (albeit without
   useful error messages, see my previous mail). test_dbi dumps core
   when trying to connect to the freshly created database:

#0  0x284fcce3 in THD_restore_specific () from /usr/local/lib/libfbclient.so.1
#1  0x28512120 in error () from /usr/local/lib/libfbclient.so.1
#2  0x2850bd2e in REM_attach_database () from /usr/local/lib/libfbclient.so.1
#3  0x284fec97 in isc_attach_database () from /usr/local/lib/libfbclient.so.1
#4  0x284deca8 in _dbd_real_connect () from /usr/local/lib/dbd/libfirebird.so
#5  0x284dd901 in dbd_connect () from /usr/local/lib/dbd/libfirebird.so
#6  0x28089f49 in dbi_conn_connect () from /usr/local/lib/libdbi.so.0
#7  0x0804980f in main (argc=1, argv=0xbfbfe7f4) at test_dbi.c:84

firebird.log contains two types of error messages (several entries for
each of these per crash):

yeti.mininet    Sun Sep 18 00:58:14 2005
        SERVER/process_packet: connection rejected for markus

yeti.mininet    Sun Sep 18 00:58:14 2005
        SERVER/process_packet: connect reject, server exiting


Once again, I can use the command-line client isql without any
problems. It is only through libdbi that I keep getting problems.

I'm sorry that I can't contribute much to fix these problems. If you
can make sense of the backtrace, or if you want me to test further
things on FreeBSD, just let me know.

regards,
Markus

Markus Hoenicka writes:
 > Hi Christian,
 > 
 > I've spent another two hours trying to sort this out but failed. Now I
 > have a closer understanding as to how firebird handles access control,
 > but at the moment this is only sufficient to create databases and
 > tables using the isql command-line tool.
 > 
 > The real bad thing is that firebird does not run at all on FreeBSD and
 > is broke on Debian. All error messages on Debian read like "cannot
 > format message" which means that the firebird.msg file is
 > corrupt. Therefore I don't get useful diagnostics when running
 > libdbi. Is there any platform where firebird actually runs? BTW I'm
 > running firebird 1.5.1. If you happen to use the same version, could
 > you send me your firebird.msg file? I'd just like to try.
 > 
 > Still I can't see why the test program should fail if other apps using
 > the firebird driver work. The test program is very simple and does not
 > attempt to do weird things. It must be possible to fix the test
 > program.
 > 
 > regards,
 > Markus
 > 
 > Christian M. Stamgren writes:
 >  > I guess, You have to take my word for it. Why the test program cant create 
 >  > tables have something to do with the user not having the right access 
 >  > permissions. I have tried to sort that out but failed. 
 >  > 
 > 
 > 
 > -- 
 > Markus Hoenicka
 > mar...@ca...
 > (Spam-protected email: replace the quadrupeds with "mhoenicka")
 > http://www.mhoenicka.de
 > 
 > 
 > 
 > -------------------------------------------------------
 > SF.Net email is sponsored by:
 > Tame your development challenges with Apache's Geronimo App Server. Download
 > it for free - -and be entered to win a 42" plasma tv or your very own
 > Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
 > _______________________________________________
 > libdbi-devel mailing list
 > lib...@li...
 > https://lists.sourceforge.net/lists/listinfo/libdbi-devel
 > 

-- 
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de