Thread: Postgres User Password File????

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.

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 ?

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.

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

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

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