Re: client authentication problem - Mailing list pgsql-admin

From Tom Lane
Subject Re: client authentication problem
Date
Msg-id 12550.1107411014@sss.pgh.pa.us
Whole thread Raw
In response to client authentication problem  (Dave Vieglais <vieglais@ku.edu>)
List pgsql-admin
Dave Vieglais <vieglais@ku.edu> writes:
> Contents of pg_hba.conf:

> local  all  postgres                       ident sameuser
> local  all  all                            md5
> host   all  all  127.0.0.1 255.255.255.255 md5
> host   all  all  0.0.0.0   0.0.0.0         reject

> # tail /var/log/postgresql/postgresql.log
> LOG:  redo record is at 0/6851324; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction ID: 61873; next OID: 28747
> LOG:  database system is ready
> 2005-01-31 16:03:23 [31418] LOG:  connection received: host=127.0.0.1 port=33377
> 2005-01-31 16:03:23 [31418] LOG:  cannot use authentication method "crypt"
> because password is MD5-encrypted
> 2005-01-31 16:03:23 [31418] FATAL:  Password authentication failed for user
> "test"

I'm fairly sure that this log entry is not possible unless the
postmaster found a pg_hba.conf entry specifying "crypt".  Accordingly
I suspect pilot error.  Perhaps you are looking at the wrong copy of
pg_hba.conf?  Or maybe you changed the file and forgot to SIGHUP the
postmaster?

            regards, tom lane

pgsql-admin by date:

Previous
From: Dave Vieglais
Date:
Subject: client authentication problem
Next
From: Morus Walter
Date:
Subject: Re: PITR WAL backups