can't connect with md5 encrypted pw

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

Responses

Browse pgsql-admin by date

  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