Unable to connect to PostgreSQL Server: Permission denied

This is a multipart mime message

--Next_1144083971---0-203.199.83.33-19612
Content-type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

=0AHi ,=0AHere is the complete description of the problem ...=0A=0AI have=
newly installed fedora core 4 with option as everyting.=0A=0Ait comes with=
apache webserver, postgresql , php-postgresql, php-gd etc,=0A=0Ait creates=
a default user postgres with home =3D /var/lib/psql=0A=0A1. i loged in as =
postgres=0A=0A2. called initdb=0A created database under directory ~/data=
=0A=0A3. changed postgresql.conf to include=0A listen_addresses =3D '*=
'=0A port =3D 5432=0A=0A4. changed pg_hba.conf=0A local all all=
trust=0A host all all 127.0.0.1/32 =
trust=0A host all all 192.168.1.18/24 trust=0A host =
all all ::1/128 trust=0A=0A5. postmaster -i -D ~/data &=0A=
=0A6. createdb AddressBook=0A=0A7. psql AddressBook=0A=0A8. create table ad=
dresses( Name text, Phone text, Email text);=0A=0A9. create user www NOCREA=
TEDB NOCREATEUSER;=0A=0A10. grant all on addresses to www;=0A=0A11. from ot=
her terminal i loged in as root=0A=0A12. changed /etc/httpd/conf/httpd.conf=
=0A=0A User www=0A Group postgres=0A=0A13. copied add.html and add-en=
try.php into directory /var/www/html=0A=0Aadd.html=0A----------------------=
--------------------------------=0A<HTML>=0A<BODY>=0A=0A<FORM ACTION=3D"add=
-entry.php" METHOD=3D"GET">=0A=0A<TABLE BORDER=3D1>=0A <TR>=0A <TD>=0A <=
TABLE BORDER=3D0 CELLPADDING=3D2 CELLSPACING=3D2>=0A <TR>=0A <TD>Name=
</TD>=0A <TD><INPUT TYPE=3D"TEXT" NAME=3D"Name" VALUE=3D""></TD>=0A <=
/TR>=0A <TR>=0A <TD>Phone</TD>=0A <TD><INPUT TYPE=3D"TEXT" NAME=3D=
"Phone" VALUE=3D""></TD>=0A </TR>=0A <TR>=0A <TD>E-mail</TD>=0A =
<TD><INPUT TYPE=3D"TEXT" NAME=3D"Email" VALUE=3D""></TD>=0A </TR>=0A =
<TR>=0A <TD COLSPAN=3D2 ALIGN=3DCENTER>=0A <INPUT TYPE=3D"SUBMIT" =
VALUE=3D"Add Entry">=0A </TD>=0A </TR>=0A </TABLE>=0A </TD>=0A </T=
R>=0A</TABLE>=0A</FORM>=0A=0A</BODY>=0A</HTML>=0A--------------------------=
------------------------=0Aadd-entry.php=0A----------------- ---------------=
------------------=0A=0A<HTML>=0A<BODY>=0A<?PHP=0A$db =3D pg_Connect( "dbna=
me=3DAddressBook user=3Dwww");=0Aif( !$db )=0A{=0A echo "Could not connect=
!";=0A exit;=0A}=0A=0A$Name=3D$_GET['Name'];=0A$Email=3D$_GET['Emai l'];=0A=
$Phone=3D$_GET['Phone'];=0A=0A$query =3D "INSERT INTO Addresses VALUES( '$N=
ame', '$Phone', '$Email' );";=0A=0A$result =3D pg_Exec( $db, $query );=0A=
=0Aif( !$result )=0A{=0A echo "No result set returned!";=0A exit;=0A}=0A=
=0A$rows =3D pg_NumRows( $result );=0A=0Aif( $rows =3D 0 )=0A{=0A echo "Ad=
d Failed.";=0A exit;=0A}=0A=0A$query =3D "SELECT * FROM Addresses WHERE \"=
Name\" =3D '$Name';";=0A=0A$query =3D "SELECT * FROM Addresses WHERE \"Name=
\" =3D '$Name';";=0A=0A$result =3D pg_Exec( $db, $query );=0A$row =3D pg_Fe=
tch_Row( $result, 0 );=0A=0A$nameResult =3D $row[0];=0A$phoneResult =3D $ro=
w[1];=0A$emailResult =3D $row[2];=0A=0Aecho "Name =3D $nameResult ";=0Ae=
cho "Phone =3D $phoneResult ";=0Aecho "E-mail =3D $emailResult ";=0A=
=0Apg_Close( $db );=0A?>=0A=0A<H3>Add Okay!</H3>=0A=0A</BODY>=0A</HTML>=0A-=
------------------------------------------------------------ =0AError i get =
is=0AMon Apr 03 18:39:53 2006] [notice] Apache/2.0.54 (Fedora) configured -=
- resuming normal operations=0A[Mon Apr 03 18:42:17 2006] [error] [client 1=
27.0.0.1] File does not exist: /var/www/html/favicon.ico=0A[client 127.0.0.=
1] PHP Warning: pg_connect() [<a href=3D'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 "/tmp/.s.PGSQL.5432"? in /var/=
www/html/add-entry.php on line 5, referer: http://localhost/add.html=0A[Mon=
Apr 03 18:42:22 2006] [error] [client 127.0.0.1] File does not exist: /var=
/www/html/favicon.ico=0A=0A_________________________________ _______________=
_______=0A=0Afrom the command line it works fine=0Ai.e php add-entry.php wo=
rks fine ( ofcourse adds an empty row into the data base)=0A=0A------------=
--------------------------------------=0A=0Ai did telnet=0A=0A[root [at] localho=
st html]# telnet localhost 5432=0ATrying 127.0.0.1...=0AConnected to localh=
ost.localdomain (127.0.0.1).=0AEscape character is '^]'.=0A=0A=0AConnection=
closed by foreign host.=0A=0Adata/pg_log/postgresql-Mon.log contains=0A=0A=
LOG: invalid length of startup packet=0A=0A=0A=0A-------------------------=
------=0A=0A=0AI am not getting any clue as to how to solve this problem ..=
..let me know if you have any idea in solving this porblem.=0A=0Aregards=0AM=
uralidhar=0A=0A=0A
--Next_1144083971---0-203.199.83.33-19612
Content-type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

=0A =0AHi , =0AHere is the complete description of the prob=
lem ... =0A =0AI have newly installed fedora core 4 with option as ev=
eryting. =0A =0Ait comes with apache webserver, postgresql , php-post=
gresql, php-gd etc, =0A =0Ait creates a default user postgres with ho=
me =3D /var/lib/psql =0A =0A1. i loged in as postgres =0A =0A2.=
called initdb =0A created database under directory ~/data =0A<=
BR>=0A3. changed postgresql.conf to include =0A list=
en_addresses =3D '*' =0A port =3D 5432 =0A =0A=
4. changed pg_hba.conf =0A local all all=
=
; trust =0A host all all&n=
bsp; 127.0.0.1/32 trust =0A &nbs=
p; host all all 192.168.1.18/24 =
; trust =0A host all all &n=
bsp; ::1/128 trust =0A =0A5.=
postmaster -i -D ~/data & =0A =0A6. createdb AddressBook =0A<=
BR>=0A7. psql AddressBook =0A =0A8. create table addresses( Name text=
, Phone text, Email text); =0A =0A9. create user www NOCREATEDB NOCRE=
ATEUSER; =0A =0A10. grant all on addresses to www; =0A =0A11. f=
rom other terminal i loged in as root =0A =0A12. changed /etc/httpd/c=
onf/httpd.conf =0A =0A User www =0A Grou=
p postgres =0A =0A13. copied add.html and add-entry.php into director=
y /var/www/html =0A =0Aadd.html =0A-------------------------------=
----------------------- =0A<HTML> =0A<BODY> =0A =0A=
<FORM ACTION=3D"add-entry.php" METHOD=3D"GET"><BR=
>=0A =0A<TABLE BORDER=3D1> =0A <TR> =0A &l=
t;TD> =0A <TABLE BORDER=3D0 CELLPADDING=3D2 CELLSPACING=3D2&=
gt; =0A <TR> =0A <TD>Name</T=
D> =0A <TD><INPUT TYPE=3D"TEXT" NAME=
=3D"Name" VALUE=3D""></TD> =0A =
</TR> =0A <TR> =0A <TD>P=
hone</TD> =0A <TD><INPUT TYPE=3D"TEXT&q=
uot; NAME=3D"Phone" VALUE=3D""></TD> =0A&nb=
sp; </TR> =0A <TR> =0A &=
lt;TD>E-mail</TD> =0A <TD><INPUT TYPE=3D&=
quot;TEXT" NAME=3D"Email" VALUE=3D""></TD>=
; =0A </TR> =0A <TR> =0A&nbs=
p; <TD COLSPAN=3D2 ALIGN=3DCENTER> =0A =
<INPUT TYPE=3D"SUBMIT" VALUE=3D"Add Entry"> =
=0A </TD> =0A </TR> =0A &=
lt;/TABLE> =0A </TD> =0A </TR> =0A</=
TABLE> =0A</FORM> =0A =0A</BODY> =0A</HTML>=
; =0A-------------------------------------------------- =0Aadd-entry.=
php =0A-------------------------------------------------- =0A =0A&=
lt;HTML> =0A<BODY> =0A<?PHP =0A$db =3D pg_Connect( &qu=
ot;dbname=3DAddressBook user=3Dwww"); =0Aif( !$db ) =0A{ =0A&=
nbsp; echo "Could not connect!"; =0A exit; =0A} =
=0A =0A$Name=3D$_GET['Name']; =0A$Email=3D$_GET['Email']; =0A$Phon=
e=3D$_GET['Phone']; =0A =0A$query =3D "INSERT INTO Addresses VAL=
UES( '$Name', '$Phone', '$Email' );"; =0A =0A$result =3D pg_Exec=
( $db, $query ); =0A =0Aif( !$result ) =0A{ =0A echo &quo=
t;No result set returned!"; =0A exit; =0A} =0A =0A$r=
ows =3D pg_NumRows( $result ); =0A =0Aif( $rows =3D 0 ) =0A{ =
=0A echo "Add Failed."; =0A exit; =0A} =0A<B=
R>=0A$query =3D "SELECT * FROM Addresses WHERE \"Name\" =3D =
'$Name';"; =0A =0A$query =3D "SELECT * FROM Addresses WHERE=
\"Name\" =3D '$Name';"; =0A =0A$result =3D pg_Exec( $=
db, $query ); =0A$row =3D pg_Fetch_Row( $result, 0 ); =0A =0A$name=
Result =3D $row[0]; =0A$phoneResult =3D $row[1]; =0A$emailResult =3D =
$row[2]; =0A =0Aecho "Name =3D $nameResult "; =
=0Aecho "Phone =3D $phoneResult "; =0Aecho "E-ma=
il =3D $emailResult "; =0A =0Apg_Close( $db ); =0A?&=
gt; =0A =0A<H3>Add Okay!</H3> =0A =0A</BODY><=
BR>=0A</HTML> =0A-------------------------------------------------=
------------ =0AError i get is =0AMon Apr 03 18:39:53 2006] [notice] =
Apache/2.0.54 (Fedora) configured -- resuming normal operations =0A[Mon =
Apr 03 18:42:17 2006] [error] [client 127.0.0.1] File does not exist: /var/=
www/html/favicon.ico =0A[client 127.0.0.1] PHP Warning: pg_connect=
() [<a href=3D'function.pg-connect'>function.pg-connect</a>]: U=
nable to connect to PostgreSQL server: could not connect to server: Permiss=
ion denied\n\tIs the server running locally and accepting\n\tconnections on=
Unix domain socket "/tmp/.s.PGSQL.5432"? in /var/www/htm=
l/add-entry.php on line 5, referer: http://localhost/add.html =0A[Mon Ap=
r 03 18:42:22 2006] [error] [client 127.0.0.1] File does not exist: /var/ww=
w/html/favicon.ico =0A =0A___________________________________________=
____________ =0A =0Afrom the command line it works fine =0Ai.e php=
add-entry.php works fine ( ofcourse adds an empty row into the data base)<=
BR>=0A =0A-------------------------------------------------- =0A =
=0Ai did telnet =0A =0A[root [at] localhost html]# telnet localhost 5432<B=
R>=0ATrying 127.0.0.1... =0AConnected to localhost.localdomain (127.0.0.=
1). =0AEscape character is '^]'. =0A =0A =0AConnection closed b=
y foreign host. =0A =0Adata/pg_log/postgresql-Mon.log contains =0A=
 =0ALOG: invalid length of startup packet =0A =0A =0A =
