Thread: [NEWBIE] FATAL 1: IDENT authentication failed for user "admin"
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
Alexandre Touret
CGBI
69 Boulevard Galliéni
92130 Issy les Moulineaux
tel.: 01/55/95/53/95 Poste: 5395
mailto:alexandre.touret@cgbi.fr
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
______________________________# 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
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
Have you got an example of configuration please?
Alexandre Touret
Wim wrote:
Alexandre Touret
CGBI
69 Boulevard Galliéni
92130 Issy les Moulineaux
tel.: 01/55/95/53/95 Poste: 5395
mailto:alexandre.touret@cgbi.fr
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
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