Re: [NEWBIE] FATAL 1: IDENT authentication failed for - Mailing list pgsql-novice

Have you got an example of configuration please?

Alexandre Touret
Wim wrote:

Hi Alexandre,

You need to install or configure your ident server...

This is written in pg_hba.conf:

ident:      For TCP/IP connections, authentication is done by contacting
the ident server on the client host.  Remember, this is only as secure
as the client machine.  On machines that support unix-domain socket
credentials (currently Linux, FreeBSD, NetBSD, and BSD/OS), this method
also works for "local" connections.

Cheers!
Wim De Hul
------------------------------------------------------------------------------
IP SERVICES SPECIALIST
Belgacom Carrier and Wholesale Business Unit (CBU)
------------------------------------------------------------------------------
AS6774
Ripe : WDH25-RIPE
reply-to : NOC@belbone.be
peering : peering@belbone.be
NOC Tel : +32 2/547.51.00
www.belgacom.be/carrier
------------------------------------------------------------------------------
"Egotist: a person more interested in himself than in me."
- Ambrose Bierce (1842-1914)
------------------------------------------------------------------------------
1:50pm up 37 days, 4:29, 1 user, load average: 1.57, 1.24, 1.09



On Thu, 2003-08-07 at 13:28, Alexandre Touret wrote: 

Hi all,
I m beginning under Postgres.
I want to connect an UDDI registry to Postgres with JDBC . Altough I
was created a database and a user. However, when I am trying to
connect to my database with JDBC ant with the psql command I have the
same error in /var/log/syslog

Aug  7 13:17:43 linux167 postgres[8254]: [1] FATAL 1:  IDENT
authentication failed for user "admin"

I have filled the files pg_hba.conf and pg_ident.conf . Also I have
created an user in my db schema.

My configuration:

OS Debian Linux Woody (stable)
DB : PostgreSQL 7.2

pg_hba.conf:

local        all                                           ident uddi
host    all     192.168.3.97    255.0.0.0       ident   uddi
host    all     127.0.0.1       255.0.0.0       ident   uddi
host    all     127.0.0.1       255.0.0.0       trust   uddi

pg_ident.conf:

# MAP     IDENT    PGUSERNAME
uddi    admin   admin
uddi    postrges        postgres

my command under psql:

CREATE USER admin PASSWD 'admin';

Thanks for your help

Alexandre Touret
______________________________
Alexandre Touret
CGBI
69 Boulevard Galliéni
92130 Issy les Moulineaux
tel.: 01/55/95/53/95        Poste: 5395
mailto:alexandre.touret@cgbi.fr   

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
 

______________________________
Alexandre Touret
CGBI
69 Boulevard Galliéni
92130 Issy les Moulineaux
tel.: 01/55/95/53/95        Poste: 5395
mailto:alexandre.touret@cgbi.fr