gnucash-2.3 + sql backend

Scott Peshak speshak at randomscrews.net
Sat Jun 6 14:03:00 EDT 2009


I fought this too, to use a postgres server that isn't on the local
box you have to modify the libdbi backend code.  I think Phil said
that this would change in the future, for details check the devel list
archives.

-Scott

2009/6/6 Klaus Dahlke <klaus.dahlke at gmx.de>:
> 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.
> _______________________________________________
> 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.
>


More information about the gnucash-user mailing list