Mac OS X Lion Server, can't connect PT3 to Postgresql

[bender]

I purchased new mac mini with Mac OS X Lion Server installed (not just Lion, but Lion Server). It has Postgresql 9.0.5 installed. It's used buy OS, I think, so I can't really mess with it too much.
I followed instructions here http://www.mactasia.co.uk/revisited-using-postgresql-in-lion-server and I can connect to it from pgAdmin. Unusual thing is, pgAdmin accepts any password at all, including blank. I also tried different random (non-existent) usernames, but only "_postgres" (with underscore) works.
I installed PT3. Every time I run it it asks me to install Postgresql. I refuse. Then it asks me to connect to existing Postgresql. This fails with error message : "Unable to connect to this database. Please check the configuration". I tried all kind of passwords including blank and my OS X password.
I looked at PostgreSQL.log and it adds messages when I connect to Postgresql server from pgAdmin, but when I attempt to connect from PT3 it doesn't add any new messages there.
I initially tried to set up PT3 a couple of months ago, so I could forget something I did.

Please help.

This is status of postgresql:
mini:~ edik$ sudo serveradmin fullstatus postgres
Password:
postgres:dataDirHasBeenInitialized = yes
postgres:PG_VERSION = "9.0.5"
postgres:dataDir = "/var/pgsql"
postgres:postgresIsResponding = yes
postgres:dataDirIsDirectory = yes
postgres:PGserverVersion = 90005
postgres:dataDirExists = yes
postgres:setStateVersion = 1
postgres:state = "RUNNING"

Screenshot (how do I add a picture to the post directly?):
http://imglink.ru/show-image.php?id=a35 ... 9fe7f88771

[kraada]

