Re: [NEWBIE] FATAL 1: IDENT authentication failed for

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(at)belbone(dot)be
peering : peering(at)belbone(dot)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(dot)touret(at)cgbi(dot)fr