Unable to connect to PostgreSQL Server: Permission denied

Unable to connect to PostgreSQL Server: Permission denied

am 03.04.2006 19:06:11 von muralidhar sortur

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 ... 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=0A created database under directory ~/data=
3. changed postgresql.conf to include=0A listen_addresses =3D '*=
'=0A port =3D 5432 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 5. postmaster -i -D ~/data &=0A=
=0A6. createdb AddressBook 7. psql AddressBook 8. create table ad=
dresses( Name text, Phone text, Email text); 9. create user www NOCREA=
TEDB NOCREATEUSER; 10. grant all on addresses to www; 11. from ot=
her terminal i loged in as root 12. changed /etc/httpd/conf/httpd.conf=
User www=0A Group postgres 13. copied add.html and add-en=
try.php into directory /var/www/html add.html=0A----------------------=
--------------------------------=0A=0A

-entry.php" METHOD=3D"GET"> =0A =0A =0A =0A =0A <=
/TR>=0A =0A =0A =0A =0A =0A =0A =
=0A =0A =
=0A =0A =0A
=0A <=
TABLE BORDER=3D0 CELLPADDING=3D2 CELLSPACING=3D2>=0A
Name=
Phone "Phone" VALUE=3D"">
E-mail
=0A VALUE=3D"Add Entry">=0A
=0A =0A R>=0A=0A
=0A=0A--------------------------=
------------------------=0Aadd-entry.php=0A----------------- ---------------=
------------------ =0A=0A me=3DAddressBook user=3Dwww");=0Aif( !$db )=0A{=0A echo "Could not connect=
!";=0A exit;=0A} $Name=3D$_GET['Name'];=0A$Email=3D$_GET['Emai l'];=0A=
$Phone=3D$_GET['Phone']; $query =3D "INSERT INTO Addresses VALUES( '$N=
ame', '$Phone', '$Email' );"; $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 ); if( $rows =3D 0 )=0A{=0A echo "Ad=
d Failed.";=0A exit;=0A} $query =3D "SELECT * FROM Addresses WHERE \"=
Name\" =3D '$Name';"; $query =3D "SELECT * FROM Addresses WHERE \"Name=
\" =3D '$Name';"; $result =3D pg_Exec( $db, $query );=0A$row =3D pg_Fe=
tch_Row( $result, 0 ); $nameResult =3D $row[0];=0A$phoneResult =3D $ro=
w[1];=0A$emailResult =3D $row[2]; echo "Name =3D $nameResult
";=0Ae=
cho "Phone =3D $phoneResult
";=0Aecho "E-mail =3D $emailResult
";=0A=
=0Apg_Close( $db );=0A?>

Add Okay!

=0A=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() [function.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=0A[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=0Ai.e php add-entry.php wo=
rks fine ( ofcourse adds an empty row into the data base) ------------=
-------------------------------------- i did telnet [root@localho=
st html]# telnet localhost 5432=0ATrying 127.0.0.1...=0AConnected to localh=
ost.localdomain (127.0.0.1).=0AEscape character is '^]'. =0AConnection=
closed by foreign host. data/pg_log/postgresql-Mon.log contains =
LOG: invalid length of startup packet -------------------------=
------ =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. regards=0AM=
uralidhar =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"> >=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 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<BR>";
=
=0Aecho "Phone =3D $phoneResult<BR>";
=0Aecho "E-ma=
il =3D $emailResult<BR>";
=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 &quot;/tmp/.s.PGSQL.5432&quot;? 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@localhost html]# telnet localhost 5432 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 Works/sigclick.cgi/www.rediff.com/signature-home.htm/1507191 490@Middle5?PAR=
TNER=3D3"> cgi/www.rediff.com/signature-home.htm/1963059423@Middle5?OAS _query=3Dnull&P=
ARTNER=3D3" BORDER=3D0 VSPACE=3D0 HSPACE=3D0>
=0A
--Next_1144083971---0-203.199.83.33-19612--

Re: Unable to connect to PostgreSQL Server: Permission denied

am 03.04.2006 22:01:23 von Mariusz Pekala

--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:
> =20
> Hi ,
> Here is the complete description of the problem ...
>=20
> 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@localhost html]# telnet localhost 5432
> Trying 127.0.0.1...
> Connected to localhost.localdomain (127.0.0.1).
> Escape character is '^]'.
>=20
>=20
> Connection closed by foreign host.
>=20
> data/pg_log/postgresql-Mon.log contains
>=20
> 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'];
>=20
> $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');


