Open Side Menu Go to the Top
Register
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

09-20-2008 , 01:52 PM
Any ideas as to when the install wizard is gonna be added? I'm not very computer savvy and i'm scared i might break something if i try to do a manual install. Also while i have your ears what rooms does this tracker support?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 03:39 PM
Quote:
Originally Posted by grumpy64
Any ideas as to when the install wizard is gonna be added? I'm not very computer savvy and i'm scared i might break something if i try to do a manual install. Also while i have your ears what rooms does this tracker support?
The installer is now being uploaded by Michael, he'll post when it's finished
We currently have full (meaning holdem, omaha, omaha/8, stud, stud/8 and razz in cash and SnG and MTT) support for PokerStars and cash games only for Full Tilt.

Edit: Support for draw games incl badugi is planned but as of yet not started.

Last edited by steffen123; 09-20-2008 at 03:40 PM. Reason: add draw comment
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 03:52 PM
Quote:
Originally Posted by steffen123
The installer is now being uploaded by Michael, he'll post when it's finished
We currently have full (meaning holdem, omaha, omaha/8, stud, stud/8 and razz in cash and SnG and MTT) support for PokerStars and cash games only for Full Tilt.

Edit: Support for draw games incl badugi is planned but as of yet not started.
Just to clarify this a bit. Full Tilt support is not working in the HUD. I will have that up in a few days.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 04:00 PM
ok i'm trying to gave the manual install an honest try but i'm stuck. When i install python then go back to the cmd screen it says no database selected.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 04:22 PM
@ALL

The first version of the fpdb environment installer is now available on the fpdb sourceforge download page. Easiest way to get there is:
1. Go to http://fpdb.sf.net
2. Click 'Downloads' in the navigation bar on the left side

This is the first version and it is not perfect. It is an installer only, no uninstaller yet.
It assumes that you have enough disc space on C:\ and whereever you put the installer after downloading it.
It checks if you have MySQL installed (specifically mysql.exe) to determine if it needs to be installed or not and right now it only looks in the standard MySQL installation directory which is %programfiles%\MySQL\MySQL Server 5.0\bin (on an English Windows this would be C:\Program Files\MySQL\MySQL Server 5.0\bin).
I'm not sure if this will work with Windows Vista but I'll check that out eventually.

I'll keep developing it so you can expect better versions over time.

Please post any problems you have with the installer. If I don't about something I can't fix it.

Last edited by One; 09-20-2008 at 04:39 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 05:16 PM
Quote:
Originally Posted by One
@ALL

The first version of the fpdb environment installer is now available on the fpdb sourceforge download page. Easiest way to get there is:
1. Go to http://fpdb.sf.net
2. Click 'Downloads' in the navigation bar on the left side

This is the first version and it is not perfect. It is an installer only, no uninstaller yet.
It assumes that you have enough disc space on C:\ and whereever you put the installer after downloading it.
It checks if you have MySQL installed (specifically mysql.exe) to determine if it needs to be installed or not and right now it only looks in the standard MySQL installation directory which is %programfiles%\MySQL\MySQL Server 5.0\bin (on an English Windows this would be C:\Program Files\MySQL\MySQL Server 5.0\bin).
I'm not sure if this will work with Windows Vista but I'll check that out eventually.

I'll keep developing it so you can expect better versions over time.

Please post any problems you have with the installer. If I don't about something I can't fix it.

Downloading now; I'll report my progress.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 05:32 PM
Installed.
Restarted.
Ran fpdb.py
Got a command window for a while but then nothing happened; said something about a global lock.
Now when I load, it just brings up the command screen and then goes away.

What now?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 05:50 PM
YoureToast,
which operating system are you using?
What's the location of your fpdb folder? (I can give you a line to start fpdb in a command line window which will not close. Then you will be able to post the whole error that fpdb reports.

Please check your path variable by doing this:
1. Right-click 'My Computer', then click properties
2. Then choose 'Advanced' and click on 'Environment Variables' button
3. In 'Uservariables' double click 'path' and check if the following is appended at the end: ;C:\gtk\bin;C:\Python25
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 06:02 PM
Quote:
Originally Posted by One
YoureToast,
which operating system are you using?
What's the location of your fpdb folder? (I can give you a line to start fpdb in a command line window which will not close. Then you will be able to post the whole error that fpdb reports.

