Re: Cannot connect to remote postgres using php
"Dimitris Sakellarios" <[email protected]> Mon, 30 Apr 2012 13:16:06 +0300
| Newsgroups | gmane.comp.db.postgresql.php |
|---|---|
| Message-ID | <2636D2B5ABD346E7AED4900C78859811@toshiba> |
This is a multi-part message in MIME format. ------=_NextPart_000_009E_01CD26D3.67E813B0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit If you are admin of Pgsql server pls provide pg_hda.conf postgresql.conf maybe the configuration of your server doesn't allow connection other that local host. 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 Dimitris Sakellarios Sent: Monday, April 30, 2012 1:11 PM To: 'Archana K N'; [email protected] Subject: Re: [PHP] Cannot connect to remote postgres using php Dear archana, Is the PHP script you are running on a remote server other than the one running Pgsql? If so, have you got rights to access Pgsql server remotely? Or you are allowed only from a web browser using phpmyadmin? Are you the admin of Pgsql server? --------- Did you try pgAdmin3 as a standalone client to connect from your pc? Please provide some topology design. 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 1:02 PM To: [email protected] Subject: Re: [PHP] Cannot connect to remote postgres using php Hello, I can connect to the other computer using web browser and also can access postgres. -- ------------------- regards archana -------------------- ------=_NextPart_000_009E_01CD26D3.67E813B0 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.EmailStyle19 {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'>If you are admin of Pgsql server pls provide = <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_hda.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'>postgresql.conf<o:p></o:p></span></font></p> <p class=3DMsoNormal><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> <p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-GB = style=3D'font-size: 8.0pt;font-family:Verdana'>maybe the configuration of your server = doesn’t allow connection other that local host.<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-30T13:13:00Z" w:endInsAuthor=3D"dimitris.sakellarios" = w:endInsDate=3D"2012-04-30T13:13:00Z"><ns0:City w:insAuthor=3D"dimitris.sakellarios" = w:insDate=3D"2012-04-30T13:13:00Z" w:endInsAuthor=3D"dimitris.sakellarios" = w:endInsDate=3D"2012-04-30T13:13: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>Dimitris = Sakellarios<br> <b><span style=3D'font-weight:bold'>Sent:</span></b> Monday, April 30, = 2012 1:11 PM<br> <b><span style=3D'font-weight:bold'>To:</span></b> 'Archana K N'; [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=3D1 face=3DVerdana><span lang=3DEN-US = style=3D'font-size: 8.0pt;font-family:Verdana'>Dear archana,<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'>Is the PHP script you are running on a remote = server other than the one running Pgsql?<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, have you got rights to access Pgsql = server remotely? Or you are allowed only from a web browser using = phpmyadmin?<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'>Are you the admin of Pgsql = server?<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'>Did you try pgAdmin3 as a standalone client = to connect from your pc?<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'>Please provide some topology = design.<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'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<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'>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<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">Athens</u1:City></st1:place>, <u1:country-region = u2:st=3D"on">Greece</u1:country-region></u1:country-region><o:p></o:p></s= pan></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 1:02 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'><br> Hello,<br> <br> I can connect to the other computer using web browser and also can = access postgres.<br> <br> <br clear=3Dall> <br> -- <br> -------------------<br> regards<br> archana<br> --------------------<o:p></o:p></span></font></p> </div> </body> </html> ------=_NextPart_000_009E_01CD26D3.67E813B0--