pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgres User Password File????
8+ messages / 5 participants
[nested] [flat]

* Postgres User Password File????
@ 2007-09-07 16:13 smiley2211 <smiley2211@yahoo.com>
  2007-09-12 07:34 ` Re: Postgres User Password File???? Kis János Tamás <kjt@takarnet.hu>
  0 siblings, 1 reply; 8+ messages in thread

From: smiley2211 @ 2007-09-07 16:13 UTC (permalink / raw)
  To: pgsql-admin


Hello all,

Where do I find the PASSWORDs for users on Postgresql???  It seems
connections are failing because user PROOT's password is not correct - where
do I find out what it's set to - do I need to change it???

DataObjects_Users : CONNECT :
a:1:{s:32:"b8c77e08e3d43ac04152a2db76d9728a";O:8:"DB_Error":8:{s:20:"error_message_prefix";s:0:"";s:4:"mode";i:1;s:5:"level";i:1024;s:4:"code";i:-24;s:7:"message";s:24:"DB
Error: connect failed";s:8:"userinfo";s:171:" [nativecode=Unable to connect
to PostgreSQL server: FATAL: password authentication failed for user
"proot"]

Thanks...Michelle
-- 
View this message in context: http://www.nabble.com/Postgres-User-Password-File-----tf4402191.html#a12558425
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.




^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Postgres User Password File????
  2007-09-07 16:13 Postgres User Password File???? smiley2211 <smiley2211@yahoo.com>
@ 2007-09-12 07:34 ` Kis János Tamás <kjt@takarnet.hu>
  0 siblings, 0 replies; 8+ messages in thread

From: Kis János Tamás @ 2007-09-12 07:34 UTC (permalink / raw)
  To: pgsql-admin

