Thanks, i installed the MySQLdb, and it gets past that error now, but it now says _mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

This makes me think mayb there is a place in the config file i don't see that tells it not to connect to MySQL since i have postgresql installed and want to use that?

Need some help to get the hud to work...

hands are importing fine and table viewer works great the main hud windows appear but nothing on my table??

The HUD_config need to be in the working direc right ? (not where i put the default conf)

I took the example in xml and modified to put the right password in

EDIT: ok now the the specific window for each table appears but no stats yet..

I believe I fixed this in git82 (git-ID: cd212af). I tried it with only mysql-python (using mysql as backend of course) and it works - could someone git pull this version and try it WITH psycopg2 but WITHOUT MySQLdb please (using pgsql as backend)? My pgsql is currently on strike for some reason so I can't unfortunately. Once this is tested I'll release it as alpha4 so everyone can use it.

HUD_config.xml has to be in the current working directory. So if you start it from inside the fpdb/pyfpdb folder as the instructions say you need to have it inside that pyfpdb folder, ie. together with the .py files.

This depends on how histories are exported. I did a quick test using HM and unfortunately that does not restore the original format (it doesn't even seem to include the poker site's name..) so it will need a separate importer as if it were a new site. I don't know how PTO exports files, give it a go - if it doesn't work send me an exported history file. If you can include the original file for that export that would be nice too. I'll have a look at it, but I think most people will agree with me that expanding site support would be more useful than importing exported hands.
However, if PTO or PT2/3 export the file so it is formatted just like it was when it was originally imported then of course it'll just work in fpdb.

As of git82, which will hopefully become alpha4 tonight (see my last post), fpdb should fully support mysql and pgsql with one exception, the table viewer only runs with mysql. Since the HUD now covers almost all users I don't think there's much point in continuing to expand the table viewer's functionality. If you disagree let me know
For the stats, it is indeed quite LHE centric since that is what my housemates play. If you know your game quite well and it's not LHE pls send me a list of what stats will be useful - I won't give a timeframe for when these stats will become available, but it'll go into the todolist and be done evenually. Adding more stats to the HUD does require adding new fields to the cache table but that is not an issue and should not break things (but will require a reimport - PLEASE ALWAYS KEEP YOUR HISTORY FILES!). Donk bets are already on the list for example.

