From owner-freebsd-questions  Mon Feb  7 17:58:52 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 0E0AE4106
	for <freebsd-questions@FreeBSD.ORG>; Mon,  7 Feb 2000 17:58:43 -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 OAA31370
	for <freebsd-questions@FreeBSD.ORG>; Tue, 8 Feb 2000 14:59:27 +1300 (NZDT)
Message-ID: <389F78FB.8F188B3C@patho.gen.nz>
Date: Tue, 08 Feb 2000 15:01:31 +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: Postgres user nobody
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

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