Thread: ALTER USER abc PASSWORD - what's going on ???
Hi,
I can't change the pass for my user. When I invoke ALTER USER abc PASSWORD newpassword
it changes ok but then I can't login with my newpassword...
It says authetication failed.
My pg_hba.conf has md5 entry for the ip I connect from. It used to work ok, but I accidentaly changed the password for the user abc from pgAdmin and now I can't change it back to what it was.
What's going on ?
regards
mk
mk
Which version of postgresql.?
Sent from my Samsung Galaxy Note.
On 18 Apr 2013 11:01, "Marcin Krawczyk" <jankes.mk@gmail.com> wrote:
Hi,I can't change the pass for my user. When I invoke ALTER USER abc PASSWORD newpasswordit changes ok but then I can't login with my newpassword...It says authetication failed.My pg_hba.conf has md5 entry for the ip I connect from. It used to work ok, but I accidentaly changed the password for the user abc from pgAdmin and now I can't change it back to what it was.What's going on ?regards
mk
I figured it out... when changing role from pgAdmin, it has a default VALID UNTIL 1970 set and after confirming changes it just made my abc user account invalid... but upon connecting postgres complains about pass authetication, maybe the message should be changed ?
It's 9.1 by the way.
pozdrowienia
mk
mk
2013/4/18 Marcin Krawczyk <jankes.mk@gmail.com>
Hi,I can't change the pass for my user. When I invoke ALTER USER abc PASSWORD newpasswordit changes ok but then I can't login with my newpassword...It says authetication failed.My pg_hba.conf has md5 entry for the ip I connect from. It used to work ok, but I accidentaly changed the password for the user abc from pgAdmin and now I can't change it back to what it was.What's going on ?regards
mk
OK then..
Sent from my Samsung Galaxy Note.
On 18 Apr 2013 11:22, "Marcin Krawczyk" <jankes.mk@gmail.com> wrote:
I figured it out... when changing role from pgAdmin, it has a default VALID UNTIL 1970 set and after confirming changes it just made my abc user account invalid... but upon connecting postgres complains about pass authetication, maybe the message should be changed ?It's 9.1 by the way.pozdrowienia
mk2013/4/18 Marcin Krawczyk <jankes.mk@gmail.com>Hi,I can't change the pass for my user. When I invoke ALTER USER abc PASSWORD newpasswordit changes ok but then I can't login with my newpassword...It says authetication failed.My pg_hba.conf has md5 entry for the ip I connect from. It used to work ok, but I accidentaly changed the password for the user abc from pgAdmin and now I can't change it back to what it was.What's going on ?regards
mk
On Thu, 2013-04-18 at 13:21 +0200, Marcin Krawczyk wrote: > I figured it out... when changing role from pgAdmin, it has a default VALID > UNTIL 1970 set and after confirming changes it just made my abc user > account invalid... FYI, this pgAdmin bug has been fixed. The fix will be available in the next minor release. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com
Ok, thank you.
pozdrowienia
mk
mk
2013/4/18 Guillaume Lelarge <guillaume@lelarge.info>
On Thu, 2013-04-18 at 13:21 +0200, Marcin Krawczyk wrote:FYI, this pgAdmin bug has been fixed. The fix will be available in the
> I figured it out... when changing role from pgAdmin, it has a default VALID
> UNTIL 1970 set and after confirming changes it just made my abc user
> account invalid...
next minor release.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com