David M. Kaplan wrote: > Hi, > > I recently experienced a weird bug with postgresql. I am running: > > postgresql-7.2.1-8 > postgresql-server-7.2.1-5 > > I was trying to connect to a database on a my machine from another > machine. Initially, my pg_hba.conf looked like: > > host all 127.0.0.1 0.0.0.0 ident sameuser > host all 192.168.1.2 255.255.255.128 password > > where my machine is 192.168.1.1 and the client is 192.168.1.2. > Connecting using psql -h 192.168.1.1 failed stating: > > FATAL 1: IDENT authentification failed for user 'me' > > Then I changed the order of the lines in my configuration file: > > host all 192.168.1.2 255.255.255.128 password > host all 127.0.0.1 0.0.0.0 ident sameuser > > Now the connection worked without problems. In the first case, it seems > to be trying to use IDENT authentification, even though that should only > apply to localhost.
ident only socket authentication when you connection type is 'local', not 'host'. Even though you said 127.0.0.1, that is tcp to localhost, not socket authentication. I think you wanted: local all ident sameuser host all 192.168.1.2 255.255.255.128 password -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
