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
====================================================================
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 |