Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > > >

Notices

Free Software Discussion of Free / Freeware / Donationware / Open Source poker software and Free Graphics mods

Reply
 
Thread Tools Display Modes
Old 09-16-2008, 04:36 PM   #251
mattgoody
journeyman
 
Join Date: Oct 2006
Posts: 350
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

Quote:
Originally Posted by Eratosthenes View Post
You only need either MySQL or PostgreSQL installed. These are the actual database servers and are large downloads.

You do need both MySQLdb and psycopg2 installed. These are the python interfaces to the databases and are not big downloads or very painful to install. In the current release they both need to be installed. We need to do some surgery so that fpdb/HUD are only looking for the interfaces they actually need.
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?
mattgoody is offline   Reply With Quote
Old 09-16-2008, 04:57 PM   #252
Shininggg
newbie
 
Join Date: Oct 2007
Posts: 24
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

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

Last edited by Shininggg; 09-16-2008 at 05:06 PM.
Shininggg is offline   Reply With Quote
Old 09-16-2008, 04:57 PM   #253
steffen123
journeyman
 
Join Date: Aug 2008
Location: Manchester, UK
Posts: 251
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

Quote:
Originally Posted by Eratosthenes View Post
You do need both MySQLdb and psycopg2 installed. These are the python interfaces to the databases and are not big downloads or very painful to install. In the current release they both need to be installed. We need to do some surgery so that fpdb/HUD are only looking for the interfaces they actually need.
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.

Quote:
Originally Posted by sorrow View Post
New one - just copied HUD_config.example.xml to ~/fpdb and renamed
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.

Quote:
Originally Posted by fnord_too View Post
Ok, I am going to try to install this sometime this week. I just thought of another questions: Can you import from exported hand histories (e.g. exported from PTO) or just from the original files?
Quote:
Originally Posted by _dave_ View Post
Stars exports from PT2 etc. should be no more than a straight copy of the original HH text.
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.
steffen123 is offline   Reply With Quote
Old 09-16-2008, 05:01 PM   #254
steffen123
journeyman
 
Join Date: Aug 2008
Location: Manchester, UK
Posts: 251
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

Quote:
Originally Posted by fnord_too View Post
Postgresql is not supported yet, but MySQL is. (snip)
Do you support a wide range of statistics (e.g. fold to pf 3bet, fold to 4th street donk)? It looked like originally, the stats you could provide were somewhat limited, but that was more a function of getting something up and an LHE centric perspective.

Actually, that is the main question, because the others like supporting additional sites like Prima don't entail DB changes, so theoretically those additions should not have any real impact on the project (i.e. one would not have to break anything to add them). (snip)
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
steffen123 is offline   Reply With Quote
Old 09-16-2008, 05:17 PM   #255
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

Quote:
Originally Posted by mattgoody View Post
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?
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
Eratosthenes is offline   Reply With Quote
Old 09-16-2008, 05:32 PM   #256
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

Quote:
Originally Posted by Shininggg View Post
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..
OK, this sounds like a new problem. You say you are seeing the window that says:
Quote:
Close this window to kill the HUD for table Utopia IV.
?? 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?
Eratosthenes is offline   Reply With Quote
Old 09-16-2008, 06:01 PM   #257
daedal
centurion
 
Join Date: Jul 2007
Posts: 187
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

Quote:
Originally Posted by Shininggg View Post
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..
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.
daedal is offline   Reply With Quote
Old 09-16-2008, 06:08 PM   #258
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

Quote:
Originally Posted by daedal View Post
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.
Eratosthenes is offline   Reply With Quote
Old 09-16-2008, 06:34 PM   #259
Shininggg
newbie
 
Join Date: Oct 2007
Posts: 24
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

Quote:
Originally Posted by daedal View Post
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.
Yup that was it.. any hints on how to add omaha hi/lo and razz??
Shininggg is offline   Reply With Quote
Old 09-16-2008, 06:42 PM   #260
daedal
centurion
 
Join Date: Jul 2007
Posts: 187
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

I just copied the holdem <game> section and changed game_name="holdem" to game_name="omahahi" and game_name="razz"
daedal is offline   Reply With Quote
Old 09-16-2008, 07:39 PM   #261
steffen123
journeyman
 
Join Date: Aug 2008
Location: Manchester, UK
Posts: 251
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

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.
steffen123 is offline   Reply With Quote
Old 09-17-2008, 12:52 PM   #262
Shininggg
newbie
 
Join Date: Oct 2007
Posts: 24
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

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...
Shininggg is offline   Reply With Quote
Old 09-17-2008, 01:06 PM   #263
steffen123
journeyman
 
Join Date: Aug 2008
Location: Manchester, UK
Posts: 251
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

Quote:
Originally Posted by Shininggg View Post
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.
steffen123 is offline   Reply With Quote
Old 09-17-2008, 02:28 PM   #264
Shininggg
newbie
 