=0A------------------------------- =0A =0A =0AI am not getting any=
clue as to how to solve this problem ...let me know if you have any idea i=
n solving this porblem. =0A =0Aregards =0AMuralidhar =0A =0A=
 =0A=0A=0A =0A<a href=3D"http://adworks.rediff.com/cgi-bin/Ad=
Works/sigclick.cgi/www.rediff.com/signature-home.htm/1507191 490 [at] Middle5?PAR=
TNER=3D3"><IMG SRC=3D"http://adworks.rediff.com/cgi-bin/AdWorks/sigimpress.=
cgi/www.rediff.com/signature-home.htm/1963059423 [at] Middle5?OAS _query=3Dnull&P=
ARTNER=3D3" BORDER=3D0 VSPACE=3D0 HSPACE=3D0></a>=0A
--Next_1144083971---0-203.199.83.33-19612--

--uQr8t48UFsdbeI+V
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2006-04-03 17:06:11 -0000 (Mon, Apr), muralidhar sortur wrote:
>
> Hi ,
> Here is the complete description of the problem ...
>
> I have newly installed fedora core 4 with option as everyting.
[...]
> ------------------------------------------------------------ -
> Error i get is
> [client 127.0.0.1] PHP Warning: pg_connect(): 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 "/tmp/.s.PGSQL.5432"? in
> /var/www/html/add-entry.php on line 5, referer:
> http://localhost/add.html

How does the file /tmp/.s.PGSQL.* look like? Does 'www' user have access
to it?
ls -l /tmp/.s.PGSQL.*

As you enabled network interface in postgresql, you may try to add
'host=3D127.0.0.1' to your pg_connect function. This should let 'www'
user to connect.

