postgresql

[Geert Janssens]

On Thursday 9 September 2010, Paddy Walker wrote:
> Geert,?        You are correct in discovering my typographic error. It
>  should be a colon not a semicolon.?        I am using Fedora 13 for this
>  trial.? I can connect to postgresql using "psql gnucash" as yarelea
>  (user).? Using the same user yarelea in a terminal I can start gnucash.
>  Only one line in response "Found Finance::Quote version 1.17"?       When
>  I attempt to "save as", I select postgresql from the dropdown box.?The
>  next dialog requests my username & password. I do not understand what I
>  ?should do about that. Provided the username has a role in Postgresql,
>  surely ?that should be enough. I have not tried using gnucash as
>  postgres.?The contents of the gnucash.trace file;?* * 14:19:53 DEBUG
>  <gnc.backend.dbi> [enter gnc-backend-
> dbi.c:gnc_dbi_postgres_session_begin()]
> * 14:19:53  CRIT <gnc.backend.dbi>     [pgsql_error_fn()] DBI error: FATAL:
>   Ident authentication failed for user "yarelea"
> 
> * 14:19:53  CRIT <gnc.backend.dbi>     gnc_dbi_set_error: assertion
>  `dbi_conn != NULL' failed * 14:19:53  CRIT <gnc.backend.dbi>    
>  [gnc_dbi_postgres_session_begin()] Unable to connect to database 'gnucash'
>  * 14:19:53 DEBUG <gnc.backend.dbi> [leave
>  gnc_dbi_postgres_session_begin()] * 14:23:23 DEBUG <gnc.backend.dbi>
>  [enter gnc-backend-dbi.c:gnc_dbi_session_end()] * 14:23:23 DEBUG
>  <gnc.backend.dbi> [leave gnc_dbi_session_end()]
> * 14:25:18 DEBUG <gnc.backend.dbi> [enter
>  gnc-backend-dbi.c:gnc_dbi_postgres_session_begin()] * 14:25:18  CRIT
>  <gnc.backend.dbi>     [pgsql_error_fn()] DBI error: FATAL:  Ident
>  authentication failed for user "0"
> 
> * 14:25:18  CRIT <gnc.backend.dbi>     gnc_dbi_set_error: assertion
>  `dbi_conn != NULL' failed * 14:25:18  CRIT <gnc.backend.dbi>    
>  [gnc_dbi_postgres_session_begin()] Unable to connect to database 'gnucash'
>  * 14:25:18 DEBUG <gnc.backend.dbi> [leave
>  gnc_dbi_postgres_session_begin()] This would appear to indicate that
>  yarelea is not a role but why in that case can I access postgresql using
>  the command line.
> I may not be allowed to attach a file. If not I apologise.
> Paddy
> 
Paddy,

Thank you for your feedback. Do I understand you correctly that you don't 
provide a password when connecting to postgresql ? I wonder if that is 
supported. It's very well possible the GnuCash code to connect to postgresql 
expects a password and will fail of there's none.

Perhaps it's best to create a bugreport for this in https://bugzilla.gnome.org 
(see http://wiki.gnucash.org/wiki/Bugzilla for additional information).

Geert