Gametime window error message

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

Gametime window error message

Postby Cooder » Mon Dec 15, 2008 1:03 pm

I recently made some changes to my PTO databases. The next time I tried open a gametime window it asked for my username and password. I typed in the wrong username and clicked remember these settings. How do I get it to "forget" the settings so I can put in the correct name? PTO, PT (Including gametime windows) and PAHUD work fine otherwise.

I'm using:
XP SP3
PostgreSQL 8.2 (The conf file is edited to "trust")
PTO 2.17.03d

This is the error message:
-----
Database error
Error connecting to the database.
101 - SQLSTATE = 08001
FATAL: role "cooder" does not exist
-----
Cooder
 
Posts: 32
Joined: Wed May 14, 2008 8:41 pm

Re: Gametime window error message

Postby ptrack pat » Mon Dec 15, 2008 4:32 pm

What changes did you make exactly??

The user name should be "postgres" on the Utilities > PostgreSQL Settings window.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Gametime window error message

Postby Cooder » Mon Dec 15, 2008 11:33 pm

ptrack pat wrote:What changes did you make exactly??


I was afraid you'd ask that. It was something trivial like renaming it or changing the default. By the time I discovered the problem with the Game Time window I'd forgotten what it was.

ptrack pat wrote:The user name should be "postgres" on the Utilities > PostgreSQL Settings window.


It is "postgres", I just don't have a way to enter it.
Cooder
 
Posts: 32
Joined: Wed May 14, 2008 8:41 pm

Re: Gametime window error message

Postby ptrack pat » Mon Dec 15, 2008 11:54 pm

I don't know how you would be getting this error then

FATAL: role "cooder" does not exist


It thinks the user name is "cooder".

Open the File > Maintain Database Names window.
Click the Add button.
Enter a new description, check the "Dflt" box and in the last field choose "Select existing PostgreSQL database"
Select the PTO database from the window that opens.
Click OK to save all changes then CLOSE AND REOPEN PTO and try it again.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Gametime window error message

Postby Cooder » Tue Dec 16, 2008 11:20 am

ptrack pat wrote:I don't know how you would be getting this error then

FATAL: role "cooder" does not exist


It thinks the user name is "cooder".


Just to be clear, that was what I typed in when it asked for my username.

I followed your instructions, but it didn't work.

I've found something else. If I click on the Game Time tab of the Statistics window, it works normally. But if I click the "View Outside PTO" button, I get the same error message.
Cooder
 
Posts: 32
Joined: Wed May 14, 2008 8:41 pm

Re: Gametime window error message

Postby ptrack pat » Tue Dec 16, 2008 12:59 pm

When it asks for your user name, it should be "postgres". Does it work after you enter this username? I don't know what else you could have changed to cause this problem.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Gametime window error message

Postby Cooder » Tue Dec 16, 2008 3:58 pm

ptrack pat wrote:When it asks for your user name, it should be "postgres". Does it work after you enter this username? I don't know what else you could have changed to cause this problem.


It doesn't give me a chance to put in my user name. I get the error message, click on OK, and that's it. That's why I want it to "forget" the remembered settings.
Cooder
 
Posts: 32
Joined: Wed May 14, 2008 8:41 pm

Re: Gametime window error message

Postby ptrack pat » Tue Dec 16, 2008 4:06 pm

Go to the c:\program files\poker tracker omaha folder. Double-click on the file called ptogt.exe there. It will open to ask you to select a database. Select the PostgreSQL db from the list. Does this work?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Gametime window error message

Postby Cooder » Tue Dec 16, 2008 5:54 pm

Nope. There were four databases listed in the window, and I tried all of them. The only one that worked was the original Access database.
Cooder
 
Posts: 32
Joined: Wed May 14, 2008 8:41 pm

Re: Gametime window error message

Postby ptrack pat » Tue Dec 16, 2008 9:00 pm

I'll have to ask Mike about this problem, he's the PTO support person. I don't know how PTO can be working fine but not the external window.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Next

Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 0 guests