> [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

Telnet is not the best tool for binary protocols.
You may try netcat (nc), but anyway - this test is not significant
here.

By the way, you used this construction:
> $Name=3D$_GET['Name'];
> $Email=3D$_GET['Email'];
> $Phone=3D$_GET['Phone'];
>
> $query =3D "INSERT INTO Addresses VALUES( '$Name', '$Phone', '$Email' );";

Forgive me if that is only because this is test, and you know that, but
I just HAVE to say:
Don't let the untrusted parameters to go into query. Someone may call
your page like this:
http://example.com/add-entry.php?Email=3Da'); delete from Addresses; --

As *MINIMAL* precaution use:
$Name =3D pg_escape_string( $_GET['Name');

--
No virus found in this outgoing message.
Checked by "grep -i virus $MESSAGE"
Trust me.

--uQr8t48UFsdbeI+V
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)

iD8DBQFEMX8TIzblgXdKMIURAvB8AKCVmy45QPOfaGD5HHDg6f6BVJlaNACg u7Cc
yvIgquNLb3eNvwVa2AK2rfM=
=r9kI
-----END PGP SIGNATURE-----

--uQr8t48UFsdbeI+V--

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 =3D /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 =3D '*'
> port =3D 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=3D"add-entry.php" METHOD=3D"GET">
>
> <TABLE BORDER=3D1>
> <TR>
> <TD>
> <TABLE BORDER=3D0 CELLPADDING=3D2 CELLSPACING=3D2>
> <TR>
> <TD>Name</TD>
> <TD><INPUT TYPE=3D"TEXT" NAME=3D"Name" VALUE=3D""></TD>
> </TR>
> <TR>
> <TD>Phone</TD>
> <TD><INPUT TYPE=3D"TEXT" NAME=3D"Phone" VALUE=3D""></TD>
> </TR>
> <TR>
> <TD>E-mail</TD>
> <TD><INPUT TYPE=3D"TEXT" NAME=3D"Email" VALUE=3D""></TD>
> </TR>
> <TR>
> <TD COLSPAN=3D2 ALIGN=3DCENTER>
> <INPUT TYPE=3D"SUBMIT" VALUE=3D"Add Entry">
> </TD>
> </TR>
> </TABLE>
> </TD>
> </TR>
> </TABLE>
> </FORM>
>
> </BODY>
> </HTML>
> --------------------------------------------------
> add-entry.php
> --------------------------------------------------
>
> <HTML>
> <BODY>
> <?PHP
> $db =3D pg_Connect( "dbname=3DAddressBook user=3Dwww");
> if( !$db )
> {
> echo "Could not connect!";
> exit;
> }
>
> $Name=3D$_GET['Name'];
> $Email=3D$_GET['Email'];
> $Phone=3D$_GET['Phone'];
>
> $query =3D "INSERT INTO Addresses VALUES( '$Name', '$Phone', '$Email' )=
;";
>
> $result =3D pg_Exec( $db, $query );
>
> if( !$result )
> {
> echo "No result set returned!";
> exit;
> }
>
> $rows =3D pg_NumRows( $result );
>
> if( $rows =3D 0 )
> {
> echo "Add Failed.";
> exit;
> }
>
> $query =3D "SELECT * FROM Addresses WHERE \"Name\" =3D '$Name';";
>
> $query =3D "SELECT * FROM Addresses WHERE \"Name\" =3D '$Name';";
>
> $result =3D pg_Exec( $db, $query );
> $row =3D pg_Fetch_Row( $result, 0 );
>
> $nameResult =3D $row[0];
> $phoneResult =3D $row[1];
> $emailResult =3D $row[2];
>
> echo "Name =3D $nameResult ";
> echo "Phone =3D $phoneResult ";
> echo "E-mail =3D $emailResult ";
>
> 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 exi=
st:
> /var/www/html/favicon.ico
> [client 127.0.0.1] PHP Warning: pg_connect() [<a
> href=3D'function.pg-connect'>function.pg-connect</a>]: Unable to connec=
t to
> PostgreSQL server: could not connect to server: Permission denied\n\tIs
> the server running locally and accepting\n\tconnections on Unix domain
> socket "/tmp/.s.PGSQL.5432"? in /var/www/html/add-entry.php o=
n
> line 5, referer: http://localhost/add.html
> [Mon Apr 03 18:42:22 2006] [error] [client 127.0.0.1] File does not exi=
st:
> /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 kno=
w
> if you have any idea in solving this porblem.
>
> regards
> Muralidhar
>
>
>

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

This is a multipart mime message

--Next_1144158392---0-203.199.83.42-22090
Content-type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

=0AHi ,=0Ain my last mail i forgot to mention that i have restarted apach=
e server after making changes to the httpd.conf.=0A=0AToday i made one more=
experiment ...=0A=0A1. changed httpd.conf =0A=0A user apache=0A Grou=
p apache=0A=0A DocumentRoot=3D"/home/murali/html"=0A=0A <DocumentRoot=
"/home/murali/html">=0A ......(as it is)....=0A <DocumentRoot>=0A=0A=
2. copied the files add.html and add-entry.html to directory html under my =
home directory i.e =0A=0A/home/murali/html=0A=0A3. restarted apache=0A/usr/=
sbin/apachectl start ( from root)=0A=0A4. from postgres login started postm=
aster.=0A=0Apostmaster -i -D data&=0A=0A5. http://localhost/add.html ( ente=
red Name , Phone , Email)=0A =0AEVERY THING WORKED !!!!!=0A=0ABUT CAN ANY=
ONE TELL ME, WHAT WAS THE PROBLEM WITH EARLIER SETTING AND WHAT MADE IT TO=
WORK PROPERLY NOW !!! I NEED TO ANSWER THESE QUESTIONS=0A=0A=0AThanks for =
all of your help =0Aregards=0AMuralidhar=0A=0AOn Tue, 04 Apr 2006 Javier Ca=
rlos wrote :=0A> Did you try to restart the PosgreSQL server using pg_ctl=
?=0A>=0A>$ pg_ctl restart=0A>=0A>=0A> Are you able to connect as user f=
rom the command line?=0A>=0A>$ psql AddressBook www=0A>=0A> Regards,=0A>=
=0A> Javier=0A>=0A>=0A> >=0A> > Hi ,=0A> > Here is the complete descripti=
on of the problem ...=0A> >=0A> > I have newly installed fedora core 4 with=
option as everyting.=0A> >=0A> > it comes with apache webserver, postgresq=
l , php-postgresql, php-gd etc,=0A> >=0A> > it creates a default user postg=
res with home =3D /var/lib/psql=0A> >=0A> > 1. i loged in as postgres=0A> >=
=0A> > 2. called initdb=0A> > created database under directory ~/data=0A>=
>=0A> > 3. changed postgresql.conf to include=0A> > listen_addresses=
=3D '*'=0A> > port =3D 5432=0A> >=0A> > 4. changed pg_hba.conf=0A> >=
local all all trust=0A> > host all=
all 127.0.0.1/32 trust=0A> > host all all 192.168.1.18=
/24 trust=0A> > host all all ::1/128 trust=0A>=
>=0A> > 5. postmaster -i -D ~/data &=0A> >=0A> > 6. createdb AddressBook=
=0A> >=0A> > 7. psql AddressBook=0A> >=0A> > 8. create table addresses( Nam=
e text, Phone text, Email text);=0A> >=0A> > 9. create user www NOCREATEDB =
NOCREATEUSER;=0A> >=0A> > 10. grant all on addresses to www;=0A> >=0A> > 11=
.. from other terminal i loged in as root=0A> >=0A> > 12. changed /etc/httpd=
/conf/httpd.conf=0A> >=0A> > User www=0A> > Group postgres=0A> >=0A=
> > 13. copied add.html and add-entry.php into directory /var/www/html=0A> =
>=0A> > add.html=0A> > ----------------------------------------------------=
--=0A> > <HTML>=0A> > <BODY>=0A> >=0A> > <FORM ACTION=3D"add-entry.php" MET=
HOD=3D"GET">=0A> >=0A> > <TABLE BORDER=3D1>=0A> > <TR>=0A> > <TD>=0A> >=
<TABLE BORDER=3D0 CELLPADDING=3D2 CELLSPACING=3D2>=0A> > <TR>=0A> > =
<TD>Name</TD>=0A> > <TD><INPUT TYPE=3D"TEXT" NAME=3D"Name" VALUE=3D=
""></TD>=0A> > </TR>=0A> > <TR>=0A> > <TD>Phone</TD>=0A> > =
<TD><INPUT TYPE=3D"TEXT" NAME=3D"Phone" VALUE=3D""></TD>=0A> > </TR>=0A=
> > <TR>=0A> > <TD>E-mail</TD>=0A> > <TD><INPUT TYPE=3D"TEXT" N=
AME=3D"Email" VALUE=3D""></TD>=0A> > </TR>=0A> > <TR>=0A> > <TD=
COLSPAN=3D2 ALIGN=3DCENTER>=0A> > <INPUT TYPE=3D"SUBMIT" VALUE=3D"Ad=
d Entry">=0A> > </TD>=0A> > </TR>=0A> > </TABLE>=0A> > </TD>=0A=
> > </TR>=0A> > </TABLE>=0A> > </FORM>=0A> >=0A> > </BODY>=0A> > </HTML>=
=0A> > --------------------------------------------------=0A> > add-entry.p=
hp=0A> > --------------------------------------------------=0A> >=0A> > <HT=
ML>=0A> > <BODY>=0A> > <?PHP=0A> > $db =3D pg_Connect( "dbname=3DAddressBoo=
k user=3Dwww");=0A> > if( !$db )=0A> > {=0A> > echo "Could not connect!";=
=0A> > exit;=0A> > }=0A> >=0A> > $Name=3D$_GET['Name'];=0A> > $Email=3D$_=
GET['Email'];=0A> > $Phone=3D$_GET['Phone'];=0A> >=0A> > $query =3D "INSERT=
INTO Addresses VALUES( '$Name', '$Phone', '$Email' );";=0A> >=0A> > $resul=
t =3D pg_Exec( $db, $query );=0A> >=0A> > if( !$result )=0A> > {=0A> > ec=
ho "No result set returned!";=0A> > exit;=0A> > }=0A> >=0A> > $rows =3D p=
g_NumRows( $result );=0A> >=0A> > if( $rows =3D 0 )=0A> > {=0A> > echo "A=
dd Failed.";=0A> > exit;=0A> > }=0A> >=0A> > $query =3D "SELECT * FROM Ad=
dresses WHERE \"Name\" =3D '$Name';";=0A> >=0A> > $query =3D "SELECT * FROM=
Addresses WHERE \"Name\" =3D '$Name';";=0A> >=0A> > $result =3D pg_Exec( $=
db, $query );=0A> > $row =3D pg_Fetch_Row( $result, 0 );=0A> >=0A> > $nameR=
esult =3D $row[0];=0A> > $phoneResult =3D $row[1];=0A> > $emailResult =3D $=
row[2];=0A> >=0A> > echo "Name =3D $nameResult ";=0A> > echo "Phone =3D =
$phoneResult ";=0A> > echo "E-mail =3D $emailResult ";=0A> >=0A> > pg=
_Close( $db );=0A> > ?>=0A> >=0A> > <H3>Add Okay!</H3>=0A> >=0A> > </BODY>=
=0A> > </HTML>=0A> > ------------------------------------------------------=
-------=0A> > Error i get is=0A> > Mon Apr 03 18:39:53 2006] [notice] Apach=
e/2.0.54 (Fedora) configured --=0A> > resuming normal operations=0A> > [Mon=
Apr 03 18:42:17 2006] [error] [client 127.0.0.1] File does not exist:=0A> =
> /var/www/html/favicon.ico=0A> > [client 127.0.0.1] PHP Warning: pg_conne=
ct() [<a=0A> > href=3D'function.pg-connect'>function.pg-connect</a>]: Unabl=
e to connect to=0A> > PostgreSQL server: could not connect to server: Permi=
ssion denied\n\tIs=0A> > the server running locally and accepting\n\tconnec=
tions on Unix domain=0A> > socket "/tmp/.s.PGSQL.5432"? in /var/www/html/ad=
d-entry.php on=0A> > line 5, referer: http://localhost/add.html=0A> > [Mon =
Apr 03 18:42:22 2006] [error] [client 127.0.0.1] File does not exist:=0A> >=
/var/www/html/favicon.ico=0A> >=0A> > ____________________________________=
___________________=0A> >=0A> > from the command line it works fine=0A> > i=
..e php add-entry.php works fine ( ofcourse adds an empty row into the=0A> >=
data base)=0A> >=0A> > --------------------------------------------------=
=0A> >=0A> > i did telnet=0A> >=0A> > [root [at] localhost html]# telnet localho=
st 5432=0A> > Trying 127.0.0.1...=0A> > Connected to localhost.localdomain =
(127.0.0.1).=0A> > Escape character is '^]'.=0A> >=0A> >=0A> > Connection c=
losed by foreign host.=0A> >=0A> > data/pg_log/postgresql-Mon.log contains=
=0A> >=0A> > LOG: invalid length of startup packet=0A> >=0A> >=0A> >=0A> >=
-------------------------------=0A> >=0A> >=0A> > I am not getting any clu=
e as to how to solve this problem ...let me know=0A> > if you have any idea=
in solving this porblem.=0A> >=0A> > regards=0A> > Muralidhar=0A> >=0A> >=
=0A> >=0A>=0A>=0A>=0A>-------------=0A>nediam.com.mx=0A>=0A>=0A>- ----------=
----------------(end of broadcast)---------------------------=0A>TIP 5: don=
't forget to increase your free space map settings=0A
--Next_1144158392---0-203.199.83.42-22090
Content-type: text/html;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

