gnucash-2.3 + sql backend

[Klaus Dahlke]

Hi Phil,
I digged around a bit and found the following statement in gnucash.trace:

* 18:31:18  INFO <qof.session> [qof_session_load_backend]  selected GnuCash Libdbi (POSTGRESQL) Backend
* 18:31:18  CRIT <gnc.backend.dbi> [pgsql_error_fn()] DBI error: could not connect to server: Connection refused
        Is the server running on host "localhost" and accepting
        TCP/IP connections on port 0?

the server is up and running, started even with the -i option:
postgres 22560     1  0 18:30 ?        00:00:00 /usr/lib/postgresql-8.3/bin/postgres --silent-mode=true -i

The server listens to the default port :5432 and works normal.

Any ideas?

Best regards,
Klaus



On Mon, 25 May 2009 17:36:31 -0400
Phil Longstaff <plongstaff at rogers.com> wrote:

> Hi Klaus,
> 
> thanks for reporting these.
> 
> On May 25, 2009 09:48:52 am Klaus Dahlke wrote:
> > Hi,
> > I'd like to test gnucash-2.3, in particular the sql backend (with
> > Postgres). I reading some older post I figured out to use --enable-dbi to
> > build the proper backend functionality.
> >
> > gnucash-2.3.0 compiled fine (gentoo, amd64).
> >
> > a) sqlite3 works out of the box. But reading seems a bit slow (the file is
> > ~ 7MB)
> >
> > b) With mysql some messages are displayed during creation of the database:
> >
> 
> I'm aware of the problems with mysql and they should be fixed with 2.3.1.  I 
> hadn't thought of modifying the password box so that it wasn't clear text.  
> I'll do that as well.
> 
> > c) When trying to save to a postgres database the following error comes up:
> >
> > Can't parse the URL postgres://localhost:dbname:user:.
> 
> Is the password blank (in otherwords, you enter a host="localhost", 
> db="dbname" and user="user" but leave the password field empty)?
> 
> Phil
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.