Phil Longstaff wrote: > On January 31, 2009 11:07:17 pm Mark Johnson wrote: > >> Phil Longstaff wrote: >> >>> Hmmm... 'configure' does allow any wrong options and does not seem to >>> flag it. What is *supposed* to happen (and what happens for me) is that >>> the 'Database Connection' menu item will be there, but insensitive unless >>> '--enable-dbi' is specified. >>> >>> Can you send me your config.log and config.h? >>> >>> Phil >>> >>> 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 >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_string registered >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_boolean registered >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_int registered >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_int64 registered >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_double registered >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_guid registered >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_timespec registered >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_gdate registered >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_numeric registered >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_commodityref registered >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_accountref registered >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_txref registered >>>> * 07:22:41 DEBUG <gnc.backend.sql> >>>> [gnc_sql_register_col_type_handler] Col type ct_lotref registered >>>> * 07:22:41 DEBUG <qof.session> [leave qof_session_load_backend()] >>>> * 07:22:41 DEBUG <gnc.backend.dbi> [enter >>>> gnc-backend-dbi.c:gnc_dbi_postgres_session_begin()] >>>> * 07:22:41 CRIT <gnc.backend.dbi> >>>> [gnc_dbi_postgres_session_begin()] Unable to create pgsql dbi connection >>>> * 07:22:41 DEBUG <gnc.backend.dbi> [leave >>>> gnc_dbi_postgres_session_begin()] >>>> * 07:22:41 INFO <qof.session> [qof_session_begin] Done running >>>> session_begin on backend >>>> * 07:22:41 DEBUG <qof.session> [leave qof_session_begin()] backend >>>> error 3 (null) >>>> * >>>> >>>> It seems odd to me that it is loading a postgresql backend, when I did >>>> not specify --enable-dbi. >>>> >>>> Mark >>>> >>>> _______________________________________________ >>>> gnucash-devel mailing list >>>> [email protected] >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-devel >>>> >> Aha, I found the problem. I executed the right build script (with the >> --enable-dbi), but looked at the wrong one (with the --enable-gda). So >> I did pass --enable-gda after all! >> >> Now, my question is: what do I do about this URL parsing problem? I >> have confirmed all the values I filled into the dialog box. I built rev >> 1864 and still have the problem. >> >> Mark >> > > Besides libdbi, you also need the low level postgresql driver for libdbi. On > my system, these are in /usr/lib/dbd. > > Phil > _______________________________________________ > gnucash-devel mailing list > [email protected] > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > > I have it: m...@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 _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
