PT3 uses postgresql, so setting up mysql will not affect PT3.

For the record, this is what the installer does in mysql:

1. Creates an empty database, named fpdb.
2. Gives full permissions to a user named fpdb to the fpdb database.

The source for the installer is in the packaging dir of the tree. Alpha 9 has the old installer. You can get the new installer from the git tree or from alpha 10 when it comes out.

download page is ok now

Sourceforge is down occasionally, that could have been the problem.

Hi, I have been trying to get this running for a few days now and have no joy.

I am not great with this stuff but can usually follow instructions ok.

My OS is windows vista.

I downloaded mysql as recommended and the 2 latest fpdb downloads (alpha9 and the installer)

everything seemed to install fine (when the installer was installing python etc, It asked for my root password and fpdb password. I basically made one up for both - is that correct??)

When I click on the fpdb file to access it, I get a black window that breifly comes up with an error about graphics and when I check my error txt log file, it has this -

Traceback (most recent call last):
File "C:\Users\Dan\Desktop\fpdb\pyfpdb\fpdb.py", line 448, in <module>
me = fpdb()
File "C:\Users\Dan\Desktop\fpdb\pyfpdb\fpdb.py", line 361, in __init__
self.load_profile()
File "C:\Users\Dan\Desktop\fpdb\pyfpdb\fpdb.py", line 266, in load_profile
self.db.connect(self.settings['db-backend'], self.settings['db-host'], self.settings['db-databaseName'], self.settings['db-user'], self.settings['db-password'])
File "C:\Users\Dan\Desktop\fpdb\pyfpdb\fpdb_db.py", line 43, in connect
self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database)
File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
return Connection(*args, **kwargs)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'fpdb'@'localhost' (using password: YES)")

Can anyone please advise me what I can try next as I would love to get this up and running. Should I uninstall everything and try with postgres?? or is there an easier way?

No. The root password is made as part of the mysql installation process. The fpdb installer in then asking you for that password so it can access mysql and create the fpdb password that basically you do make up at that time.

xaiviax beat me to it, but yeah, you should have specified a root password for MySQL when you intalled it. The installer should have complained if you gave it a bad root password.

The default root password in blank. That is no password, just clear the the password field in the installer or just hit enter at the command line.


Don't uninstall. Follow this how to from the wiki to set up MySQL and you should be OK. Please report any problems with that how to back here--I just wrote it about 1 minute ago.

Ok thanks xaiviax - Is there somewhere I can got to, to find this password or will I have to un-install/re-install mysql and be more vigilant when it tells me the password?

see above, i posted while you were posting

Eratosthenes, thank you very much. I followed those instructions, which were very clear, even for a newbie like me and it is now working. I can get into fpdb anyway

I just dont know how to use it properly now, I haven't imported anything yet as I need a bit more time just to see how to. I did briefly try to see if the HUD was working and when I opened my table I saw the hud window (that says exiting this will close the hud), but I did not see any stats.

Anyway, I'm sure it's just me, so I will have a proper look later and read some more in the help section if I get stuck. But once again, thank you, at least it is now up and running.

In your HUD_config.xml file you just need to change the information in the lines that look like: screen_name="ENTER HERO NAME" site_path="~/.wine/drive_c/Program Files/PokerStars/" HH_path="~/.wine/drive_c/Program Files/PokerStars/HandHistory/abc/" to whatever is appropriate for your setup.

Full Tilt is borked for me at the moment, hanging hard in wine so i can't debug this presonally.

Could you find the function clean_title(name) in your install (Tables.py) and try a couple of mods.
If there is no clean_title (NOTE: there may be 2x fix both) in your install, then the function is in fulltilt_decode_table

You'll need to restart fpdb after each change - could you try that and report back please?

You’re right, of course. In fact, I think one needs in excess of 100,000 hands to be able to determine one’s win rate with any sort of accuracy.

In the meantime, I have run into trouble with the HUD again.

Firstly, the problem of the misplaced windows has reappeared; and now the menu option to put them back where they should be does nothing. I have to re-position them manually. In the previous version the windows were always correctly placed. (I don’t know how to specify which version this was, as I got it by syncing with the repository.)

