pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedALTER USER abc PASSWORD - what's going on ???
6+ messages / 3 participants
[nested] [flat]
* ALTER USER abc PASSWORD - what's going on ???
@ 2013-04-18 10:59 Marcin Krawczyk <jankes.mk@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: Marcin Krawczyk @ 2013-04-18 10:59 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ALTER USER abc PASSWORD - what's going on ???
@ 2013-04-18 11:19 SEKA Bruno-Emmanuel <master.ematris@gmail.com>
parent: Marcin Krawczyk <jankes.mk@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: SEKA Bruno-Emmanuel @ 2013-04-18 11:19 UTC (permalink / raw)
To: Marcin Krawczyk <jankes.mk@gmail.com>; +Cc: pgsql-sql
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
> 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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ALTER USER abc PASSWORD - what's going on ???
@ 2013-04-18 11:21 Marcin Krawczyk <jankes.mk@gmail.com>
parent: Marcin Krawczyk <jankes.mk@gmail.com>
1 sibling, 2 replies; 6+ messages in thread
From: Marcin Krawczyk @ 2013-04-18 11:21 UTC (permalink / raw)
To: pgsql-sql
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
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
> 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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ALTER USER abc PASSWORD - what's going on ???
@ 2013-04-18 11:31 SEKA Bruno-Emmanuel <master.ematris@gmail.com>
parent: Marcin Krawczyk <jankes.mk@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: SEKA Bruno-Emmanuel @ 2013-04-18 11:31 UTC (permalink / raw)
To: Marcin Krawczyk <jankes.mk@gmail.com>; +Cc: pgsql-sql
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
> 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 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
>>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ALTER USER abc PASSWORD - what's going on ???
@ 2013-04-18 18:18 Guillaume Lelarge <guillaume@lelarge.info>
parent: Marcin Krawczyk <jankes.mk@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Guillaume Lelarge @ 2013-04-18 18:18 UTC (permalink / raw)
To: Marcin Krawczyk <jankes.mk@gmail.com>; +Cc: pgsql-sql
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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ALTER USER abc PASSWORD - what's going on ???
@ 2013-04-19 08:13 Marcin Krawczyk <jankes.mk@gmail.com>
parent: Guillaume Lelarge <guillaume@lelarge.info>
0 siblings, 0 replies; 6+ messages in thread
From: Marcin Krawczyk @ 2013-04-19 08:13 UTC (permalink / raw)
To: Guillaume Lelarge <guillaume@lelarge.info>; +Cc: pgsql-sql
Ok, thank you.
pozdrowienia
mk
2013/4/18 Guillaume Lelarge <guillaume@lelarge.info>
> 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
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2013-04-19 08:13 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-04-18 10:59 ALTER USER abc PASSWORD - what's going on ??? Marcin Krawczyk <jankes.mk@gmail.com>
2013-04-18 11:19 ` SEKA Bruno-Emmanuel <master.ematris@gmail.com>
2013-04-18 11:21 ` Marcin Krawczyk <jankes.mk@gmail.com>
2013-04-18 11:31 ` SEKA Bruno-Emmanuel <master.ematris@gmail.com>
2013-04-18 18:18 ` Guillaume Lelarge <guillaume@lelarge.info>
2013-04-19 08:13 ` Marcin Krawczyk <jankes.mk@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox