Right now it is fairly painful to add this sort of info to the HUD or HUD popups, etc. One thing I have been doing is to make an interface for plugins--the flop games mucked card display is an example of one of those plugins. I need to clean up the code some and then these sorts of things become pretty easy. This will be my first priority when I get back to working on the HUD.

Gave it a go using MySQL, but dont have the time to get it running(uni exams very soon). Ill definately give it another shot(or more). Im going to wait for next release so I can use PostgreSQL(maybe thatll be easier), am very interested in this software and think its great all the work your putting in.

Also on the previous page, thanks for the zip file, just saves time looking around for everything I need.

And yes this thread has grown very large.

Hi all,

I tried fpdb a couple of months ago and was pretty impressed. I gave it away for a while, built a new computer and have now returned to see that development of fpdb has been clicking along.

I went thru the wiki, did a Ubuntu install of postgress and fydp and everything seem fine.... database was created, I can connect to it, fpdb and HUD window launches, but the HUD doesn't display any data in the poker client table.

fpdb-error-log.txt:
home/wayne/fpdb/pyfpdb/fpdb.py:241: DeprecationWarning: use gtk.UIManager
self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)

Hud-error-log.txt
HUD_main starting
Using db name = fpdb
Exception exceptions.KeyError: KeyError(-1210124096,) in <module 'threading' from '/usr/lib/python2.5/threading.pyc'> ignored

Any help would be appreciated as I really want this to work... obv.

None of the errors look useful.

What sire are you playing? Are you sure that the correct folder is selected for you HHs to import? Is there any output in the console besides .......?

Dog,

What were you getting when you didn't have "run as administrator" on ?

If you installed python in C:\Python26\ as it would default to, open a command prompt, and try

c:\python26\python

if that is successful, exit that, then try from the fpdb folder..

c:\python26\python fpdb.py

?

I was getting an "unauthorized" error code, I can't remember the exact wording. So, I changed it to "run as admin" and the error code went away.
I did this, from the command line (my actual location was c:\program files\python2.6.1\python), but it worked and started python and I saw the copyright and help and so on info in the command box. So, I know it started.

I'm not sure about this that you wanted me to run. When I entered it on a command line, just as you typed it, it errored saying it was an invalid command. It looks like you're trying to run/start two programs simultaneously.????? I did go to the c:\program files\fpdb\pyfpdb and tried to run fpdb.py

I got the same results, the mouse pointer went to an hour glass and nothing. It looked like it was working, but no program opened up.

Dog

You're attempting to run python interpreter - and interpret the fpdb.py scipt.

You want

I did it from the command line. It opened the standard Vista "do you want this program to run" idiot box. I clicked allow. I could here the harddrive doing it's thing, then it returned me to the command line.

I was sitting in the directory c:\program files\python2.6.1 and nothing happened, nothing opened, it appears nothing is running. And, there are no errors on the command line. Don't know what to tell you at this point. I did remember to enter the quotes around "Program files" when in the command line because of the spacing in the directory name.

The operation was successful, but the "patient" died. No errors. I checked in the AppData directory under FPDB and there are no error logs. It doesn't make sense. Everything is there. But it just doesn't open the program, AND gives no errors as to why.... frustrating.... but I really appreciate the help/attempts to resolve this.. thanks Sorrow

Dog

Did it actually die or hang?

Try running with -x on the end of the command line in theory that redirects all log output to the console instead of a file(failing to open the log file is a possibility). Also pm me your email address and i'll send you a version of fpdb.py that has a lot more output on startup.

It did not "appear" to hang. Other than the program not actually opening, I thought it was going to start, then nothing. I tried to open it both ways, trying to open the fpdb.py file from file manager, and using the command line. Both had the same results... a busy light, activity on the harddrive, then silence. I will PM you... again, thanks

Dog

Testing fpdb out on Full Tilt. I'm thinking the issue is with the HH folder... none of the HH text files have been moved (ergo, processed) by fpdb. When I check the path to the HH folder within fpdb I initially get an error about the directory not existing... so I point fpdb at the correct HH folder, start playing the pokerz but the HUD data never materializes... strange.

There is nothing in the console besides the HH folder error, then a line of text showing me connecting to the right folder, then the normal '.....'

Regards

fpdb doesn't move HH files after processing. It does sound like the importer is not pointing at the correct folder, which can be set in the HUD_config.xml file. It is better to try the bulk importer first--you can click browse and select a single file in the bulk importer.

Ahh... we might have something:

started at 2009-05-31 20:56:36.247333 -- 2 files to import. drop
! failed drop pg fk Hands_gametypeId_fkey
! failed drop pg fk HandsPlayers_handId_fkey
! failed drop pg fk HandsPlayers_playerId_fkey
! failed drop pg fk HandsActions_handPlayerId_fkey
! failed drop pg fk HudCache_gametypeId_fkey
! failed drop pg fk HudCache_tourneyTypeId_fkey
! failed drop index HandsPlayers_handId_idx
! failed drop index HandsPlayers_playerId_idx
! failed drop index HudCache_gametypeId_idx
! failed drop index Players_siteId_idx
! failed drop index Tourneys_tourneyTypeId_idx
DEBUG: import_fpdb_file: failed on self.lines[0]: '/home/wayne/.wine/drive_c/Program Files/Full Tilt Poker/HandHistory/PJs Ronin/FT20090531 Tierra De Palmas - $0.05-$0.10 - No Limit Hold'em.txt' 'default' '[]' '9996'

