Menu
▾
▴
libdbi-devel
|
From: Markus H. <mar...@mh...> - 2005-09-11 19:57:17
|
Hi fellow-developers, I've spotted a bug that hits both the sqlite and the sqlite3 driver. In some cases the parser that isolates the field and table names in order to determine the data type of a field fails to get the table name right. This requires an update of the drivers as soon as possible. I intend to release 0.8.1 somewhere during the next week. I'll include Vadym's FreeTDS driver, although there is no feedback yet from someone else. My question is, is there any chance to include the Firebird and Oracle drivers too? I could spend a few hours during the next week trying to fix the Firebird driver, but there's nothing I can do about Oracle. Christian, Ashsish, please let me know about your plans. regards, Markus -- Markus Hoenicka mar...@ca... (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de |
|
From: Christian M. S. <cm...@ce...> - 2005-09-11 20:27:41
|
On Sunday 11 September 2005 21.44, Markus Hoenicka wrote: > Hi fellow-developers, > > I've spotted a bug that hits both the sqlite and the sqlite3 > driver. In some cases the parser that isolates the field and table > names in order to determine the data type of a field fails to get the > table name right. This requires an update of the drivers as soon as > possible. > > I intend to release 0.8.1 somewhere during the next week. I'll include > Vadym's FreeTDS driver, although there is no feedback yet from someone > else. My question is, is there any chance to include the Firebird and > Oracle drivers too? I could spend a few hours during the next week > trying to fix the Firebird driver, but there's nothing I can do about > Oracle. The firebird driver is working as it should. Its just the test program that doesn't work with firebird. I don't see that as a reason to not include it. About the Oracle driver. This driver worked good before the API changes for 8.0. So to get the Oracle driver up speed should be straight forward. Finally I'm starting to have some more time for projects like this again. So if somebody will just give me access to an Oracle server I will do the changes that is needed quickly. I would really like to include the patch from Henrique that brings uniform transaction support to libdbi included before the next release. I was just on my way to submit that patch to cvs. What do you think about that? Christian |
|
From: Markus H. <mar...@mh...> - 2005-09-11 20:43:03
|
Hi Christian, Christian M. Stamgren writes: > The firebird driver is working as it should. > Its just the test program that doesn't work with firebird. I don't see that as > a reason to not include it. > Ok, but the test program is currently my only way to test the driver. Last time I tried I was not able to create tables. Do you have a simple program on your box that is suitable to do some testing on Debian? > I would really like to include the patch from Henrique that brings uniform > transaction support to libdbi included before the next release. I was just on > my way to submit that patch to cvs. > > What do you think about that? > This would require moving to 0.9.0 two weeks after releasing 0.8.0. I'm afraid this is going to confuse packagers. So far I've seen 0.8.0 only as a Fink package, thanks to Peter O'Gorman. I'd suggest to invest some more work into 0.9.0. A couple of things come to mind, like support for sequences, a create_db() function which handles encoding stuff transparently and so on. regards, Markus -- Markus Hoenicka mar...@ca... (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de |
|
From: Christian M. S. <cm...@ce...> - 2005-09-12 07:54:46
|
Hi again, On Sunday 11 September 2005 22.41, Markus Hoenicka wrote: [..] > This would require moving to 0.9.0 two weeks after releasing > 0.8.0. I'm afraid this is going to confuse packagers. So far I've seen > 0.8.0 only as a Fink package, thanks to Peter O'Gorman. BTW, Gentoo have 0.8.0 included and support for Mysql, Oracle, Postgres and Sqlite drivers. Regards, Christian |
|
From: Markus H. <mar...@mh...> - 2005-09-12 09:07:06
|
"Christian M. Stamgren" <cm...@ce...> was heard to say: > BTW, Gentoo have 0.8.0 included and support for > Mysql, Oracle, Postgres and Sqlite drivers. > Oh, cool. Last time I talked to Ashish he told me the Oracle driver was not done yet. Apparently it works better than he thought. regards, Markus -- Markus Hoenicka mar...@ca... (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de |
|
From: Christian M. S. <cm...@ce...> - 2005-09-12 07:02:10
|
Hi Markus, On Sunday 11 September 2005 22.41, Markus Hoenicka wrote: > Hi Christian, > > Christian M. Stamgren writes: > > The firebird driver is working as it should. > > Its just the test program that doesn't work with firebird. I don't see > > that as a reason to not include it. > > Ok, but the test program is currently my only way to test the > driver. Last time I tried I was not able to create tables. Do you have > a simple program on your box that is suitable to do some testing on > Debian? No not at the moment. 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. Ofcourse I see the test program as a very good thing to have, but I really dont see that it should be used as the things that decides if a driver goes into stable or not. > I'd suggest to invest some more work into 0.9.0. A couple of things > come to mind, like support for sequences, a create_db() function which > handles encoding stuff transparently and so on. Ok fair enough. Is the CVS taged for 8.0 so that we can start to commit things that are going into 0.9? Regards, Christian |
|
From: Markus H. <mar...@mh...> - 2005-09-12 09:13:25
|
Hi Christian, "Christian M. Stamgren" <cm...@ce...> was heard to say: > 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. > > Ofcourse I see the test program as a very good thing to have, but I really > dont see that it should be used as the things that decides if a driver goes > into stable or not. > Please don't take me wrong. It's not like I'm saying I don't trust you that you have the driver working ok. The problem is, if even I as a libdbi developer can't get the driver to do the right thing for me, how should a plain user out there make good use of the driver? I promise I'll look into the access rights stuff again, it may very well be that got something wrong. But as things are at the moment, I can create tables from the command line, but not through the libdbi driver using the very same username/password combo. > Ok fair enough. Is the CVS taged for 8.0 so that we can start to commit > things > that are going into 0.9? > Yes, both libdbi and libdbi-drivers are tagged and ready for new commits. regards, Markus -- Markus Hoenicka mar...@ca... (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de |
|
From: Markus H. <mar...@mh...> - 2005-09-14 22:07:38
|
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 |
|
From: Markus H. <mar...@mh...> - 2005-09-17 23:02:46
|
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
|
|
From: Christian M. S. <cm...@ce...> - 2005-09-18 09:36:40
|
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 |
|
From: Markus H. <mar...@mh...> - 2005-09-18 16:18:01
|
Hi Christian,
Christian M. Stamgren writes:
> I don't get these problems or error on my development platform (Linu=
x Gentoo).
> That libdbi dumps core when a user have the wrong rights to connect =
is not the=20
> right thing obviously.
It is not yet clear to me whether the crash has something to do with
permissions. It could be a rather unrelated problem that is specific
to my platform or my setup. Remember that it does not crash for me on
Debian, although I may have the permissions wrong on both platforms.
=20
>=20
>=20
> > Once again, I can use the command-line client isql without any
> > problems. It is only through libdbi that I keep getting problems.
>=20
> Are you using isql as root=3F=20
> Then you have =FCber-access rights, and can connect and perfrom task=
on every=20
> database on this server.=20
>=20
No, I'm not running this as root. I use my regular user account. For
what it's worth, running test=5Fdbi as root does not help either.
>=20
> Its not the same thing as accessing the databases through the C API =
which uses=20
> the user you have supplied in your program.=20
> Have you setupped a user with the gsec program=3F=20
>=20
Initially I've only used gsec to equip the SYSDBA account with a new
password. I ran all tests using the SYSDBA user with that new
password. To exclude any problems specific to this account, I've also
created another account:
GSEC> display=20
user name uid gid full name
-----------------------------------------------------------------------=
-------------------
SYSDBA 0 0 =20
MARKUS 1000 1000 =20
The uid and gid match my system account. I've repeated all tests using
this account with the same results. I can create, access, and change
the libdbitest database using the isql tool, but not through libdbi.
As far as I understand the permission handling of Firebird, it makes a
difference whether I use a local connection or a TCP connection. I use
something like:
localhost:/home/markus/workspace/libdbi/firebird
as the path in the iSQL CONNECT command and
database directory=3F [.] /home/markus/workspace/libdbi/firebird
database hostname=3F [(blank for local socket if possible)] localhost
in test=5Fdbi. According to the docs this runs the server using its own=
account, not the users account. In my case, there is a firebird
user. I've added this user to my group and changed the permissions of
the above directory to group write access. This way the isql call
which initially creates the database under the firebird account is
allowed to do so. This actually results in a file created by
firebird:markus.
In order to exclude permission problems, I added a chmod call right
after the isql command to change the database file to write access for
all. test=5Fdbi still segfaults when trying to access the database.
>=20
> I have just tested the "make check" option and on my platform with a=
user with=20
> correct rights, libdbi can create tables. Both from "make check"'s =
test=20
> program and other applications written that uses libdbi.
>=20
> I will spend some time today trying to get the test program to run o=
n Linux=20
> and then it should run on freebsd as well.=20
>=20
Could you elaborate a little further on how you handle permissions=3F
Which user account and which permissions do you use=3F I may still miss=
a simple detail about the permission handling of firebird. I'm not
sure whether I really grasp how the UNIX file permissions and the SQL
permissions have to be set to allow me to connect.=20
regards,
Markus
--=20
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
|
|
From: Christian M. S. <cm...@ce...> - 2005-09-18 17:01:42
|
Hi Markus,
On Sunday 18 September 2005 18.03, Markus Hoenicka wrote:
[..]
> Initially I've only used gsec to equip the SYSDBA account with a new
> password. I ran all tests using the SYSDBA user with that new
> password. To exclude any problems specific to this account, I've also
> created another account:
>
> GSEC> display
> user name uid gid full name
> ---------------------------------------------------------------------------
>--------------- SYSDBA 0 0
> MARKUS 1000 1000
>
> The uid and gid match my system account. I've repeated all tests using
> this account with the same results. I can create, access, and change
> the libdbitest database using the isql tool, but not through libdbi.
>
> As far as I understand the permission handling of Firebird, it makes a
> difference whether I use a local connection or a TCP connection. I use
> something like:
I'm not a firebird export either. On my system the user I'm using for firebird
isn't a regular user and was created running gsec as root.
GSEC> display
user name uid gid full name
------------------------------------------------------------------------------------------
SYSDBA 0 0
TESTUSER 0 0
>
> localhost:/home/markus/workspace/libdbi/firebird
>
> as the path in the iSQL CONNECT command and
>
> database directory? [.] /home/markus/workspace/libdbi/firebird
>
> database hostname? [(blank for local socket if possible)] localhost
I can run the test program either with localhost or just empty doesn't mather.
I can also run the test program as any user on my system. As long as I use the
valid db user testuser as the user for libdbi.
1 drivers available: firebird
test which driver? firebird
database administrator name? testuser
database administrator password? testpassword
database directory? [.] /opt/firebird
database hostname? [(blank for local socket if possible)] localhost
database name? [libdbitest] test.fdb
>
> in test_dbi. According to the docs this runs the server using its own
> account, not the users account. In my case, there is a firebird
> user. I've added this user to my group and changed the permissions of
> the above directory to group write access. This way the isql call
> which initially creates the database under the firebird account is
> allowed to do so. This actually results in a file created by
> firebird:markus.
>
> In order to exclude permission problems, I added a chmod call right
> after the isql command to change the database file to write access for
> all. test_dbi still segfaults when trying to access the database.
>
> > I have just tested the "make check" option and on my platform with a
> > user with correct rights, libdbi can create tables. Both from "make
> > check"'s test program and other applications written that uses libdbi.
> >
> > I will spend some time today trying to get the test program to run on
> > Linux and then it should run on freebsd as well.
>
> Could you elaborate a little further on how you handle permissions?
> Which user account and which permissions do you use? I may still miss
> a simple detail about the permission handling of firebird. I'm not
> sure whether I really grasp how the UNIX file permissions and the SQL
> permissions have to be set to allow me to connect.
The crazy thing about this is that my setup looks as simple as yours.
I have only used Firebird on Gentoo (and Windows in the form of Interbase many
years ago).
I really can see what is going on here. One thing that might be mentioned is
that I run the server as a superserver. I don't know exactly whats the
difference between superserver and classicserver but ....
libdbi driver directory? [/usr/local/lib/dbd]
1 drivers available: firebird
test which driver? firebird
database administrator name? testuser
database administrator password? testpassword
database directory? [.] /opt/firebird
database hostname? [(blank for local socket if possible)] localhost
database name? [libdbitest] test.fdb
Driver information:
-------------------
Name: firebird
Filename: /usr/local/lib/dbd/libfirebird.so
Desc: Firebird/Interbase database support
Maintainer: Christian M. Stamgren <cm...@ce...>
URL: http://libdbi-drivers.sourceforge.net
Version: dbd_firebird v0.8.0
Compiled: Sep 18 2005
Use CONNECT or CREATE DATABASE to specify a database
CREATE DATABASE 'localhost:/opt/firebird/test.fdb' user 'testuser' password
'testpassword';
Successfully connected!
Using database engine version 1050247 (numeric) and 1.5.2.47 (string)
Test 1: List databases:
not yet implemented
Test 2: Create database test.fdb using default encoding:
This is a no-op with the sqlite/msql/firebird drivers.
Test 3: Select database:
Ok.
Test 4: Get encoding:
The database encoding appears to be: US-ASCII
Test 5: Create table:
Ok.
Test 6: List tables:
Got result, try to access rows
TEST_DATATYPES
Test 7: Insert row:
Ok.
Regards,
Christian
|
|
From: Markus H. <mar...@mh...> - 2005-09-18 19:48:15
|
Hi Christian, unfortunately there is no superserver port for FreeBSD. This may indeed be a part of the problem. I've also used the classic server on my Debian box. I'll try the superserver next week (Debian does have superserver packages). In any case, if the test program runs on your Linux box, I see my problems as porting problems rather than as driver problems. I agree with your cvs message that we should include the firebird driver in 0.8.1 and see what happens. regards, Markus Christian M. Stamgren writes: > I really can see what is going on here. One thing that might be mentioned is > that I run the server as a superserver. I don't know exactly whats the > difference between superserver and classicserver but .... > > -- Markus Hoenicka mar...@ca... (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de |
|
From: Markus H. <mar...@mh...> - 2005-09-19 19:59:13
|
Hi Christian,
I've installed the superserver on my Debian box, and finally I got it
to work. make test runs successfully without giving me these
permission headaches like the classic server did. I have no
explanation for this behaviour, but this should probably be mentioned
in the yet-to-be-written driver documentation or in the README.
The bad news is that the Retrieve data test produces a couple of
errors and mostly incorrect output. Partially the test program exceeds
firebird's builtin limits, so we have to adapt the test program. Other
errors, e.g. the binary string quoting, simply look broke:
Test 8: Retrieve data:
Got result, try to access rows
the_char errflag=3
the_uchar errflag=3
the_ulonlong: test skipped for this driver.
the_ulonlong: test skipped for this driver.
the_date errflag=5
the_time errflag=5
the_char: in:-127 out:0<<
the_uchar: in:127 out:0<<
the_short: in:-32768 out:-32768<<
the_ushort: in:32767 out:32767<<
the_long: in:-2147483648 out:-2147483648<<
the_ulong: in:2147483647 out:2147483647<<
the_longlong: in:-9223372036854775807 out:4621650893385983808<<
the_ulonglong: in:9223372036854775807 out:4618721243712313736<<
the_float: in:3.402823466E+38 out:3.400000e+37<<
the_double: in:1.7976931348623157E+307 out:1.700000e+307
the_driver_string: in:'Can 'we' "quote" this properly?' out:'Can 'we' "quote" this properly?'<<
the_conn_string: in:'Can 'we' "quote" this properly?' out:'Can 'we' "quote" this properly?'<<
the_datetime: in:'2001-12-31 23:59:59' out:1970-1-1 0:0:0
the_date: in:'2001-12-31' out:1970-1-1
the_time: in:'23:59:59' out:0:0:0
the_binary_string: in: 65-66-0-67-39-68- out: 1-64-65-255-66-38-67-<<
This is after updating to your latest checkins. Does this look the
same on your box? I'll see what I can do.
regards,
Markus
Markus Hoenicka writes:
> Hi Christian,
>
> unfortunately there is no superserver port for FreeBSD. This may
> indeed be a part of the problem. I've also used the classic server on
> my Debian box. I'll try the superserver next week (Debian does have
> superserver packages).
>
> In any case, if the test program runs on your Linux box, I see my
> problems as porting problems rather than as driver problems. I agree
> with your cvs message that we should include the firebird driver in
> 0.8.1 and see what happens.
>
--
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
|
|
From: Markus H. <mar...@mh...> - 2005-09-20 22:46:10
|
Hi Christian, I've spent an evening fixing the firebird driver, but now it works for me. I've adapted the test program to only use the types and ranges that firebird actually supports. I've fixed the handling of binary strings which are now returned ok. I've also fixed the handling of TIMESTAMP. The only thing I couldn't fix is that the client library seems to insist on using SQL dialect 1. No matter what I do, I can't create a table containing TIME or DATE columns (both are only supported in dialect 3). I tried issuing a SET SQL DIALECT 3 from test_dbi which doesn't change anything (the command works in isql). It would be nice to run this from within dbd_real_connect(). I have no ideas why this fails, and google won't tell me either. Any ideas? Unless you come up with an idea how to fix this, I'll release 0.8.1 tomorrow. regards, Markus Markus Hoenicka writes: > This is after updating to your latest checkins. Does this look the > same on your box? I'll see what I can do. > -- Markus Hoenicka mar...@ca... (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de |
|
From: Christian M. S. <cm...@ce...> - 2005-09-21 12:43:11
|
Hi Markus, I'm pretty sure there is something like an isc_dpb_sql_dialect option to isc_expand_dpb() which can be used in _dbd_real_connect() I will have a look at this tonight and see if I find the solution. Regards, Christian On Wednesday 21 September 2005 00.44, Markus Hoenicka wrote: > Hi Christian, > > I've spent an evening fixing the firebird driver, but now it works for > me. I've adapted the test program to only use the types and ranges > that firebird actually supports. I've fixed the handling of binary > strings which are now returned ok. I've also fixed the handling of > TIMESTAMP. > > The only thing I couldn't fix is that the client library seems to > insist on using SQL dialect 1. No matter what I do, I can't create a > table containing TIME or DATE columns (both are only supported in > dialect 3). I tried issuing a > > SET SQL DIALECT 3 > > from test_dbi which doesn't change anything (the command works in > isql). It would be nice to run this from within dbd_real_connect(). I > have no ideas why this fails, and google won't tell me either. Any > ideas? > > Unless you come up with an idea how to fix this, I'll release 0.8.1 > tomorrow. > > regards, > Markus > > Markus Hoenicka writes: > > This is after updating to your latest checkins. Does this look the > > same on your box? I'll see what I can do. -- Christian M. Stamgren | COO; Head of development Direct: +46 (0)8-410 446 01 | Mobile: +46 (0)708-50 74 01 E-mail: cm...@ce... Internet: www.cention.se Cention AB | PO Box 3326 | SE-103 66 Stockholm | Sweden Visiting address: Birger Jarlsgatan 20 | SE-114 34 Stockholm Phone: +46 (0)8-410 446 00 | Fax: +46 (0)8-656 49 00 |
Thanks for helping keep SourceForge clean.
X