Please check your path variable by doing this:
1. Right-click 'My Computer', then click properties
2. Then choose 'Advanced' and click on 'Environment Variables' button
3. In 'Uservariables' double click 'path' and check if the following is appended at the end: ;C:\gtk\bin;C:\Python25
XP
fpdb folder is in My Documents (I downloaded alpha4)
The items you mentioned aren't just appended; they're the only things there (which is odd isn't it). Also, that line starts with the semicolon. Is that correct?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 06:25 PM
Quote:
Originally Posted by YoureToast
Installed.
Restarted.
Ran fpdb.py
Got a command window for a while but then nothing happened; said something about a global lock.
Now when I load, it just brings up the command screen and then goes away.

What now?
I think you still need to edit your config files manually. There is a file named default.conf in the dir where fpdb.py is.

The critical lines in that file are:

Code:
db-backend=2 
db-host=localhost
db-databaseName=fpdb 
db-user=USER
db-password=PASSWORD
Where USER and PASSWORD are the username and password that you set up for mysql during the install process.

After you've edited that move it to your Application Data folder.

Then look at your HUD_config.xml file (same folder as fpdb). The database line is near the bottom.

Code:
<database db_ip="localhost" db_name="fpdb" db_pass="PASSWORD" db_server="mysql" db_type="fpdb" db_user="USER">    </database>
Make those changes. HUD_config.xml can stay in the dir with fpdb etc.

Now you should be able to start fpdb OK.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 06:33 PM
Quote:
Originally Posted by YoureToast
The items you mentioned aren't just appended; they're the only things there (which is odd isn't it). Also, that line starts with the semicolon. Is that correct?
The installer might have replaced your path instead of appending to it!

You have a backup path stored. It is in that same dialog box inside system, inside the control panel. You might want to save that in a safe place. Copy the backup and paste it in front of the stuff the installer "appended." Make sure there is a ; after the stuff you are pasting.

Starting the path line with a ; doesn't seem to hurt anything.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 06:35 PM
Quote:
Originally Posted by YoureToast
The items you mentioned aren't just appended; they're the only things there (which is odd isn't it).
Not too odd, I don't even have a $PATH in my user variables - and mine is an ancient XP installation with all manner of environments installed. Still I guess $PATH in user variables might work OK. For me I have everything in System variables $PATH.

Quote:
Also, that line starts with the semicolon. Is that correct?
Probably not. remove the leading semicolon, may fix it.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 06:41 PM
Quote:
Originally Posted by Eratosthenes
I think you still need to edit your config files manually. There is a file named default.conf in the dir where fpdb.py is.

The critical lines in that file are:

Code:
db-backend=2 
db-host=localhost
db-databaseName=fpdb 
db-user=USER
db-password=PASSWORD
Where USER and PASSWORD are the username and password that you set up for mysql during the install process.

After you've edited that move it to your Application Data folder.

Then look at your HUD_config.xml file (same folder as fpdb). The database line is near the bottom.

Code:
<database db_ip="localhost" db_name="fpdb" db_pass="PASSWORD" db_server="mysql" db_type="fpdb" db_user="USER">    </database>
Make those changes. HUD_config.xml can stay in the dir with fpdb etc.

Now you should be able to start fpdb OK.

Still not working:

Here is my config file after modifying (that should be done in the install):

Code:
db-backend=2
db-host=localhost
db-databaseName=fpdb
db-user=fpdb
db-password=z3636
imp-callFpdbHud=True
tv-combinedStealFold=True
tv-combined2B3B=True
tv-combinedPostflop=True
bulkImport-defaultPath=default
hud-defaultPath=default
But I have no idea whether database name of db-user are correct.

Also this came from the "docs" directory of the alpha4 directory. Is that correct?

When you you move to the App Data folder, I assume you mean the fpdb subdirectory of the App Data folder.

In any event, I've done all that and still not having luck.


The msg in the command prompt is: todo: implement obtain_global_lock and then is says "Opened and read profile file c:\app data....\fpdb\default.conf"

Also, there is no HUD_config.xml file, only a HUD_config.xml.example file
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 07:43 PM
Quote:
Originally Posted by One
@ALL

It checks if you have MySQL installed (specifically mysql.exe) to determine if it needs to be installed or not and right now it only looks in the standard MySQL installation directory which is %programfiles%\MySQL\MySQL Server 5.0\bin (on an English Windows this would be C:\Program Files\MySQL\MySQL Server 5.0\bin).
Does this mean this version does not support Postgresql?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 08:58 PM
I thought I had followed all the instructions, but I think I must have messed things up along the way. Correct me if I am wrong, but I should not see the "An invalid DB version..." info box after I created or recreated the tables, correct?

When I try to do that I get an internal error with the transaction aborted. (can't copy paste from that cmd window)

I think I have a bunch of configuration errors, and I don't really know what things should look like when they are running properly.

I am sure I will have HUD issues when I get that far, too, but one thing at a time

I am running XP and using postgresql.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 09:44 PM
Quote:
Originally Posted by fnord_too
I thought I had followed all the instructions, but I think I must have messed things up along the way. Correct me if I am wrong, but I should not see the "An invalid DB version..." info box after I created or recreated the tables, correct?

When I try to do that I get an internal error with the transaction aborted. (can't copy paste from that cmd window)
I always have the "invalid" popup, but it works OK after I click thru it.

You need manually create the tables for postgresql. There is a file "schema.postgres.sql" IIRC somewhere in the fpdb folders - find it.

Open pgAdmin, right click and create a new database. I just set the owner to postgres, left everything else default. I named it "fpdb"

then right click on the (empty) fpdb database, hit the SQL Query tool icon (like a pencil & pad, with "SQL" written - open the schema file and execute it.


Done with pgadmin, I edited the fpdb.conf so the dbformat(?) to 3 rather than 2, username postgres, dbname fpdb, and it seems to be working... early days yet tho, and I haven't been near the hud yet...
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 10:40 PM
Quote:
Originally Posted by YoureToast
Still not working:

Here is my config file after modifying (that should be done in the install):

Code:
db-backend=2
db-host=localhost
db-databaseName=fpdb
db-user=fpdb
db-password=z3636
imp-callFpdbHud=True
tv-combinedStealFold=True
tv-combined2B3B=True
tv-combinedPostflop=True
bulkImport-defaultPath=default
hud-defaultPath=default
But I have no idea whether database name of db-user are correct.
That default.conf looks ok to me. If you had wrong user or pw you would get this:

_mysql_exceptions.OperationalError: (1045, "Access denied for user 'mythtv'@'192.168.1.102' (using password: YES)")

or this:

_mysql_exceptions.OperationalError: (1045, "Access denied for user 'farts'@'192.168.1.102' (using password: YES)")

at the end of the traceback
Quote:

Also this came from the "docs" directory of the alpha4 directory. Is that correct?
yes
Quote:
When you you move to the App Data folder, I assume you mean the fpdb subdirectory of the App Data folder.
yes, and fpdb seems to be finding the default.conf OK
Quote:
In any event, I've done all that and still not having luck.


The msg in the command prompt is: todo: implement obtain_global_lock and then is says "Opened and read profile file c:\app data....\fpdb\default.conf"
This is normal. You should get an fpdb main window at that point. You don't get any more messages and the terminal window stays open? Did you start fpdb by double clicking on the fpdb icon?
Quote:
Also, there is no HUD_config.xml file, only a HUD_config.xml.example file
y, I should have said rename the HUD_config.xml and edit it.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 10:42 PM
Quote:
Originally Posted by GrindUnumb
Does this mean this version does not support Postgresql?
This release supports PostgreSQL ok. We thought that anybody that wanted to use PostgreSQL would already have it installed and configured, as well as having a running pgadmin.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 10:56 PM
Quote:
Originally Posted by _dave_
I always have the "invalid" popup, but it works OK after I click thru it.

You need manually create the tables for postgresql. There is a file "schema.postgres.sql" IIRC somewhere in the fpdb folders - find it.

Open pgAdmin, right click and create a new database. I just set the owner to postgres, left everything else default. I named it "fpdb"

then right click on the (empty) fpdb database, hit the SQL Query tool icon (like a pencil & pad, with "SQL" written - open the schema file and execute it.


Done with pgadmin, I edited the fpdb.conf so the dbformat(?) to 3 rather than 2, username postgres, dbname fpdb, and it seems to be working... early days yet tho, and I haven't been near the hud yet...
Yes, this is all good advice.

For now, if you use PostgreSQL, you must create a PostgreSQL database in pgadmin or using the command line thingie.

If you have not created a db, you get this error in the terminal window when you try to run fpdb:

_mysql_exceptions.OperationalError: (1044, "Access denied for user 'mythtv'@'192.168.1.102' to database 'fpdbfarts'")


When you see the "invalid" popup, you need to select the create or recreate tables item in the database menu. (or create them in pgadmin as _dave_ suggested--I have created them both ways and they worked OK)

If you have created a database, then fpdb should create tables just fine when you select the create or recreate tables menu item. But creating the tables in pgadmin should work fine, too.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 10:58 PM
Quote:
Originally Posted by fnord_too
When I try to do that I get an internal error with the transaction aborted. (can't copy paste from that cmd window)
Is everybody getting this when you try to create tables in a PostgreSQL database from the Database menu? That could be a problem.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-20-2008 , 11:36 PM
Quote:
Originally Posted by Eratosthenes
You should get an fpdb main window at that point. You don't get any more messages and the terminal window stays open? Did you start fpdb by double clicking on the fpdb icon?y, I should have said rename the HUD_config.xml and edit it.
No it doesnt stay open. It closes almost immediately. I opened it by double clicking fpdb.py from Windows Explorer.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-21-2008 , 12:01 AM
Quote:
Originally Posted by YoureToast
No it doesnt stay open. It closes almost immediately. I opened it by double clicking fpdb.py from Windows Explorer.
could you open fpdb from the command line and post the error message?

thanks
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-21-2008 , 12:11 AM
Quote:
Originally Posted by Eratosthenes
Is everybody getting this when you try to create tables in a PostgreSQL database from the Database menu? That could be a problem.
I think so yes, I seem to remember Steffen commenting on it some posts back, I know for certain I was already expecting it to not work for postgresql, but tried it anyhow just to see.

EDIT: I get the "no tables" popup regardless (I have a working fpdb database, with tables and hands imported). The create tables fails with "transaction error", no matter if there is an already created fpdb database present.

I haven't had time to check my postgresql logs and figure out problems yet, was just satisfied to import a file or two, I left it at hat until I have a good few hours set aside to mess with this python thing
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-21-2008 , 05:52 AM
C:\Documents and Settings\Giorgio.THEGIORGIO\Desktop\fpdb\pyfpdb>fp db.py
todo: implement obtain_global_lock
Opened and read profile file C:\Documents and Settings\Giorgio.THEGIORGIO\Application Data\fpdb\default.conf
Traceback (most recent call last):
File "C:\Documents and Settings\Giorgio.THEGIORGIO\Desktop\fpdb\pyfpdb\fp db.py", line 492, in <module>
me = fpdb()
File "C:\Documents and Settings\Giorgio.THEGIORGIO\Desktop\fpdb\pyfpdb\fp db.py
", line 405, in __init__
self.load_default_profile()
File "C:\Documents and Settings\Giorgio.THEGIORGIO\Desktop\fpdb\pyfpdb\fp db.py", line 246, in load_default_profile
self.load_profile(defaultpath)
File "C:\Documents and Settings\Giorgio.THEGIORGIO\Desktop\fpdb\pyfpdb\fp db.py", line 324, 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 "C:\Documents and Settings\Giorgio.THEGIORGIO\Desktop\fpdb\pyfpdb\fp db_db.py", line 40, in connect
self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database)
File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
return Connection(*args, **kwargs)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

Last edited by TheGiorgio; 09-21-2008 at 06:22 AM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-21-2008 , 07:14 AM
Quote:
Originally Posted by TheGiorgio
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")
Doesn't look like mysql is running, or the username/password/database combo in your default.conf file is wrong.(can't really tell because you've edited the output)
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m