--=20
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--

Re: Unable to connect to PostgreSQL Server: Permission denied

am 04.04.2006 07:13:07 von Javier Carlos

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


>
>
>
>
>
>

>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Name
Phone
E-mail

>
>

>

>

>
>
>
> --------------------------------------------------
> add-entry.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 );
> ?>
>
>

Add Okay!


>
>
>
> ------------------------------------------------------------ -
> 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() [ > href=3D'function.pg-connect'>function.pg-connect]: 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@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

Re: Unable to connect to PostgreSQL Server: Permission denied

am 04.04.2006 15:46:32 von muralidhar sortur

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. Today i made one more=
experiment ... 1. changed httpd.conf user apache=0A Grou=
p apache DocumentRoot=3D"/home/murali/html" "/home/murali/html">=0A ......(as it is)....=0A =
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=0A/usr/=
sbin/apachectl start ( from root) 4. from postgres login started postm=
aster. postmaster -i -D data& 5. http://localhost/add.html ( ente=
red Name , Phone , Email)=0A =0AEVERY 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 =0AThanks for =
all of your help =0Aregards=0AMuralidhar On 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> > =0A> > =0A> >=0A> >

HOD=3D"GET">=0A> >=0A> > =0A> > =0A> > =0A=
> > =0A> >
=0A> >=
=0A> > =0A> > =
=0A> > =0A> > =0A> > =0A> > =0A> > =
=0A> > =0A=
> > =0A> > =0A> > =0A> > =0A> > =0A> > COLSPAN=3D2 ALIGN=3DCENTER>=0A> > d Entry">=0A> > =0A> > =0A> >
Name "">
Phone
E-mail AME=3D"Email" VALUE=3D"">
=0A> >
=0A> >
=0A> >=0A> > =0A> > =
=0A> > --------------------------------------------------=0A> > add-entry.p=
hp=0A> > --------------------------------------------------=0A> >=0A> > ML>=0A> > =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> >

Add Okay!

=0A> >=0A> > =
=0A> > =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() [ > href=3D'function.pg-connect'>function.pg-connect]: 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@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" >=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 >=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 >=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 >=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; >=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> > >=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<BR>";
=0A> > echo "Phone =3D $phoneResult<BR&=
gt;";
=0A> > echo "E-mail =3D $emailResult<BR>&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@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> > 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 ff.com/cgi-bin/AdWorks/sigclick.cgi/www.rediff.com/signature -home.htm/15071=
91490@Middle5?PARTNER=3D3"> Works/sigimpress.cgi/www.rediff.com/signature-home.htm/19630 59423@Middle5?O=
AS_query=3Dnull&PARTNER=3D3" BORDER=3D0 VSPACE=3D0 HSPACE=3D0>
=0A
--Next_1144158392---0-203.199.83.42-22090--

Re: Unable to connect to PostgreSQL Server: Permission denied

am 04.04.2006 16:00:47 von CGMoller

--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"
@rediffmail.com> "Javier Carlos"
Sent by: , "Gnanavel
pgsql-php-owner@p S" ,
ostgresql.org "pgsql_php"

cc
04/04/2006 09:46
AM Subject
Re: [PHP] Unable to connect to
PostgreSQL Server: Permission
Please respond to denied
"muralidhar
sortur"
@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"


......(as it is)....


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


> >
> >
> >
> >
> >
> >

> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
Name
Phone
E-mail

> >
> >

> >

> >

> >
> >
> >
> > --------------------------------------------------
> > add-entry.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 );
> > ?>
> >
> >

Add Okay!


> >
> >
> >
> > ------------------------------------------------------------ -
> > 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() [ > > href='function.pg-connect'>function.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
> > [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@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--

Re: Unable to connect to PostgreSQL Server: Permission denied

am 04.04.2006 19:35:10 von Pawel Bernat

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,
--=20
Pawe=B3 Bernat; uselessness' lover;
select''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@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Unable to connect to PostgreSQL Server: Permission denied

am 04.04.2006 23:26:32 von Mariusz Pekala

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


--=20
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--