Re: Bug in user pg_ident.conf mapping code?

On 04/02/2014 10:01 AM, Shaun Thomas wrote:
> 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?

Who are you connecting as dude-guy or dudeguy?

Looks to me like:

psql -d some_db -U dude-guy

From here:

http://www.postgresql.org/docs/9.3/interactive/auth-username-maps.html

Example 19.2

If I am following you are restricting dude-guy to logging in as dudeguy.

>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com