SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 08:13 PM
| ||||
| ||||
 Re: Remote Server Connection Problem 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq      |
|
04-17-2008, 08:13 PM
| |||
| |||
| Re: Remote Server Connection Problem Hi Ray, Thanks for your help. I forgot to tell you that I have done that. See below the hosts I put in pg_hba.conf file: host rftDatabase "globus" "138.250.104.229" 255.255.255.255 md5 host rftDatabase "globus" "138.250.104.225" 255.255.255.255 md5 host rftDatabase "globus" "138.250.104.226" 255.255.255.255 md5 host rftDatabase "globus" "138.250.104.227" 255.255.255.255 md5 host rftDatabase "globus" "138.250.104.228" 255.255.255.255 md5 host rftDatabase "globus" "138.250.104.230" 255.255.255.255 md5 host rftDatabase "globus" "138.250.104.231" 255.255.255.255 md5 host rftDatabase "globus" "138.250.104.232" 255.255.255.255 md5 I have also put all host in the /etc/hosts.allow file. I have read the client authentication of PostgreSQL. I am using port 5432 (default) for postgres to connect. It works fine for local servers but not for remote servers. Any help is highly appreciated. Kind regards Gokop rod@iol.ie wrote: 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 --------------------------------- Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how. |
|
04-17-2008, 08:13 PM
| ||||
| ||||
| Re: Remote Server Connection Problem Hi Ray, Thanks very much. It has worked. I restarted the headnode and tried to connect and create new servers and it works just fine. Thanks again Gokop rod@iol.ie wrote: 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 --------------------------------- Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now. |
Linear Mode