Hold option and click on PokerTracker to start it with Logging Enabled, then check the PokerTracker.log file (it's in ~/Documents/PokerTracker/) and let me know what error message you receive there - that should give us more information as to what is going wrong here.

[bender]

Hold option and click on PokerTracker to start it with Logging Enabled, then check the PokerTracker.log file (it's in ~/Documents/PokerTracker/) and let me know what error message you receive there - that should give us more information as to what is going wrong here.

2012/02/16 10:46:15.146: [- Main -][System] PokerTracker v3.11.9 beta
2012/02/16 10:46:15.147: [- Main -][SystemInfo] MacOS 10.7.3
2012/02/16 10:46:15.148: [- Main -][SystemInfo] Mac OS X (Darwin 11.3.0 x86_64)
2012/02/16 10:46:15.148: [- Main -][SystemInfo] Model: Macmini5,3 CPUs: 8 x86_64 CPU Freq: 2.00 GHz Clock Freq: 0.10 GHz
2012/02/16 10:46:15.149: [- Main -][SystemInfo] Physical Memory: 2,048 mb Logical Memory: 2,048 mb
2012/02/16 10:46:15.149: [- Main -][SystemInfo] Server HD: Disk Space: 476,120 mb total; 134,413 mb used; 341,707 mb free
2012/02/16 10:46:15.178: [- Main -][SystemInfo] Configuration: [General]\nBuildDate=2012/02/02\nRegistrationCode=*** REG CODE REMOVED ***\n[Messages]\nOptOut\:1ab4c8e72d3d58a327deeadb1bbc88a9=Y\n[Database]\nDefault.Postgres.Port=0\n
2012/02/16 10:46:15.191: [- Main -][System] Getting String: FBF492BF-091F-5C41-85F8-BA13C65AB4BC
2012/02/16 10:46:15.207: [- Main -][System] Attempting to connect to: https://www.ptrackupdate.com/regcheck.php
2012/02/16 10:46:15.213: [- Main -][wxThreadedRead] Starting read thread ...
2012/02/16 10:46:15.214: [B0207000][ConnectorReadThread::Entry] Beginning thread.
2012/02/16 10:46:15.215: [B0207000][ConnectorReadThread] Creating socket...
2012/02/16 10:46:15.216: [B0207000][ConnectorReadThread] DNS lookup...
2012/02/16 10:46:15.586: [B0207000][ConnectorReadThread] Socket connect...
2012/02/16 10:46:16.012: [B0207000][ConnectorReadThread] Sending request...
2012/02/16 10:46:16.463: [B0207000][ConnectorReadThread] Reading response...
2012/02/16 10:46:16.467: [B0207000][ConnectorReadThread] Read complete.
2012/02/16 10:46:16.467: [B0207000][ConnectorReadThread] Returning.
2012/02/16 10:46:16.470: [- Main -][wxThreadedRead] Getting data ...
2012/02/16 10:46:16.474: [- Main -][Registration] License written to /Users/edik/Library/Application Support/PokerTracker/PokerTracker.lic
2012/02/16 10:46:16.478: [- Main -][System] Registered: true
2012/02/16 10:46:16.480: [- Main -][System] HelpMessages v1.01 is up to date.
2012/02/16 10:46:16.481: [- Main -][System] FullTilt v1.15 is up to date.
2012/02/16 10:46:16.530: [- Main -][System] 888 v0.00 is up to date.
2012/02/16 10:46:16.533: [- Main -][System] Currencies v1.01 is up to date.
2012/02/16 10:46:16.547: [- Main -][System] TournamentDetect v1.79 is up to date.
2012/02/16 10:46:16.559: [- Main -][System] TRP Status: TH: false; TO: false; RH: true; RO: false; PH: true; PO: false;
2012/02/16 10:46:16.584: [- Main -][Everleaf] Everleaf.cfg not found
2012/02/16 10:46:16.593: [- Main -][WindowSplash] Beginning load process
2012/02/16 10:46:26.103: [- Main -][PostgresConnection] Connecting to database: postgres
2012/02/16 10:46:26.105: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
2012/02/16 10:46:26.106: [- Main -][PostgresConnection] Connecting to database: template1
2012/02/16 10:46:26.106: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
2012/02/16 10:46:34.298: [- Main -][PostgresConnection] Connecting to database: postgres
2012/02/16 10:46:34.300: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
2012/02/16 10:46:34.300: [- Main -][PostgresConnection] Connecting to database: template1
2012/02/16 10:46:34.301: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
2012/02/16 10:46:39.923: [- Main -][PostgresConnection] Connecting to database: postgres
2012/02/16 10:46:39.925: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
2012/02/16 10:46:39.926: [- Main -][PostgresConnection] Connecting to database: template1
2012/02/16 10:46:39.926: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

[kraada]

Could you paste the contents of /Library/PostgreSQL/9.0/data/pg_hba.conf here for me please? I suspect the configuration there may be causing us some trouble. You might be able to get around this using your local IP address in the host box (e.g. 192.168.1.100 or whatever your local IP is - you can find it through running ifconfig in the terminal) but I'd like to see what the default setup is so that if something needs changing at least we know what it is for the future.

[bender]

I didn't find the file where you specified it, but I found one in /private/var/pgsql/pg_hba.conf
Here it is:

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust

I tried a few IPs. They all failed with different errors:
2012/02/16 20:53:57.393: [- Main -][PostgresConnection] Connecting to database: postgres
2012/02/16 20:53:57.395: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: could not connect to server: Connection refused Is the server running on host "10.43.4.129" and accepting TCP/IP connections on port 5432?
2012/02/16 20:53:57.395: [- Main -][PostgresConnection] Connecting to database: template1
2012/02/16 20:53:57.396: [- Main -][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.
2012/02/16 21:01:38.694: [- Main -][PostgresConnection] Connecting to database: postgres
2012/02/16 21:01:38.739: [- Main -][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.
2012/02/16 21:01:38.740: [- Main -][PostgresConnection] Connecting to database: template1
2012/02/16 21:01:38.740: [- Main -][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.
2012/02/16 21:02:36.869: [- Main -][PostgresConnection] Connecting to database: postgres
2012/02/16 21:02:36.929: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: could not connect to server: Connection refused Is the server running on host "10.43.102.238" and accepting TCP/IP connections on port 5432?
2012/02/16 21:02:36.930: [- Main -][PostgresConnection] Connecting to database: template1
2012/02/16 21:02:36.930: [- Main -][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.
2012/02/16 21:03:14.863: [- Main -][PostgresConnection] Connecting to database: postgres
2012/02/16 21:03:14.886: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
2012/02/16 21:03:14.886: [- Main -][PostgresConnection] Connecting to database: template1
2012/02/16 21:03:14.887: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
2012/02/16 21:05:42.411: [- Main -][PostgresConnection] Connecting to database: postgres
2012/02/16 21:05:42.426: [- Main -][PostgresConnection (Error)] Unable to login to database (postgres). Reason: could not connect to server: Connection refused Is the server running on host "169.254.35.195" and accepting TCP/IP connections on port 5432?
2012/02/16 21:05:42.427: [- Main -][PostgresConnection] Connecting to database: template1
2012/02/16 21:05:42.427: [- Main -][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.
2012/02/16 21:42:27.857: [- Main -][PostgresConnection] Connecting to database: postgres
2012/02/16 21:42:27.878: [- Main -][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.
2012/02/16 21:42:27.878: [- Main -][PostgresConnection] Connecting to database: template1
2012/02/16 21:42:27.878: [- Main -][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.
2012/02/16 21:42:49.906: [- Main -][PostgresConnection] Connecting to database: postgres
2012/02/16 21:42:49.907: [- Main -][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.
2012/02/16 21:42:49.907: [- Main -][PostgresConnection] Connecting to database: template1
2012/02/16 21:42:49.907: [- Main -][PostgresConnection (Error)] This server is not responding to connection attempts. Please restart the PostgreSQL service, then PokerTracker and try again.

[kraada]

Try using 127.0.0.1 and see if that works better for you.

[bender]

127.0.0.1 gives the same error:

2012/02/16 23:26:52.733: [- Main -][PostgresConnection] Connecting to database: template1
2012/02/16 23:26:52.733: [- Main -][PostgresConnection (Error)] Unable to login to database (template1). Reason: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

PT3 still wants to install Postgresql every time I start it (I refused every time). This may mean something.

[kraada]

This is very odd. Please create a support ticket using our system requesting remote assistance and link to this thread and we'll take care of you. This will be much easier to troubleshoot when connected directly to the machine.