Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 08 Feb 2000 15:01:31 +1300
From:      "Sarton O'Brien" <roguetr@patho.gen.nz>
To:        "freebsd-questions@FreeBSD.ORG" <freebsd-questions@FreeBSD.ORG>
Subject:   Postgres user nobody
Message-ID:  <389F78FB.8F188B3C@patho.gen.nz>

next in thread | raw e-mail | index | archive | help
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?389F78FB.8F188B3C>