Connection problem
Connection problem
От:
Gunnar <gunnar@gunix.mine.nu>
Дата:
I'm having problems connecting to my postgresql 7.2.1 running on my Debian Linux box. (as root) $ psql template1 foobar psql: FATAL 1: IDENT authentication failed for user "foobar" Could anybody tell me what the problem is? The user "foobar" is created with the createuser command without any problem. Here is the pg_hba.conf local all ident sameuser local all trust
Re: Connection problem
От:
"Nick Fankhauser" <nickf@ontko.com>
Дата:
Gunnar- It looks to me like the two lines in pg_hba conflict, and the first one is being used. Since you are logged in as root, it looks for "sameuser" on foobar and doesn't get a match. Try either logging into linux as foobar or eliminate the first line of pg_hba. -Nick -------------------------------------------------------------------------- Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Gunnar > Sent: Sunday, April 21, 2002 2:35 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Connection problem > > > I'm having problems connecting to my postgresql 7.2.1 running on > my Debian > Linux box. > > (as root) > $ psql template1 foobar > psql: FATAL 1: IDENT authentication failed for user "foobar" > > Could anybody tell me what the problem is? > The user "foobar" is created with the createuser command without > any problem. > > Here is the pg_hba.conf > > local all ident sameuser > local all trust > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
Re: Connection problem
От:
Ferdinand Smit <ferdinand@telegraafnet.nl>
Дата:
On Sunday 21 April 2002 09:35, Gunnar wrote: > I'm having problems connecting to my postgresql 7.2.1 running on my Debian > Linux box. > > (as root) > $ psql template1 foobar > psql: FATAL 1: IDENT authentication failed for user "foobar" > > Could anybody tell me what the problem is? > The user "foobar" is created with the createuser command without any > problem. > > Here is the pg_hba.conf > > local all ident sameuser > local all trust I think that postgres only uses the first line and that line says that postgres uses the ident autentication (without a password if the user is the same). This means that the user MUST exist in the /etc/passwd. The second line (not used because the first is the same) allows al users without a password. So remove the first line or add user to passwd. Ferdinand