[Libdbi-drivers-devel] firebird: linux experience with the current cvs version of the driver
Dear Markus, dear Developers, I'm sorry for the delay in my communication. Let me describe my experience with the firebird driver in the current cvs version. Unfortunately it does not yet work perfectly. Platform: xubuntu 9.04 Jaunty Jackalope on an Intel Atom based machine Firebird: LI-V2.1.1.17910 Firebird 2.1 (I have upgraded the linux distro, but Firebird 2.0 is not currently installable on this particular Ubuntu due to a package dependency bug. So I had to switch to 2.1. However, a week ago I had the very same experience with 2.0 as well.) So the details: Libdbi autogen.sh and ./configure runs perfectly. make has some problems with the documentation: -- make[2]: Entering directory `/home/kmatyas/software/libdbi/install_cvs/libdbi/doc' make[2]: *** No rule to make target `libdbi-versioning.sgml', needed by `programmers-guide.pdf'. Stop. make[2]: Leaving directory `/home/kmatyas/software/libdbi/install_cvs/libdbi/doc' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/kmatyas/software/libdbi/install_cvs/libdbi' make: *** [all] Error 2 -- After using ./configure --disable-docs it compiles. libdbi-drivers: autogen.sh ./configure --with-firebird --with-mysql --disable-docs (disable docs for the same reasons as above, though the problems with the doc reported by make are different) it compiles and make install works. Then I tried make check with the result below. It should be still some memory management issue. - libdbi-drivers test program: $Id: test_dbi.c,v 1.57 2008/08/06 21:55:18 mhoenicka Exp $ test recallable (r) or legacy (l) libdbi interface? [r] libdbi driver directory? [/usr/local/lib/dbd] 2 drivers available: mysql firebird test which driver? firebird database administrator name? sysdba database administrator password? masterkey database directory? [DEFAULT] /var/databases database hostname? [(blank for local socket if possible)] localhost database name? [libdbitest] Library information: Current:1 Revision: 0 Age:1 Version string: libdbi v0.9.0-pre1 Driver information: --- Name: firebird Filename: /usr/local/lib/dbd/libdbdfirebird.so Desc: Firebird/Interbase database support Maintainer: Christian M. Stamgren c...@cention.se URL:http://libdbi-drivers.sourceforge.net Version:dbd_firebird v0.9.0-pre1 Compiled: May 5 2009 Use CONNECT or CREATE DATABASE to specify a database CREATE DATABASE 'localhost:/var/databases/libdbitest'; Successfully connected! Using database engine version 2010279 (numeric) and 2.1.1.179 (string) Test 1: List databases: not yet implemented Test 2: Run driver-specific function: not yet implemented for this driver Test 3: Create another connection: Successfully opened another connection! Using database engine version 2010279 (numeric) and 2.1.1.179 (string) Successfully closed second connection Test 4: List databases: not yet implemented Test 5: Create database libdbitest using default encoding: This is a no-op with the sqlite/msql/firebird/ingres drivers. Test 6: Select database: Ok. Test 7: Get encoding: The database encoding appears to be: US-ASCII Test 8: Create table: libdbi: [query] CREATE TABLE test_datatypes ( the_char SMALLINT,the_uchar SMALLINT,the_short SMALLINT, the_ushort SMALLINT,the_long INTEGER,the_ulong INTEGER, the_float FLOAT,the_double DOUBLE PRECISION, the_driver_string VARCHAR(255),the_conn_quoted_string VARCHAR(255),the_conn_quoted_string_copy VARCHAR(255),the_conn_escaped_string VARCHAR(255),the_conn_escaped_string_copy VARCHAR(255),the_numstring VARCHAR(255),the_empty_string VARCHAR(255),the_null_string VARCHAR(255), the_binary_quoted_string BLOB,the_binary_escaped_string BLOB,the_datetime TIMESTAMP, the_date DATE,the_time TIME,id INTEGER NOT NULL PRIMARY KEY) Ok. Test 9: List tables: Got result, try to access rows TEST_DATATYPES Test 10: Run driver-specific function parameters: not yet implemented for this driver Test 11: Insert row: libdbi: [query] INSERT INTO test_datatypes (the_char,the_uchar,the_short, the_ushort,the_long,the_ulong,the_float,the_double, the_driver_string,the_conn_quoted_string,the_conn_quoted_string_copy,the_conn_escaped_string,the_conn_escaped_string_copy,the_numstring,the_empty_string,the_null_string,the_binary_quoted_string, the_binary_escaped_string, the_datetime,the_date,the_time,id) VALUES (-127,127,-32768,32767,-2147483648,2147483647, 3.4e+37,1.7e+307,'Can ''we'' quote this properly?','Can ''we'' quote this properly?','Can ''we'' quote this
Re: [Libdbi-drivers-devel] firebird: linux experience with the current cvs version of the driver
Hi Matyas, Quoting Dr. Matyas Koniorczyk koni...@gmail.com: Then I tried make check with the result below. Thanks for the report. Unfortunately I cannot reproduce this on FreeBSD, and valgrind does not indicate any such buffer overflow. I'll try to repeat my tests on a Debian box. It is hard to fix something which you can't reproduce. regards, Markus -- Markus Hoenicka markus.hoeni...@cats.de (Spam-protected email: replace the quadrupeds with mhoenicka) http://www.mhoenicka.de -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
Re: [Libdbi-drivers-devel] cgreen test problems [was: DB2 driver]
See http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html Item 4.1.2.1. In test_dbi_cgreen.c:803 I use: E'AB000C''D', E'AB000C''D', In pgsql 8.0 it is no supported. May be I need to change it? 2009/5/1 Markus Hoenicka markus.hoeni...@mhoenicka.de: João Henrique Freitas writes: What is our postgresql version? mar...@yeti:~# psql --version psql (PostgreSQL) 8.0.19 What do you run? regards, Markus -- Markus Hoenicka markus.hoeni...@cats.de (Spam-protected email: replace the quadrupeds with mhoenicka) http://www.mhoenicka.de -- --- João Henrique Freitas - joaohf_at_gmail.com Campinas-SP-Brasil BSD051283 LPI 1 http://www.joaohfreitas.eti.br -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
Re: [Libdbi-drivers-devel] cgreen test problems [was: DB2 driver]
Hello, 6) sqlite and sqlite 3 report 6 failures. Two stem from the test_dbi_result_field_is_null(_idx) tests which may actually indicate driver bugs. I'll look into that. The remainder are the problems mentioned above. I have a lot of failures with sqlite and sqlite3. Can you retest with these drivers and report to me? Thanks -- --- João Henrique Freitas - joaohf_at_gmail.com Campinas-SP-Brasil BSD051283 LPI 1 http://www.joaohfreitas.eti.br -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
Re: [Libdbi-drivers-devel] sqlite selects for bigint return 0
Hi, Using old tests: Library information: Current:1 Revision: 0 Age:1 Version string: libdbi v1.0-pre2 Driver information: --- Name: sqlite3 Filename: /usr/local/lib/dbd/libdbdsqlite3.so Desc: SQLite3 database support (using libsqlite3) Maintainer: Markus Hoenicka mhoeni...@users.sourceforge.net URL:http://libdbi-drivers.sourceforge.net Version:dbd_sqlite3 v0.9.0-pre1 Compiled: Apr 25 2009 the_longlong: in:-9223372036854775807 out:0 the_ulonglong: in:9223372036854775807 out:0 The the_longlong is BIGINT. 2009/5/2 Markus Hoenicka markus.hoeni...@mhoenicka.de: Mariusz Mazur writes: I assume sqlite is mostly off the radar and just seen as legacy, but I think this should at least get a mention in bacula's docs: sqlite via libdbi is majorly broken (standard 686 platform). Reason is this: selects for bigints (and bacula's volume sizes are bigints) always return a 0 no matter what the actual value is. I've confirmed this using bacula's debugging output (the native 'sqlite' client showed correct values with the exact same SELECT), but didn't bother I cannot confirm this problem on a FreeBSD box. Running gmake check in libdbi-drivers (current cvs revision) tells me that the sqlite driver stores and retrieves all sizes of integers ok, including long long int and unsigned long long int. I cannot find changes since 0.8.3 which would affect this behaviour either. Is there some specific problem with using the sqlite driver with bacula? regards, Markus -- Markus Hoenicka markus.hoeni...@cats.de (Spam-protected email: replace the quadrupeds with mhoenicka) http://www.mhoenicka.de -- --- João Henrique Freitas - joaohf_at_gmail.com Campinas-SP-Brasil BSD051283 LPI 1 http://www.joaohfreitas.eti.br -- The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com ___ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel