Network Connection Error

[TeddyKGB]

Hi Guys,

here's my error:
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.

[TeddyKGB]

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.

[TeddyKGB]

No one has an idea?

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

[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.

[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.

[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.

[TeddyKGB]

Thank u very much kraada That was the solution.