=0A =0AHi , =0Ain my last mail i forgot to mention that i h=
ave restarted apache server after making changes to the httpd.conf. =0A<=
BR>=0AToday i made one more experiment ... =0A =0A1. changed httpd.co=
nf =0A =0A user apache =0A Group apache=
 =0A =0A DocumentRoot=3D"/home/murali/html"<BR=
>=0A =0A <DocumentRoot "/home/murali/html">=
 =0A ......(as it is).... =0A <DocumentR=
oot> =0A =0A2. copied the files add.html and add-entry.html to dir=
ectory html under my home directory i.e =0A =0A/home/murali/html =
=0A =0A3. restarted apache =0A/usr/sbin/apachectl start ( from root)<=
BR>=0A =0A4. from postgres login started postmaster. =0A =0Apostma=
ster -i -D data& =0A =0A5. http://localhost/add.html ( entered Na=
me , Phone , Email) =0A =0AEVERY THING WORKED !!!!! =0A<BR=
>=0ABUT CAN ANY ONE TELL ME, WHAT WAS THE PROBLEM WITH EARLIER SETTING AND =
WHAT MADE IT TO WORK PROPERLY NOW !!! I NEED TO ANSWER THESE QUESTIONS =
=0A =0A =0AThanks for all of your help =0Aregards =0AMuralidha=
r =0A =0AOn Tue, 04 Apr 2006 Javier Carlos wrote : =0A> =
Did you try to restart the PosgreSQL server using pg_ctl ? =0A> =
=0A>$ pg_ctl restart =0A> =0A> =0A> Are y=
ou able to connect as user from the command line? =0A> =0A>$ ps=
ql AddressBook www =0A> =0A> Regards, =0A> =0A&=
gt; Javier =0A> =0A> =0A> > =0A> > Hi =
, =0A> > Here is the complete description of the problem ... =
=0A> > =0A> > I have newly installed fedora core 4 with opti=
on as everyting. =0A> > =0A> > it comes with apache webse=
rver, postgresql , php-postgresql, php-gd etc, =0A> > =0A> &=
gt; it creates a default user postgres with home =3D /var/lib/psql =0A&g=
t; > =0A> > 1. i loged in as postgres =0A> > =0A>=
; > 2. called initdb =0A> > created database under direc=
tory ~/data =0A> > =0A> > 3. changed postgresql.conf to i=
nclude =0A> > listen_addresses =3D '*' =0A=
> > port =3D 5432 =0A> > =0A> >=
; 4. changed pg_hba.conf =0A> > local a=
ll all =
trust =0A> > host =
all all 127.0.0.1/32 trust<BR=
>=0A> > host all all 19=
2.168.1.18/24 trust =0A> > =
host all all ::1/128 =
trust =0A> > =0A> > 5. postmaster -i=
-D ~/data & =0A> > =0A> > 6. createdb AddressBook<BR=
>=0A> > =0A> > 7. psql AddressBook =0A> > =0A>=
; > 8. create table addresses( Name text, Phone text, Email text); =
=0A> > =0A> > 9. create user www NOCREATEDB NOCREATEUSER;<BR=
>=0A> > =0A> > 10. grant all on addresses to www; =0A>=
> =0A> > 11. from other terminal i loged in as root =0A>=
> =0A> > 12. changed /etc/httpd/conf/httpd.conf =0A> >=
; =0A> > User www =0A> > Grou=
p postgres =0A> > =0A> > 13. copied add.html and add-entr=
y.php into directory /var/www/html =0A> > =0A> > add.html=
 =0A> > ------------------------------------------------------ =
