HUD Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 - Page 42 - Poker Software -- Two Plus Two Poker Forums

To be honest, I would know how to initialize the database... I just followed the guide/tutorial/wiki.

Yes, I have edited the HUD_config.xml file and it's in the /home/ME/.fpdb directory

Quote

02-10-2009 , 06:41 AM

#1028

The Minder

newbie

Join Date: Feb 2009 Posts: 22

Quote:

Originally Posted by The Minder

To be honest, I would know how to initialize the database... I just followed the guide/tutorial/wiki.

Yes, I have edited the HUD_config.xml file and it's in the /home/ME/.fpdb directory

I tried to edit my post but it appears that option is not available... so I will post a corrected version:

To be honest, I would NOT know how to initialize the database... I just followed the guide/tutorial/wiki.

Yes, I have edited the HUD_config.xml file and it's in the /home/ME/.fpdb directory

Quote

02-10-2009 , 05:21 PM

#1029

xaiviax

grinder

Join Date: Jun 2008 Posts: 552

@TheMinder: when you run fpdb.py from a terminal, does the program start? (It's the middle layer window of this screenshot: http://fpdb.****************/img/fpdbScreenshot1.png )

What is the terminal output?

What are the contents of fpdb-error-log.txt and HUD-error.txt?

Quote

02-11-2009 , 12:29 AM

#1030

The Minder

newbie

Join Date: Feb 2009 Posts: 22

@ xaivaix:

Ok, running /home/me/fpdb/pyfpdb/fpdb.py in terminal yields a pop-up window saying:
"Fatal Error - SQL Interface Library Missing
Please note that the table viewer only works with mysgl, if your use postgresSQL this error msg is expected yada yada yada."

The terminal window shows:
"Note: error output is being diverted to fpdb-error-log.txt and HUD-error.txt. Any major error will be reported there _only_."

output of fpdb-error-log.txt is:
Traceback (most recent call last):
File "/home/wayne/fpdb/pyfpdb/fpdb.py", line 464, in <module>
me = fpdb()
File "/home/wayne/fpdb/pyfpdb/fpdb.py", line 377, in __init__
self.load_profile()
File "/home/wayne/fpdb/pyfpdb/fpdb.py", line 275, in load_profile
self.settings['db-password'])
File "/home/wayne/fpdb/pyfpdb/fpdb_db.py", line 64, in connect
import MySQLdb
ImportError: No module named MySQLdb

output of HUD-error.txt is:
HUD_main starting
Using db name = fpdb
No HUD_config.xml found, using HUD_config.xml.example.
A HUD_config.xml will be written. You will probably have to edit it.Unhandled exception in thread started by <function read_stdin at 0x839f3e4>
Traceback (most recent call last):
File "/home/wayne/fpdb/pyfpdb/HUD_main.py", line 114, in read_stdin
db_connection = Database.Database(config, db_name, 'temp')
File "/home/wayne/fpdb/pyfpdb/Database.py", line 56, in __init__
import MySQLdb
ImportError: No module named MySQLdb

Thank you for your patience.

Quote

02-11-2009 , 01:15 AM

#1031

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by The Minder

...
ImportError: No module named MySQLdb

It is asking for the mysql interface, which should have been installed by the windows installer. If you are trying to use mysql go here and download and install the mysqldb interface. You want the file that ends in py2.5.exe.

If you intend to use Postgres, then look in your HUD_config.xml file and change the mysql in this line

Code:

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

to postgresql.

Quote

02-11-2009 , 02:16 AM

#1032

The Minder

newbie

Join Date: Feb 2009 Posts: 22

Quote:

Originally Posted by Eratosthenes

Code:

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

to postgresql.

Ok, downloaded the mysql interface and attempted to install it under Wine. It complained that Python 2.5 was not on the system. Went and found Python 2.5, downloaded it and installed it under Wine... all ok. Re-installed the msql interface under Wine... all ok.