péntek 07 szeptember 2007 18.13 dátummal smiley2211 ezt írta:
> Hello all,
>
> Where do I find the PASSWORDs for users on Postgresql???  It seems
> connections are failing because user PROOT's password is not
> correct - where do I find out what it's set to - do I need to
> change it???
>
> DataObjects_Users : CONNECT :
> a:1:{s:32:"b8c77e08e3d43ac04152a2db76d9728a";O:8:"DB_Error":8:{s:20
>:"error_message_prefix";s:0:"";s:4:"mode";i:1;s:5:"level";i:1024;s:4
>:"code";i:-24;s:7:"message";s:24:"DB Error: connect
> failed";s:8:"userinfo";s:171:" [nativecode=Unable to connect to
> PostgreSQL server: FATAL: password authentication failed for user
> "proot"]
>
> Thanks...Michelle

Did you read the chapter 20.1 in PostgreSQL documentation?
Your pg_hba.conf is good?

If you can connect to template1, then you can to see the encrypted 
passwords: SELECT rolname, rolpassword FROM pg_catalog.pg_authid; but 
I think you don't need this...

Bye,
kjt


McAfee SCM 4.1 által ellenrizve!


^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Postgres User Password File????
@ 2007-09-07 16:15 smiley2211 <smiley2211@yahoo.com>
  2007-09-07 16:37 ` Re: Postgres User Password File???? Medi Montaseri <montaseri@gmail.com>
  0 siblings, 1 reply; 8+ messages in thread

From: smiley2211 @ 2007-09-07 16:15 UTC (permalink / raw)
  To: pgsql-admin


Hello all,

Where do I find the PASSWORDs for users on Postgresql???  It seems
connections are failing because user PROOT's password is not correct - where
do I find out what it's set to - do I need to change it???

DataObjects_Users : CONNECT :
a:1:{s:32:"b8c77e08e3d43ac04152a2db76d9728a";O:8:"DB_Error":8:{s:20:"error_message_prefix";s:0:"";s:4:"mode";i:1;s:5:"level";i:1024;s:4:"code";i:-24;s:7:"message";s:24:"DB
Error: connect failed";s:8:"userinfo";s:171:" [nativecode=Unable to connect
to PostgreSQL server: FATAL: password authentication failed for user
"proot"]

Thanks...Michelle
-- 
View this message in context: http://www.nabble.com/Postgres-User-Password-File-----tf4402207.html#a12558458
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.




^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Postgres User Password File????
  2007-09-07 16:15 Postgres User Password File???? smiley2211 <smiley2211@yahoo.com>
@ 2007-09-07 16:37 ` Medi Montaseri <montaseri@gmail.com>
  2007-09-07 16:49   ` Re: Postgres User Password File???? smiley2211 <smiley2211@yahoo.com>
  0 siblings, 1 reply; 8+ messages in thread

From: Medi Montaseri @ 2007-09-07 16:37 UTC (permalink / raw)
  To: smiley2211 <smiley2211@yahoo.com>; +Cc: pgsql-admin

PG maintains user passwd within itself in a table called pg_shadow.
But based on the error message, it seems like you are having problem
connecting to the server.
Try accessing PG from command line with something like psql(1) as in

psql -U proot -d databaseName

and see what error message do you get...can you connect to PG as a different
user ?

On 9/7/07, smiley2211 <smiley2211@yahoo.com> wrote:
>
>
> Hello all,
>
> Where do I find the PASSWORDs for users on Postgresql???  It seems
> connections are failing because user PROOT's password is not correct -
> where
> do I find out what it's set to - do I need to change it???
>
> DataObjects_Users : CONNECT :
>
> a:1:{s:32:"b8c77e08e3d43ac04152a2db76d9728a";O:8:"DB_Error":8:{s:20:"error_message_prefix";s:0:"";s:4:"mode";i:1;s:5:"level";i:1024;s:4:"code";i:-24;s:7:"message";s:24:"DB
> Error: connect failed";s:8:"userinfo";s:171:" [nativecode=Unable to
> connect
> to PostgreSQL server: FATAL: password authentication failed for user
> "proot"]
>
> Thanks...Michelle
> --
> View this message in context:
> http://www.nabble.com/Postgres-User-Password-File-----tf4402207.html#a12558458
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Postgres User Password File????
  2007-09-07 16:15 Postgres User Password File???? smiley2211 <smiley2211@yahoo.com>
  2007-09-07 16:37 ` Re: Postgres User Password File???? Medi Montaseri <montaseri@gmail.com>
@ 2007-09-07 16:49   ` smiley2211 <smiley2211@yahoo.com>
  2007-09-07 18:14     ` Re: Postgres User Password File???? Uwe C. Schroeder <uwe@oss4u.com>
  2007-09-07 18:38     ` Re: Postgres User Password File???? Tom Lane <tgl@sss.pgh.pa.us>
  2007-09-07 20:10     ` Re: Postgres User Password File???? Medi Montaseri <montaseri@gmail.com>
  0 siblings, 3 replies; 8+ messages in thread

From: smiley2211 @ 2007-09-07 16:49 UTC (permalink / raw)
  To: pgsql-admin


Yep, I can connect LOCALLY with no problem...it's when I come through an
application using this user that I have the connection issue.

Thanks...Michelle

-- 
View this message in context: http://www.nabble.com/Postgres-User-Password-File-----tf4402207.html#a12559172
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.




^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Postgres User Password File????
  2007-09-07 16:15 Postgres User Password File???? smiley2211 <smiley2211@yahoo.com>
  2007-09-07 16:37 ` Re: Postgres User Password File???? Medi Montaseri <montaseri@gmail.com>
  2007-09-07 16:49   ` Re: Postgres User Password File???? smiley2211 <smiley2211@yahoo.com>
@ 2007-09-07 18:14     ` Uwe C. Schroeder <uwe@oss4u.com>
  2 siblings, 0 replies; 8+ messages in thread

From: Uwe C. Schroeder @ 2007-09-07 18:14 UTC (permalink / raw)
  To: pgsql-admin; +Cc: smiley2211 <smiley2211@yahoo.com>


Have you checked your pg_hba.conf and postgresql.conf files?
To remote connect you need to "listen" on your external interface (see 
postgresql.conf) and you need according settings in pg_hba.conf that allow 
you to connect from the ip-address you try it from.

Uwe


On Friday 07 September 2007, smiley2211 wrote:
> Yep, I can connect LOCALLY with no problem...it's when I come through an
> application using this user that I have the connection issue.
>
> Thanks...Michelle


--
Open Source Solutions 4U, LLC	1618 Kelly St
Phone:  +1 707 568 3056		Santa Rosa, CA 95401
Cell:   +1 650 302 2405		United States
Fax:    +1 707 568 6416



^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Postgres User Password File????
  2007-09-07 16:15 Postgres User Password File???? smiley2211 <smiley2211@yahoo.com>
  2007-09-07 16:37 ` Re: Postgres User Password File???? Medi Montaseri <montaseri@gmail.com>
  2007-09-07 16:49   ` Re: Postgres User Password File???? smiley2211 <smiley2211@yahoo.com>
@ 2007-09-07 18:38     ` Tom Lane <tgl@sss.pgh.pa.us>
  2 siblings, 0 replies; 8+ messages in thread

From: Tom Lane @ 2007-09-07 18:38 UTC (permalink / raw)
  To: smiley2211 <smiley2211@yahoo.com>; +Cc: pgsql-admin

smiley2211 <smiley2211@yahoo.com> writes:
> Yep, I can connect LOCALLY with no problem...it's when I come through an
> application using this user that I have the connection issue.

Connect locally as superuser and issue an ALTER USER command to set the
user's password to whatever it should be.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Postgres User Password File????
  2007-09-07 16:15 Postgres User Password File???? smiley2211 <smiley2211@yahoo.com>
  2007-09-07 16:37 ` Re: Postgres User Password File???? Medi Montaseri <montaseri@gmail.com>
  2007-09-07 16:49   ` Re: Postgres User Password File???? smiley2211 <smiley2211@yahoo.com>
@ 2007-09-07 20:10     ` Medi Montaseri <montaseri@gmail.com>
  2 siblings, 0 replies; 8+ messages in thread

From: Medi Montaseri @ 2007-09-07 20:10 UTC (permalink / raw)
  To: smiley2211 <smiley2211@yahoo.com>; +Cc: pgsql-admin

Ok...next step is to try to connect remotely from the trusted psql(1) again,
as in

psql -U proot -d databaseName -h hostname -p portNumber

If you can connect, then your listner configuration is working ok (per other
caller's comment). In which case you focus on the application.

Cheers
Medi

On 9/7/07, smiley2211 <smiley2211@yahoo.com> wrote:
>
>
> Yep, I can connect LOCALLY with no problem...it's when I come through an
> application using this user that I have the connection issue.
>
> Thanks...Michelle
>
> --
> View this message in context:
> http://www.nabble.com/Postgres-User-Password-File-----tf4402207.html#a12559172
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                 http://www.postgresql.org/about/donate
>

^ permalink  raw  reply  [nested|flat] 8+ messages in thread


end of thread, other threads:[~2007-09-12 07:34 UTC | newest]

Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-07 16:13 Postgres User Password File???? smiley2211 <smiley2211@yahoo.com>
2007-09-12 07:34 ` Kis János Tamás <kjt@takarnet.hu>
2007-09-07 16:15 Postgres User Password File???? smiley2211 <smiley2211@yahoo.com>
2007-09-07 16:37 ` Medi Montaseri <montaseri@gmail.com>
2007-09-07 16:49   ` smiley2211 <smiley2211@yahoo.com>
2007-09-07 18:14     ` Uwe C. Schroeder <uwe@oss4u.com>
2007-09-07 18:38     ` Tom Lane <tgl@sss.pgh.pa.us>
2007-09-07 20:10     ` Medi Montaseri <montaseri@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