Date: Tue, 08 Feb 2000 17:00:52 +1300 From: "Sarton O'Brien" <roguetr@patho.gen.nz> To: "freebsd-questions@FreeBSD.ORG" <freebsd-questions@FreeBSD.ORG> Subject: Re: Postgres user nobody Message-ID: <389F94F4.A31524E3@patho.gen.nz> References: <389F78FB.8F188B3C@patho.gen.nz>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?389F94F4.A31524E3>