Thread: Postgres User Password File????

Postgres User Password File????

From
smiley2211
Date:
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.


Re: Postgres User Password File????

From
"Medi Montaseri"
Date:
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

Re: Postgres User Password File????

From
smiley2211
Date:
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.


Re: Postgres User Password File????

From
"Uwe C. Schroeder"
Date:
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

Re: Postgres User Password File????

From
Tom Lane
Date:
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

Re: Postgres User Password File????

From
"Medi Montaseri"
Date:
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