Thread: [NEWBIE] FATAL 1: IDENT authentication failed for user "admin"

[NEWBIE] FATAL 1: IDENT authentication failed for user "admin"

From
Alexandre Touret
Date:
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

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

From
Wim
Date:
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





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

From
Alexandre Touret
Date:
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

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

From
Wim
Date:
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