Secondly, the HUD has started to crash (in X-Windows under Linux). This is what happens:

FYI, I was able to get the HUD working for Pokerstars. After configuring the HUD_config.xml file, I had to delete all the files in the user hand history folder. For me, this folder was something like "c:\Program Files/PokerStars/HandHistory/mostlybs/". If there was old files in this folder, the HUD stats would not display. Then start fpdb by clicking on fpdb.py. When the Free Poker DB window comes up, I click on Viewers --> Auto Import and HUD. The click on Start Autoimport which will start the HUD Main Window. Now open up table(s) from the Pokerstars lobby and take seats and play. The stats will display after the first hand. Note, if I open up tables before launching the HUD, the HUD stats will no display on each table. The HUD-error.txt would show this error:

HUD_main starting
Using db name = fpdb
Unhandled exception in thread started by <function read_stdin at 0x02C54BB0>
Traceback (most recent call last):
File "HUD_main.py", line 136, in read_stdin
tablewindow = Tables.discover_table_by_name(config, table_name)
File "C:\fpdb-1.0_alpha9_p142\pyfpdb\Tables.py", line 76, in discover_table_by_name
table = discover_nt_by_name(c, tablename)
File "C:\fpdb-1.0_alpha9_p142\pyfpdb\Tables.py", line 200, in discover_nt_by_name
pshandle = win32api.OpenProcess(win32con.PROCESS_QUERY_INFORM ATION | win32con.PROCESS_VM_READ, False, processid[1])
pywintypes.error: (5, 'OpenProcess', 'Access is denied.')


which was reported earlier in this thread. Everything would work fine if the HUD was started first before joining tables.

As for Fulltiltpoker, I am still unable to see the HUD stats on the poker tables and is getting the above error. I am going to research the win32api to see if i can find the fix.
Hope this helps anyone trying to get this working on Vista with Pokerstars.

(Regarding my report about the HUD’s crashing: ) By the way, I suspect that the HUD only crashes when I start to close some of the tables I have been playing on. That may help to explain what is going wrong.

Thanks guys, I am nearly there....but not quite

First fpdb -

I cannot import any hands. First of all, I get the error msg
"Error getting information for 'C:\Users\Dan/.wine/drive_c/Program Files/PokerStars/HandHistory': The system cannot find the path specified."