Attempted to run fpdb.py and got the same popup error msg about mysql/postgress and the following error in terminal:
"wayne@wayne-desktop:~/fpdb/pyfpdb$ python fpdb.py
Note: error output is being diverted to fpdb-error-log.txt and HUD-error.txt. Any major error will be reported there _only_.
Failed to load libs for graphing, graphing will not function. Please in
stall numpy and matplotlib if you want to use graphs.
This is of no consequence for other parts of the program, e.g. import
and HUD are NOT affected by this problem.
Reading configuration file /home/wayne/.fpdb/HUD_config.xml"

fpdb-error-log.txt and HUD-error.txt contain the same info as last time.

Quote

02-11-2009 , 03:26 AM

#1033

xaiviax

grinder

Join Date: Jun 2008 Posts: 552

@TheMinder: Ignore Eratosthenes reply to you. Pay close heed to all replies from him in the future.

@Eratosthenes: TheMinder is using Ubuntu. I believe you mistakingly thought he was on windows.

@TheMinder: I'm not sure how you have installed everything. The only thing you should have installed/running with wine are Pokerstars and/or Full Tilt. You haven't used the windows .exe installer, have you? Have you installed mysql, python, mysql-python, and pygtk with the ubuntu package manager? Have you gotten to the mysql> prompt in a terminal? Have you then succesfully followed this:

Now type this:
CREATE DATABASE fpdb;