=0A> > <HTML> =0A> > <BODY> =0A> > =
=0A> > <FORM ACTION=3D"add-entry.php" METHOD=3D"GET=
"> =0A> > =0A> > <TABLE BORDER=3D1> =0A&=
gt; > <TR> =0A> > <TD> =0A> >=
; <TABLE BORDER=3D0 CELLPADDING=3D2 CELLSPACING=3D2> =0A>=
; > <TR> =0A> > <TD>Nam=
e</TD> =0A> > <TD><INPUT TYPE=3D"=
;TEXT" NAME=3D"Name" VALUE=3D""></TD> =
=0A> > </TR> =0A> > <TR=
> =0A> > <TD>Phone</TD> =0A> &g=
t; <TD><INPUT TYPE=3D"TEXT" NAME=3D"P=
hone" VALUE=3D""></TD> =0A> > =
</TR> =0A> > <TR> =0A> > =
; <TD>E-mail</TD> =0A> > <TD&=
gt;<INPUT TYPE=3D"TEXT" NAME=3D"Email" VALUE=3D"=
;"></TD> =0A> > </TR> =0A>=
> <TR> =0A> > <TD COLSPAN=
=3D2 ALIGN=3DCENTER> =0A> > <INPUT TYPE=
=3D"SUBMIT" VALUE=3D"Add Entry"> =0A> >&nbs=
p; </TD> =0A> > </TR> =0A>=
> </TABLE> =0A> > </TD> =0A> &=
gt; </TR> =0A> > </TABLE> =0A> > </=
FORM> =0A> > =0A> > </BODY> =0A> > <=
/HTML> =0A> > -------------------------------------------------=
- =0A> > add-entry.php =0A> > ---------------------------=
----------------------- =0A> > =0A> > <HTML> =0A=
> > <BODY> =0A> > <?PHP =0A> > $db =3D pg_=
Connect( "dbname=3DAddressBook user=3Dwww"); =0A> > if( =
!$db ) =0A> > { =0A> > echo "Could not connec=
t!"; =0A> > exit; =0A> > } =0A> ><BR=
>=0A> > $Name=3D$_GET['Name']; =0A> > $Email=3D$_GET['Email'=
]; =0A> > $Phone=3D$_GET['Phone']; =0A> > =0A> >=
$query =3D "INSERT INTO Addresses VALUES( '$Name', '$Phone', '$Email'=
);"; =0A> > =0A> > $result =3D pg_Exec( $db, $query=
); =0A> > =0A> > if( !$result ) =0A> > { =0A=
> > echo "No result set returned!"; =0A> >&=
nbsp; exit; =0A> > } =0A> > =0A> > $rows =3D pg=
_NumRows( $result ); =0A> > =0A> > if( $rows =3D 0 ) =
=0A> > { =0A> > echo "Add Failed."; =0A&=
gt; > exit; =0A> > } =0A> > =0A> > $qu=
ery =3D "SELECT * FROM Addresses WHERE \"Name\" =3D '$Name';=
"; =0A> > =0A> > $query =3D "SELECT * FROM Addr=
esses WHERE \"Name\" =3D '$Name';"; =0A> > =0A&g=
t; > $result =3D pg_Exec( $db, $query ); =0A> > $row =3D pg_Fet=
ch_Row( $result, 0 ); =0A> > =0A> > $nameResult =3D $row[=
0]; =0A> > $phoneResult =3D $row[1]; =0A> > $emailResult =
=3D $row[2]; =0A> > =0A> > echo "Name =3D $nameResul=
t "; =0A> > echo "Phone =3D $phoneResult<BR&=
gt;"; =0A> > echo "E-mail =3D $emailResult &quo=
t;; =0A> > =0A> > pg_Close( $db ); =0A> > ?><=
BR>=0A> > =0A> > <H3>Add Okay!</H3> =0A> &=
gt; =0A> > </BODY> =0A> > </HTML> =0A> =
> ------------------------------------------------------------ - =0A&g=
t; > Error i get is =0A> > Mon Apr 03 18:39:53 2006] [notice] A=
pache/2.0.54 (Fedora) configured -- =0A> > resuming normal operati=
ons =0A> > [Mon Apr 03 18:42:17 2006] [error] [client 127.0.0.1] F=
ile does not exist: =0A> > /var/www/html/favicon.ico =0A> &g=
t; [client 127.0.0.1] PHP Warning: pg_connect() [<a =0A> >=
; href=3D'function.pg-connect'>function.pg-connect</a>]: Unable to=
connect to =0A> > PostgreSQL server: could not connect to server:=
Permission denied\n\tIs =0A> > the server running locally and acc=
epting\n\tconnections on Unix domain =0A> > socket "/tmp/.s.P=
GSQL.5432"? in /var/www/html/add-entry.php on =0A> > line 5, =
referer: http://localhost/add.html =0A> > [Mon Apr 03 18:42:22 200=
6] [error] [client 127.0.0.1] File does not exist: =0A> > /var/www=
/html/favicon.ico =0A> > =0A> > _________________________=
______________________________ =0A> > =0A> > from the com=
mand line it works fine =0A> > i.e php add-entry.php works fine ( =
ofcourse adds an empty row into the =0A> > data base) =0A> &=
gt; =0A> > -------------------------------------------------- =
=0A> > =0A> > i did telnet =0A> > =0A> > [=
root [at] localhost html]# telnet localhost 5432 =0A> > Trying 127.0.0.=
1... =0A> > Connected to localhost.localdomain (127.0.0.1). =0A=
> > Escape character is '^]'. =0A> > =0A> > =0A&=
gt; > Connection closed by foreign host. =0A> > =0A> >=
data/pg_log/postgresql-Mon.log contains =0A> > =0A> > LO=
G: invalid length of startup packet =0A> > =0A> ><B=
R>=0A> > =0A> > ------------------------------- =0A> &=
gt; =0A> > =0A> > I am not getting any clue as to how to =
solve this problem ...let me know =0A> > if you have any idea in s=
olving this porblem. =0A> > =0A> > regards =0A> >=
; Muralidhar =0A> > =0A> > =0A> > =0A> =
=0A> =0A> =0A>------------- =0A>nediam.com.mx =0A&g=
t; =0A> =0A>---------------------------(end of broadcast)------=
--------------------- =0A>TIP 5: don't forget to increase your free s=
pace map settings =0A=0A=0A =0A<a href=3D"http://adworks.redi=
ff.com/cgi-bin/AdWorks/sigclick.cgi/www.rediff.com/signature -home.htm/15071=
91490 [at] Middle5?PARTNER=3D3"><IMG SRC=3D"http://adworks.rediff.com/cgi-bin/Ad=
Works/sigimpress.cgi/www.rediff.com/signature-home.htm/19630 59423 [at] Middle5?O=
AS_query=3Dnull&PARTNER=3D3" BORDER=3D0 VSPACE=3D0 HSPACE=3D0></a>=0A
--Next_1144158392---0-203.199.83.42-22090--