• All of those "failed drop index" are not really a problem--they don't interfere with the import. Somebody (possibly me) has fouled up the drop index syntax for postgres.
• This looks like an output from a run using postgres ast the db. Postgres support is spectacularly broken in version 0.11. I have import working on my box now, but I'm still stuggling with getting the HUD to work. I will try to have something for you to try in my git repo later today(no promises, it is really, really broken). I'll post here when that is ready.
• The DEBUG, etc. message might or might not be a big problem. I get that message about every fourth time I play at FTP. With the new importer almost ready, I have not been motivated to track it down.

The debug message means that it attempted to read the file from character 9996 of the file, and found no new content. Were you (The Minder) trying to bulk import a file for a table that is currently active? The code caches the last position in the file that it read, the error message occurs when the file is re-read when no new content has been added.

OK, I just pushed changes to my public git repo that should allow postgres users to import hands and use the HUD. I have not tried the stats displays and graphing, but have no doubt that they are seriously hosed. I also saw some other ugliness in the postgres stuff that I'm going to fix now while I'm in that part of the code.

I am not going to make this a release because so much of the postgres stuff is still broken. I will work on that tomorrow. Git users can get this version from my git repo.

Meanwhile, I would like to have feedback from anyone trying it with postgres, especially windows.

You can learn how to use git to download/upgrade fpdb in the wiki. (it really is easy)

Py2exe sounds like a good idea to me (not that I need it myself) but I suppose it should wait until the software is a little more stable. The same comment has also been made as to why there is no installer: the program isn't finished yet.

I mention this since I think there are so many complaints because Fpdb is the victim of its own success. I hope the developers won't mind my saying that people who stumble onto this thread (as I did) should really consider themselves warned: this is experimental software. There are a lot of people reading this who will not be used to open source stuff and don't immediately realise what "version 0.11" (or any other number less than 1.0) means.

As to the idea of using SQLite, I've said before that I like it and would be happy to do testing. I'm using Fpdb primarily as an HUD; I don't need a huge database of hundreds of thousands of hands, just one large enough to categorise opponents I meet frequently. All in all, simpler is better.

I don't see anything in the database code that SQLite couldn't do, and it would probably do it faster. You can't have foreign keys and whatnot, but then I've already been using MyISAM tables for ages with no foreign keys.

An unrelated point:

No, the HUD doesn't close when the table closes. I just leave it hanging around; it does no harm.

Houston, we have success.

Bulk import worked fine.
HUD displayed data over the client window.
Mucked cards displayed properly.
Graph function worked.

<--- happy camper. Thank you.

One more request if I may b4 I fade back into the mire of users. All I want the HUD to show is VPIP/PFR/AF and number of hands. Which file would I mod to achieve this, and what section of that file.

Regards

http://fpdb.wiki.****************/Howto+HUD is the start of a document that shows how to configure the HUD windows. The example down the bottom shows lots of additional stats.

I dont believe the AF stat is yet PT compatible.

As s0rrow says in his post, our current AF is "aggression frequency." The db does not have the info needed to calculate aggression factor. We'll fix that with the new importer/analyzer--that will take some time.

py2exe looks pretty good--I have been doing some reading on it. I think we are at or near the point where fpdb is "sufficiently stable" for someone to begin working on a py2exe script. to wit:

• When a dev makes changes to a source file, the py2exe script only needs to be rerun to produce an updated exe--this is not a problem.
• When a dev adds (or removes) a source file, there may need to be some small changes to the py2exe script, depending on how the script is set up.
• If a dev adds a library, then fairly large changes need to be made to the py2exe script (this could be a pretty big deal, but doesn't happen very often).
• When we go to a new version of python, there would be some work to do on the script.

py2exe is here. Anybody who is preparing to work on a py2exe script for fpdb should probably talk to the devs on the mailing list. We are doing lots of development on fpdb--we will break stuff as this goes on. One of the things about fpdb is that it is a very ambitious project--who else is trying to support all the games on all the sites on all the operating systems and you can use the database server of your choice. If we were trying to support one game on one site on windows and postgres, we would have a polished, easy-to-use product by now. I am happy that we are ambitious; I agree that we should warn new users that fpdb is under development. I am still interested in supporting SQLite and the MyIAM tables. I don't have any plans to work on this in the short term. I have written some code that does this (and some other cool stuff like having the HUD follow when the table is dragged). I have not merged this because it breaks windows. You can try this code by running Table_Demo.py from my git repo.

I just pushed a few more changes to my public git repo that iron out a few more wrinkles from the postgres support. Importing and HUD seem to work nicely now.

There is still some bother in the graphs when using postgres. This has already been fixed in the code that will become the next release (after the bug fix release I'm working on now). I will look at that fix and decide whether I backport it to the current bug fix release.

The new fix is in my public git repo. If I don't hear any complaints I'll make that bug fix release 0.11.1 tonight or 1st thing tomorrow.

to download you git need enter in Git Bash this line: git clone git://git.assembla.com/free_poker_tools.git ?

i make that and have eror in fpdb-error-log.txt
Traceback (most recent call last):
File "C:\Users\Дмитрий\free_poker_tools\pyfpdb\fpdb.py" , line 465, in <module>
me = fpdb()
File "C:\Users\Дмитрий\free_poker_tools\pyfpdb\fpdb.py" , line 377, in __init__
self.load_profile()
File "C:\Users\Дмитрий\free_poker_tools\pyfpdb\fpdb.py" , line 269, in load_profile
self.settings['db-password'])
File "C:\Users\Дмитрий\free_poker_tools\pyfpdb\fpdb_db. py", line 73, in connect
self.db = psycopg2.connect(database = database)
psycopg2.OperationalError: fe_sendauth: no password supplied