From nicolas.renie@wanadoo.fr Tue Apr  8 20:32:21 2003
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--




From wweng@kencast.com Wed Apr  9 16:23:18 2003
X-Original-To: pgsql-interfaces@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 0C0AD475FEE
	for <pgsql-interfaces@postgresql.org>;
	Wed,  9 Apr 2003 12:23:18 -0400 (EDT)
Received: from mta5.snet.net (mta5.snet.net [204.60.203.77])
	by postgresql.org (Postfix) with ESMTP id 05E29475EDF
	for <pgsql-interfaces@postgresql.org>;
	Wed,  9 Apr 2003 12:23:17 -0400 (EDT)
Received: from pop.snet.net (pop.snet.net [204.60.203.72])
	by mta5.snet.net (8.12.3/8.12.3/SNET-mx-1.2/D-1.1.1.1/O-1.1.1.1) with
	ESMTP id h39GNMBd015535; Wed, 9 Apr 2003 12:23:22 -0400 (EDT)
X-Originating-IP: [64.252.95.167]
X-SBCIS-MTA: [pop.snet.net]
Received: from kencast.com (167.95.252.64.snet.net [64.252.95.167])
	by pop.snet.net (8.12.3/8.12.3/SNET-pop-1.2/D-1.1.1.1/O-1.1.1.1) with
	ESMTP id h39GNLme004854; Wed, 9 Apr 2003 12:23:21 -0400 (EDT)
Message-ID: <3E944D04.9000301@kencast.com>
Date: Wed, 09 Apr 2003 12:40:36 -0400
From: Wei Weng <wweng@kencast.com>
User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:1.3) Gecko/20030312
X-Accept-Language: en-us, en, zh-cn
MIME-Version: 1.0
To: nicolas renie <nicolas.renie@wanadoo.fr>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: problem to connect
References: <000801c2fe0e$63ee8b10$670c0c50@nicolas>
In-Reply-To: <000801c2fe0e$63ee8b10$670c0c50@nicolas>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Status: No, hits=-38.8 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT,
	REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MOZILLA_UA
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/52
X-Sequence-Number: 3991

The default behavior for postgres uses IDENT. So you need to log on as 
user nicolas to be able to use postgres user nicolas. You can look at 
/var/lib/pgsql/data/pg_hba.conf for configuration detail.

Wei

nicolas renie wrote:

> 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(createdb 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
>  comes up, (empty) but there is an error message box in front of it. 
> The message is:
>     
>  "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
>  
>  
> Please, help me !
> regards
>  
> Nicolas RENIE
>  
>  




From cmaj@freedomcorpse.info Wed Apr  9 16:45:34 2003
X-Original-To: pgsql-interfaces@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7790B476342
	for <pgsql-interfaces@postgresql.org>;
	Wed,  9 Apr 2003 12:45:34 -0400 (EDT)
Received: from Freedomcorpse.INFO (roc-66-67-208-153.rochester.rr.com
	[66.67.208.153])
	by postgresql.org (Postfix) with ESMTP id 681AE476332
	for <pgsql-interfaces@postgresql.org>;
	Wed,  9 Apr 2003 12:45:33 -0400 (EDT)
Received: from a pile of corpses; Wed, 09 Apr 2003 12:42:53 -0400
Date: Wed, 9 Apr 2003 12:42:53 -0400 (EDT)
From: "C. Maj" <cmaj@freedomcorpse.info>
To: nicolas renie <nicolas.renie@wanadoo.fr>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: problem to connect
In-Reply-To: <000801c2fe0e$63ee8b10$670c0c50@nicolas>
Message-ID: <Pine.LNX.4.44.0304091227250.8925-100000@freebird.stanley.cup>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Status: No, hits=-18.5 required=5.0
	tests=BAYES_00,IN_REP_TO,QUOTED_EMAIL_TEXT,USER_AGENT_PINE
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/53
X-Sequence-Number: 3992

On Tue, 8 Apr 2003, nicolas renie waxed:

8<'s

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

In pg_hba.conf, do you have the following:

local        all                                           trust
host         all         127.0.0.1     255.255.255.255     trust

Also, you need to be either root or the postgres user to edit the file.

To work with PgAccess, you will need to give the user you want to login
as SELECT permission on the pg_user table (if it's a different user than
that which created the database.)

--Chris


-- 

Chris Maj <cmaj_hat_freedomcorpse_hot_info>
0xC0051F6A
5EB8 2035 F07B 3B09 5A31  7C09 196F 4126 C005 1F6A