When I change it to the correct path, it still does not do anything. (and also doesn't seem to save the path I put in as I get that error msg every time I open it). My correct path is c\:/program files/pokerstars/handhistory/Rockafella77
I have added the path in the box on left and can see it whenever I go in though.
The same applies with the auto import - it has the incorrect path listed. I browse and choose the correct path but still get nothing.
My pokerstars set up does save the handhistory in the folder I am going to.
(just a quick question slightly off topic incase you know - on pokerstars, it saves my handhistory for 30 days, if I put a 0 in the box instead of 30, will that make it unlimited??)

The HUD-
This does not work either, I have followed the instructions from xaiviax above, I get the HUD window, but no stats are ever displayed (I have only played STT's though, but it should still work right??)
I may have put the config in wrong as I am confused with the paths and not sure how it should look. Here is my hud_config please have a look and tell me if it is correct -
<site enabled="True" site_name="PokerStars" table_finder="PokerStars.exe" screen_name="Rockafella77" site_path="~/.wine/drive_c/Program Files/PokerStars/" HH_path="~/.wine/drive_c/Program Files/PokerStars/HandHistory/Rockafella77/"

I think your using my tree at the moment. That has recently had some table tracking code added. I suspect the timer callback is crashing at that point.

Try "C:\Program Files\PokerStars\HandHistory\YourStarsUsername" as HH_path in the config. Also make sure you have the directory selected, not multiple files.
The bulk importer is a bit dumb still.

In windows you probably need the path i specfied above.
Added, or navigated to it?
It wont save the path between fpdb runs, it reads the path from the config, and never writes it back.

No idea - i use 365 as a value

Sorrow pretty much answered your entire group of questions for you.

On the above question, I just enter some big number and manually move all the files each month into a new folder labeled something like November08. This way I have all my HH's saved independent of any specific database program and thus can easily use them in any program and all their versions. Also it allows me to decide what timeframe of hands to use regardless of a particular trackers ability to that. For example, PokerAceHud could use the last time frame or last specific # of hands. I like to use the last 2 or 3 thousand hands, but no hands older than a couple of months, that combo was not able to be achieved. Imho, old data can be worse than no data in profiling an opponent. I could ramble on, but I won't.

On it...

Hmm. There is a bug if your HH folder contains a directory
ie. You point it at:
C:\hh\Sorrow\
but there is a directory C:\hh\Sorrow\subdir - but thats not your issue.

I suspect the issues below may have something to do with that.
Having the tables already open shouldnt make a difference. That it works when they are open is a bit weird.

The error is real though. It looks like a security problem, fpdb is being prevented from getting the window handle on another running processes. Sounds like an additional security measure in vista.

Beyond my expertise at this point.

Good luck

Thanks for your time sorrow - I have done everything as above and still no joy.
I cannot import hands, nor can I use the HUD.
The is the error in my HUD error.txt file -
" File "HUD_main.py", line 136, in read_stdin
tablewindow = Tables.discover_table_by_name(config, table_name)
File "C:\Users\Dan\Desktop\fpdb\pyfpdb\Tables.py", line 76, in discover_table_by_name
table = discover_nt_by_name(c, tablename)
File "C:\Users\Dan\Desktop\fpdb\pyfpdb\Tables.py", line 200, in discover_nt_by_name
pshandle = win32api.OpenProcess(win32con.PROCESS_QUERY_INFORM ATION | win32con.PROCESS_VM_READ, False, processid[1])
pywintypes.error: (5, 'OpenProcess', 'Access is denied.')"


This is the error in my fpdb.error. txt
"Traceback (most recent call last):
File "C:\Users\Dan\Desktop\fpdb\pyfpdb\fpdb.py", line 317, in tab_auto_import
self.add_and_display_tab(aimp_tab, "Auto Import")
File "C:\Users\Dan\Desktop\fpdb\pyfpdb\fpdb.py", line 55, in add_and_display_tab
self.add_tab(new_tab, new_tab_name)
File "C:\Users\Dan\Desktop\fpdb\pyfpdb\fpdb.py", line 64, in add_tab
raise fpdb_simple.FpdbError("duplicate tab_name not permitted")
fpdb_simple.FpdbError: 'duplicate tab_name not permitted'"

Since I changed the config as advised above by sorrow, the hand history path is now stored and this is what shows everytime I open fpdb now (which is a good thing, I just wanted to let you know)

Looks like the Vista problem MostlyBS posted.
I dont think this is an issue - i think this crash is being caused by the auto importer failing.

I'm not going to pretend like I know what I'm going about and this might sound silly, but if it is something to do with vista......
I know alot of programs (tournament shark etc) will only run if you "run as administrator". You must do this for the program and for the poker client you are using.
You normally right click them, then run as administrator, but you cannot do this with fpdb as it is a file you are clicking on. Could this be anything to do with it maybe?

Also I tried what mostlyb recommended and cleared the HH folder and tried the auto-import. This still didnt work for me

Any ideas what I can try now? (if you need me to copy and paste anything just ask)

That not a silly suggestion at all...

If UAC is the problem then could you try disabling it temporarily - http://www.howtogeek.com/howto/windo...windows-vista/ and see if that fixes the issue?

There is a problem in my git repo. I am also getting a crash of the HUD process when I close a HUD and I have a regression on import bug I fixed a month ago (this only affects stud, so I'm probably the only dev who would see it.) I think I have pulled from someone who is not up to date and then I did a bad merge. I was tired and in a hurry when I did the merge, so I just screwed up.

It probably won't take me too long to fix this, and I'm getting on it as soon as I have some breakfast.

I can't figure out how to make my repo temporarily unavailable, so I'll fix this ASAP and let you know when it is safe to pull.

Sorry about the inconvenience.

STTs are not supported in the alpha9 release. They are in supported in the current versions of git, but don't get that yet--I'll tell you when it is safe to pull from git.