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