Re: Unable to connect to PostgreSQL Server: Permission denied

From: "Javier Carlos" <nediam(at)nediam(dot)com(dot)mx>
To: "muralidhar sortur" <sorturmuralidhar(at)rediffmail(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: Unable to connect to PostgreSQL Server: Permission denied
Date: 2006-04-04 05:13:07
Message-ID: 65133.201.139.153.195.1144127587.squirrel@mail.nediam.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

Did you try to restart the PosgreSQL server using pg_ctl ?

$ pg_ctl restart

Are you able to connect as user from the command line?

$ psql AddressBook www

Regards,

Javier

>
> Hi ,
> Here is the complete description of the problem ...
>
> I have newly installed fedora core 4 with option as everyting.
>
> it comes with apache webserver, postgresql , php-postgresql, php-gd etc,
>
> it creates a default user postgres with home = /var/lib/psql
>
> 1. i loged in as postgres
>
> 2. called initdb
> created database under directory ~/data
>
> 3. changed postgresql.conf to include
> listen_addresses = '*'
> port = 5432
>
> 4. changed pg_hba.conf
> local all all trust
> host all all 127.0.0.1/32 trust
> host all all 192.168.1.18/24 trust
> host all all ::1/128 trust
>
> 5. postmaster -i -D ~/data &
>
> 6. createdb AddressBook
>
> 7. psql AddressBook
>
> 8. create table addresses( Name text, Phone text, Email text);
>
> 9. create user www NOCREATEDB NOCREATEUSER;
>
> 10. grant all on addresses to www;
>
> 11. from other terminal i loged in as root
>
> 12. changed /etc/httpd/conf/httpd.conf
>
> User www
> Group postgres
>
> 13. copied add.html and add-entry.php into directory /var/www/html
>
> add.html
> ------------------------------------------------------
> <HTML>
> <BODY>
>
> <FORM ACTION="add-entry.php" METHOD="GET">
>
> <TABLE BORDER=1>
> <TR>
> <TD>
> <TABLE BORDER=0 CELLPADDING=2 CELLSPACING=2>
> <TR>
> <TD>Name</TD>
> <TD><INPUT TYPE="TEXT" NAME="Name" VALUE=""></TD>
> </TR>
> <TR>
> <TD>Phone</TD>
> <TD><INPUT TYPE="TEXT" NAME="Phone" VALUE=""></TD>
> </TR>
> <TR>
> <TD>E-mail</TD>
> <TD><INPUT TYPE="TEXT" NAME="Email" VALUE=""></TD>
> </TR>
> <TR>
> <TD COLSPAN=2 ALIGN=CENTER>
> <INPUT TYPE="SUBMIT" VALUE="Add Entry">
> </TD>
> </TR>
> </TABLE>
> </TD>
> </TR>
> </TABLE>
> </FORM>
>
> </BODY>
> </HTML>
> --------------------------------------------------
> add-entry.php
> --------------------------------------------------
>
> <HTML>
> <BODY>
> <?PHP
> $db = pg_Connect( "dbname=AddressBook user=www");
> if( !$db )
> {
> echo "Could not connect!";
> exit;
> }
>
> $Name=$_GET['Name'];
> $Email=$_GET['Email'];
> $Phone=$_GET['Phone'];
>
> $query = "INSERT INTO Addresses VALUES( '$Name', '$Phone', '$Email' );";
>
> $result = pg_Exec( $db, $query );
>
> if( !$result )
> {
> echo "No result set returned!";
> exit;
> }
>
> $rows = pg_NumRows( $result );
>
> if( $rows = 0 )
> {
> echo "Add Failed.";
> exit;
> }
>
> $query = "SELECT * FROM Addresses WHERE \"Name\" = '$Name';";
>
> $query = "SELECT * FROM Addresses WHERE \"Name\" = '$Name';";
>
> $result = pg_Exec( $db, $query );
> $row = pg_Fetch_Row( $result, 0 );
>
> $nameResult = $row[0];
> $phoneResult = $row[1];
> $emailResult = $row[2];
>
> echo "Name = $nameResult<BR>";
> echo "Phone = $phoneResult<BR>";
> echo "E-mail = $emailResult<BR>";
>
> pg_Close( $db );
> ?>
>
> <H3>Add Okay!</H3>
>
> </BODY>
> </HTML>
> -------------------------------------------------------------
> Error i get is
> Mon Apr 03 18:39:53 2006] [notice] Apache/2.0.54 (Fedora) configured --
> resuming normal operations
> [Mon Apr 03 18:42:17 2006] [error] [client 127.0.0.1] File does not exist:
> /var/www/html/favicon.ico
> [client 127.0.0.1] PHP Warning: pg_connect() [<a
> href='function.pg-connect'>function.pg-connect</a>]: Unable to connect to
> PostgreSQL server: could not connect to server: Permission denied\n\tIs
> the server running locally and accepting\n\tconnections on Unix domain
> socket &quot;/tmp/.s.PGSQL.5432&quot;? in /var/www/html/add-entry.php on
> line 5, referer: http://localhost/add.html
> [Mon Apr 03 18:42:22 2006] [error] [client 127.0.0.1] File does not exist:
> /var/www/html/favicon.ico
>
> _______________________________________________________
>
> from the command line it works fine
> i.e php add-entry.php works fine ( ofcourse adds an empty row into the
> data base)
>
> --------------------------------------------------
>
> i did telnet
>
> [root(at)localhost html]# telnet localhost 5432
> Trying 127.0.0.1...
> Connected to localhost.localdomain (127.0.0.1).
> Escape character is '^]'.
>
>
> Connection closed by foreign host.
>
> data/pg_log/postgresql-Mon.log contains
>
> LOG: invalid length of startup packet
>
>
>
> -------------------------------
>
>
> I am not getting any clue as to how to solve this problem ...let me know
> if you have any idea in solving this porblem.
>
> regards
> Muralidhar
>
>
>

-------------
nediam.com.mx

In response to

Browse pgsql-php by date

  From Date Subject
Next Message muralidhar sortur 2006-04-04 13:46:32 Re: Unable to connect to PostgreSQL Server: Permission denied
Previous Message Mariusz Pękala 2006-04-03 20:01:23 Re: Unable to connect to PostgreSQL Server: Permission denied