PDA

View Full Version : "missing or erroneous pg_hba.conf file"



scratch28
05-16-2009, 06:38 PM
I'm trying to setup my laptop to access the database on my desktop over my home network. I had no problems with PT2 doing this but can't seem to get it working with HEM. I followed the steps EXACTLY according to the tutorial and am now getting a msg that says:

Connection Error: Unable to read data from the transport connection. An existing connection was forcibly closed by the remote host.

then when i try again it says...

Connection Error: FATAL: F0000: missing or erroneous pg_hba.conf file
followed by a bunch of details...

One side note...when i changed the pg_hba.conf file to allow the ip of my laptop to connect, the changes show up if i open that file in notepad but do NOT show up if i open it thru pgadminIII

morny
05-16-2009, 06:58 PM
Im not familiar with that error to be honest, maybe try repeating the process and if the problem persists try posting on the PostgreSQL forum about that error or maybe try exporting the hands, doing a fresh install and when you get it up and running reimport the hands

Crazyeyez
05-31-2009, 10:45 PM
FWIW I had the same issue. I slapped a "/32" on the end of the ip address in the pg_hba.conf file and now I'm in business. I don't know what that means but I found it via google in another sql forum.

Good luck.

Papa Cheche
01-27-2010, 05:42 AM
Thanks, i had the same problem. with /32 , it's now OK :-)

Sept
04-01-2010, 12:41 AM
Damn... I have the exact same problem, but it wasn't fixed by adding the '/32' :/

Here's how my pg_hba.conf looks like :

# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 192.168.1.0/32 md5
# IPv6 local connections:
host all all ::1/128 trust

Please help !!! :)

Papa Cheche
04-01-2010, 01:40 AM
stop and restart the service

Sept
04-01-2010, 04:39 AM
Did that about a couple dozen times already :)

netsrak
04-01-2010, 06:46 AM
Please try another ip address.
I think 192.168.1.0 is not valid. You should use the exact IP of your 2nd computer

_Loki_
04-01-2010, 10:29 AM
Like Karsten says...

to find your ip addresses in xp use ipconfig in cmd - look here for examples:
Windows 2000 / XP TCP/IP protocol (http://www.windowsnetworking.com/articles_tutorials/w2ktcpip.html)
& here
Windows XP ipconfig Tutorial (http://www.ncsu.edu/resnet/windows/ipconfig/)
(but the comments about resnet are particular to the user)

Maybe the procedure is diff in other OS, but easy to find if you google ipconfig & your OS

Sept
04-01-2010, 10:31 PM
Please try another ip address.
I think 192.168.1.0 is not valid. You should use the exact IP of your 2nd computer

I love you! That did the trick, everything working fine now. Thanks so much!

On a side note, the "192.168.1.0" came from your faq page (http://faq.holdemmanager.com/questions/90/Run+PostgreSQL+Over+a+Network+) : "add a line like host/all/postgres/192.168.2.0 (= address of your local network)/md5 if your laptop is getting an IP Adres from a DHCP server within your network."

My laptop indeed is getting its IP from DHCP. Maybe someone should edit that line if it doesn't work?

Thanks again.