Thread: pg_hba.conf and ident authentification

I don't know, what is problem, see next please:

1. OS:
debian linux 2.2.x

2. postgres version:
6.5.3

3. auth deamon runing

4. name of my account:
krssak

5. pg_hba.conf:
local   rocnikovy                                       trust
host    rocnikovy       127.0.0.1       255.255.255.255 ident   map

6. pg_ident.conf:
map     krssak  jozok

7. create user jozok;

8. select * from pg_shadow; :
usename |usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd|valuntil

--------+--------+-----------+--------+--------+---------+------+---------------
-------
jozok   |    1091|f          |f       |f       |f        |      |

postgres|      31|t          |t       |t       |t        |
|2037-01-31 07:0
0:00+01

9.
krssak@pec:~$ psql -h localhost -d rocnikovy
Connection to database 'rocnikovy' failed.
IDENT authentication failed for user 'krssak'
krssak@pec:~$

what am I missing?

thanks

====================================================================
Univerzitne pastoracne centrum bl. Jozefa Freinademetza v Bratislave
Jozef Krssak
krssak@upc.uniba.sk       tel. 0905 906 297
====================================================================

of course:
postmaster.init:
PGALLOWTCPIP=yes

---------------------------
Jozef KRSSAK

sorry, I want to say:
PGALLOWTCPIP=yes
but nothing

krssak@pec:~$ psql -h localhost -d rocnikovy
Connection to database 'rocnikovy' failed.
IDENT authentication failed for user 'krssak'
krssak@pec:~$

Jozef Krssak

>This is just a guess, which may be wrong as you did not post your postmaster
>options and the error message explicitly points out IDENT as the culprit. If
>my guess is wrong, your IDENT setup would be a good place to look (and
>tcpwrappers or anything else that might affect).

IDENT setup is OK, I think:
/var/log/syslog:
Apr 12 14:14:55 pec identd[5349]: reply to 127.0.0.1: 1610 , 5432 : USERID : UNIX
:krssak

--------------------------
Jozef KRSSAK

Jozef KRSSAK writes:

> 4. name of my account:
> krssak
>
> 5. pg_hba.conf:
> local   rocnikovy                                       trust
> host    rocnikovy       127.0.0.1       255.255.255.255 ident   map
>
> 6. pg_ident.conf:
> map     krssak  jozok
>
> 7. create user jozok;

> 9.
> krssak@pec:~$ psql -h localhost -d rocnikovy
> Connection to database 'rocnikovy' failed.
> IDENT authentication failed for user 'krssak'

You need to instruct psql to connect as database user 'jozok'.  Otherwise
it will default to 'krssak' and your careful setup is for nought.  See
option '-u'.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/

Check the file permissions on pg_hba.conf, I beat my head against the wall with
a similar situation.

Rodney Hampton