SQL Backend can't parse URL

[Phil Longstaff]

On February 1, 2009 12:08:40 pm Mark Johnson wrote:
> >>> On January 31, 2009 09:34:32 am Mark Johnson wrote:
> >>>> I have built trunk rev 17855 with the wrong configure options.  I
> >>>> accidentally used the old --enable-gda instead of the correct
> >>>> --enable-dbi.  The file menu has a Database Connection option and when
> >>>> I filled in its dialog's fields and clicked OK, I got a "can't parse
> >>>> URL error".
> >>>>
> >>>> If I haven't enabled the dbi backend, should this menu option even be
> >>>> there?
> >>>>
> >>>> Here is the relevant portion of gnucash.trace:
> >>>> * 07:22:41 DEBUG <qof.session> [enter
> >>>> qofsession.c:qof_session_begin()] sess=0x8512e68 ignore_lock=0,
> >>>> book-id=postgres://localhost:gnucash:gnucash_user:kirk
> >>>> * 07:22:41 DEBUG <qof.session>     [enter
> >>>> qofsession.c:qof_session_load_backend()]  list=6, initted=true
> >>>> * 07:22:41  INFO <qof.session>         [qof_session_load_backend]
> >>>> selected GnuCash Libdbi (POSTGRESQL) Backend
> >>>> * 07:22:41  INFO <gnc.backend.dbi>         [init_sql_backend] -1 DBD
> >>>> drivers found
>
> I have it:
> mj at ds9:/usr/local/lib/dbd$ ls
> libdbdmysql.a    libdbdpgsql.a    libdbdsqlite3.a
> libdbdmysql.la    libdbdpgsql.la    libdbdsqlite3.la
> libdbdmysql.so    libdbdpgsql.so    libdbdsqlite3.so
>
> I was pretty sure I compiled dbd with it, and I did.
>
> Mark

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