| From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
|---|---|
| To: | lynch(at)lscorp(dot)com, pgsql-general(at)postgreSQL(dot)org, php3(at)lists(dot)php(dot)net |
| Subject: | RE: [GENERAL] User Authentication Failed |
| Date: | 1998-05-19 19:37:26 |
| Message-ID: | F10BB1FAF801D111829B0060971D839F292F1B@dal_cps.cpsgroup.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Make sure the PostgreSQL's postmaster is being run with the -i option.
Or take out the port number specification in your script.
Hope this helps,
DEJ
> -----Original Message-----
> From: lynch(at)lscorp(dot)com [SMTP:lynch(at)lscorp(dot)com]
> Sent: Tuesday, May 19, 1998 1:43 PM
> To: pgsql-general(at)postgreSQL(dot)org; php3(at)lists(dot)php(dot)net
> Subject: [GENERAL] User Authentication Failed
>
> The PostgreSQL Glimpse mailing list search thing is down.
>
> I found some similar things in PHP's archives, but none that really
> seemed
> applicable. I only know half the story, though, because my ISP is
> running
> PostgreSQL and compiling PHP for me, so it's hard to play around with
> options and such.
>
> All I can say for sure is:
>
> The php.cgi seems to work okay from the web, as far as phpinfo goes.
>
> psql -u chat works okay, and I've granted everything to user www, and
> verified that I can psql -u chat and use www as name and password and
> do a
> select.
>
> Is there something I need to do to "grant connect access" to user www?
> I can't seem to find such a beast...
>
> php.cgi -v reports version 3.0b6, but my ISP claimed it was an RC
> release...
>
> php.cgi is owned by my login name, and when it used to be owned by
> root, it
> had an even nastier error message about misconfiguration :-)
>
> PostgreSQL is probably the most recent version, since it was just
> rebuilt,
> which is what caused the trouble.
>
> pg_Connect destructively modifies the arguments passed to it, which
> seems
> odd to me, but I'm a lisp hacker, so what do I know?
>
> Here's the actual error message:
>
> Warning: Unable to connect to PostgresSQL server: User authentication
> failed in /iiw/htdocs/chatmusic.com/connect.php
> on line 10
> Couldn't connect to database chat on port 5432 at host ruby
> (Options auth=password user=www password=www tty /dev/null)
>
> And my source code that produced it:
> <HTML>
> <HEAD><TITLE>Just Connect To PostgreSQL</TITLE></HEAD>
> <BODY>
> <?php
> $host = "";
> $port = 5432;
> $options = "";
> $tty = "";
> $dbname = "chat";
> $connection = pg_Connect($host, $port, $options, $tty, $dbname);
> if (!$connection){
> echo("Couldn't connect to database $dbname on port $port at
> host
> $host<BR>\n");
> if ($options != "" || $tty != ""){
> echo(" (Options $options tty $tty)<BR>\n");
> }
> exit;
> }
> else{
> echo("<H1><CENTER>Successfully Connected</CENTER></H1>\n");
> phpinfo();
> }
> ?>
> </BODY>
> </HTML>
>
> --
> --
> -- "TANSTAAFL" Rich lynch(at)lscorp(dot)com
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wr | 1998-05-19 20:34:31 | Re: [GENERAL] extracting date information? |
| Previous Message | Richard Lynch | 1998-05-19 18:43:13 | User Authentication Failed |