I can't find working libdbi version

[John Ralls]

On Jan 26, 2011, at 3:59 PM, Christoph Holtermann wrote:

> Am 25.01.2011 17:54, schrieb John Ralls:
>> On Jan 25, 2011, at 8:18 AM, Christoph Holtermann wrote:
>> 
>>> Hello !
>>> 
>>> The recent SVN Version got a test for libdbi versions with what gnucash doesn't
>>> work. I have been using this non-stable combination for quite a while with only
>>> few data loss ;-) I am now forced to change the libdbi which i have been trying
>>> for quite some time yesterday but i can't make that error message disappear.
>>> 
>>> I am using OpenSuSe 11.3 but before i used factory so my system may not be
>>> clean. I tried the rpms i could find but i didn't find any that made it through
>>> GnuCashs test and i was stuck with the error message.
>>> 
>>> My database is MySql. SVN is 20166.
>>> 
>>> Then i tried to compile libdbi and libdbi-devel myself. The current versions that
>>> could be downloaded didn't go through either. But trying this i also got stuck
>>> because GnuCash wasn't even able to parse the SQL. I guess that's because
>>> the libraries were not found.
>>> 
>>> Then i went to the developer versions of libdbi at cvs. Make check of libdbi-drivers
>>> doesn't get through, breaks with
>>> 
>>> make[3]: Entering directory `/usr/local/src/libdbi-drivers/tests'
>>> gcc -DHAVE_CONFIG_H -I. -I.. -I.. -I../include -I../tests/cgreen/include -I/usr/include -DDBDIR=\"/usr/var/lib/libdbi\" -DDBI_DRIVER_DIR=\"/usr/lib/dbd\" -g -MT test_dbi.o -MD -MP -MF .deps/test_dbi.Tpo -c -o test_dbi.o test_dbi.c
>>> test_dbi.c:46:10: error: expected ‘=’, ‘,’, ‘;’, ‘asm’ or ‘__attribute__’ before ‘dbi_instance’
>>> ...
>>> there come a lot of further errors.
>>> 
>>> When i make and install them though at least GnuCash parses SQL correctly, so it uses the
>>> libraries and i get through to this nice error message.
>>> I got some confusion because i tried to compile and install different versions of libdbi. I think
>>> i cleaned things up correctly though and when i use
>>> strace gnucash
>>> after searching different locations for libdbi like
>>> ...
>>> open("/usr/lib/sse2/libdbi.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
>>> stat64("/usr/lib/sse2", 0xbf91a1b4) = -1 ENOENT (No such file or directory)
>>> open("/usr/lib/libdbi.so.1", O_RDONLY) = 5
>>> read(5, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0P:\0\0004\0\0\0"..., 512) = 512
>>> ...
>>> it reads the file /usr/lib/libdbi.so.1 which is a link to libdbi.so.1.1.0. And this should be the
>>> correct file for the cvs version.
>>> 
>>> It seems to me that i now use the most recent version of libdbi and libdbi-drivers and that doesn't
>>> make it through the test. I tried "make debug" for both. It didn't help.
>>> 
>>> By the way :
>>> 
>>> make check for GnuCash stops with the following :
>>> TEST: test-qof... (pid=19210)
>>> /qof/qofbook: OK
>>> /qof/qofinstance: **
>>> ERROR:test-qofinstance.c:55:test_book_readonly: assertion failed: (!qof_begin_edit( fixture->instance ))
>>> FAIL
>>> GTester: last random seed: R02S89f22d5b966baeb8f7ef6e1fb67c2a4d
>>> /bin/sh: Zeile 1: 19209 Beendet gtester --verbose test-qof
>>> make[5]: *** [test] Fehler 143
>>> 
>>> I don't know any further. Maybe someone can help ?
>> Oops. The failing test is my fault; I took out what it tests and forgot to remove the test. I'll fix that today.
>> 
>> In order to get libdbi to work, you have to edit configure and change the CFLAGS to not use -ffast-math or use "make debug" to build a debug library; the CFLAGS for debug don't include -ffast-math. Unfortunately, they wrote their configure to ignore CFLAGS passed in on the command line or in the environment.
> make debug doesn't work for me...
> 
> I tried some versions of libdbi. Combinations which let me come through to the error message
> reporting the nonworking libdbi were :
> 
> libdbi CVS & libdbi-driver CVS    (- the sqlite3 driver didn't compile here though, but i only need mysql so i don't care)
> libdbi 0.8.4 & libdbi-drivers-0.8.3-1 ( compiles fine )
> 
> (Other combinations stopped even before that. GnuCash told me that the url could not be parsed.)
> 
>> Debian provides a prebuilt debug version (libdbi-debug). Perhaps Suse does too, and you could use that.
> I didn't find something like that. I don't know if it would work if try to use debian binaries. I will do that tomorrow.
> I hope i can use GnuCash once again ;-)

The debian binaries should work just fine... extracting them without the debian apt infrastructure might be a bit of a challenge.

If make debug didn't work, what failed? Did you edit configure to remove -ffast-math from the CFLAGS for Linux before running it? 

Regards,
John Ralls