Database connection problem

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

Database connection problem

Postby robinm » Tue May 27, 2008 5:51 pm

i downloaded PT 3 yesterday and am now getting this error message when I try to open it...

Unable to create postgresSQL database: pt3 database
Reson unable to login to database(template 1)
reason: could not connect to server: connection refused (0x0000274d/10061) is the server running on host "localhost" and acceptingTCP/IP connections on port 5432

I have tried to start services via Programs -> Postgre 8.3 -> Start Services

There is no Service in Services and Applications to let me autostart the services either but there is a postgres user in Local Users and Groups.
robinm
 
Posts: 8
Joined: Mon May 26, 2008 1:03 pm

Re: Database connection problem

Postby WhiteRider » Wed May 28, 2008 4:18 am

Did you already have postgres installed before you installed PT3?
Or did you install "PT3 with postgres"?

Sounds like a problem with your postgres install.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Database connection problem

Postby robinm » Wed May 28, 2008 4:35 pm

WhiteRider wrote:Did you already have postgres installed before you installed PT3?
Or did you install "PT3 with postgres"?

Sounds like a problem with your postgres install.


I did install Postgres first...this connected fine the day I bought it, 3 days ago. I had an issue with queries not running though (divide by zero error, which I'm awaiting a response on too)
robinm
 
Posts: 8
Joined: Mon May 26, 2008 1:03 pm

Re: Database connection problem

Postby robinm » Wed May 28, 2008 5:19 pm

I've been trying to resolve this but cannot. I don't think my Port 5432 is open. I ran netstat -an in a command window and 5432 did not appear on the list
robinm
 
Posts: 8
Joined: Mon May 26, 2008 1:03 pm

Re: Database connection problem

Postby robinm » Wed May 28, 2008 7:59 pm

Hi WhiteRider,

You can scratch this issue. I reinstalled Postgres, ensured it was added as a service, and am now able to connect to it via PokerTracker. My other issue remains where all of the queries attempting to run in the stats windows are failing.
robinm
 
Posts: 8
Joined: Mon May 26, 2008 1:03 pm

Re: Database connection problem

Postby kraada » Thu May 29, 2008 11:42 am

Can you please enable logging, reproduce the error, then attach the PokerTracker.log file to a support ticket and reference this thread? We will be able to figure out what is going on better once we can see the log file.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: Google [Bot] and 33 guests

cron