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

HI Alexandre,

Sorry, I don't use ident as authentication. Maybe google can help you
with that ;-)

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
------------------------------------------------------------------------------
"Things should be described as simply as possible,but no simpler." --
Albert Einstein
------------------------------------------------------------------------------
2:35pm up 37 days, 5:14, 1 user, load average: 1.29, 1.18, 1.12




On Thu, 2003-08-07 at 14:32, Alexandre Touret wrote:
> 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