Skip site navigation (1) Skip section navigation (2)

BUG #4572: Incorrect error message when using wrong password with hostssl

From: "Tommy Gildseth" <tommy(dot)gildseth(at)usit(dot)uio(dot)no>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4572: Incorrect error message when using wrong password with hostssl
Date: 2008-12-09 07:04:52
Message-ID: 200812090704.mB974qJL077373@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4572
Logged by:          Tommy Gildseth
Email address:      tommy(dot)gildseth(at)usit(dot)uio(dot)no
PostgreSQL version: 8.3.x,8.2.x
Operating system:   Linux
Description:        Incorrect error message when using wrong password with
hostssl
Details: 

When logging into postgresql requiring SSL, providing the wrong password
will produce an incorrect and confusing error message.

========== pg_hba.conf ===============
hostssl all postgres 192.168.123.234 255.255.255.255 md5
======================================

========== Logging in: ===============
[postgres(at)anothermachine ~]$ psql -W -h pgtest02
Password: <type in bogus password>
psql: FATAL:  no pg_hba.conf entry for host "192.168.123.234", user
"postgres", database "postgres", SSL off
======================================

The error message returned here is clearly bogus. It's correct in that there
is no pg_hba.conf entry for that user/host, with SSL off, but imo. it should
have returned the more usefull error message:
======================================
psql -W -h pgtest02
Password: <type in bogus password>
psql: FATAL:  password authentication failed for user "postgres"
======================================

Responses

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2008-12-09 08:53:57
Subject: Re: BUG #4572: Incorrect error message when using wrong password with hostssl
Previous:From: Tom LaneDate: 2008-12-09 01:20:28
Subject: Re: BUG #4562: ts_headline() adds space when parsing url

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group