Re: Cannot connect to remote postgres using php
"Dimitris Sakellarios" <[email protected]> Mon, 30 Apr 2012 11:40:37 +0300
| Newsgroups | gmane.comp.db.postgresql.php |
|---|---|
| Message-ID | <78A8EE7180F64BB9B80731343DC27C2D@toshiba> |
This is a multi-part message in MIME format. ------=_NextPart_000_0086_01CD26C6.10DD4890 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Dear Archana hi, Follow below: Step0 Make sure you have no firewall between you (php server root ip) and the server that blocks requests. If this is OK then: Step1 Inside postgresql.conf make sure you have set the listen IP and listen port of your server and this will be the port you connect with php pg_connect Step2 Inside pg_hda.conf configure the hosts you will allow connection either as trusted or md5 Typically bellow will allow all to connect hostnossl all all 0.0.0.0/0 trust Below will allow all to connect using username and password (but before have the first rule enabled to create remotely the users) hostnossl all all 0.0.0.0/0 md5 Step3 restart Pgsql server to grand the new setting. 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 11:30 AM To: [email protected] Subject: [PHP] Cannot connect to remote postgres using php Hello, I am getting this error whenever I try to connect to remote computer. "Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "10.162.19.3" and accepting TCP/IP connections on port 5432? " -- ------------------- regards archana -------------------- ------=_NextPart_000_0086_01CD26C6.10DD4890 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-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> </head> <body lang=3DEL link=3Dblue vlink=3Dpurple> <div class=3DSection1> <p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US = style=3D'font-size: 8.0pt;font-family:Verdana'>Dear Archana hi,<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'>Follow below:<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'>Step0 <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'>Make sure you have no firewall between you = (php server root ip) and the server that blocks = requests.<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 this is OK = then:<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'>Step1 = <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 make sure you have set = the listen IP and listen port of your server and this will be the port you = connect with php pg_connect<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'>Step2<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_hda.conf configure the hosts you = will allow connection either as trusted or md5<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'>Typically bellow will allow all to = connect<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'>Below will allow all to connect using = username and password (but before have the first rule enabled to create remotely the = users)<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 = md5<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'>Step3 restart Pgsql server = to grand the new setting.<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,</span></font><font size=3D1 = face=3DVerdana><span lang=3DEN-GB = style=3D'font-size:8.0pt;font-family:Verdana'><o:p></o:p></span></font></= p> <div> <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'mso-element:para-border-div;border:none;border-top:solid = windowtext 1.0pt; padding:0cm 0cm 0cm 0cm'> <p class=3DMsoNormal = style=3D'text-align:justify;border:none;padding:0cm'><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;border:none;padding:0cm'><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<o:p></o:p></span></font></b></p> <p class=3DMsoNormal = style=3D'text-align:justify;border:none;padding:0cm'><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</span></font>= </b><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'> = </span></font></b><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'>ltd</span></font></b><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'> = </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<o:p></o:p></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"></span></font><font size=3D1 face=3DVerdana><span lang=3DEN-US = style=3D'font-size:8.0pt;font-family:Verdana'><ns0:place w:insAuthor=3D"dimitris.sakellarios" w:insDate=3D"2012-04-30T11:32:00Z" w:endInsAuthor=3D"dimitris.sakellarios" = w:endInsDate=3D"2012-04-30T11:32:00Z"><ns0:City w:insAuthor=3D"dimitris.sakellarios" = w:insDate=3D"2012-04-30T11:32:00Z" w:endInsAuthor=3D"dimitris.sakellarios" = w:endInsDate=3D"2012-04-30T11:32:00Z"><st1:place w:st=3D"on"><st1:City w:st=3D"on"><font color=3Dblack><span = style=3D'color:black'>Athens</u1:City></span></font></st1:City></ns0:City= ></st1:place></ns0:place><font color=3Dblack><span style=3D'color:black'>, <u1:country-region = u2:st=3D"on"><st1:country-region w:st=3D"on">Greece</u1:country-region></u1:country-region></u1:place></st= 1:country-region><o:p></o:p></span></font></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 11:30 AM<br> <b><span style=3D'font-weight:bold'>To:</span></b> = [email protected]<br> <b><span style=3D'font-weight:bold'>Subject:</span></b> [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'><br clear=3Dall> Hello,<br> <br> I am getting this error whenever I = try to connect to remote computer.<br> "Warning: pg_connect(): Unable to connect to PostgreSQL server: = could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "10.162.19.3" and accepting TCP/IP connections = on port 5432? "<br> -- <br> -------------------<br> regards<br> archana<br> --------------------<o:p></o:p></span></font></p> </div> </body> </html> ------=_NextPart_000_0086_01CD26C6.10DD4890--