From owner-freebsd-questions  Mon Feb  7 19:58: 6 2000
Delivered-To: freebsd-questions@freebsd.org
Received: from tardis.patho.gen.nz (tardis.patho.gen.nz [203.97.2.226])
	by builder.freebsd.org (Postfix) with ESMTP id 59F9F4059
	for <freebsd-questions@FreeBSD.ORG>; Mon,  7 Feb 2000 19:58:02 -0800 (PST)
Received: from patho.gen.nz (dhcp2.quicksilver.co.nz [202.89.130.11])
	by tardis.patho.gen.nz (8.9.3/8.9.3) with ESMTP id QAA04615
	for <freebsd-questions@FreeBSD.ORG>; Tue, 8 Feb 2000 16:58:48 +1300 (NZDT)
Message-ID: <389F94F4.A31524E3@patho.gen.nz>
Date: Tue, 08 Feb 2000 17:00:52 +1300
From: "Sarton O'Brien" <roguetr@patho.gen.nz>
Reply-To: sobrien@quicksilver.co.nz
Organization: Quicksilver Internet
X-Mailer: Mozilla 4.7 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
To: "freebsd-questions@FreeBSD.ORG" <freebsd-questions@FreeBSD.ORG>
Subject: Re: Postgres user nobody
References: <389F78FB.8F188B3C@patho.gen.nz>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

Delete this from your mail and forget you ever saw it :)


Sarton O'Brien wrote:
> 
> Hi,
> 
> This is my pg_Connect line:
> 
> <?php
>           $db = pg_connect("localhost", 5432, "signup");
> 
> I tried to use pg_Connect and I eventually got it working by creating a
> database user called 'nobody'. Now I can connect but everything is
> access denied, unless (I'm assuming) I create the database using
> 'nobody'.
> 
> Warning: PostgresSQL query failed: ERROR: details: Permission denied. in
> /home/roguetr/public_html/index.php on line
> 21
> 
> But I don't want to do that, I want to use roguetr. So I used:
> 
> <?php
>           $db = pg_connect("localhost", 5432, "roguetr", "signup");
> 
>                                 OR
> 
> <?php
>           $db = pg_connect("local", 5432, "roguetr", "mypasswd", "signup");
> 
> and I get:
> 
> Warning: Unable to connect to PostgresSQL server: pqReadData() --
> backend closed the channel unexpectedly. This
> probably means the backend terminated abnormally before or while
> processing the request. in
> /home/roguetr/public_html/index.php on line 20
> 
> Any help appreciated.
> 
> Sarton O'Brien
> 
> To Unsubscribe: send mail to majordomo@FreeBSD.org
> with "unsubscribe freebsd-questions" in the body of the message


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message