Hi,
João Henrique Freitas writes:
> [a long long test case]
>
> Completed "libdbi tests": 365 passes, 6 failures, 0 exceptions.
>
Wish I'd get there!
> The set_driver_options() and ask_for_conninfo() are functions to
> control user input and choices. Could you copy and cut a session
> error?
>
Ok, here goes:
libdbi-drivers test program: $Id: test_dbi_cgreen.c,v 1.1.2.1 2009/02/27
01:22:56 joaohf Exp $
test recallable (r) or legacy (l) libdbi interface? [r]
libdbi driver directory? [/usr/local/lib/dbd]
5 drivers available: mysql pgsql sqlite sqlite3 firebird
test which driver? mysql
database administrator name? root
database administrator password? [the right one]
database hostname? [(blank for local socket if possible)]
database name? [libdbitest]
encoding? [UTF-8]
Connection information:
--------------------
Legacy mode: 0
Driverdir: /usr/local/lib/dbd
Drivername: mysql
Dbdir:
Initial Database: mysql
Database: libdbitest
Username: root
Password: [the right one]
Hostname: localhost
Version:
Initial tables schema: CREATE TABLE test_datatypes ( the_char
TINYINT,the_uchar TINYINT,the_short SMALLINT,the_ushort SMALLINT,the_long
INT,the_ulong INT,the_longlong BIGINT,the_ulonglong BIGINT,the_float
FLOAT4,the_double FLOAT8,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 DATETIME,the_datetime_tz DATETIME,the_date DATE,the_time
TIME,the_time_tz TIME,id INT AUTO_INCREMENT,PRIMARY KEY (id))
Initial data schema: INSERT INTO test_datatypes
(the_char,the_uchar,the_short,the_ushort,the_long,the_ulong,the_longlong,the_ulonglong,the_float,the_double,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_datetime_tz,the_date,the_time,the_time_tz)
VALUES
(-127,127,-32768,32767,-2147483648,2147483647,-9223372036854775807,9223372036854775807,3.402823466E+38,1.7976931348623157E+307,'Can
\'we\' "quote" this properly?','Can \'we\' "quote" this properly?','Can \'we\'
"escape" this properly?','Can \'we\' "escape" this
properly?','-54321','',NULL,'AB\0C\'D','AB\0C\'D','2001-12-31
23:59:59','2001-12-31 23:59:59 -10:00','2001-12-31','23:59:59','23:59:59-10:00')
Beggin tests:
--------------------
Running "libdbi tests"...
Could not connect. Please check the option settings
FAIL: test_dbi
===================
1 of 1 tests failed
===================
> I tested with Postgresql, Mysql, SQlite and DB2.
>
> Some things:
>
> Could you connect with successfully in Mysql or Postgresql?, without
> the tests. Like: 'mysql -h localhost -u root -proot [database]'
>
Yes, I can connect to both engines using their clients. Also, as I've
mentioned previously I can connect to both engines through the very same
libdbi drivers if I use the test program in HEAD, or any other program
linked against libdbi.
> I need to test with Freebsd (you used it to make this test?) , but it
> should work too.
Yes, there is no particular reason why this should fail on FreeBSD. Do
your tests rely on any features not present in MySQL 5.0 or PostgreSQL
8.0?
>
> You can set the error level in Mysql and Postgresql. This will be nice
> to see what happens.
>
I did that for MySQL. Running gmake check as described above creates a
single line in the log like this:
090310 22:37:54 1 Connect r...@localhost on libdbitest
There is no indication of an error. BTW passing an incorrect password
causes a connection error which is faithfully listed in the log, so
wer're certainly not looking at some authentication problem. I
take from this, and from the fact that both the mysql and pgsql
drivers fail, that it is not a database engine problem, but rather
some weird problem within libdbi or libdbi-drivers. It drives me nuts
that I can't get this to work after years of fiddling with libdbi.
I'll try and add a couple of debug printf()s to the test program in
order to see whether something strange happens. Otherwise, I'm pretty
clueless right now.
regards,
Markus
--
Markus Hoenicka
[email protected]
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Libdbi-drivers-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
