Thanks guys.

I'm using Arch Linux and recently upgraded Xorg from 1.4x to 1.5x. Current environment is gnome with compiz and emerald. I upgraded my nvidia binaries to the current beta ones, as they depend on Xorg 1.5+ and fix the window decorations corruptions with wine and compiz. I'm using a non current git slightly newer than alpha 9. After the upgrades, a new bug developed. When selecting an individual tables "close this hud" my system immediately hard crashes (a feat I have not been able to accomplish in quite some time )

I've determined compiz is not the issue, as the bug is replicated without it using Metacity. The Xorg upgrade is actually a major one as it changes the way X and hal with dbus communicate with all periphrials (including mouse and keyboard). And of course the proprietary nvidia driver upgrade is suspect too. I haven't isolated those yet as I can't downgrade Xorg and Xorg server without downgrading the video drivers first, and that involves recompiling my kernel and some other things first. And of course the issue might be something completely different.

Still pretty busy, so I'm not sure if I'll be able to finish self troubleshooting before alpha 10, we'll see how it goes. In the mean time I can get along fine with the bug, just letting you all know what's up.

Still loving the project and all open source, Later.

I don't know when you last updated fpdb from git, but you should probably update again before you do more investigation. There was toxic code in some of our git repos for a day or two earlier this month--I thought that it only affected windows users, but you might save yourself some trouble by getting the most up-to-date.

My repo is up-to-date:
http://www.assembla.com/spaces/free_.../trac_git_tool

to get it:
git clone git://git.assembla.com/free_poker_tools.git

Edit to say don't forget get to look in your ~/.fpdb directory for the log files and that if you run from the console, you might get a messge there.

Updated to your latest git, bug still exists. There are no error logs from the program or the OS as the crash is an immediate total lockup that can only be recovered from with power reset.

Also, the full tilt deep stack tables aren't recognized by the HUD, and if I'm on one, the HUD also will stop updating on the other non deep stack tables.

compiz + wine on my system still isn't that great, some of the window manager calls aren't being dealt with properly. If i switch to another desktop while playing a hand, I hear an alarm, then switch back to my poker desktop, and everything has disappeared - its still running but the compiz WM no longer displays.

I'd suggest this is and emerald + wine + nvidia issue...

What is the full table title bar? We should be able to fix that pretty quickly.

whatever (deep)

1 white space after (deep) : same as non deep tables

actual full example:

French (deep) - $0.25/$0.50 - No Limit Hold'em - Logged In As xxxx

Hi guys.. I download this thing jsut earlier.. I am using Vista so followed all the relevant steps on how to reinstall MySQL etc.. I have ensured that MySQL is running and so forth but I am unable to open the fpdb.py file.. A window pops up and closes and then nothing.. I tried reinstalling thrice but it does not seem to work.. I also used the command prompt to check whether to check everything in python was fine and it was all installed.. Can someone please help here.. I have been at this for three hours and am now at my wits end to the point where I am like I would just buy pokeroffice or something if I cannot get this running soon..

also i got this emssage

Traceback (most recent call last):
File "C:\Users\Hp\Desktop\pyfpdb\fpdb.py", line 448, in <module>
me = fpdb()
File "C:\Users\Hp\Desktop\pyfpdb\fpdb.py", line 361, in __init__
self.load_profile()
File "C:\Users\Hp\Desktop\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\Hp\Desktop\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)")

It looks like the installer is not setting the password for the fpdb database correctly. You need to get in to mysql and set up the db. The easiest way is to start the mysql client from the start menu--give it the root password you specified when you installed it. Then give the mysql client these commands:

exit [enter] exits the client

You might get an error message from the create statement, if fpdb already exists--no problem, go ahead with the other commands.

Then edit your config file to specify the database parameters. The is in the c:\documents and setting\YOURNAME\Application Data\ directrory. Near the bottom of that file is a line like this:

put your password in db_pass parameter.

I did get the error message as you mentioned.. I am using windows vista and have no idea where the equivalent of the doc/settings is.. I tried changing it in the HUD config/xml file but it still did not work.. so can you tell me where I need to paste this thing you said when dealing with vista??

also still the get the same 1045 error message..

Hi, I am getting a permission error when I try to auto import on pokerstars:

C:\fpdb-1.0_alpha9_p142\pyfpdb\fpdb.py:242: DeprecationWarning: use gtk.UIManager
self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)
Traceback (most recent call last):
File "C:\fpdb-1.0_alpha9_p142\pyfpdb\GuiAutoImport.py", line 74, in do_import
self.importer.runUpdated()
File "C:\fpdb-1.0_alpha9_p142\pyfpdb\fpdb_import.py", line 153, in runUpdated
self.import_file_dict(file)
File "C:\fpdb-1.0_alpha9_p142\pyfpdb\fpdb_import.py", line 164, in import_file_dict
inputFile=open(file, "rU")
IOError: [Errno 13] Permission denied: 'C:\\Users\\mostlybs\\AppData\\Local\\PokerStars\\ HandHistory\\mostlybs'


I checked the permission of that folder, it is read only, I change the code to "r" (without the U) but the error is the same. I am unable to change the permission of the folder even though I am an adminstrator. Perhaps the pokerstars software keeps it as read only. But I don't see why that should impact importing the hands. I am using Vista Home and the latest alpha9 and postgresql.
Anyone seen this error before? Any idea?

As for FullTilt, it is auto importing the hands but the HUD isn't displayed. This is the error from HUD-error.txt:

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.')


any ideas?

Read access should be fine. fpdb also needs read access to the parent of the mostlybs dir. I think that if you can get by this, you will just run in to the same problems you are hitting with FTP.

