Bug in user pg_ident.conf mapping code?

From: Shaun Thomas <sthomas(at)optionshouse(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Bug in user pg_ident.conf mapping code?
Date: 2014-04-02 17:01:46
Message-ID: 533C427A.2080901@optionshouse.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey,

So, I've gotten this on 9.3.4 after having a complaint from a user with
a hyphen in his name, but I dug further.

This is at the top of my pg_hba.conf file:

local all all peer map=local

And this is my pg_ident.conf:

local dude-guy dudeguy
local /(.*)$ \1

I've reloaded configs, and even went as far as to restart the database.
Yet the errors I get in the logs say this:

2014-04-02 10:39:59 CDT|LOG: no match in usermap "local" for user
"dude-guy" authenticated as "dude-guy"
2014-04-02 10:39:59 CDT|FATAL: Peer authentication failed for user
"dude-guy"
2014-04-02 10:39:59 CDT|DETAIL: Connection matched pg_hba.conf line 84:
"local all all peer map=local"

What's going on, here? Shouldn't it be checking for peer auth before
applying the mapping? Am I missing something?

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas(at)optionshouse(dot)com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Victor Sterpu 2014-04-02 18:13:22 Re: Lock problem
Previous Message Victor Sterpu 2014-04-02 16:19:06 Re: Lock problem