Page 1 of 1

Network Connection Error

PostPosted: Fri Nov 11, 2011 3:31 pm
by TeddyKGB
Hi Guys,

here's my error: Image
Pokertracker Database on a Virtual Machine ( ESXI 5) Server 2008 R2 64 bit with Postgressql 9.1 64 Bit.

Want to log on with a Win7 32 Bit Machine with Postgressql 9.1 32 bit.

I had no Problems without a Virtual Machine to share the Database but since i made the VM i have problems. I always used this how to http://www.pokertracker.com/forums/view ... =45&t=4638

Thank u for your help.

Re: Network Connection Error

PostPosted: Fri Nov 11, 2011 7:26 pm
by TeddyKGB
Image

heres another screen to the error. I dont understand it.
i copied this to to the pg_hba.conf: host all all 192.168.1.0/24 md5
Server IP is 1.6 and the client has 1.8. So normally he must have access. Password is also correct on both.

Re: Network Connection Error

PostPosted: Sat Nov 12, 2011 8:38 am
by TeddyKGB
No one has an idea?

maybe i have no access because they dont have the same bit system?

Re: Network Connection Error

PostPosted: Sat Nov 12, 2011 9:42 am
by kraada
Please also take a look in the postgres.conf file - in that file listen_addresses = '*' must be uncommented if it is not already (by removing the # at the start of the line and saving the file). If that is not set (or listen_addresses is set otherwise) its restrictions supersede those of pg_hba.conf.

Re: Network Connection Error

PostPosted: Sat Nov 12, 2011 10:00 am
by TeddyKGB
heres a copy of the postgres.conf:

# Put your actual configuration here
# ----------------------------------
#
# If you want to allow non-local connections, you need to add more
# "host" records. In that case you will also need to make PostgreSQL
# listen on a non-local interface via the listen_addresses
# configuration parameter, or via the -i or -h command line switches.



# TYPE DATABASE USER ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#host replication postgres 127.0.0.1/32 md5
#host replication postgres ::1/128 md5
#host all all 192.168.1.0/24 md5


I think its correct.

Re: Network Connection Error

PostPosted: Sat Nov 12, 2011 10:23 am
by kraada
That's pg_hba.conf but I see your problem - you need to remove the "#" in front of the last line - do that, save the file, restart PostgreSQL and everything should work.

Lines with # in front of them are not interpreted.

Re: Network Connection Error

PostPosted: Sat Nov 12, 2011 10:53 am
by TeddyKGB
Thank u very much kraada :-) That was the solution.