Post Sql Issues

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

Moderator: Moderators

Post Sql Issues

Postby nineshine » Sat Oct 29, 2011 11:01 am

Hello
I receive the following message when i try to open poker tracker and does not allow me to open, has anybody else had the same problem?

Unable to create PostgreSQL database: PT3_2011_10_29_155618
Reason: Unable to login to database (template1). Reason: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

Thanks
nineshine
 
Posts: 20
Joined: Wed Feb 16, 2011 12:52 pm

SQL ISSUES PLS HELP

Postby soci » Sat Oct 29, 2011 2:09 pm

I havent been using PT3 since it expired a while back and just bought it again earlier today.
Althought I have been using it in the past on this PC today I got fllwg error message when I tried to connect:

UNABLE TO CONNECT OT THIS DATABASE. PLEASE CHECK THE CONFIGURATION

Can anyone help please?
Thanks
soci
 
Posts: 15
Joined: Tue Feb 22, 2011 11:05 am

Re: Post Sql Issues

Postby WhiteRider » Sat Oct 29, 2011 4:21 pm

nineshine wrote:Hello
I receive the following message when i try to open poker tracker and does not allow me to open, has anybody else had the same problem?

Unable to create PostgreSQL database: PT3_2011_10_29_155618
Reason: Unable to login to database (template1). Reason: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

Thanks

That normally indicates that your firewall is interfering with PostgreSQL. Please check our Firewall Guide.
soci wrote:I havent been using PT3 since it expired a while back and just bought it again earlier today.
Althought I have been using it in the past on this PC today I got fllwg error message when I tried to connect:

UNABLE TO CONNECT OT THIS DATABASE. PLEASE CHECK THE CONFIGURATION

Can anyone help please?
Thanks

Our default password is dbpass but you could also try postgrespass. In either case the username should be postgres.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Post Sql Issues

Postby soci » Sat Oct 29, 2011 5:15 pm

that was easy . thanks
soci
 
Posts: 15
Joined: Tue Feb 22, 2011 11:05 am

Re: Post Sql Issues

Postby soci » Sat Oct 29, 2011 5:48 pm

how come the HUD only worked for 5 min or so and suddenly stopped - no error msg whatsoever to be found.
I stopped the HUD and restarted again but still doesnt work.
soci
 
Posts: 15
Joined: Tue Feb 22, 2011 11:05 am

Re: Post Sql Issues

Postby soci » Sat Oct 29, 2011 6:20 pm

now only one out of 4 tables (stars) shows HUD but it only shows stats for 1 hand - and the stats or messed up and dont match to player names?
I remember this to work much better 6 months ago ??

think i found the issue but not sure about how to solve it:


PokerStars: Hand observed but not imported (#69717276514) from 544010596 26

it also states that it has imported 1 hand only ??
soci
 
Posts: 15
Joined: Tue Feb 22, 2011 11:05 am

Re: Post Sql Issues

Postby soci » Sat Oct 29, 2011 9:00 pm

ANYONE???

Do I have to consider the 90$ as lost money and buy an alternative product???
Why is this thing not working?
soci
 
Posts: 15
Joined: Tue Feb 22, 2011 11:05 am

Re: Post Sql Issues

Postby kraada » Sun Oct 30, 2011 8:36 am

Please restart PT3 using the Logging Enabled link via your Start Menu, reproduce and report this problem - your log file will contain considerable information to help us figure out exactly what is causing the problem and exactly what we need to do to get it fixed.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Post Sql Issues

Postby soci » Sun Oct 30, 2011 10:28 am

how come I am not getting answers right here - this is the forum for thechnical support !!!!!!!!!!
the other way u are suggesting is way complicated specially when I am running 20 tables session and try not to loose any money because of a program I bought is not working and not providing the service I PAID for.
And on top of all that the support seems to be sub-optimal to say the least.

this are the log files I copied:


2011/10/29 23:21:06: Info: PartyGaming: Starting auto-import.
2011/10/29 23:21:06: Info: PartyGaming: Stopping auto-import.
2011/10/29 23:21:06: Info: PartyGaming: Stopping auto-import.
2011/10/29 23:21:06: Info: PokerStars: Starting auto-import.
2011/10/29 23:21:06: Info: PokerStars Network: Stopping auto-import.
2011/10/29 23:21:07: Info: PokerStars Network: Stopping auto-import.
2011/10/29 23:21:33: Info: PartyGaming: Starting auto-import.
2011/10/29 23:21:33: Info: PartyGaming: Stopping auto-import.
2011/10/29 23:21:33: Info: PartyGaming: Stopping auto-import.
2011/10/29 23:21:33: Info: PokerStars: Starting auto-import.
2011/10/29 23:21:33: Info: PokerStars Network: Stopping auto-import.
2011/10/29 23:21:34: Info: PokerStars Network: Stopping auto-import.
2011/10/29 23:22:25: Info: PartyGaming: Starting auto-import.
2011/10/29 23:22:25: Info: PartyGaming: Found 1 files to monitor.
2011/10/29 23:22:26: Info: PartyGaming: Loading hand history file: C:\Programs\PartyGaming\PartyPoker\HandHistory\struga555\20111012\$5,000 Gtd (2386085) Table #7_2290659.txt
2011/10/29 23:22:26: Info: PokerStars: Starting auto-import.
2011/10/29 23:22:26: Info: PokerStars: Found 0 files to monitor.
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '457918880 118'
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '544010586 76'
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '457918846 192'
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '457918846 29'
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '544010576 119'
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '544010516 432'
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '544010596 4'
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '544010686 32'
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '457918880 102'
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '544010516 9'
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '457919923 173'
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '544010396 87'
2011/10/29 23:22:33: Info: PokerStars: Importing observed hands from table '544010566 121'
2011/10/29 23:22:34: Info: PokerStars: Importing observed hands from table '447986345 679'
2011/10/29 23:22:34: Info: PokerStars: Importing observed hands from table '457918846 182'
2011/10/29 23:22:34: Info: PokerStars: Importing observed hands from table '544010596 34'
2011/10/29 23:22:34: Info: PokerStars: Importing observed hands from table '544010576 163'
2011/10/29 23:22:34: Info: PokerStars: Importing observed hands from table '544010586 107'
2011/10/29 23:22:34: Info: PokerStars: Importing observed hands from table '544010566 87'
2011/10/29 23:22:34: Info: PokerStars: Importing observed hands from table '544010596 26'
2011/10/29 23:22:34: Info: PokerStars: Importing observed hands from table '457918820 910'
2011/10/29 23:22:34: Info: PokerStars: Importing observed hands from table '544010516 16'
2011/10/29 23:22:34: Info: PokerStars: Importing observed hands from table '544010596 24'
2011/10/29 23:22:34: Info: PokerStars: Importing observed hands from table '457918788 21'
2011/10/29 23:22:34: Info: PokerStars: Hand observed but not imported (#69714694099) from 457918880 118
2011/10/29 23:22:34: Info: PokerStars: Hand observed but not imported (#69718758751) from 544010586 76
2011/10/29 23:22:34: Info: PokerStars: Hand observed but not imported (#69715135163) from 457918846 192
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69715183983) from 457918846 192
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69715226710) from 457918846 192
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69714481530) from 457918846 29
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69714559426) from 457918846 29
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69714609576) from 457918846 29
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69718777682) from 544010576 119
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69719050878) from 544010576 119
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69719135722) from 544010576 119
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69719177782) from 544010576 119
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69719232581) from 544010576 119
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69719263099) from 544010576 119
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69719365027) from 544010576 119
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69719413034) from 544010576 119
2011/10/29 23:22:35: Info: PokerStars: Hand observed but not imported (#69719441133) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69719827670) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69719864724) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69719915314) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69719942526) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720009649) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720070766) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720099606) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720150212) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720193003) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720217818) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720235180) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720269337) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720297071) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720325583) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720400077) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720445249) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720505013) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720538069) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720565533) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69720788574) from 544010576 119
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69718739752) from 544010516 432
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69718798478) from 544010516 432
2011/10/29 23:22:36: Info: PokerStars: Hand observed but not imported (#69718834097) from 544010516 432
2011/10/29 23:22:37: Info: PokerStars: Hand observed but not imported (#69718866766) from 544010516 432
2011/10/29 23:22:37: Info: PokerStars: Hand observed but not imported (#69719031977) from 544010596 4
2011/10/29 23:22:37: Info: PokerStars: Hand observed but not imported (#69719051969) from 544010596 4
2011/10/29 23:22:37: Info: PokerStars: Hand observed but not imported (#69719078807) from 544010596 4
2011/10/29 23:22:37: Info: PokerStars: Hand observed but not imported (#69719112407) from 544010596 4
2011/10/29 23:22:37: Info: PokerStars: Hand observed but not imported (#69719987300) from 544010686 32
2011/10/29 23:22:37: Info: PokerStars: Hand observed but not imported (#69720665259) from 544010686 32
2011/10/29 23:22:37: Info: PokerStars: Hand observed but not imported (#69720701861) from 544010686 32
2011/10/29 23:22:37: Info: PokerStars: Hand observed but not imported (#69720744815) from 544010686 32
2011/10/29 23:22:37: Info: PokerStars: Hand observed but not imported (#69716028422) from 457918880 102
2011/10/29 23:22:37: Info: PokerStars: Hand observed but not imported (#69718638339) from 544010516 9
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69718685360) from 544010516 9
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69718717029) from 544010516 9
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69718750818) from 544010516 9
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69714487043) from 457919923 173
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69714561316) from 457919923 173
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69714597605) from 457919923 173
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69712802994) from 544010396 87
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69712868494) from 544010396 87
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69714591079) from 544010566 121
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69714635708) from 544010566 121
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69714682475) from 544010566 121
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69713988720) from 447986345 679
2011/10/29 23:22:38: Info: PokerStars: Hand observed but not imported (#69714023278) from 447986345 679
2011/10/29 23:22:39: Info: PokerStars: Hand observed but not imported (#69714047726) from 447986345 679
2011/10/29 23:22:39: Info: PokerStars: Hand observed but not imported (#69714093358) from 447986345 679
2011/10/29 23:22:39: Info: PokerStars: Hand observed but not imported (#69715871129) from 457918846 182
2011/10/29 23:22:39: Info: PokerStars: Hand observed but not imported (#69718504971) from 544010596 34
2011/10/29 23:22:39: Info: PokerStars: Hand observed but not imported (#69718531880) from 544010596 34
2011/10/29 23:22:39: Info: PokerStars: Hand observed but not imported (#69713324400) from 544010576 163
2011/10/29 23:22:39: Info: PokerStars: Hand observed but not imported (#69715497993) from 544010586 107
2011/10/29 23:22:39: Info: PokerStars: Hand observed but not imported (#69715531457) from 544010586 107
2011/10/29 23:22:39: Info: PokerStars: Hand observed but not imported (#69715571157) from 544010586 107
2011/10/29 23:22:39: Info: PokerStars: Hand observed but not imported (#69715622864) from 544010586 107
2011/10/29 23:22:39: Info: PokerStars: Hand observed but not imported (#69715660838) from 544010586 107
2011/10/29 23:22:40: Info: PokerStars: Hand observed but not imported (#69715489088) from 544010566 87
2011/10/29 23:22:40: Info: PokerStars: Hand observed but not imported (#69715621017) from 544010566 87
2011/10/29 23:22:40: Info: PokerStars: Hand observed but not imported (#69715682592) from 544010566 87
2011/10/29 23:22:40: Info: PokerStars: Hand observed but not imported (#69717276514) from 544010596 26
2011/10/29 23:22:40: Info: PokerStars: Hand observed but not imported (#69717431563) from 544010596 26
2011/10/29 23:22:40: Info: PokerStars: Hand observed but not imported (#69713892238) from 457918820 910
2011/10/29 23:22:40: Info: PokerStars: Hand observed but not imported (#69718911569) from 544010516 16
2011/10/29 23:22:40: Info: PokerStars: Hand observed but not imported (#69718944273) from 544010516 16
2011/10/29 23:22:41: Info: PokerStars: Hand observed but not imported (#69715694405) from 544010596 24
2011/10/29 23:22:41: Info: PokerStars: Hand observed but not imported (#69718633504) from 457918788 21
2011/10/29 23:23:17: Info: PokerStars: Hand Imported (#69720811599) from 544010686 32
2011/10/29 23:23:19: Info: PokerStars: Hand Imported (#69720810464) from 544010576 119
2011/10/29 23:23:47: Info: PokerStars: Hand Imported (#69720856796) from 544010576 119
2011/10/29 23:24:18: Info: PokerStars: Hand Imported (#69720881424) from 544010576 119
2011/10/29 23:24:33: Info: PokerStars: Hand Imported (#69720855225) from 544010686 32
2011/10/29 23:25:04: Info: PokerStars: Hand Imported (#69720905517) from 544010576 119
2011/10/29 23:25:32: Info: PokerStars: Hand Imported (#69720917721) from 544010686 32
2011/10/29 23:26:17: Info: PokerStars: Hand Imported (#69720946008) from 544010576 119
2011/10/29 23:26:33: Info: PokerStars: Hand Imported (#69720972423) from 544010686 32
2011/10/29 23:26:48: Info: PokerStars: Hand Imported (#69721006563) from 544010576 119
2011/10/29 23:27:01: Info: PokerStars: Hand Imported (#69721020807) from 544010686 32
2011/10/29 23:27:31: Info: PokerStars: Hand Imported (#69721041754) from 544010576 119
2011/10/29 23:28:02: Info: PokerStars: Hand Imported (#69721044344) from 544010686 32
2011/10/29 23:28:32: Info: PokerStars: Hand Imported (#69721070314) from 544010576 119
2011/10/29 23:29:48: Info: PokerStars: Importing observed hands from table '457919302 30'
2011/10/29 23:29:50: Info: PokerStars: Hand observed but not imported (#69721158050) from 457919302 30
2011/10/29 23:32:32: Info: PokerStars: Importing observed hands from table '544010736 76'
2011/10/29 23:32:34: Info: PokerStars: Hand observed but not imported (#69721257688) from 544010736 76
2011/10/29 23:33:15: Info: PokerStars: Hand Imported (#69721318964) from 544010736 76
2011/10/29 23:54:35: Info: PokerStars: Importing observed hands from table '457919302 29'
2011/10/29 23:54:38: Info: PokerStars: Hand observed but not imported (#69722228840) from 457919302 29
2011/10/29 23:54:38: Info: PokerStars: Hand observed but not imported (#69722333510) from 457919302 29
2011/10/29 23:55:35: Info: PokerStars: Hand Imported (#69722406837) from 457919302 29
soci
 
Posts: 15
Joined: Tue Feb 22, 2011 11:05 am

Re: Post Sql Issues

Postby kraada » Sun Oct 30, 2011 10:33 am

You do not need to manually copy anything - the file writes itself and contains far more information than you see in PT3. Once we have it we will be able to diagnose exactly what is going on in your situation.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 39 guests