This is saying that the fpdb HUD process (actually a python process) doesn't have enough permissions find out what program owns the poker client table window. Since you are already an admin, I don't see what more you can do.

None of the fpdb devs use vista, so we are sort of flying blind and trying to figure out what vista needs from reading posts here and other sources. I hope somebody with vista security skills sees this and enlightens us. Sorry to be of no help.

hmm. Interesting. Anyone else with Vista reporting that they've got the HUD functioning?

I was still in the very early learning stages when I wrote that code, but I remember there being a big difference in how the OpenProcess call was handled between Win98 and XP, but I don't think the docs mentioned any major differences between XP and Vista on that call. I could be wrong, however.

I'd say likely it would be related to using PROCESS_VM_READ as part of the permission request, but I do seem to recall that PROCESS_QUERY_INFORMATION didn't work without that one as well, or something like that.

I'll try to set up everything in a Vista virtualbox.

Anything up on the Full Tilt deepstack tables?

Finding myself in need of a little amusement I was leafing recently through one of the more diverting sections of The Mathematics of Poker (Pt 4, Ch. 22), and came to wondering whether in future FPDB could include an automatic risk-of-ruin calculator for cash games.

As it happens, when I said I had ideas for new features, I was referring to the HUD, and this feature would have nothing to do with the HUD; but it has occurred to me lately that I have more than a year of hand histories on my hard drive but still have no clue as to what my historical win rate is at any of the limits I have played.

It would be a simple enough matter for FPDB to display one’s win rate (PTBB/100), hourly rate and variance for any given cash game and limit. A risk-of-ruin calculator could be a natural extension of this. It would answer the question: Given a known win rate and variance, what is my risk of losing my bankroll (as a percentage probability) given that it is so-and-so large? The formulae for this are given in The Mathematics of Poker, on the assumption that the distribution of wins and losses is approximately normal.

Plenty of people post on 2+2 to ask how large their bankroll should be for a particular game, usually in some confusion about the matter; it would be nice if FPDB could just give them the answer on the basis of their actual (historical) win rate.

I have never used Pokertracker, so I need to ask: Does this or do other similar pieces of software already do this? Would it be worth doing? It seems to me it would help when deciding when to move up in limits. Suppose one’s risk of ruin at one’s current game were considered acceptably small (say 1%) given a bankroll of $2000. This would suggest that one must have at least (but probably somewhat more than) $4000 before moving up to the next highest limit.

Dude please someone help me how to get it working on vista.. it shows erroe 1045 so i even to the hmd xml thing and changed it to the sql password.. the black box still open shuts.. has anyone tried/checked that it works on vista?? if so how do you do it??

can you start mysql from the command line or from the start menu?

If those don't work maybe you can start it with this statement on the command line:
c:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe

OK, to be of some help, I have attempted to install this in Vista. I have a lot of experience with MySQL in a Lamp environment, and have been using this program in Linux. So with that said, it should be easy for me to get everything running in Vista. And .... it was.

To the developers: I used the current instructions and the new environment installer. Everything worked well for someone who knows their way around Vista, mysql, and this program. I noticed a few small potential issues for newbies, I'll get around to writing something up soon. The program works great (better than even in Linux, although much uglier)

To LordV27: It sounds like you have mysql set up properly. It also sounds like the program is set up correctly too. What seems the most likely issue first, is your password in the HUD_config.xml file is not the database password of your fpdb. Note that this password is the fpdb's password and not the root password you set for mysql. If you used the installer, this would be the 2nd set of passwords you entered. I would suggest you do the following:

From the start menu, run MySQL command line client
A cmd terminal (dos looking) window will pop up asking for password. This is the root password of mysql. When entered, you should get a message and the mysql> prompt.
Enter show databases;
and you should see a short list including mysql, test, information_schema, and fpdb.
If fpdb is in the list, Enter drop database fpdb;
Enter show databases; again to verify fpdb is no longer there.
Run the setup program again and remember the password entered for the fpdb database (again, this is different than the root password).

If this helps or doesn't help, post back here.

Bankroll and RoR have been discussed in 1000's of threads. One good phzon post on the subject is here: http://forumserver.twoplustwo.com/32...48/#post967871

Yes, Pokertracker and the like give win rates and variance for different criteria. There are lots of Bankroll and RoR tools and calculaters such as this one: http://www.poker-tools-online.com/riskofruin.html

This problem is not where sorrow and I thought it was, we have not quit looking.

Hi, i'm on ubuntu try to install fpdb python mysql working
i build my mysql user db ok.

but when i run fpdb i get and error of the HUD_config.xml

HUD-error.txt

i'm stuck here.
should i install anything more or fill in something somewhere?

befor i also configure the configuration.py here

...and...

did i miss something or any idea ?

DaSMRDS: not sure if this is your problem, but on my linux setup, I have to run the program from it's folder. So instead of:
~$ python /home/rms/X_X/fpdb/pyfpdb/fpdb.py ,
try:
~$ cd /home/rms/X_X/fpdb/pyfpdb
and then
~/X_X/fpdb/pyfpdb/$ fpdb.py (I think that's your bash and terminal setup, could be a different prompt though, depending on your settings)
or just click (or double click, again depending on your settings) the fpdb.py icon in your file manager.

Edit: also, don't change anything in configuration.py

oh yes i see, i backuped my original configuration.py
and edit the HUD_config.xml and past it on my .fpdb

so now i can launch it by Double click it or from the terminal

but still problem like this

good, that's normal for the first time you run it. Just click Valider (assume that's ok?) and then from the program menu Database, select Create or Recreate Tables. That will initialize the fpdb database.