pg_hba.conf and ident authentification

From: Jozef KRSSAK <krssak(at)upc(dot)uniba(dot)sk>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_hba.conf and ident authentification
Date: 2001-04-12 00:52:38
Message-ID: Pine.LNX.4.21.0104120223330.2883-100000@pec.upc.uniba.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)pec:~$ psql -h localhost -d rocnikovy
Connection to database 'rocnikovy' failed.
IDENT authentication failed for user 'krssak'
krssak(at)pec:~$

what am I missing?

thanks

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message vijayendra mohan agrawal 2001-04-12 10:01:11 Access Control in PostGreSQL
Previous Message superedo.geoNOSPAM 2001-04-11 17:14:24 PHP/Postgres/Solaris problem