From: | Thomas Schuster <thom(dot)schuster(at)gmx(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | can't connect with md5 encrypted pw |
Date: | 2008-02-10 22:50:46 |
Message-ID: | 1202683846.15629.19.camel@boa |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Phillip Smith | 2008-02-10 22:59:51 | Re: Postgres Backup and Restore |
Previous Message | Phillip Smith | 2008-02-10 22:34:02 | Re: Postgres Backup and Restore |