At Tue, 22 Oct 2002 17:01:27 +1000 (EST), david wrote: > I'm trying to set up SQL-ledger, having never used postgresql before. > When I attempt to login through the SQL-Ledger admin web page, I get: > FATAL 1: IDENT authentication failed for user "SQL-Ledger_Owner"
the default (at least on debian, i assume its similar elsewhere) setup for postgres is to authenticate local users via ident (ie: no password, just matching your system user name to the database user name. for *local* (unix socket) connections, it actually uses getpeername() not ident, but the effect is the same). see /etc/postgresql/pg_hba.conf where that is configured. there's also a user-map idea, which you could probably use to say that "david" should be treated as "SQL-Ledger_Owner", etc - but from memory that can't be used with ident authentication. you will probably have to switch to using login passwords if you want to have arbitrary system user <-> db user. see pg_hba.conf. -- - Gus -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