--0__=0ABBFBD5DFDF2A728f9e8a93df938690918c0ABBFBD5DFDF2A72
Content-type: text/plain; charset=US-ASCII

Perhaps you or your host are running SE Linux?? Depending on your
configuration, users may be forced to run personal websites out of their
home directories.

Cameron

+++++++++++++++++++++++++++++++++++++
Cameron G. Moller, Senior Officer
Technical Project Manager
SSGM Infrastructure
State Street Corporation ... __o
Cell: 617-799-9049 ... -\<,
Desk: 617-664-4501 ... (_)/(_) ..
+++++++++++++++++++++++++++++++++++++

"muralidhar
sortur"
<sorturmuralidhar To
[at] rediffmail.com> "Javier Carlos"
Sent by: <nediam [at] nediam.com.mx>, "Gnanavel
pgsql-php-owner [at] p S" <s.gnanavel [at] gmail.com>,
ostgresql.org "pgsql_php"
<pgsql-php [at] postgresql.org>
cc
04/04/2006 09:46
AM Subject
Re: [PHP] Unable to connect to
PostgreSQL Server: Permission
Please respond to denied
"muralidhar
sortur"
<sorturmuralidhar
[at] rediffmail.com>

Hi ,
in my last mail i forgot to mention that i have restarted apache server
after making changes to the httpd.conf.

Today i made one more experiment ...

1. changed httpd.conf

user apache
Group apache

DocumentRoot="/home/murali/html"

<DocumentRoot "/home/murali/html">
......(as it is)....
<DocumentRoot>

2. copied the files add.html and add-entry.html to directory html under my
home directory i.e

/home/murali/html

3. restarted apache
/usr/sbin/apachectl start ( from root)

4. from postgres login started postmaster.

postmaster -i -D data&

5. http://localhost/add.html ( entered Name , Phone , Email)

EVERY THING WORKED !!!!!

BUT CAN ANY ONE TELL ME, WHAT WAS THE PROBLEM WITH EARLIER SETTING AND WHAT
MADE IT TO WORK PROPERLY NOW !!! I NEED TO ANSWER THESE QUESTIONS

Thanks for all of your help
regards
Muralidhar

On Tue, 04 Apr 2006 Javier Carlos wrote :
> 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 ";
> > echo "Phone = $phoneResult ";
> > echo "E-mail = $emailResult ";
> >
> > 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 "/tmp/.s.PGSQL.5432"? 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
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: don't forget to increase your free space map settings

(Embedded image moved to file: pic14604.gif)

--0__=0ABBFBD5DFDF2A728f9e8a93df938690918c0ABBFBD5DFDF2A72
Content-type: image/gif;
name="pic14604.gif"
Content-Disposition: attachment; filename="pic14604.gif"
Content-Transfer-Encoding: base64

