From: Thomas Schuster <thom.schuster@gmx.de>
To: pgsql-admin@postgresql.org
Subject: can't connect with md5 encrypted pw
Date: Sun, 10 Feb 2008 17:50:46 -0500
Message-ID: <1202683846.15629.19.camel@boa> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: thom.schuster@gmx.de
Subject: Re: can't connect with md5 encrypted pw
In-Reply-To: <1202683846.15629.19.camel@boa>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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