Re: [GENERAL] Password authentication failed for user
On Tue, Jun 07, 2005 at 11:17:52AM -0400, Robert Fitzpatrick wrote: > > I have a database that is used every day for the past year and all of a > sudden, this morning, I get a report that a user cannot login. I have > doubled checked the pg_hba.conf file, which has not been changed in > several months. But only this one user even after resetting the > password, any other user works fine and if I update the pg_hba.conf file > to trust that user, it works. What can cause this? I don't know if I > should post by pg_hba.conf file here, but like I said, nothing has > changed in several months and this problem just appeared today. Apparently something has changed -- the question is what? If nothing on the server, what about on the user's machine? When was the last time it was known for certain to have worked? What method were you using before you changed it to "trust"? If you change it back, can you log in as the user from someplace that works for other users? Can the user in question log in as any other user from wherever his or her own account is failing? What error shows up in the server's logs? Are you restricting logins by IP address? If so, has the user's IP address changed? It might be useful to see the contents of pg_hba.conf. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[GENERAL] Password authentication failed for user
I have a database that is used every day for the past year and all of a sudden, this morning, I get a report that a user cannot login. I have doubled checked the pg_hba.conf file, which has not been changed in several months. But only this one user even after resetting the password, any other user works fine and if I update the pg_hba.conf file to trust that user, it works. What can cause this? I don't know if I should post by pg_hba.conf file here, but like I said, nothing has changed in several months and this problem just appeared today. -- Robert ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] password authentication failed for ..
Doug McNaught <[EMAIL PROTECTED]> writes: > "Manu M P" <[EMAIL PROTECTED]> writes: >> I then created the "passwords" file in $PGDATA using pg_pasword and >> added entries for the two users "test1" and "test2". > I've never heard of a 'pg_password' program and it is not part of the > standard distribution. pg_passwd did exist in releases up to 7.2, but we got rid of it because that functionality got moved into ALTER USER. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] password authentication failed for ..
"Manu M P" <[EMAIL PROTECTED]> writes: > Hi > > I have the data base "test" and two users "test1" "test2". I added the following > record to pg_hba.conf > > local test password passwords > > I then created the "passwords" file in $PGDATA using pg_pasword and > added entries for the two users "test1" and "test2". Ummm... Passwords are stored in the 'pg_shadow' table and set using CREATE/ALTER USER, not in a file. I've never heard of a 'pg_password' program and it is not part of the standard distribution. -Doug ---(end of broadcast)--- TIP 8: explain analyze is your friend