Re: Cannot connect to remote postgres using php

"Dimitris Sakellarios" <[email protected]> Mon, 30 Apr 2012 13:26:52 +0300
Newsgroups gmane.comp.db.postgresql.php
Message-ID <160199AAABF9415FB10CB518309EC4F2@toshiba> 
This is a multi-part message in MIME format.

------=_NextPart_000_00AB_01CD26D4.E8C354D0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,

 

When you changed the 2 files did you restart the Pgsql server? If not do it.

 

Where is the pgadmin3 installed on the same computer running the Pgsql
server or on a remote computer? 

If it is on the same server default behaviour of Pgsql server is to allow
connection from the same server (local host) but if it is remotely then
either you will need to update the 2 files we mentioned earlier correctly.

 

Let me know.

 

 

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: Archana K N [mailto:[email protected]] 
Sent: Monday, April 30, 2012 1:20 PM
To: Dimitris Sakellarios
Subject: Re: [PHP] Cannot connect to remote postgres using php

 

hello,

     I have changed both conf files. It is not working.


-- 
-------------------
regards
archana
--------------------

 

From: Archana K N [mailto:[email protected]] 
Sent: Monday, April 30, 2012 1:20 PM
To: Dimitris Sakellarios
Subject: Re: [PHP] Cannot connect to remote postgres using php

 



Yes my php script is running on a computer other than pgsql. 

yes logged in as admin in pgsql.

I am using pgadmin 3 also. I can connect using pgadmin.

-- 
-------------------
regards
archana
--------------------


------=_NextPart_000_00AB_01CD26D4.E8C354D0
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=3D"Content-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>
<!--[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>

<p class=3DMsoNormal><font size=3D1 face=3DVerdana><span lang=3DEN-US =
style=3D'font-size:
8.0pt;font-family:Verdana'>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>&nbsp;</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'>When you changed the 2 files did you restart =
the Pgsql
server? If not do it.<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>&nbsp;</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'>Where is the pgadmin3 installed on the same =
computer
running the Pgsql server or on a remote computer? =
<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 it is on the same server default behaviour =
of Pgsql
server is to allow connection from the same server (local host) but if =
it is remotely
then either you will need to update the 2 files we mentioned earlier =
correctly.<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>&nbsp;</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'>Let me know.</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>&nbsp;</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>&nbsp;</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:20:00Z"
 w:endInsAuthor=3D"dimitris.sakellarios" =
w:endInsDate=3D"2012-04-30T13:20:00Z"><ns0:City
  w:insAuthor=3D"dimitris.sakellarios" =
w:insDate=3D"2012-04-30T13:20:00Z"
  w:endInsAuthor=3D"dimitris.sakellarios" =
w:endInsDate=3D"2012-04-30T13:20: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>&nbsp; =
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'>
Archana K N [mailto:[email protected]] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Monday, April 30, =
2012 1:20
PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Dimitris =
Sakellarios<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>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt'>hello,<br>
<br>
&nbsp;&nbsp;&nbsp;&nbsp; I have changed both conf files. It is not =
working.<br>
<br clear=3Dall>
<br>
-- <br>
-------------------<br>
regards<br>
archana<br>
--------------------<o:p></o:p></span></font></p>

<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'><o:p>&nbsp=
;</o:p></span></font></b></p>

<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'>
Archana K N [mailto:[email protected]] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Monday, April 30, =
2012 1:20
PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Dimitris =
Sakellarios<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 =
lang=3DEN-GB
style=3D'font-size:12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DEN-GB
style=3D'font-size:12.0pt'><br>
<br>
</span>Yes my php script is running on a computer other than pgsql. <br>
<br>
yes logged in as admin in pgsql.<br>
<br>
I am using pgadmin 3 also. I can connect using pgadmin.<br clear=3Dall>
<br>
-- <br>
-------------------<br>
regards<br>
archana<br>
--------------------<o:p></o:p></font></p>

</div>

</body>

</html>

------=_NextPart_000_00AB_01CD26D4.E8C354D0--