PT4 on Windows can't connect to pgsql server

[Hand84]

Hi,

I'm experiencing an odd problem with PT4 under windows. I've moved my database to my new homeserver, which is reachable under its alias 'wandboard'. With my MacBook and the MacOS X version of PT4 (v4.10.5) I was able to establish the connection to this server without any problems (via 'Browse Databases'). If I use the same connection settings with the windows version of PT4 (v4.10.5), I get an error ('This server is not responding to connection attempts. Please restart the PostrgeSQL service, than PokerTracker and try again'). I followed these instructions but nothing changed and the message is shown again. I thought this might be some firewall issue, since an erronous config on the server would result in other errors (I've seen them many times before ), but my firewall shows no blocked connection attempts and if I use the pgAdmin to connect to the server everything works fine. I have no idea what else might prevent the win version from connecting to the server in my network. Any ideas?

Regards,
Richard

[kraada]

Are you sure you're using the right settings to connect via the Windows machine? Make sure you've got the right IP address set in PT4; depending how you did the alias it may not be recognized properly.

[Hand84]

I tried both, the alias and the IP address, neither of them worked. Via the terminal (ping) and pgAdmin (connect to database) both, the IP and the alias work. I'm only talking about the windows environment here.

[kraada]

That's really odd. If you start PT4 with Logging Enabled what does the log file say when you try to connect?

[Hand84]

I think the relevant part of the logfile is:

2013/11/20 20:45:33.118 [15516]: [0000133C][PostgresPickerLoader::Entry] Beginning thread.
2013/11/20 20:45:33.118 [00000]: [0000133C][PostgresPickerLoader] Thread [0x0000133C]: Begin
2013/11/20 20:45:33.118 [00000]: [0000133C][PostgresConnection] Connecting to database: postgres
2013/11/20 20:45:33.243 [00125]: [0000133C][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: no pg_hba.conf entry for host "192.168.178.20", user "postgres", database "postgres", SSL off
2013/11/20 20:45:33.274 [00029]: [0000133C][PostgresConnection] Connecting to database: template1
2013/11/20 20:45:33.274 [00000]: [0000133C][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.
2013/11/20 20:45:45.957 [12691]: [00001460][PostgresPickerLoader::Entry] Beginning thread.
2013/11/20 20:45:45.957 [00001]: [00001460][PostgresPickerLoader] Thread [0x00001460]: Begin
2013/11/20 20:45:45.957 [00000]: [00001460][PostgresConnection] Connecting to database: postgres
2013/11/20 20:45:46.035 [00073]: [00001460][PostgresConnection (Error)] Unable to login to database (postgres). Reason: FATAL: no pg_hba.conf entry for host "192.168.178.20", user "postgres", database "postgres", SSL off
2013/11/20 20:45:46.066 [00024]: [00001460][PostgresConnection] Connecting to database: template1
2013/11/20 20:45:46.066 [00000]: [00001460][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.

See attachment for complete logfile from startup, over trying to connect until shutdown of PT4. I had to rename *.txt to *.zip to be able to attach the file!

[kraada]

Could you paste your pg_hba.conf file from the server? It sounds like the problem might be there.

[Hand84]

Hey kraada,

I got things running. Your advice looking at the pg_hba.conf file let me think about those settings again.

When I first tried to configure the connection I used only one setting for all my local devices:
hostssl all all 192.168.178.0/24 md5

Later I also tried (which of course is the same config):
hostssl all all 192.168.178.20/32 md5 (<- PC)
hostssl all all 192.168.178.21/32 md5 (<- MacBook)

After your post I changed the config to
host all all 192.168.178.21/32 md5 (<-- PC)
hostssl all all 192.168.178.20/32 md5 (<-- MacBook)
and suddenly I was able to connect to my database.

So it seems that the win version of PT4 does not use SSL to connect to the server, while the mac version does. This is my guess because pgAdminIII on Windows was able to establish the connection via SSL (and still is without SSL).

Anyways, thanks for your help and support. I really appreciate it.

[WhiteRider]

That's good to hear - thanks for letting us know.