R0lGODlhQgImALMLAPCxq0I1JtGREpNpG+tjUOUrN/3xAcwGAAAAAP////+w
D////wAAAAAAAAAAAAAAACH/C05FVFNDQVBFMi4wAwEAAAAh+QQFLAELACwA
AAAAQgImAAAE//DIQ5IF8wCbyixcklVXtlmeBHIjh01n94VtCXPpsVp1QmSh
lyT2m9AmpIRQwylKjpLkMpbbiZAuE27GwtqGWxWUkr2huDyvUnsWd6NNYBls
cR7GUrZPnoZ/mW06eHOAMm59ZH9UaFd+a2aGgm+Jj3SRVj12QXqak3mQnYif
llV4PVNhkqKEi4eNlKiBmGqxl4N1fJWFoa+ju7mneqWerKmzjrXDq4rGt7qt
qr1xRsW41MvP00/EzLLOyYzBkMrS3bbc2d7ovLW84pbutMLhaiH29/j5+vv8
/f7/AAMKHEiwoMGDCBMqXMiwocOHECNKTKigosWLGC8CiHGBoxIAAv8yihxJ
sqTJkyhTqlzJsqXLlzBjypxJs6bNmzhz6ixpoKdPnzsrhiBAYqWAjReU1CH6
0QWAoFCjSp1KtarVq1izarX5s6vPkDmXbluJdEOBASfObiATA+TWt3Djyp1L
t65drV7z9gR7E5EFlQMsoEVxgigBAGgRS7nLuLHjx5AjS54ZUm9evjX9Jkh5
YmOBDUiV1gEAAvQFzJNTq17NurXrmCELKPipoLIBArO/9n3192TgpAQGBwkC
esfT18iTK1/OXKoA1CNDHlBQQEDPH7MVUNhLAHrMNCFQXhhAIEDojejRX/gh
3G3z9/Djy48/IECAk9YF6NiuXbYB7dYZoEP/bRZ5J8AAA4iHj29OdbbRc7U9
px4ATLlQUUjezafhhhx2KBNfIGIEYUX1BQAWiCDeNoF1PxRw3QF7HZBfbfaJ
VF+CJ+WToxIFHNZRhkdt4GMICKYwQIbwCdAdht156OSTT9pXIoJSkmiffSGV
iFgARypQookVGZBDbDr0VICLYspoQIJTRnjgcwiC9NybGelYkgCCUXgCkheG
dgGXHxDgAZJwvnnkkXzClOhLLe7ngWw4LcohghiCCeWlUF2p6ZVH2QfAlVty
KeWnUmJp3aBnpkrAf2pSN50BB2oaqqc1foklRkf0Fl1hh22AFkqgDfDBmRsJ
egCONiKg7LLMIltT/32SsiRoqtRGm1KNmFo0wLLbImBpYyO+NydyoJZrHpyy
2pqgAKNWKaBsLSpAFKyv6ocmulySmq+WU16JK2+bkXRUR6Addye7AQTqGY/s
CYygsgh2++2zCDhb03OP6tAjSkSlpOxI0G4oALPLTnxXxfDVp6zJB3cZV7v5
YkmqvrFq2ummXW7nwarVpcmqmmuGWpG/XtboL6n/ymFSHQF8pgShB2bwGVJF
gFZEolxqy3JGlKoUgLdGdY3fmdZu7Juy0I0M9oVc0inSgQiiBLez9nlrosq3
XhgxRnGj1C3JFts18n3ifg2xiHlfJLG1QcEcaqhUmtcvl1N++qB2s52Zuf90
Lk4bIJue1myl5LRia5Fmd643mMEXwTnskIIUW0GjWLN5JAKK38iX4XV7m6Hh
zIK1beAKAF9xogLsjBFR4V5I9p0kr33hysKTbDiyf/teUvaWGn8k8IRzDxbv
vP+OdvHnI3wo5a1/afHe4xbovogQNn8g2qjBzTKVxKc0bvPRacnK+Ha4jKgN
RPNbie4AaBKYoUVmmzLRzEh1M3/F5jpoStWAetSdniRIX1vC0Y1mVaWLpKFC
JTnBAHp0gfYJCwk/OIzTPHCG0siwf9oKyfGwBzgSRU96rTOet3BkONRcj11A
fNvzLJKxVFXEUUvkmvFMh6G+1eaHa+vW986XrOP/FZFGy8JQAbWIRARk6YeE
y8jXRKg9tdktjD4kGV/+Bjw29jCOvSOcEKVXRuqxjVlb0xuntLUy3pFkW1nj
25UshkRGfi2NekNkgaKHrLnBSWxCTKTf0BKnQyHmQIjZCCdHycm5/co2/8mN
flSwwdnUL2JwcgsoaxYn1CwlPAIbjhJI9MIo/EBIGmALE87UK2PxSX0ouwj5
0kdHP76tiJh5ZN+QaKL7mdEkgyqQqjSGoTNRoDoOg1i4bNY6NIbkiGrrHxnV
lkYtoi+N0HSnNb3FLZF8LId/9N0Xy9i7SpoTfW9MppfQWDRAIot67PRh277Y
xZLF0XrRWaOIrAeiAl6o/1DKBKRFlrm2PnLJoc1cltciSNKSmhRbAeoKdboz
IOp4sE+UK5WozAOqkdhpJB5RAqBU8CgekIBCP1hDBYpVhZMMUaBXxN8jLUK9
AR6yjRsNXlIpeaco2qs6nmMipIyKsjler5zN+lpFSqZRkUzRqQOtmDvBSFbp
NVV7aiQcwqqUUPSdCE4OneTK4DgnlQGRjl+1ZrjY+ZwvxtOiQSxk+urIUK4V
cnyKRapE/2i6qVq0r4YcWj3L97eH3dNvlqNpaEcrWslF7IGIQcuJ8qJKV67K
ZXPF2SItl6Gbvs0F5QnUUInFo9D8UgbT+oDLtnef4SZVj9L72jlxGMf7EfGN
9/9h5xuNK5JsWmRaUazID2LTQN8BcbLTE5UZb/VIuyUusRH0pxwpeyW1MvWa
VsxIFpul2XUpV5Bljep9nOlXtCZVjNdM6rrO+MPnYJF4bjxnR7WHSCABUsEo
k2RUMVPGOXr3r1M8ERnRCj6xyeU5lvFJdYx7lMQkRnLuKQlxdPW2LfG0RTxi
mJAwMFQKGEu41qrP27i41LEG+GwV6zG2anRA+Z0ku25KFV+IKSg+raxbFnZW
g8GGrcsysL6Ki2Z+0SdlvsC1JGJl6+6SycWQQnKgtiPkXr88Mjaq92HFhdgi
u1RIUVF3emvrcZt9iMPBQVkBTv2zZvMHXokOTs30/PL/O9c6tPIiNS4gDjGS
4WbKGwXShB8ZiwELy1MPAFNIPvjMUClk4yqc5cpgRvAjrYks8JrEjQUkMpED
fV+BOdF5WyXmdamFG5JkOELgxdvgDg3QSj06qtekJliHWCDD/fGgx1ajQC1q
aB4zOImu1iyYJKxQPl8ksv/VFo4ue+e0QjZ88yUUfK8Zaz7WOqNjBov0EMmm
JGZPyq3+7FzmpJfkMfJTcRJVKMudNGoYsJc9IhYgmOAjEPSIQt4UbsEEqM41
Rxh4kspegGeN3KMqunXB1bW9umNMrSoZzBrto/bKF+Tz8W5xIHvyk5ctbY9v
G+MmkfBXFVpHbR/Xij3OaHSf/7yuMCr7vfWUWHMBfU9GY2TVX/1bYZNYzjMq
mHL+1XdtGF1teOYZYs6ibxztyJg39TVi4GydhDw5JwntSGkYUQEGPm2YGJNG
CUXIgQ6G9BGWfJTZjs2r8aJVMjv2fJ6arO6jqFURb1ZLmzpIFB0JrFGWJ5CO
BH9o26R9Zs27bPCvvl49Hxq8MmrcjP21GEe5hfm8Mn30HDV8Zhu6WdaP3rEK
HncP8arWej84rX59bkBvD3M8exx34Gq7dreKE9QpTgPoKY2N1eMjG2tMBcJJ
wOoY56XTqnNveoObSsQv7kMhStyLSriS1g9yJW06JR7u/mnviqECudB/8RUR
wckvP//+by+sWhZQCbJH1HNvT4dFcQZ2xDdzevNkmNFZkid2UtdZOxZQ6FYy
V/dgpyd8ieZ7BaZXRhQ9nfcYHaMTaRAafAMCMeQ0OqAnU6NBEmcPpBEYrJMt
NmgV55c/58c3brODysc1bhOEznIgPPg2OJR59ENiQ0golBI/EXJnfXVXhzJY
XQJbU6g3bHM7W0Np3BcXJRgWTcEBIqKCszM7HNQoI+AnuGUeT3ODbviGcLgT
iJRty+F+JrggrbMCw2Q116cDiYEP6JEYGxGHhFiIhsgSk5d87YM8F2U/jKhi
eKg4s1MsjoIEakgcwcEUg3iInNiJnshWzIUVbdd2XcIuQ6j/f4UCIZTShBfl
QlkSOLZFIhRAahF3AGyoBH9IIUuxQtv3ib74i8CoFd63PogCfjGUO1NYjOiC
LMrDS6sIi13AYtryARKAKDHQNE0jSmdRHr1yOcH4jeAYjjdhZ2bXNuanXZEX
fpQ2hYX1LY+CG4ZiKHUCMG+TPMcyWEHyEYmRiROSYuL4jwAZkA20N4iSNVdY
G2m3dexoO8WILE0mSAUJjXDXEpfoAh/RhQKZkRrJifVHIP9DIAJTPxp2ISBp
QHTFQM7nEhISJOhxFBi5kTAZkxr5klt3aQpwgupBHJeYkw3iEekhgzvJkwTj
k0FZlER5lEi5GT0JlGr4k2IIFR+R+ZQ6eZRMKZUNUpVYqZNZuZRaOZVYeZND
uZVRaZVhyZVmSTBiOZZMmZZOeZVe+ZZueZZq2ZVy+ZNgOZdn2ZYBExRRiZXv
UAjk8JfQcAywMA+uIJjNsA650A7AIA+g0JjIYJjRgJjqgA3gcJiOSQr0EJnj
sJmUwA6cAJmF+ZjXUA7pcA6WKZmE6QuD+Q2q6ZqdiZmOAJqkuQ2pWZt3gA6X
OZlIQJmoaZq7uZrV8Ju+GZhqQJvwIJqsqQ25eZuaKZuj+Zy8yZnSKZzmYJzU
CZiemQTI+Qul6ZvxkJ2tqZuvSZ6xOZ3RqZ3QuZyVaZrdSQTKOZzhmZ7jKQoR
AAAh+QQFLAELACw6AAsAqgETAAAE/1DJSau9OOvNu/9gKI5kaZ5oqq6sKQiS
MMBtbd94ru98XwqEoHBILBqPyCShEkAEBM2Bh+arUKvYrHbLPUGlmSBgTC6b
z+i0ek0o0AaIuDzQkYGz365+z+/XXhhNCHcVBQAJiImKi4yNjo+QiW5QcnKE
GQKDJIA/miOcfhcDT6GlfjJXJaNOqZRxF0CRsrO0jwAEmYOUpBN2qXB0Gr4y
TwFRwgOjlwrAG3YzyclOwQq+PzMfw6kSTbwxyRjRIjI3zy/JVKgd6KAo1iOr
AcvVytsWgk5W+BcEh7X/ACO5yceMoAQ4ceTFqGRsngJBxuJI09XkFz6DqxIi
sFdQYkKEwf8QOnFIL5kxXiBP8oJijBPIaS0nILyDLwoNVyNhnaQCMSJJVDDe
sVwpaCKpXCq9VRAJk9ooeVSAqYyKDxs9QO+sWNJXaaOFdiCvHkzIjwCjAmgP
BUm0FgBaswn6xS3AFi7dBG4LmHWLSC9euIoOwLmpcOygVVIybv0KsnG+XRRc
RfTK7KInCyJnAoMxMxdJy6QUb8XpifTic3eYLu4mQ6JWhoa72hMpD2K1rmAg
ulrY9XJk1Qk54+bWOxhSyLQlZ2DtMmHRyBG9dcMX1PVXf4kOGGoTF7AYvQAO
mD1wyxBb8gnohu9X4ED6uXTXLnJj/Ckp1g/jBEXYjusM554Ag87/QdEE1wt/
G3STn0/EPbELRzMJ8sYcZKVkHXCaZBKTYbUp+CBkFFhIGW3WLTVHfvmIKAVk
lMgEkYEXWKYfitEF1ZNrAnbUWnC2hQNbSRlRQxo10xlIiT1yJcIXImp5F8Rd
eKWXliJt0GUlYIZsxx168w3WkX44URdDRcxkIBVDhC1WWSVX5MIZJidRaCOF
rGRQ5zENUiLFc81U041EhcXTS09QffnjBBIWRI1ECDJ2DH6JKphfbpQpqqeZ
Tny0EYt4woGNazJqgtiCHBlammKpAejUHOmQaYF5SkKJiHzd0dpXe9h1p5eV
2JGnl68EuHdWJvvNqACgytzhmacYSHbi/0Ly1Clim/oxqxOdXnlW24CBYGNt
fpxRGlqdGmr4UKrU+BmntyMle4mkfbIkFqbR8gIvQWSai6hX4GAqzQwO4tkp
Zfi2K49VAhrrY20ZvoiRLlDwJEcqG1qRawJckkerGMLyBR6X3bnlHnd4xYcW
fI3QB8aRxEWlbJGfAUrWmIndxwrLg07jm4kjzQzuNySdSxxNlY4lrtGZ7Kms
QXaM+Zir6lAgsEEGOVPTvkcXlNgrMhXdbEujECPBjJf+/FAweDLzspoLa61j
a6uCYRWNl/Q3AaxstXdylVpKqZ1Z5pHc3VyIaPdWyeqdfNaxDjbK3GZOs82z
Ky9zZvPWh900nP+Ph1n3YZ+BbIoniF0fjKNESTP7An4drcifZ6tXrehEcpeY
oJoCzjRWnJSR/rV+DZEpYKJhQf56oyjujBkrzTSzCziaGfRnYerOI8DFeI3B
5Bh7+UPG9uBnz6SS2odf/nwdQVS7ztSHWSprzyENJoA/uo/pRj2m303QRWbL
JhPDKcqZnqCaGeRCZ3dS1TYsIxwYOcOByTPWAVk1waAdC3iDcM2QYECdE8Vj
f5GBoCg0Iir6TSyCriOhtHxGAVsF5IUvLIC62tWqmy1lJxp4yoOcZp+tTQeE
u5ubTuiQIxfZEE5zkNtUrCAVJUIFGk/MlE0qMz2qHOZr+xPOSepgtkHOAXF3
HVJXxcIBNigqcRq1e+IW/TSSBXoNFlI84w91wQ1JPe8p2Cjbq2DIx4Dgohel
sls1BPmVoLQDKJx4gSIH2YpSRcaQ2yCkVhzUpkXCQogxaJYiD7lJKzgyBpyU
JKIAphRQ2u2UluTAJ1NpyVSC8jfFKCUszlFJrPSHlVgpJCbw1sdeOiIIpghm
iAT4SWF64U8WNKYqkanMr7TBcGiJpjSnSc1qWvOa1ixmM/FgmWRucxy6+eYn
winOcppTD6jh1jlRoMN1gqCd7lRmBAAAOw==

