Bug#659216: not possible to connect base with a postgresql db via libreoffice-sdbc-postgresql

[Lionel Elie Mamane <lionel@mamane.lu>]

On Thu, Feb 23, 2012 at 12:36:10PM +0100, Torsten Wiebke wrote:

>> The error message has no other detail? It usually has. Please click on
>> the "more" button and copy/paste the whole error message and send it
>> to us (at the address 659216@bugs.debian.org).

> Here it is:
> SQL-Status: FATAL:  Ident-Authentifizierung f?r Benutzer >>gncuser<< 
> fehlgeschlagen

> Fehler-Code: 1

> Couldn't establish database connection to 'sdbc:postgresql:dbname=gnucash'
> FATAL:  Ident-Authentifizierung f?r Benutzer >>gncuser<< fehlgeschlagen

My guess: you did not provide a password to PostgreSQL, and it wants
one. Or you use the wrong user. In menu edit / database / properties,
check "password required" and/or correct the user. Click "test
connection", give correct password.

Does connecting with the "psql" command-line tool work? With which
command-line exactly, are any of PGPORT, PGDATABASE, PGHOST, PGUSER
environment variables set?

-- 
Lionel