SQL Backend can't parse URL

[Mark Johnson]

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
>>>> 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
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>
>   
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