pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcan't connect with md5 encrypted pw
2+ messages / 2 participants
[nested] [flat]
* can't connect with md5 encrypted pw
@ 2008-02-10 22:50 Thomas Schuster <thom.schuster@gmx.de>
0 siblings, 1 reply; 2+ messages in thread
From: Thomas Schuster @ 2008-02-10 22:50 UTC (permalink / raw)
To: pgsql-admin
hi all
i tried to explain my problem in the following lines. for me it is
necessary to connect my db with the unix user and md5 encryption on my
local machine. i couldn't found a solution. thx for any idea!
my system:
PostgreSQL 8.2.6 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.3
20070929 (prerelease) (Ubuntu 4.1.2-16ubuntu2)
my problem:
createdb test
psql -U john -d test -W
password:******
psql: FATAL: password authentication failed for user "john"
my pg_hba.conf:
#TYPE DATABASE USER CIDR-ADDRESS METHOD
local all all md5
my roles:
rolname | rolsuper | rolcanlogin | rolpassword
---------+----------+-------------+-------------------------------------
postgres | t | t | md5xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
john | f | t | md5xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
my description:
-john is my unix user
-postgresql server is reloaded
-connecting with my postgres user and md5 works fine
-connecting with "john" and METHOD ident sameuser works although fine
-why can't i connect with my unix user using md5 in pg_hba.conf ?
--
Best regards,
Thomas Schuster
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: can't connect with md5 encrypted pw
@ 2008-02-11 17:14 Tom Lane <tgl@sss.pgh.pa.us>
parent: Thomas Schuster <thom.schuster@gmx.de>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2008-02-11 17:14 UTC (permalink / raw)
To: Thomas Schuster <thom.schuster@gmx.de>; +Cc: pgsql-admin
Thomas Schuster <thom.schuster@gmx.de> writes:
> my problem:
> createdb test
> psql -U john -d test -W
> password:******
> psql: FATAL: password authentication failed for user "john"
Given the facts you show, the most obvious explanation is that you
entered the wrong password. You might want to do an ALTER USER PASSWORD
command (as the superuser) just to make sure you didn't fat-finger the
password setting initially.
If that isn't it, try looking into the postmaster log to see if it logs
any additional details about the failure.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-02-11 17:14 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-10 22:50 can't connect with md5 encrypted pw Thomas Schuster <thom.schuster@gmx.de>
2008-02-11 17:14 ` Tom Lane <tgl@sss.pgh.pa.us>
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