cant connect to database and forgot sql password

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

cant connect to database and forgot sql password

Postby smeegal » Wed Dec 11, 2013 11:36 pm

Hello get this error message.
An error occurred in an internal database import thread.
Exception: Unable to connect to database: PokerTracker 4 Database
Also I forgot my Postgress password
smeegal
 
Posts: 6
Joined: Fri Aug 10, 2012 9:43 am

Re: cant connect to database and forgot sql password

Postby WhiteRider » Thu Dec 12, 2013 4:04 am

If you haven't already; reboot your computer - that will often get PostgreSQL working again.

If not, click 'Start' and type 'services' and open the Services window.
Is PostgreSQL in the list?
Can you start it?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: cant connect to database and forgot sql password

Postby smeegal » Thu Dec 12, 2013 10:48 pm

It isn't there I can log on to pgadmin 3 but postgres file is not installed i remember a while ago I tried reinstalling postgress but I forgot the password for superuser postgres and account user postgres. So I'm just stuck with the password.
smeegal
 
Posts: 6
Joined: Fri Aug 10, 2012 9:43 am

Re: cant connect to database and forgot sql password

Postby WhiteRider » Fri Dec 13, 2013 3:49 am

Please follow the directions here to fully uninstall PostgreSQL and then you will be able to reinstall and set a new password (our default is 'dbpass'). If you reinstall the same major version that you were previously using then PostgreSQL will be able to reconnect to any existing databases.

Please note: Versions 9.1 and newer are NOT supported - our recommended version (if you don't have databases from an older version) is 9.0.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: cant connect to database and forgot sql password

Postby smeegal » Fri Dec 13, 2013 8:52 am

When I go into cmd and type net user postgres /delete it says System error 5 has occurred

Access is deneid.
smeegal
 
Posts: 6
Joined: Fri Aug 10, 2012 9:43 am

Re: cant connect to database and forgot sql password

Postby kraada » Fri Dec 13, 2013 9:27 am

Run cmd as administrator and then it will complete successfully.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: cant connect to database and forgot sql password

Postby smeegal » Fri Dec 13, 2013 10:15 am

I reinstalled it with password but when i go on to pokertacker 4 it still has the same problem An error occured in an internal database import thread.
smeegal
 
Posts: 6
Joined: Fri Aug 10, 2012 9:43 am

Re: cant connect to database and forgot sql password

Postby kraada » Fri Dec 13, 2013 10:38 am

Please restart PT4 using the logging enabled link on your Start Menu, reproduce this problem and then report it via our support system with the log file - that will help us figure out what is going on here and get it fixed for you. You can find that file by clicking File --> Show User Data Folder in the main PT4 window - the file we need is the text file called PokerTracker4 that is in that folder.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: cant connect to database and forgot sql password

Postby smeegal » Sat Dec 14, 2013 12:05 pm

I sent the report off and haven't received a reply yet.
smeegal
 
Posts: 6
Joined: Fri Aug 10, 2012 9:43 am

Re: cant connect to database and forgot sql password

Postby WhiteRider » Sat Dec 14, 2013 2:00 pm

Please bear with us - replies can take a little longer over the weekend. Your ticket is in the right place, but please ATTACH your log file rather than pasting it. Logs can get cut off when you paste them, and pasted lots make tickets much harder to read.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 33 guests