Join Date: Oct 2007
Posts: 24
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

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
Shininggg is offline   Reply With Quote
Old 09-17-2008, 02:51 PM   #265
CallMeLucid
old hand
 
CallMeLucid's Avatar
 
Join Date: Jul 2008
Location: Spewtarded
Posts: 1,825
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

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?
CallMeLucid is offline   Reply With Quote
Old 09-17-2008, 03:43 PM   #266
Pomtidom
grinder
 
Pomtidom's Avatar
 
Join Date: Sep 2006
Posts: 500
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

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.
Pomtidom is offline   Reply With Quote
Old 09-17-2008, 05:00 PM   #267
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

Quote:
Originally Posted by Shininggg View Post
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
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:
Code:
GuiAutoImport.import_dir done
HUD_main starting
Using db name =  fpdb
GuiAutoImport.import_dir done
GuiAutoImport.import_dir done
Opened file /home/xxxx/Desktop/xxxxxx/HH20080917 Dejopeja II no all-in - $0.50-$1 Ante $0.05 - Limit Razz.txt and connected to MySQL on 192.168.1.100
Total stored: 1 duplicates: 0 partial: 0 errors: 0
GuiAutoImport.import_dir done
GuiAutoImport.import_dir done
GuiAutoImport.import_dir done
GuiAutoImport.import_dir done
Opened file /home/xxxx/Desktop/xxxxx/HH20080917 Dejopeja II no all-in - $0.50-$1 Ante $0.05 - Limit Razz.txt and connected to MySQL on 192.168.1.100
Total stored: 1 duplicates: 1 partial: 0 errors: 0
GuiAutoImport.import_dir done
GuiAutoImport.import_dir done
GuiAutoImport.import_dir done
GuiAutoImport.import_dir done
GuiAutoImport.import_dir done
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
Eratosthenes is offline   Reply With Quote
Old 09-17-2008, 05:04 PM   #268
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

Quote:
Originally Posted by CallMeLucid View Post
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?
Quote:
Originally Posted by Pomtidom View Post
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.
That should get you a usable error message. Thanks Pomtidom.

Did you restart windows after installing all the "stuff"?
Eratosthenes is offline   Reply With Quote
Old 09-17-2008, 07:37 PM   #269
steffen123
journeyman
 
Join Date: Aug 2008
Location: Manchester, UK
Posts: 251
Re: New Free/open source poker tracking software: FPDB - (Alpha3 inc. HUD) - 16-Sept-

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!
steffen123 is offline   Reply With Quote
Old 09-17-2008, 08:29 PM   #270
steffen123
journeyman
 
Join Date: Aug 2008
Location: Manchester, UK
Posts: 251
Re: New Free/open source poker tracking software: FPDB - (Alpha4 inc. HUD) - 18-Sept-

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
steffen123 is offline   Reply With Quote
Old 09-17-2008, 08:46 PM   #271
Shininggg
newbie
 
Join Date: Oct 2007
Posts: 24
Re: New Free/open source poker tracking software: FPDB - (Alpha4 inc. HUD) - 18-Sept-

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



Last edited by Shininggg; 09-17-2008 at 09:09 PM.
Shininggg is offline   Reply With Quote
Old 09-17-2008, 09:14 PM   #272
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha4 inc. HUD) - 18-Sept-

Quote:
Originally Posted by Shininggg View Post
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
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.
Eratosthenes is offline   Reply With Quote
Old 09-18-2008, 10:07 AM   #273
sugoi
newbie
 
Join Date: Sep 2007
Posts: 25
Re: New Free/open source poker tracking software: FPDB - (Alpha4 inc. HUD) - 18-Sept-

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
Quote:
failed to read settings table - please recreate tables
C:\fpdb\pyfpdb\fpdb.py:227: DeprecationWarning: use gtk.UIManager
self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)
when i try to recreate tables i get this
Quote:
todo: implement obtain_global_lock
recreating tables in postgres db
Traceback (most recent call last):
File "C:\fpdb\pyfpdb\fpdb.py", line 189, in dia_recreate_tables
self.db.recreate_tables()
File "C:\fpdb\pyfpdb\fpdb_db.py", line 169, in recreate_tables
curse.execute(sql)
psycopg2.InternalError: current transaction is aborted, commands ignored until e
nd of transaction block
sugoi is offline   Reply With Quote
Old 09-18-2008, 12:29 PM   #274
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha4 inc. HUD) - 18-Sept-

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.
Eratosthenes is offline   Reply With Quote
Old 09-18-2008, 12:37 PM   #275
Eratosthenes
old hand
 
Join Date: Oct 2004
Posts: 1,535
Re: New Free/open source poker tracking software: FPDB - (Alpha4 inc. HUD) - 18-Sept-

Quote:
Originally Posted by sugoi View Post
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
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?
Eratosthenes is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Forum Jump


All times are GMT -4. The time now is 10:16 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © 2008-2010, Two Plus Two Interactive
 
Poker Players - Streaming Live Online