--0__=0ABBFBD5DFDF2A728f9e8a93df938690918c0ABBFBD5DFDF2A72
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

--0__=0ABBFBD5DFDF2A728f9e8a93df938690918c0ABBFBD5DFDF2A72--

On Mon, Apr 03, 2006 at 10:01:23PM +0200, Mariusz P=EAkala wrote:
> Telnet is not the best tool for binary protocols.
> You may try netcat (nc), but anyway - this test is not significant
> here.
It doesn't matter here.

> Don't let the untrusted parameters to go into query. Someone may call
> your page like this:
> http://example.com/add-entry.php?Email=3Da'); delete from Addresses; --
Nothing wrong will happen.

Regards,
--
Pawe=B3 Bernat; uselessness' lover;
select'<asm'||chr(64)||'asm'||'.'||'flynet'||chr(46)||'pl>'as email;
Slowly and surely the unix crept up on the Nintendo user ...

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo [at] postgresql.org so that your
message can get through to the mailing list cleanly

--X1bOJ3K7DJ5YkBrT
Content-Type: text/plain; charset=iso-8859-2
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2006-04-04 19:35:10 +0200 (Tue, Apr), Pawel Bernat wrote:
> On Mon, Apr 03, 2006 at 10:01:23PM +0200, Mariusz P=EAkala wrote:
> > Telnet is not the best tool for binary protocols.
> > You may try netcat (nc), but anyway - this test is not significant
> > here.
> It doesn't matter here.

Okay, you're saying my English isn't perfect ? :-)

> > Don't let the untrusted parameters to go into query. Someone may call
> > your page like this:
> > http://example.com/add-entry.php?Email=3Da'); delete from Addresses; --
> Nothing wrong will happen.

Why?
Unless I really overlooked something, I would humbly disagree.

1) It is possible to put a few sql requests in one string.

2) Relying on 'magic_quotes_gpc' and *possible* addslashes() is a bad thing,
IMHO.

So, where is my mistake?

--
No virus found in this outgoing message.
Checked by "grep -i virus $MESSAGE"
Trust me.

--X1bOJ3K7DJ5YkBrT
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)

iD8DBQFEMuSIIzblgXdKMIURAmHuAKCvMkJUzqQbvCrkNVEPlT3xGq6HgACf Yiwz
iU1v1U7K9P4FHVY/obk9ujg=
=ZvWY
-----END PGP SIGNATURE-----

--X1bOJ3K7DJ5YkBrT--

Unable to connect to PostgreSQL Server: Permission denied

Re: Unable to connect to PostgreSQL Server: Permission denied

Re: Unable to connect to PostgreSQL Server: Permission denied

Re: Unable to connect to PostgreSQL Server: Permission denied

Re: Unable to connect to PostgreSQL Server: Permission denied

Re: Unable to connect to PostgreSQL Server: Permission denied

Re: Unable to connect to PostgreSQL Server: Permission denied