A quick note on reimports, in the next proper alpha (ie. not counting the emergency bugfix alpha4 which will merely allow using mysql without the pgsql-interface-library and vice-versa) I will be storing the raw hand history into the database to allow automated reimporting without a need for the original history files - nevertheless you should ALWAYS KEEP YOUR HISTORY FILES! (can't say this often enough ).

If anyone is aware of a (free software/open source) tool that can convert other site's history files to PS or FTP format, or even a tool that can convert multiple currently unsupported sites' formats into one common format please let me know and it'll greatly assist in expanding site support

Cheers, Steffen

I think you need to set:

db-backend=3

in your default.conf file to use PostgreSQL.
------------------------------------------------------------
db-backend=2

if you want to use MySQL

OK, this sounds like a new problem. You say you are seeing the window that says:
?? or whatever the table name is
But you are not seeing any stat windows.

Questions:

1. What operating system?
2. You are seeing this on more than one poker client window?
3. Do you see any error messages? You might need to start fpdb from a command line or select "run in a terminal" in Linux.
4. What else do you want to tell me?

What games are you playing? Think the hud is only setup by default for holdem if you use the example HUD_config.xml , I had to add in game types for omahahi and razz before the stats appeared.

This looks like the right answer. I prepared a new example config file that has all the games in it, but it looks like we dropped the hand off. I will send Steffen the new example config file.

Thanks for fielding my drop.

Yup that was it.. any hints on how to add omaha hi/lo and razz??

I just copied the holdem <game> section and changed game_name="holdem" to game_name="omahahi" and game_name="razz"

If you tried git82, pls try again with git83 (7dcf2d9) - I made a silly mistake trying to be clever and saving a line.
The new example config will also be in git84 (and alpha4), give me about 5 minutes.

CAn comeone send me a copy of the hud_config.xml file with a good configuration for omahahilo, holdem and razz?? Sorry for being a dumbass but i can't get it to work for omaha and razz...

Hi, you can find the one that was supposed to be in alpha3 here: http://trac-git.assembla.com/fpdb/br...ple?format=raw

Save it to HUD_config.xml and edit the database info (in particular the password) near the bottom of the file.
Remember that you can then save the current positions of the stat windows (ie. after you arranged them to your preference) simply by right clicking on the HUD window.

i ran into a weird problem here i'll try to explained as much as i can:

It seems that in order for the Hud to appear it has to do it before the auto_import process...

Let's say i leave the interval at 10 (default) and start auto-import, the main HUD window appear but the stats aren't. I can see in the command line:

HUD_main starting
Using db name = fpdb

Hands are importing fine by the way no error in the cmd window

then i closed the fpdb UI (hence stoppping the auto-import process) then TADAM stats appear (i reproduced it a couple time just to make sure...)

So i tried increasing the interval, just to see if the stats would appear before the auto-import process and turns out that if leave enough time for the stats to appear (which depend on the num of table you're playing) everything will works fine

example if i play 4 table i have to increase the interval to 90sec so that the stats appear

My setup is under windows xp, and i'm not using postgreSQL

i got to everything but the last step. i clicked the python program you told me to click and the cmd prompt looking thing came up for a second and then went away but nothing else happened after that. does anyone know how to fix this?

Start > Run > cmd

Go to the directory where fpdb is installed and type "python fpdb.py". It should give some kind of error message that should help you figure out what the problem is.

You don't really need to read this next paragraph.
I think I know what is going on here, I just don't know why. When fpdb starts the HUD, the HUD is a separate program and the two are connected by a pipe. A pipe is just an operating system thingie that lets the two programs communicate. When fpdb imports a hand it writes the hand number to the pipe, the HUD sees that hand number show up on the pipe and the HUD updates the stats based on that hand. Operating systems like to buffer output, that is, they save it up until they have enough to send and then send what they have saved. fpdb turns off buffering, so that the hand number gets sent immediately.

So it sounds like Windows is buffering the pipe output. So fpdb is busily importing hands, but nothing gets to the HUD until the buffer is full. That is why you see stats sooner when you have 4 tables open and why longer intervals seem to make it work--I think shorter intervals and waiting longer would have the same result. I suspect that you also see stats on all 4 tables at the same time, when they should pop up as the hands are finished.

So the question is: why is Windows buffering when I told it not to? I just looked at the code and buffering is indeed turned off in the alpha3 and alpha4 versions. I am stumped. I have run the same code on my windows xp box and have not seen anything like this.

How are you starting fpdb?
Are you running anything unusual that might be overriding pipe settings on a global basis?

When you run with a shorter interval your terminal output looks something like this:
When you run with a longer interval you get a whole bunch of these pairs:

Opened file /home/xxxx/Des ....
Total stored: 1 duplicates: 1 partial: 0 errors: 0

but the total stored is more than 1 probably

That should get you a usable error message. Thanks Pomtidom.

Did you restart windows after installing all the "stuff"?

Hi everyone,
I just released alpha4 on sourceforge. Please be sure to download alpha4, sometimes the sf mirrors can take a bit to update.

This version should now work if you only have the necessary SQL interface library (ie. mysql-python for MySQL backend, psycopg2 for PostgreSQL backend), though I have not been able to confirm this works with pgsql - please try and feedback
Additionally it now stores the maxSeats for FTP games, includes the HUD config that should've been in alpha3 and some other small things.

Any problems, use the usual contacts

Enjoy!

PS1: You do NOT need to reimport if you've been using alpha3. The only database difference is that it should now correctly store the maxSeats, which is only used by the HUD for determining how many stats windows to draw so it's only relevant for new hands.
PS2: "I have not been able to confirm this works with pgsql" means that I have not been able to try since my Gentoo's pgsql config tool appears to be angry with me. "we call it alpha for a reason", e.g. we only test it to a certain extent.
PS3: Alpha4 includes a Gentoo ebuild - pls try and feedback

The only thing i did was to connect to the database via JDBC with open office to do queries (stats and stuff) I'm using alpha 3 btw

while were on that if anyone knows how to connect to mySQL with ODBC via microsoft Access (to Link table you know...) i'd really appreciate the help

EDIT: btw i get exactly what you posted in the cmd line except for that little gtk message

http://img144.imageshack.us/my.php?image=cmdfpdbib0.jpg

A JDBC connection should not hurt anything.

Connecting Access to a MySQL db is not hard. You need to download the mysql odbc driver, which is named myODBC, or something similar. After you install that mysql will show up in your data sources thing. Then you just link tables in Access, as usual.

I have not forgotten about your buffer-filling problem. If I don't have a brainwave on that soon, I will boot in to windows and see if I can reproduce it.

First of all cheers on the project, it is very much appreciated.

My machine runs win xp with postgres. While installing fpdb I skipped all steps in the installation guide concerning mysql. On startup i get a strong warning "An invalid DB version or missing tables have been detected..."

in python console it says
when i try to recreate tables i get this

Hi Shininggg--

Are you still here? I have a replacement file for the fpdb_import.py file in the release. This might be a bit of a temporary fix and if you do see stats sooner I will be sure it is a buffering problem.

get the file here

Just replace the fpdb_import.py file in your ...\pyfpdb folder with that one.

Please let me know how it goes.

Everything is normal until you hit the traceback.

I think you need to create an empty database in postgres. Just open pgadmin and open your server. right click and choose new database. needs to have the same name, etc. as in your default.conf and HUD_config.xml.

If you already have a database named fpdb or whatever you chose to name it, then does it have any tables? and which tables?