X-Original-To: pgsql-interfaces@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 17D314758E6
	for <pgsql-interfaces@postgresql.org>;
	Tue,  8 Apr 2003 16:32:21 -0400 (EDT)
Received: from mwinf0403.wanadoo.fr (smtp3.wanadoo.fr [193.252.22.27])
	by postgresql.org (Postfix) with ESMTP id 319E6474E42
	for <pgsql-interfaces@postgresql.org>;
	Tue,  8 Apr 2003 16:32:20 -0400 (EDT)
Received: from nicolas (Mix-Tours-112-1-103.abo.wanadoo.fr [80.12.12.103])
	by mwinf0403.wanadoo.fr (SMTP Server) with SMTP id 2558C50003DA
	for <pgsql-interfaces@postgresql.org>;
	Tue,  8 Apr 2003 22:32:20 +0200 (CEST)
Message-ID: <000801c2fe0e$63ee8b10$670c0c50@nicolas>
From: "nicolas renie" <nicolas.renie@wanadoo.fr>
To: <pgsql-interfaces@postgresql.org>
Subject: problem to connect
Date: Tue, 8 Apr 2003 22:35:26 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0005_01C2FE1F.26A7FD20"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Spam-Status: No,
 hits=0.0 required=5.0 tests=BAYES_30,HTML_20_30 version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/51
X-Sequence-Number: 3990

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C2FE1F.26A7FD20
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hye

I use linux mandrack 9.0 and postgres 7.2
I can't connect to postgresql (even in local) if I use a postgres user.
I don't know what to do.
I've started the daemon (root# etc/rc.d/init.d/postgresql start)
logged under postgres I made a user (createuser nico) and a database(create=
db test)
But I can't access to this database if I am logged under an other user.
(su Eddy or anathor linux user)

When I try: psql test -h localhost -U nicolas I have the message :
IDENT authentification failed for user nicolas.
I can see the same message when I try to connect whith pgaccess.

If I try to start pgaccess with: "pgaccess test", the main PgAccess window=
=20
 comes up, (empty) but there is an error message box in front of it. The me=
ssage is:
=20=20=20=20=20
 "Error trying to connect to database "test" on host localhost.
   is the postmaster running (with -i) at
    'localhost' and accepting connections on TCP/IP port '5432'?"

Therefore I stopped postgresql etc/rc.d/init.d/postgresql stop
I started it logged under postgres with options ($ postmaster -h localhost =
-i )

I logged under another linux user
I tried : psql test -h localhost -U nicolas and received the message

No pga_hba.conf entry for host localhost, user nicolas, database test

I tryed to change the pg_dba.conf (trust) file but another message appears.

I would like to know what to do especially to use pgaccess
=20

Please, help me !
regards

Nicolas RENIE

=20

------=_NextPart_000_0005_01C2FE1F.26A7FD20
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hye</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I use linux mandrack 9.0 and postgres 7.2<=
BR>I=20
can't connect to postgresql (even in local) if I use a postgres user.<BR>I =
don't=20
know what to do.<BR>I've started the daemon (root# etc/rc.d/init.d/postgres=
ql=20
start)<BR>logged under postgres I made a user (createuser nico) and a=20
database(createdb test)<BR>But I can't access to this database if I am logg=
ed=20
under an other user.<BR>(su Eddy or anathor linux user)</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>When I try: psql test -h localhost -U nico=
las I=20
have the message :<BR>IDENT authentification failed for user nicolas.<BR>I =
can=20
see the same message when I try to connect whith pgaccess.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>If I try to start pgaccess with: "pgaccess=
 test",=20
the main PgAccess window <BR>&nbsp;comes up, (empty) but there is an error=
=20
message box in front of it. The message is:<BR>&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>&nbsp;"Error trying to connect to database "test" on host=20
localhost.<BR>&nbsp;&nbsp; is the postmaster running (with -i)=20
at<BR>&nbsp;&nbsp;&nbsp; 'localhost' and accepting connections on TCP/IP po=
rt=20
'5432'?"</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Therefore I stopped postgresql=20
etc/rc.d/init.d/postgresql stop<BR>I started it logged under postgres with=
=20
options ($ postmaster -h localhost -i )</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I logged under another linux user<BR>I tri=
ed : psql=20
test -h localhost -U nicolas and received the message</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>No pga_hba.conf entry for host localhost, =
user=20
nicolas, database test</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I tryed to change the pg_dba.conf (trust) =
file but=20
another message appears.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I would like to know what to do especially=
 to use=20
pgaccess<BR>&nbsp;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Please, help me !<BR>regards</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Nicolas RENIE</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;</FONT></DIV></BODY></HTML>

------=_NextPart_000_0005_01C2FE1F.26A7FD20--