SQL Backend can't parse URL

[Phil Longstaff]

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
> >> gnucash-devel at gnucash.org
> >> 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