pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAdmin user issue: unable to login after changing password
7+ messages / 5 participants
[nested] [flat]
* Admin user issue: unable to login after changing password
@ 2014-02-03 14:26 sharon <sharon@erabyte.it>
0 siblings, 1 reply; 7+ messages in thread
From: sharon @ 2014-02-03 14:26 UTC (permalink / raw)
To: pgsql-admin
Hi,
I'm using postgres 9.2 on windows 7. I've changed the password of
postgres user with pgadmin but now i'm unable to log in.
There are two users accounts but only one is the admin. The problem is
that the postgres' user expire date is set in 1970, I can see this from
the other account.
Is possible to replace users with a configuration hack? Or is possible
to install everything again without loosing database's data?
Is there a way to solve this issue?
Thank you
Sharon
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Admin user issue: unable to login after changing password
@ 2014-02-03 19:21 Jerry Sievers <gsievers19@comcast.net>
parent: sharon <sharon@erabyte.it>
0 siblings, 1 reply; 7+ messages in thread
From: Jerry Sievers @ 2014-02-03 19:21 UTC (permalink / raw)
To: sharon <sharon@erabyte.it>; +Cc: pgsql-admin
sharon <sharon@erabyte.it> writes:
> Hi,
>
> I'm using postgres 9.2 on windows 7. I've changed the password of
> postgres user with pgadmin but now i'm unable to log in.
> There are two users accounts but only one is the admin. The problem is
> that the postgres' user expire date is set in 1970, I can see this
> from the other account.
> Is possible to replace users with a configuration hack? Or is possible
> to install everything again without loosing database's data?
> Is there a way to solve this issue?
Fix your pg_hba.conf file to not require a password from the affected
user, reload it and then login and do a good pw reset and set
valid-until to infinity..
alter role postgres password 'good-pw' valid until 'infinity';
HTH
>
> Thank you
>
> Sharon
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Admin user issue: unable to login after changing password
@ 2014-02-04 23:24 sharon@erabyte.it
parent: Jerry Sievers <gsievers19@comcast.net>
0 siblings, 1 reply; 7+ messages in thread
From: sharon@erabyte.it @ 2014-02-04 23:24 UTC (permalink / raw)
To: pgsql-admin
Hi,after fixing pg_hba.conf with host "all
postgres localhost trust" i
started psql or pgadmin and i tryed to log in but i still had to type
a password.
After fixing the file .conf i restarted the service with no luck.
Any hint?
Thank you
Sharon
----- Messaggio Originale -----
Da: "Jerry Sievers"
A:"sharon"
Cc:
Inviato:Mon, 03 Feb 2014 13:21:34 -0600
Oggetto:Re: [ADMIN] Admin user issue: unable to login after changing
password
sharon writes:
> Hi,
>
> I'm using postgres 9.2 on windows 7. I've changed the password of
> postgres user with pgadmin but now i'm unable to log in.
> There are two users accounts but only one is the admin. The problem
is
> that the postgres' user expire date is set in 1970, I can see this
> from the other account.
> Is possible to replace users with a configuration hack? Or is
possible
> to install everything again without loosing database's data?
> Is there a way to solve this issue?
Fix your pg_hba.conf file to not require a password from the affected
user, reload it and then login and do a good pw reset and set
valid-until to infinity..
alter role postgres password 'good-pw' valid until 'infinity';
HTH
>
> Thank you
>
> Sharon
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Admin user issue: unable to login after changing password
@ 2014-02-05 04:00 Payal Singh <payal@omniti.com>
parent: sharon@erabyte.it
0 siblings, 1 reply; 7+ messages in thread
From: Payal Singh @ 2014-02-05 04:00 UTC (permalink / raw)
To: sharon@erabyte.it; +Cc: pgsql-admin
looks like you missed the 'type' value in pg_hba? the sequence is type,
database, user, address, method
See http://www.postgresql.org/docs/9.2/static/auth-pg-hba-conf.html
Payal Singh,
Junior Database Administrator,
OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253
On Tue, Feb 4, 2014 at 6:24 PM, <sharon@erabyte.it> wrote:
> Hi,
> after fixing pg_hba.conf with host "all postgres
> localhost trust" i started psql or pgadmin and i tryed to
> log in but i still had to type a password.
> After fixing the file .conf i restarted the service with no luck.
> Any hint?
>
> Thank you
>
> Sharon
>
>
> ----- Messaggio Originale -----
> Da:
> "Jerry Sievers" <gsievers19@comcast.net>
>
> A:
> "sharon" <sharon@erabyte.it>
> Cc:
> <pgsql-admin@postgresql.org>
> Inviato:
> Mon, 03 Feb 2014 13:21:34 -0600
> Oggetto:
> Re: [ADMIN] Admin user issue: unable to login after changing password
>
>
>
> sharon <sharon@erabyte.it> writes:
>
> > Hi,
> >
> > I'm using postgres 9.2 on windows 7. I've changed the password of
> > postgres user with pgadmin but now i'm unable to log in.
> > There are two users accounts but only one is the admin. The problem is
> > that the postgres' user expire date is set in 1970, I can see this
> > from the other account.
> > Is possible to replace users with a configuration hack? Or is possible
> > to install everything again without loosing database's data?
> > Is there a way to solve this issue?
>
> Fix your pg_hba.conf file to not require a password from the affected
> user, reload it and then login and do a good pw reset and set
> valid-until to infinity..
>
>
> alter role postgres password 'good-pw' valid until 'infinity';
>
> HTH
>
> >
> > Thank you
> >
> > Sharon
>
> --
> Jerry Sievers
> Postgres DBA/Development Consulting
> e: postgres.consulting@comcast.net
> p: 312.241.7800
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Admin user issue: unable to login after changing password
@ 2014-02-05 09:38 sharon <sharon@erabyte.it>
parent: Payal Singh <payal@omniti.com>
0 siblings, 1 reply; 7+ messages in thread
From: sharon @ 2014-02-05 09:38 UTC (permalink / raw)
To: pgsql-admin
Hi,
I'm sorry, there was a typing error. I fixed pg_hba.conf with " host
all postgres localhost trust ". I'm still
unable to run pgadmin or psql.
Any suggestions would be greatly appreciated.
Thank you
Sharon
Il 05/02/2014 5.00, Payal Singh ha scritto:
> looks like you missed the 'type' value in pg_hba? the sequence is
> type, database, user, address, method
>
> See http://www.postgresql.org/docs/9.2/static/auth-pg-hba-conf.html
>
> Payal Singh,
> Junior Database Administrator,
> OmniTI Computer Consulting Inc.
> Phone: 240.646.0770 x 253
>
>
> On Tue, Feb 4, 2014 at 6:24 PM, <sharon@erabyte.it
> <mailto:sharon@erabyte.it>> wrote:
>
> Hi,
> after fixing pg_hba.conf with host "all postgres
> localhost trust" i started psql or pgadmin and i
> tryed to log in but i still had to type a password.
> After fixing the file .conf i restarted the service with no luck.
> Any hint?
>
> Thank you
>
> Sharon
>
>
> ----- Messaggio Originale -----
> Da:
> "Jerry Sievers" <gsievers19@comcast.net
> <mailto:gsievers19@comcast.net>>
>
> A:
> "sharon" <sharon@erabyte.it <mailto:sharon@erabyte.it>>
> Cc:
> <pgsql-admin@postgresql.org <mailto:pgsql-admin@postgresql.org>>
> Inviato:
> Mon, 03 Feb 2014 13:21:34 -0600
> Oggetto:
> Re: [ADMIN] Admin user issue: unable to login after changing
> password
>
>
>
> sharon <sharon@erabyte.it <mailto:sharon@erabyte.it>> writes:
>
> > Hi,
> >
> > I'm using postgres 9.2 on windows 7. I've changed the
> password of
> > postgres user with pgadmin but now i'm unable to log in.
> > There are two users accounts but only one is the admin. The
> problem is
> > that the postgres' user expire date is set in 1970, I can
> see this
> > from the other account.
> > Is possible to replace users with a configuration hack? Or
> is possible
> > to install everything again without loosing database's data?
> > Is there a way to solve this issue?
>
> Fix your pg_hba.conf file to not require a password from the
> affected
> user, reload it and then login and do a good pw reset and set
> valid-until to infinity..
>
>
> alter role postgres password 'good-pw' valid until 'infinity';
>
> HTH
>
> >
> > Thank you
> >
> > Sharon
>
> --
> Jerry Sievers
> Postgres DBA/Development Consulting
> e: postgres.consulting@comcast.net
> <mailto:postgres.consulting@comcast.net>
> p: 312.241.7800 <tel:312.241.7800>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org
> <mailto:pgsql-admin@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
> Nessun virus nel messaggio.
> Controllato da AVG - www.avg.com <http://www.avg.com;
> Versione: 2014.0.4259 / Database dei virus: 3684/7061 - Data di
> rilascio: 04/02/2014
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Admin user issue: unable to login after changing password
@ 2014-02-05 09:53 desmodemone <desmodemone@gmail.com>
parent: sharon <sharon@erabyte.it>
0 siblings, 0 replies; 7+ messages in thread
From: desmodemone @ 2014-02-05 09:53 UTC (permalink / raw)
To: sharon <sharon@erabyte.it>; +Cc: pgsql-admin
2014-02-05 sharon <sharon@erabyte.it>:
>
> Hi,
> I'm sorry, there was a typing error. I fixed pg_hba.conf with " host
> all postgres localhost trust ". I'm
> still unable to run pgadmin or psql.
>
> Any suggestions would be greatly appreciated.
>
> Thank you
>
> Sharon
>
> Il 05/02/2014 5.00, Payal Singh ha scritto:
>
> looks like you missed the 'type' value in pg_hba? the sequence is type,
> database, user, address, method
>
> See http://www.postgresql.org/docs/9.2/static/auth-pg-hba-conf.html
>
> Payal Singh,
> Junior Database Administrator,
> OmniTI Computer Consulting Inc.
> Phone: 240.646.0770 x 253
>
>
> On Tue, Feb 4, 2014 at 6:24 PM, <sharon@erabyte.it> wrote:
>
>> Hi,
>> after fixing pg_hba.conf with host "all postgres
>> localhost trust" i started psql or pgadmin and i tryed to
>> log in but i still had to type a password.
>> After fixing the file .conf i restarted the service with no luck.
>> Any hint?
>>
>> Thank you
>>
>> Sharon
>>
>>
>> ----- Messaggio Originale -----
>> Da:
>> "Jerry Sievers" <gsievers19@comcast.net>
>>
>> A:
>> "sharon" <sharon@erabyte.it>
>> Cc:
>> <pgsql-admin@postgresql.org>
>> Inviato:
>> Mon, 03 Feb 2014 13:21:34 -0600
>> Oggetto:
>> Re: [ADMIN] Admin user issue: unable to login after changing password
>>
>>
>>
>> sharon <sharon@erabyte.it> writes:
>>
>> > Hi,
>> >
>> > I'm using postgres 9.2 on windows 7. I've changed the password of
>> > postgres user with pgadmin but now i'm unable to log in.
>> > There are two users accounts but only one is the admin. The problem is
>> > that the postgres' user expire date is set in 1970, I can see this
>> > from the other account.
>> > Is possible to replace users with a configuration hack? Or is possible
>> > to install everything again without loosing database's data?
>> > Is there a way to solve this issue?
>>
>> Fix your pg_hba.conf file to not require a password from the affected
>> user, reload it and then login and do a good pw reset and set
>> valid-until to infinity..
>>
>>
>> alter role postgres password 'good-pw' valid until 'infinity';
>>
>> HTH
>>
>> >
>> > Thank you
>> >
>> > Sharon
>>
>> --
>> Jerry Sievers
>> Postgres DBA/Development Consulting
>> e: postgres.consulting@comcast.net
>> p: 312.241.7800
>>
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>>
> Nessun virus nel messaggio.
> Controllato da AVG - www.avg.com
> Versione: 2014.0.4259 / Database dei virus: 3684/7061 - Data di rilascio:
> 04/02/2014
>
>
>
Hello sharon,
first : please use bottom
posting<http://en.wikipedia.org/wiki/Posting_style#Bottom-posting;, so
it's more easy to read the mail history / thread from up to down.
Second: could you attach the pg_hba.conf ?
Third: how you connect to postgresql ?
Four: after modify the pg_hba.conf, did you reload or restart postgresql?
I explain: if you connect to "localhost" the rule
host all postgres localhost trust
make you enter in the database trough the 127.0.0.1 on 5432 ( I imagine you
have the default settings and the firewall with the open port or firewall
down ) without password
psql -U postgres -h localhost
will connect to database
if you not specified "locahost" the probably rule you will meet will be
about "local" connection :
local all all peer
that will make you enter without password, only if your OS account exists
in the database.
Bye
Mat
^ permalink raw reply [nested|flat] 7+ messages in thread
* Fwd: Re: Admin user issue: unable to login after changing password
@ 2014-02-05 10:34 sharon <sharon@erabyte.it>
0 siblings, 0 replies; 7+ messages in thread
From: sharon @ 2014-02-05 10:34 UTC (permalink / raw)
To: pgsql-admin
-------- Messaggio originale --------
Oggetto: Re: [ADMIN] Admin user issue: unable to login after changing
password
Data: Wed, 05 Feb 2014 11:32:48 +0100
Mittente: sharon <sharon@erabyte.it>
A: desmodemone <desmodemone@gmail.com>
Hello sharon,
> first : please use bottom posting
> <http://en.wikipedia.org/wiki/Posting_style#Bottom-posting; , so it's
> more easy to read the mail history / thread from up to down.
> Second: could you attach the pg_hba.conf ?
> Third: how you connect to postgresql ?
> Four: after modify the pg_hba.conf, did you reload or restart postgresql?
>
> I explain: if you connect to "localhost" the rule
>
> host all postgres localhost trust
>
> make you enter in the database trough the 127.0.0.1 on 5432 ( I
> imagine you have the default settings and the firewall with the open
> port or firewall down ) without password
>
> psql -U postgres -h localhost
>
> will connect to database
>
> if you not specified "locahost" the probably rule you will meet will
> be about "local" connection :
>
> local all all peer
>
> that will make you enter without password, only if your OS account
> exists in the database.
>
>
> Bye
>
> Mat
>
> Nessun virus nel messaggio.
> Controllato da AVG - www.avg.com <http://www.avg.com;
> Versione: 2014.0.4259 / Database dei virus: 3684/7062 - Data di
> rilascio: 04/02/2014
>
Hi,
for some reason pgsql uses only the ipv6 configuration while i was
changing the ipv4.
Now everything is working again.
Thank you very much for your help
Sharon
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2014-02-05 10:34 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-02-03 14:26 Admin user issue: unable to login after changing password sharon <sharon@erabyte.it>
2014-02-03 19:21 ` Jerry Sievers <gsievers19@comcast.net>
2014-02-04 23:24 ` sharon@erabyte.it
2014-02-05 04:00 ` Payal Singh <payal@omniti.com>
2014-02-05 09:38 ` sharon <sharon@erabyte.it>
2014-02-05 09:53 ` desmodemone <desmodemone@gmail.com>
2014-02-05 10:34 Fwd: Re: Admin user issue: unable to login after changing password sharon <sharon@erabyte.it>
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