DBI/SQL backend save as failure

[Phil Longstaff]

Well, the SQL stuff isn't really a module, it is a library, so I'll convert it to a library.

Phil


----- Original Message ----
From: David Reiser <dbreiser at earthlink.net>
To: Phil Longstaff <plongstaff at rogers.com>
Cc: GnuCash development list <gnucash-devel at gnucash.org>
Sent: Saturday, June 14, 2008 8:28:50 AM
Subject: Re: DBI/SQL backend save as failure


On Jun 13, 2008, at 10:18 PM, Phil Longstaff wrote:

> David Reiser wrote:
>> Using r17230 (+ a GType fix in gnc-backend-dbi.c), gnucash builds,
>> launches, and opens the data file (xml). Save As results in the
>> following in the terminal window:
>>
>> dyld: lazy symbol binding failed: Symbol not found: _gnc_sql_init
>>   Referenced from: /opt/gnucash-gda/lib/gnucash/libgncmod-backend-
>> dbi.so
>>   Expected in: dynamic lookup
>>
>> dyld: Symbol not found: _gnc_sql_init
>>   Referenced from: /opt/gnucash-gda/lib/gnucash/libgncmod-backend-
>> dbi.so
>>   Expected in: dynamic lookup
>>
>> Trace/BPT trap
>>
>> The crash log has very little more:
>>
>> Process:         gnucash-bin [960]
>> Path:            /opt/gnucash-gda/bin/gnucash-bin
>> Identifier:      gnucash-bin
>> Version:         ??? (???)
>> Code Type:       PPC (Native)
>> Parent Process:  bash [31943]
>>
>> Date/Time:       2008-06-13 00:54:44.218 -0400
>> OS Version:      Mac OS X 10.5.3 (9D34)
>> Report Version:  6
>>
>> Exception Type:  EXC_BREAKPOINT (SIGTRAP)
>> Exception Codes: 0x0000000000000001, 0x000000008fe0105c
>> Crashed Thread:  0
>>
>> Dyld Error Message:
>>   Symbol not found: _gnc_sql_init
>>   Referenced from: /opt/gnucash-gda/lib/gnucash/libgncmod-backend-
>> dbi.so
>>   Expected in: dynamic lookup
>
> I don't know if it will affect anything, but I've just committed a few
> small changes.  Now, all of the gnc_sql_xxx routines (e.g.  
> gnc_sql_init)
> will be in libgncmod-backend-sql.so.  libgncmod-backend-dbi.so is  
> linked
> with libgncmod-backend-sql.so, so I don't know what the problem is,
> unless it is something mac-specific.
>
> Phil

I still get the same error. It might well be a mac specific thing  
about setting up libraries/modules/whatever.

In the the build log, I get:

  gcc -DHAVE_CONFIG_H -I. -I. -I../../.. -DG_LOG_DOMAIN= 
\"gnc.backend.dbi\" -I/sw/include -I.. -I../.. -DLOCALE_DIR=\"/opt/ 
gnucash-gda/share/locale\" -I../../../src/backend -I../../../src/ 
backend/sql -I../../../src/engine -I../../../src/core-utils -I../../../ 
lib/libc -I../../../lib/libqof/qof -I../../../lib/libqof/qof -I/sw/ 
include/glib-2.0 -I/sw/lib/glib-2.0/include -I/sw/include/glib-2.0 -I/ 
sw/lib/glib-2.0/include -I/sw/include/orbit-2.0 -I/sw/include/gconf/2 - 
DORBIT2=1 -Wall -Wmissing-prototypes -Werror -Wdeclaration-after- 
statement -Wno-pointer-sign -D_FORTIFY_SOURCE=2 -g -Wno-unused -MT gnc- 
backend-dbi.lo -MD -MP -MF .deps/gnc-backend-dbi.Tpo -c gnc-backend- 
dbi.c  -fno-common -DPIC -o .libs/gnc-backend-dbi.o
/bin/sh ../../../libtool --tag=CC --mode=link gcc -I.. -I../.. - 
DLOCALE_DIR=\""/opt/gnucash-gda/share/locale"\" -I../../../src/backend  
-I../../../src/backend/sql -I../../../src/engine -I../../../src/core- 
utils -I../../../lib/libc -I../../../lib/libqof/qof -I../../../lib/ 
libqof/qof -I/sw/include/glib-2.0 -I/sw/lib/glib-2.0/include -I/sw/ 
include/glib-2.0 -I/sw/lib/glib-2.0/include -I/sw/include/orbit-2.0 -I/ 
sw/include/gconf/2 -DORBIT2=1 -Wall -Wmissing-prototypes  -Werror - 
Wdeclaration-after-statement -Wno-pointer-sign -D_FORTIFY_SOURCE=2  - 
g  -Wno-unused  -L/sw/lib -g -o libgncmod-backend-dbi.la -rpath /opt/ 
gnucash-gda/lib/gnucash -module -avoid-version gnc-backend-dbi.lo -L/ 
sw/lib -lgthread-2.0 -lgobject-2.0 -lgmodule-2.0 -lglib-2.0 -lintl - 
liconv -L/sw/lib -lgconf-2 -lORBit-2 -lgthread-2.0 -lgobject-2.0 - 
lglib-2.0 -lintl -liconv ../../../src/backend/sql/libgncmod-backend- 
sql.la ../../../src/engine/libgncmod-engine.la -ldbi ../../../lib/ 
libqof/qof/libgnc-qof.la -lpopt -lm  -lm

*** Warning: Linking the shared library libgncmod-backend-dbi.la  
against the loadable module
*** libgncmod-backend-sql.so is not portable!
** Warning, lib libgncmod-backend-sql.so is a module, not a shared  
library

** And there doesn't seem to be a static archive available
** The link will probably fail, sorry

I'll try to get some advice from the mac folk, but it may take me a  
week until I can get that done.

Thanks for the help.

Dave
--
David Reiser
dbreiser at earthlink.net