Not quite accurate - We have a dev running fpdb with hud on everleaf, but hes using the p4e hh converter to convert everleaf hhs into stars hhs for import.

At least in theory any site with a hh converter for stars could probably be supported without too much effort.

I'm writing a native converter for fpdb at the moment that probably wont be ready for alpha10, but should be in alpha11. The converter being released then will probably be limited to nlhe cash games, with some support for other games following at a later date.

Just wanted to step in and say...

YOU SIR ARE MY HERO!

With open source we shall conquer the world

Is there a guide to installing FPDB with PostgreSQL?

Well I thought there was a postgres guide on the wiki, but I couldn't find it.

If you are using windows, use the new (as of about 10 min ago) environment installer. You want fpdbEnvInstaller0.2.exe. This will not install mysql, but will create a mysql database, if it detects mysql on your pc. If you are using linux, I am guessing you can install the dependencies OK.

You also need the fpdb python code.

Each can be downloaded here.

Now the postgres stuff.

1. Open pgAdmin and create a new database. Right click on the Databases icon in the tree view and select create database. Name it "fpdb" (without the damn quotes). Set the owner to whatever convenient user you have a password for. If you don't have a user set up, you can leave owner as "postgres" and use the root password later when you put the password in the config file. (using the root password is a pretty insecure practice, btw)
2. Edit your HUD_config.xml file. If you use windows, the installer has put it your C:\Documents and Settings\YOURNAME\Application Data\fpdb\ folder. This folder is hidden, so you'll have to select show hidden folders in its parent. Near the bottom of that file you should see a line that looks something like this:
   Code:

           <database db_name="fpdb"         db_server="mysql"      db_ip="localhost" db_user="fpdb"   db_pass="YOUR MYSQL PASSWORD"

   For postgres it needs to look like this:
   Code:

           <database db_ip="localhost" db_name="fpdb" db_pass="PASSWORD" db_server="postgresql" db_type="fpdb" db_user="USER">    </database>

   Where USER and PASSWORD are what you set up in pgAdmin a few minutes ago.

Windows Installer Updated

Hi all--

As i previously mentioned, I uploaded the new Windows environment installer last night. There is also a brief how-to in the wiki that corresponds to this installer. A few improvements worth mentioning are:

1. It does not try to install MySQL. Installing MySQL seemed to be the cause of a lot of problems later and many users prefer PostgreSQL. A link to the MySQL download page and to a installation how to is provided.
2. It writes a log file to the same folder and the configuration file. That should be:
   Code:

   c:\Documents and Settings\YOU\Application Data\

   The "Application Data" bit should be in your language.
3. If MySQL is detected it will create an fpdb database with proper permissions and write those permissions to the config file.
4. A usable config file (named HUD_config.xml) is written to the above folder. If the installer does not set up the MySQL database for you, then you will have to edit the config file to enter the correct database login parameters.
5. The installer will complain if neither MySQL nor PostgreSQL is detected, but will allow you to continue with the install, if you wish.

One side note: The installer asks for your MySQL root password--this is needed to create the fpdb database. The root password is not printed or stored. If you don't want the installer to set up the database, stop the MySQL service while you are doing the install (and restart it when you are finished).

The new installer seems to work fine, but I am trying to observe the forest with my nose stuck firmly into the bark of the nearest tree. So any feedback you have on this will be appreciated.

Installer here.

How to here.

Hey all, me again

Ok, so I had to reboot Ubuntu, as something went wrong with it, got the new ubuntu, did everything on the manual, and when I did the double-click fpdb thing at the end, I got three options: Run / Run in Terminal / Display

The first two did nothing, the final one showed text, have I missed something, previously I was able to bring a FPDB database up, but nothing much else.

Any help possible?

Your best option is to select "Run in Terminal". That way you will get some (possibly helpful) messages in the terminal window.

In this case you should have some messages in your fpdb-error-log.txt file. That should be in the same directory where fpdb.py is stored. What is there?

Ok checked the error log, this is what I got

/usr/lib/python2.5/site-packages/pytz/__init__.py:29: UserWarning: Module _mysql was already imported from /var/lib/python-support/python2.5/_mysql.so, but /var/lib/python-support/python2.5 is being added to sys.path
from pkg_resources import resource_stream
Traceback (most recent call last):
File "/home/perry/FPDB/fpdb-1.0_alpha9_p142/pyfpdb/fpdb.py", line 448, in <module>
me = fpdb()
File "/home/perry/FPDB/fpdb-1.0_alpha9_p142/pyfpdb/fpdb.py", line 361, in __init__
self.load_profile()
File "/home/perry/FPDB/fpdb-1.0_alpha9_p142/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 "/home/perry/FPDB/fpdb-1.0_alpha9_p142/pyfpdb/fpdb_db.py", line 43, in connect
self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database)
File "/var/lib/python-support/python2.5/MySQLdb/__init__.py", line 74, in Connect
return Connection(*args, **kwargs)
File "/var/lib/python-support/python2.5/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)")