Next you need to create a user. Type this (replacing newPassword with the password you want the fpdb user to have - this can, but for security shouldn't, be the same as the root mysql password):
GRANT ALL PRIVILEGES ON fpdb.* TO 'fpdb'@'localhost' IDENTIFIED BY 'newPassword' WITH GRANT OPTION;

Quote

02-11-2009 , 03:35 AM

#1034

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Quote:

Originally Posted by xaiviax

@TheMinder: Ignore Eratosthenes reply to you. Pay close heed to all replies from him in the future.

We aren't entirely sure he needs to do that - he says earlier that he managed to get through the install process on the wiki.

The packages you are looking for are (from memory)
python-mysqldb
python-matplotlib
python-numpy

For good value as it looks like we will eventually use it:
python-pypoker-eval

Quote

02-11-2009 , 09:56 AM

#1035

The Minder

newbie

Join Date: Feb 2009 Posts: 22

Quote:

Originally Posted by xaiviax

@TheMinder: Ignore Eratosthenes reply to you. Pay close heed to all replies from him in the future.

I tried the exact same procedure on my laptop computer, also running Ubuntu. The only exception was that I installed mysql, python, and pygtk though the synaptics (sic) package manager. Synaptics could not find mysql-python. When I tried to run fpdb.py I got EXACTLY the same error popups and messages as on my main system.

Yes, I can get a mysql prompt in terminal.
Yes, I could create the database.
Yes, I could grant the privileges

Quote

02-11-2009 , 10:01 AM

#1036

The Minder

newbie

Join Date: Feb 2009 Posts: 22

@sorrow
I'll try your suggestion tomorrow. Like you I'm in Perth and it's getting late here. Thanks for the suggestion.

Quote

02-11-2009 , 10:12 AM

#1037

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Quote:

Originally Posted by The Minder

@sorrow
I'll try your suggestion tomorrow. Like you I'm in Perth and it's getting late here. Thanks for the suggestion.

Heh - just got off a plane from Sydney.

sudo apt-get install python-mysqldb

from a console should do the trick. Synaptics should be able to find that one in ubuntu.

Quote

02-11-2009 , 10:23 AM

#1038

The Minder

newbie

Join Date: Feb 2009 Posts: 22

Quote:

Originally Posted by sorrow

Heh - just got off a plane from Sydney.

sudo apt-get install python-mysqldb

from a console should do the trick. Synaptics should be able to find that one in ubuntu.

Damn... ok, I'm still up. Installed everything you said and retried running fpdb.py. I didn't get the popup about postgress this time, but it still errored out.

tried to do the install of python-mysqldb and it says 'is already the newest version'

error logs:
fpdb-error-log.txt:
Traceback (most recent call last):
File "/home/wayne/Desktop/pyfpdb/Configuration.py", line 237, in __init__
doc = xml.dom.minidom.parse(file)
File "/usr/lib/python2.5/xml/dom/minidom.py", line 1915, in parse
return expatbuilder.parse(file)
File "/usr/lib/python2.5/xml/dom/expatbuilder.py", line 924, in parse
result = builder.parseFile(fp)
File "/usr/lib/python2.5/xml/dom/expatbuilder.py", line 207, in parseFile
parser.Parse(buffer, 0)
ExpatError: duplicate attribute: line 227, column 79

HUD-error.txt
HUD_main starting
Using db name = fpdb
Traceback (most recent call last):
File "/home/wayne/Desktop/pyfpdb/Configuration.py", line 237, in __init__
doc = xml.dom.minidom.parse(file)
File "/usr/lib/python2.5/xml/dom/minidom.py", line 1915, in parse
return expatbuilder.parse(file)
File "/usr/lib/python2.5/xml/dom/expatbuilder.py", line 924, in parse
result = builder.parseFile(fp)
File "/usr/lib/python2.5/xml/dom/expatbuilder.py", line 207, in parseFile
parser.Parse(buffer, 0)
ExpatError: duplicate attribute: line 227, column 79

Quote

02-11-2009 , 10:29 AM

#1039

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Quote:

Originally Posted by The Minder

Thats a problem with the format of the xml file. I'll suggest that you've accidentally deleted or added something to the file making it invalid xml.

You need to copy from the original and edit again, or fix the problem in the current file.

Quote

02-11-2009 , 10:32 AM

#1040

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Quote:

Originally Posted by No Ego Thanks

Have you considered to include EV statistics?

Of course - baby steps. We will of course accept patches.

Getting an open source hand eval library thats precompiled and releasable is probably going to be the biggest issue.

Quote

02-11-2009 , 10:37 AM

#1041

The Minder

newbie

Join Date: Feb 2009 Posts: 22

Quote:

Originally Posted by sorrow

Ok... deleted the old xml file and copied/modified a new version... the only thing I changed was the password in the 'supported databases' section (I think that's what the section was).

Still got some errors and will post tomorrow (something about an incorrect db version), but the fpdb program is up... will also play more tomorrow. Thanks mate... hope to see you at the tables.

Quote

02-11-2009 , 02:43 PM

#1042

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by xaiviax

@TheMinder: Ignore Eratosthenes reply to you. Pay close heed to all replies from him in the future.

@Eratosthenes: TheMinder is using Ubuntu. I believe you mistakingly thought he was on windows.

sorry! I see an installation problem and start babbling about Windows.

If one of you guys will post the exact package names for Ubuntu (or any other distro), I'll add them to the wiki page.

I think these are the generic names:
pyGTK - Gtk windowing system
matplotlib - 2d plotting library, optional, required for graphs
numpy - numeric computing library, optional, required for graphs

plus
mysql (need both client and server)
MySQLdb - mysql database interface
or
postgresql (pgadmin would be a good idea, too)
psycopg2 - postgresql database interface

pypoker-eval - not needed yet, but soon. Does anybody have experience using this on windows?

Quote

02-11-2009 , 04:58 PM

#1043

xaiviax

grinder

Join Date: Jun 2008 Posts: 552

Quote:

Originally Posted by The Minder

Still got some errors and will post tomorrow (something about an incorrect db version), but the fpdb program is up... will also play more tomorrow.

In Database Menu, select Create or Recreate Tables

Quote

02-11-2009 , 10:08 PM

#1044

sorrow

old hand

Join Date: Apr 2008 Posts: 1,531

Quote:

Originally Posted by Eratosthenes

If one of you guys will post the exact package names for Ubuntu (or any other distro), I'll add them to the wiki page.

Just added them to the Ubuntu install page.

Quote:

Originally Posted by Eratosthenes

pypoker-eval - not needed yet, but soon. Does anybody have experience using this on windows?

I did the research into this, there doesn't appear to be a precompiled release of this anywhere for windows. Most fo the hits I got were problems compiling in cygwin.

Its a stock package on Debian/Ubuntu and Fedora (so I assume most other distros)

Quote

02-11-2009 , 11:26 PM

#1045

The Minder

newbie

Join Date: Feb 2009 Posts: 22

@sorrow and @xaiviax
Thank you for your assistance last night. My fpdb HUD is up and working although only tested on FTP so far, but I am an optimist.

The graph function doesn't appear to be working but that may be due to a lack of data as I am starting from scratch with my HHs. I tried to find my HHs on my Windoze puter but HEM seems to have absconded with them.

@all windoze users.
Folks, you really do need to take the plunge and get into a Linux distro. HEM was my remaining holdout for retaining a Windoze box and now even that has gone. Linux is faster, more secure yadda yadda yadda.

@Stephen/developers
I know you folks have a lot on your plate but I'm going to add my 2c worth for a request or two. These may already be available, but I've read through this entire thread and didn't find anything pertinent.

First, I only want 3 things displayed in the HUD. VP, Aggression Factor and pre-flop raises. How do I configure fpdb to only display these elements.

Second, and this is a direct feed from HEM, I'd like to be able to set color ranges for the above items so that when a break point is reached the factor color changes. ie, red for a warning, orange for neutral and green for good/acceptable. Like they say, a visual cue is more readily accepted than straight data.

fpdb is a great program, you have my total support.

Cheers

Quote

02-12-2009 , 01:30 AM

#1046

ekdikeo

old hand

Join Date: Aug 2006 Posts: 1,364

The Minder:

Take a careful look through your HUD_config.xml file, and you should see how to change the stats displayed for each game type. I would recommend everyone add player name to the stats, as I showed in my examples a page or two back, but that's just me.

After using Linux and OS/2 pretty much exclusively since 1992, I switched to Windows in 2004. You guys can have all your superior stability, I'll take a system that I don't have to spend hours of every day monkeying with to keep it running and updated.

You can set a particular color for a particular stat, currently, but there's no way to do ranges with different colors, currently.

Quote

02-12-2009 , 01:37 AM

#1047

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by The Minder

First, I only want 3 things displayed in the HUD. VP, Aggression Factor and pre-flop raises. How do I configure fpdb to only display these elements.

That is pretty easy to do with the config file. You need to find the game element for the game you are playing. It probably looks like this:

Code:

        <game cols="3" db="fpdb" game_name="holdem" rows="2">
            <stat click="tog_decorate" col="0" popup="default" row="0" stat_name="vpip" tip="tip1"> </stat>
            <stat click="tog_decorate" col="1" popup="default" row="0" stat_name="pfr" tip="tip1"> </stat>
            <stat click="tog_decorate" col="2" popup="default" row="0" stat_name="ffreq_1" tip="tip1"> </stat>
            <stat click="tog_decorate" col="0" popup="default" row="1" stat_name="n" tip="tip1"> </stat>
            <stat click="tog_decorate" col="1" popup="default" row="1" stat_name="wtsd" tip="tip1"> </stat>
            <stat click="tog_decorate" col="2" popup="default" row="1" stat_name="wmsd" tip="tip1"> </stat>
        </game>

That is the default, and has the stats in a 3x2 grid. To change to a 3x1 grid change the

Code:

rows="2"

Code:

rows="1"

Now get rid of the stat elements where the row is "1" and it looks like this:

Code:

        <game cols="3" db="fpdb" game_name="holdem" rows="2">
            <stat click="tog_decorate" col="0" popup="default" row="0" stat_name="vpip" tip="tip1"> </stat>
            <stat click="tog_decorate" col="1" popup="default" row="0" stat_name="pfr" tip="tip1"> </stat>
            <stat click="tog_decorate" col="2" popup="default" row="0" stat_name="ffreq_1" tip="tip1"> </stat>
        </game>

Last change the "ffreq_1" to "a_freq_123" to make the 3rd stat be post flop aggression frequency.

Now your game element looks like this:

Code:

        <game cols="3" db="fpdb" game_name="holdem" rows="2">
            <stat click="tog_decorate" col="0" popup="default" row="0" stat_name="vpip" tip="tip1"> </stat>
            <stat click="tog_decorate" col="1" popup="default" row="0" stat_name="pfr" tip="tip1"> </stat>
            <stat click="tog_decorate" col="2" popup="default" row="0" stat_name="a_freq_123" tip="tip1"> </stat>
        </game>

You could have just copied/pasted that, but what would have been the fun in that? Don't forget to save. I don't remember why aggression factor isn't one of the available stats, I'll take a look later.

These are the currently available stats:

Code:

WMsF               Won $ when saw flop/4th.
a_freq_1           Flop/4th aggression frequency.
a_freq_123         Post-Flop aggression frequency.
a_freq_123_0       Post-Flop aggression frequency (no decimals).
a_freq_2           Turn/5th aggression frequency.
a_freq_3           River/6th aggression frequency.
a_freq_4           7th street aggression frequency.
cb_1               Flop continuation bet.
cb_2               Turn continuation bet.
cb_3               River continuation bet.
cb_4               7th street continuation bet.
f_BB_steal         Folded BB to steal.
f_SB_steal         Folded SB to steal.
ffreq_1            Flop/4th fold frequency.
ffreq_2            Turn/5th fold frequency.
ffreq_3            River/6th fold frequency.
ffreq_4            7th fold frequency.
fold_f             Folded flop/4th.
n                  Number of hands played.
pfr                Preflop (3rd street) raise.
pfr_0              Preflop (3rd street) raise (no decimals).
playername         Player Name.
profit100_0        Profit won per 100 hands (no decimal places).
saw_f              Saw flop/4th.
steal              Steal %.
three_B_0          Three bet preflop/3rd.
vpip               Voluntarily put $ in the pot.
vpip_0             Voluntarily put $ in the pot (no decimals).
wmsd               Won $ at showdown.
wtsd               Went to SD when saw flop/4th

some stats don't work for some games

Quote:

Second, and this is a direct feed from HEM, I'd like to be able to set color ranges for the above items so that when a break point is reached the factor color changes. ie, red for a warning, orange for neutral and green for good/acceptable. Like they say, a visual cue is more readily accepted than straight data.

I am designing a stat object that will give the user much more control about how each stat looks, so that a loose player could have a green vpip and a tight one a red vpip, with yellow in between (for example). I have been liberally using the ideas in this thread, plus some of my own. If people have bright ideas about what the stats in a HUD should look like, now would be a good time to tell me. That design has to coordinated with how it will be respresented in the config file and how a configuration gui will present it to the user. I have decided to be in no hurry on this, because I would like to get it right this time.

Quote

02-12-2009 , 01:59 AM

#1048

Eratosthenes

old hand

Join Date: Oct 2004 Posts: 1,535

Quote:

Originally Posted by ekdikeo

After using Linux and OS/2 pretty much exclusively since 1992, I switched to Windows in 2004. You guys can have all your superior stability, I'll take a system that I don't have to spend hours of every day monkeying with to keep it running and updated.

As you can see from this link, your closed-source, proprietary operating system is clearly doomed. You capitalist running dogs will soon be playing "The Internationale" on your Linux systems.

But seriously, I doubt that I spend an hour a month (0 hours most months, but every now and then...) monkeying with my configuration--I think the guys that do like to spend hours messing with their system are naturally drawn to Linux, but there are plenty of guys who waste untold hours reconfiguring their Windows systems, too. Typing "yum update" about once/week keeps OS and applications updated--I think that is far superior to the Windows system where the OS automatically updates itself and the apps are left on their own.

Quote

02-13-2009 , 04:00 AM

#1049

ekdikeo

old hand

Join Date: Aug 2006 Posts: 1,364

Before we de-rail this thread, lets call an end to the operating system argument.

Quote

02-14-2009 , 03:24 PM

#1050

mach2speedy

centurion

Join Date: Feb 2009 Posts: 138

hi, im new to 2+2 and i came across this thread, and i thought it was a gem, as it was exactly the program i was looking for. however i'm having troubles installing it (im a mac user) so as not to clutter up this threat, i have set up a thread here: http://forumserver.twoplustwo.com/69...7/#post8777826
where you guys could hopefully reply to, (it says a bit about what im trying to do, just starting off in the online poker world

Quote

Page 42 of 377

First

22 32 37 38 39 40 41 42 43 44 45 46 47 52 62 92 142 242

Last

Post Reply Subscribe

...

Page 42 of 377

First

22 32 37 38 39 40 41 42 43 44 45 46 47 52 62 92 142 242

Last