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

[Christian M. S. <cm...@ce...>]

Hi Markus,=20

On Sunday 18 September 2005 01.01, Markus Hoenicka wrote:
> 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=3D1,
> argv=3D0xbfbfe7f4) 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

I don't get these problems or error on my development platform (Linux Gento=
o).
That libdbi dumps core when a user have the wrong rights to connect is not =
the=20
right thing obviously. =20


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

Are you using isql as root?=20
Then you have =FCber-access rights, and can connect and perfrom task on eve=
ry=20
database on this server.=20


Its not the same thing as accessing the databases through the C API which u=
ses=20
the user you have supplied in your program.=20
Have you setupped a user with the gsec program?=20


I have just tested the "make check" option and on my platform with a user w=
ith=20
correct rights, libdbi can create tables.  Both from "make check"'s test=20
program and other applications written that uses libdbi.

I will spend some time today trying to get the test program to run on Linux=
=20
and then it should run on freebsd as well.=20



regards,=20

Christian