???? I don't even know where to begin

Ok it turns out I got alpha 2 working, but how do I update it to the newer versions?

Go here and get alpha9. You can just copy it over the older version or just unzip it in a new directory and strart fpdb from there.

One thing. You probably edited ~/.fpdb/default.conf to get alpha2 running--adding the database parameters. default.conf is no longer used, all config info goes in HUD_config.xml. The alpha9 HUD_config.xml has a ton of new stuff in it. I think this is the best way to get a new config file:

1. After you download the new version, go to the pyfpdb directory and find the HUD_config.mxl.exmple file.
2. Copy that file to your ~/.fpdb directory and rename it HUD_config.xml
3. Open the file in your editor and change the database parameters to look something like this:
   Code:

    <database db_ip="localhost" db_name="fpdb" db_pass="PASSWORD" db_server="postgresql" db_type="fpdb" db_user="USER">    </database>

You might still get an error complaining about a missing library that we have added since alpha2 and that I have forgotten about, but that will be easy to fix.

Ok re-did everything now an error message comes up, and get this error in error log:

Traceback (most recent call last):
File "/home/perry/FPDB/fpdb-1.0_alpha9_p142/pyfpdb/fpdb.py", line 448, in <module>
me = fpdb()
File "/home/perry/FPDB/fpdb-1.0_alpha9_p142/pyfpdb/fpdb.py", line 361, in __init__
self.load_profile()
File "/home/perry/FPDB/fpdb-1.0_alpha9_p142/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 "/home/perry/FPDB/fpdb-1.0_alpha9_p142/pyfpdb/fpdb_db.py", line 42, in connect
import MySQLdb
ImportError: No module named MySQLdb

This is odd that alpha2 was OK and you got this particular error on alpha9, but let's press on:

Are you using mysql? If so you need to install MySQLdb. You do that with apt-get or synaptic or aptitude or whatever. In the gui, it is "Add/Remove Software" approximately.

If you are using postgres, you need another change to your HUD_config.xml file:

<database db_ip="localhost" db_name="fpdb" db_pass="PASSWORD" db_server="postgresql" db_type="fpdb" db_user="USER"> </database>

Has the hand analysis part been implemented yet? I am assuming this is still under development or have I downloaded a wrong version somewhere?

By hand analysis you mean the big gui front page of PT3, no not developed yet. There is some work being done on this, but it will be a while before that feature gets up to speed.

ETA for alpha10?

?

We are planning to release alpha10 for Dec 15.

I have seen evidence that the guys are actually working on importing Badugi hand histories (and other draw games). I don't know if they will have that ready for alpha10. It will only take me an hour or so to have the hud working for draw games after they have importing working.

Yes! 5 Crad Draw! Thank-you!!! You guys are the greatest!!!

FYP

Originally posted in response to the question how “good” the software currently is:

This is a little out of date, but it might be worth my elaborating on my experience with the HUD. These comments might be useful to people who are wondering how usable the software is. I’ve kept up to date with the Git repository, so my comments apply to the current version.

I use the HUD with MySQL, and installed it without problems (on Linux). (Note: One has to be careful to follow the instructions in the README.) I use it when playing NLHE cash games on Pokerstars (though not on any other site, since I don’t play on them) and find it extremely useful.

Even on my rather slow laptop (with its pretty miserable 512 Mb of memory) it doesn’t slow the game down. The load on the system when the HUD is running is quite reasonable. There were some posts of mine earlier complaining about excessive CPU usage, but this is all sorted out in the current version and these problems have vanished. Normally I play on eight tables; but a few days ago I decided to kill some time (and try an experiment) by playing a session of 20 micro-stakes tables and the HUD still ran smoothly.

As it happens, the minor problem I reported earlier that some of the statistics windows were occasionally appearing out of place has stopped occurring.

I have tried the opacity setting for the HUD windows as well. It works as advertised. I have switched it off again, however, as I don’t see a compelling need for it.

Can I ask what linux distro you are using? And do you know your current Xorg version, and what video drivers, and what Desktop Environment, and do you use a composting manager?

Ubuntu 8.04 / Xorg 1.4.1 / ATI driver / Xfce (with its compositor).

Since I have been using the HUD regularly for a while now, I have had a few ideas of features that might be worth adding to it. I’ll post these later when I have a bit more time.

Ubuntu 8.10, xorg 1.5, ati (open source not fglrx), GNOME, with compiz

ES - we'll be happy to have your suggestions.

For another reference, I have been testing on a Athlon 3200+ with 512 Meg, which is about 5.5 years old. My setup is Fedora 9 (fully patched), Xfce 4.4.2 + compositor, nvidia, and Xorg 1.5.2. I can run 10 stacked tables and never see a cpu utilization over about 35%. Gnome would not pop up the stacked tables correctly for me, but switching to Xfce fixed that.

Alpha10 will have a report breaking down stats by game type per site giving you bb/100 and a couple of other things.