Обсуждение: Remote Server Connection Problem
Dear All,<br /><br />Please how can I add a remote server in my pgAdmin. I can add local servers in my cluster which runsGlobus 4 toolkit using PostgreSQL version 7.4. I am using pgAdmin3 v1.2.2. I get this error when i was trying to adda new remote server:<br /><br />An error has occured:<br /><br />Error connecting to the server: FATAL: no pg_hba.confentry for host "138.250.104.229", user "globus", database "rftDatabase", SSL off<br /><br /><br />138.250.104.229is the IP for the local server, 138.250.104.232 is the IP of the remote server, but is not showing it inthe error.<br /><br />Please any help is appreciated<br />Regards<br />Gokop<br /><br /><p><hr size="1" />Be a better penpal. Text or chat with friends inside Yahoo! Mail. <a href="http://us.rd.yahoo.com/evt=51732/*http://overview.mail.yahoo.com/">Seehow.</a>
goteng1704@yahoo.com wrote: > Error connecting to the server: FATAL: no pg_hba.conf entry > for host "138.250.104.229", user "globus", database > "rftDatabase", SSL off > > 138.250.104.229 is the IP for the local server, 138.250.104.232 > is the IP of the remote server, but is not showing it in the > error. There's your problem - you need to give 138.250.104.229 permission to connect to the remote server by adding a suitable entry to pg_hba.conf - look up "Client authentication" in the PostgreSQL docs. Ray. http://www.iol.ie
Hi Ray,<br /><br />Thanks for your help. I forgot to tell you that I have done that. See below the hosts I put in pg_hba.conffile:<br /><br />host rftDatabase "globus" "138.250.104.229" 255.255.255.255 md5<br />host rftDatabase "globus""138.250.104.225" 255.255.255.255 md5<br />host rftDatabase "globus" "138.250.104.226" 255.255.255.255 md5<br />hostrftDatabase "globus" "138.250.104.227" 255.255.255.255 md5<br />host rftDatabase "globus" "138.250.104.228" 255.255.255.255md5<br />host rftDatabase "globus" "138.250.104.230" 255.255.255.255 md5<br />host rftDatabase "globus" "138.250.104.231"255.255.255.255 md5<br />host rftDatabase "globus" "138.250.104.232" 255.255.255.255 md5<br /><br />I havealso put all host in the /etc/hosts.allow file. I have read the client authentication of PostgreSQL. I am using port5432 (default) for postgres to connect. It works fine for local servers but not for remote servers.<br /><br />Any helpis highly appreciated.<br /><br />Kind regards<br />Gokop<br /><br /><b><i>rod@iol.ie</i></b> wrote:<blockquote class="replbq"style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> goteng1704@yahoo.comwrote:<br />> Error connecting to the server: FATAL: no pg_hba.conf entry<br />> for host "138.250.104.229",user "globus", database<br />> "rftDatabase", SSL off<br />><br />> 138.250.104.229 is the IPfor the local server, 138.250.104.232<br />> is the IP of the remote server, but is not showing it in the<br />>error.<br /><br />There's your problem - you need to give 138.250.104.229 permission to<br />connect to the remoteserver by adding a suitable entry to pg_hba.conf -<br />look up "Client authentication" in the PostgreSQL docs.<br/><br /><br />Ray.<br /><br /><br /><br /><br />http://www.iol.ie<br /></blockquote><br /><p><hr size="1" />Be abetter pen pal. Text or chat with friends inside Yahoo! Mail. <a href="http://us.rd.yahoo.com/evt=51732/*http://overview.mail.yahoo.com/">Seehow.</a>
Hi Ray,<br /><br />Thanks very much. It has worked. I restarted the headnode and tried to connect and create new serversand it works just fine.<br /><br />Thanks again<br />Gokop<br /><br /><b><i>rod@iol.ie</i></b> wrote:<blockquote class="replbq"style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> goteng1704@yahoo.comwrote:<br />> Error connecting to the server: FATAL: no pg_hba.conf entry<br />> for host "138.250.104.229",user "globus", database<br />> "rftDatabase", SSL off<br />><br />> 138.250.104.229 is the IPfor the local server, 138.250.104.232<br />> is the IP of the remote server, but is not showing it in the<br />>error.<br /><br />There's your problem - you need to give 138.250.104.229 permission to<br />connect to the remoteserver by adding a suitable entry to pg_hba.conf -<br />look up "Client authentication" in the PostgreSQL docs.<br/><br /><br />Ray.<br /><br /><br /><br /><br />http://www.iol.ie<br /></blockquote><br /><p><hr size="1" />Be abetter sports nut! Let your teams follow you with Yahoo Mobile. <a href="http://us.rd.yahoo.com/evt=51731/*http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ ">Try it now.</a>