SQL Backend can't parse URL
Mark Johnson
mrj001 at shaw.ca
Mon Feb 2 23:00:24 EST 2009
Phil Longstaff wrote:
> The interesting line in your log is:
> * 07:22:41 INFO <gnc.backend.dbi> [init_sql_backend] -1 DBD drivers
> found
>
> which means that there was some problem initializing libdbi.
>
> Your listing above shows that the dbd file are in /usr/local/lib/dbd. My
> packages (ubuntu) put them in /usr/lib/dbd, so that is what I made the
> default. I would assume that /usr/lib/dbd doesn't exist on your machine,
> which is why dbi_initialize() returns -1.
>
> Try adding '--with-dbi-dbd-dir=/usr/local/lib/dbd' to your configure command.
>
> Phil
>
>
This has led to some progress. I built rev 17871 with this option and
confirmed that the gnucash script contained the correct path to the dbd
directory. Now the gnucash trace has the following:
* 20:43:12 INFO <qof.session> [qof_session_load_backend]
selected GnuCash Libdbi (POSTGRESQL) Backend
* 20:43:13 INFO <gnc.backend.dbi> [init_sql_backend] 3 DBD
drivers found
* 20:43:13 INFO <gnc.backend.dbi> [init_sql_backend] Driver: mysql
* 20:43:13 INFO <gnc.backend.dbi> [init_sql_backend] Driver: pgsql
* 20:43:13 INFO <gnc.backend.dbi> [init_sql_backend] Driver:
sqlite3
*
However, I still get the "can't parse URL" error. I've checked with ldd
and my libdbdpgsql.so is built against the correct version of PostgreSql
- it's linked to the install directory of the version actually running.
I can connect to that with psql.
I have version 0.8.3 of libdbi and 0.8.3.1 of the drivers. These are
the most recent versions. Any suggestions?
Mark
More information about the gnucash-devel
mailing list