Re: Cannot connect to remote postgres using php
"Dimitris Sakellarios" <[email protected]> Mon, 30 Apr 2012 19:40:36 +0300
| Newsgroups | gmane.comp.db.postgresql.php |
|---|---|
| Message-ID | <C9E90317C38C42179737E941E16F7685@toshiba> |
This is a multi-part message in MIME format.
------=_NextPart_000_00E2_01CD2709.1E58FDF0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
First of all set all firewall down and then test again.
I remember you said that the PHP server and the PGSQL server are on
different machines? Is that correct?
If so how did you succeed to connect to local host? Did you move your PHP
code to the same machine hosting your PGSQL server or do you host a PGSQL
server on both machines?
Provide some more details (a small design) to give more help else it is
hopeless like that sorry. Also provide the the part of the PHP you try to
create the connection.
Try the below proposal.
On server that host the PHP (IP=y.y.y.y)
<?php
..
pg_connect("host=x.x.x.x port=5432 dbname=AAAAAAA user=BBBBBBBB
password=BBBBBBBB") or die('Could not connect: ' . pg_last_error());
..
?>
On server that host PGSQL (IP=x.x.x.x)
Inside pg_hba.conf
.
hostnossl all all 0.0.0.0/0 trust
..
Inside postgresql.conf
listen_addresses = 'x.x.x.x,localhost'
port = 5432
Test and report.
BR,
Sakellarios Dimitris
Telesuite ltd Telecommunication and Internet Services
Address : T. Sofouli 14, Post Code 16344, Ilioupoli - Athens, Greece
T.: +30 211 760 1300 F.: +30 211 176 9999 M.: +30 6982 550 850 e-mail:
dimitris.sakellarios <mailto:[email protected]>
@telesuite.gr url: http://www.telesuite.gr <http://www.telesuite.gr/>
_____
From: [email protected] [mailto:[email protected]]
On Behalf Of Archana K N
Sent: Monday, April 30, 2012 6:58 PM
To: [email protected]
Subject: Re: [PHP] Cannot connect to remote postgres using php
My postgres server is listening to same port . I tried changing both but
same error is showing.
I restarted the servers after changing the conf files. pgadmin3 is running
on both servers and i can connect them remotely. I am able to connect to
local host using the php code.
I think i have changed the files correctly , some antivirus softwares are
running in the system i dont know whether that causes the problem.
--
-------------------
regards
archana
--------------------
------=_NextPart_000_00E2_01CD2709.1E58FDF0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40"
xmlns:ns0=3D"urn:schemas-microsoft-com:office:smarttags">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"country-region"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Verdana;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle18
{mso-style-type:personal;
font-family:Verdana;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Verdana;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:595.3pt 841.9pt;
margin:36.85pt 31.2pt 36.85pt 31.2pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEL link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<div>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>First of all set all firewall down and then =
test
again.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>I remember you said that the PHP server and =
the
PGSQL server are on different machines? Is that =
correct?<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>If so how did you succeed to connect to local =
host?
Did you move your PHP code to the same machine hosting your PGSQL server =
or do
you host a PGSQL server on both machines?<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>Provide some more details (a small design) to =
give
more help else it is hopeless like that sorry. Also provide the the part =
of the
PHP you try to create the connection.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>Try the below =
proposal.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>On server that host the PHP =
(IP=3Dy.y.y.y)<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><?php<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>….<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>pg_connect("host=3Dx.x.x.x port=3D5432 =
dbname=3DAAAAAAA
user=3DBBBBBBBB password=3DBBBBBBBB") or die('Could not connect: ' =
.
pg_last_error());<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>….<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>?><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>On server that host PGSQL =
(IP=3Dx.x.x.x)<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>Inside =
pg_hba.conf<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>…<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>hostnossl
all
all
0.0.0.0/0 =
trust<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>….<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>Inside =
postgresql.conf<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>listen_addresses =3D =
'x.x.x.x,localhost'<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>port =3D 5432<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>Test and report.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>BR,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 color=3Dblack face=3DVerdana><span =
lang=3DEN-GB
style=3D'font-size:8.0pt;font-family:Verdana;color:black'><o:p> </o:=
p></span></font></p>
<div style=3D'border:none;border-top:solid windowtext 1.0pt;padding:0cm =
0cm 0cm 0cm'>
<p class=3DMsoNormal style=3D'text-align:justify'><b><font size=3D1 =
color=3Dblack
face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:8.0pt;font-family:Verdana;
color:black;font-weight:bold'><o:p> </o:p></span></font></b></p>
<p class=3DMsoNormal style=3D'text-align:justify'><b><font size=3D1 =
color=3Dblack
face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:8.0pt;font-family:Verdana;
color:black;font-weight:bold'>Sakellarios =
Dimitris</span></font></b><b><font
size=3D1 color=3Dblack face=3DVerdana><span lang=3DEN-GB =
style=3D'font-size:8.0pt;
font-family:Verdana;color:black;font-weight:bold'><o:p></o:p></span></fon=
t></b></p>
<p class=3DMsoNormal style=3D'text-align:justify'><b><font size=3D1 =
color=3Dblack
face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:8.0pt;font-family:Verdana;
color:black;font-weight:bold'>Telesuite ltd </span></font></b><font =
size=3D1
color=3Dblack face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:8.0pt;font-family:
Verdana;color:black'>Telecommunication and Internet Services<b><span
style=3D'font-weight:bold'><o:p></o:p></span></b></span></font></p>
</div>
<p class=3DMsoNormal =
style=3D'margin-right:-1.4pt;text-align:justify'><font size=3D1
color=3Dblack face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:8.0pt;font-family:
Verdana;color:black'>Address : T. Sofouli 14, Post Code 16344, Ilioupoli =
- <u1:place u2:st=3D"on"><u1:City u2:st=3D"on"><st1:place
w:st=3D"on"><st1:City =
w:st=3D"on">Athens</u1:City></st1:place></st1:City>, <u1:country-region =
u2:st=3D"on"><st1:country-region
=
w:st=3D"on">Greece</u1:country-region></u1:country-region></st1:country-r=
egion></st1:place><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D1 color=3Dblack face=3DVerdana><span =
lang=3DEN-US
style=3D'font-size:8.0pt;font-family:Verdana;color:black'>T</span></font>=
<font
size=3D1 color=3Dblack face=3DVerdana><span lang=3DDE =
style=3D'font-size:8.0pt;
font-family:Verdana;color:black'>.: <b><span =
style=3D'font-weight:bold'>+30 211
760 1300</span></b> </span></font><font size=3D1 color=3Dblack =
face=3DVerdana><span
lang=3DEN-US =
style=3D'font-size:8.0pt;font-family:Verdana;color:black'>F.</span></font=
><font
size=3D1 color=3Dblack face=3DVerdana><span lang=3DDE =
style=3D'font-size:8.0pt;
font-family:Verdana;color:black'>: <strong><b><font face=3DVerdana><span
style=3D'font-family:Verdana'>+30 211 176 9999 =
</span></font></b></strong>M.:<strong><b><font
face=3DVerdana><span style=3D'font-family:Verdana'> +30 6982 550 850 =
</span></font></b></strong>e-mail<b><span
style=3D'font-weight:bold'>:</span></b> </span></font><font size=3D1 =
color=3Dblack
face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:8.0pt;font-family:Verdana;
color:black'><a =
href=3D"mailto:[email protected]">dimitris.sakellarios<sp=
an
lang=3DEN-GB>@</span>telesuite<span lang=3DEN-GB>.</span>gr</a> =
url: <a
href=3D"http://www.telesuite.gr/">http://www.telesuite.gr</a></span></fon=
t><font
size=3D1 face=3DVerdana><span lang=3DEN-GB =
style=3D'font-size:7.5pt;font-family:Verdana'><o:p></o:p></span></font></=
p>
</div>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span lang=3DEN-US style=3D'font-size:12.0pt'>
<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span lang=3DEN-US
style=3D'font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</spa=
n></font></b><font
size=3D2 face=3DTahoma><span lang=3DEN-US =
style=3D'font-size:10.0pt;font-family:Tahoma'>
[email protected] [mailto:[email protected]] =
<b><span
style=3D'font-weight:bold'>On Behalf Of </span></b>Archana K N<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Monday, April 30, =
2012 6:58
PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
[email protected]<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Re: [PHP] Cannot =
connect
to remote postgres using php</span></font><span =
lang=3DEN-US><o:p></o:p></span></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>My postgres server is listening to same port . I tried changing =
both
but same error is showing. <o:p></o:p></span></font></p>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>I restarted the servers after changing the conf files. pgadmin3 =
is
running on both servers and i can connect them remotely. I am able to =
connect
to local host using the php code.<o:p></o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>I think i have changed the files correctly , some antivirus =
softwares
are running in the system i dont know whether that causes the =
problem.<br>
<br clear=3Dall>
<o:p></o:p></span></font></p>
<div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>-- <br>
-------------------<br>
regards<br>
archana<br>
--------------------<o:p></o:p></span></font></p>
</div>
</div>
</body>
</html>
------=_NextPart_000_00E2_01CD2709.1E58FDF0--