pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (2+ messages)  latest in thread

Message-ID: <1202683846.15629.19.camel@boa>
Permalink:  ../1202683846.15629.19.camel@boa/
Also on:    postgresql.org/message-id/1202683846.15629.19.camel@boa

 · 

reply

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