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

04-18-2009 , 11:41 AM
Quote:
Originally Posted by ColdRock
I am from Russia and Windows is russian , PokerStars client and HH i switched to english. 0.11 i download from http://fpdb.****************/ and I do not know that such git repos, it is possible the link please?

you mean files of logs?

I hope all has correctly understood, excuse used online the translator
Hi ColdRock--

I have the log files you sent. The problem is not in the HUD. Your hand histories are not getting imported. There are at least 2 problems:

1. I think the file chooser is not correctly reading the path, possibly because of Cyrillic characters. Try moving your hand history folder to something like:
C:\HH\.

2. Some screen name may not be getting read properly. Could you send me a hand history file.
hand history file = "HH20090416 Circinus VI - ...Stud H/L.txt"

You can test by running bulk import.

Is there anyone else running fpdb on windows with Russian as the windows language?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-18-2009 , 01:05 PM
i send
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-18-2009 , 02:19 PM
Hi, sorry if this problem has been raised before, but I'm having trouble with the installation.

I have been following the installation instructions on the sourceforge documentation page.
I'm getting the following syntax error when trying to create the database.
Code:
mysql> CREATE DATABASE fpdb
    -> GRANT ALL PRIVILEGES ON fpdb.* TO 'fpdb'@'localhost' IDENTIFIED BY 'newPassword' WITH GRANT OPTION;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GRANT ALL PRIVILEGES ON fpdb.* TO 'fpdb'@'localhost' IDENTIFIED BY 'newPassword'' at line 2
Thanks for any help
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-18-2009 , 02:37 PM
Quote:
Originally Posted by j4mesmck
Code:
mysql> CREATE DATABASE fpdb;
    -> GRANT ALL PRIVILEGES ON fpdb.* TO 'fpdb'@'localhost' IDENTIFIED BY 'newPassword' WITH GRANT OPTION;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GRANT ALL PRIVILEGES ON fpdb.* TO 'fpdb'@'localhost' IDENTIFIED BY 'newPassword'' at line 2
need the ;
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-18-2009 , 03:17 PM
Quote:
Originally Posted by sorrow
need the ;

I can never spot my own mistakes, lol.
Cheers.

Ok, now when I try to run fpdb.py I get the following error message

Last edited by j4mesmck; 04-18-2009 at 03:28 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-18-2009 , 04:09 PM
Quote:
Originally Posted by j4mesmck

I can never spot my own mistakes, lol.
Cheers.

Ok, now when I try to run fpdb.py I get the following error message
Do you have python-mysqldb installed?

Last edited by uncooper; 04-18-2009 at 04:17 PM. Reason: python-mysqldb for linux, not py25-mysql
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-18-2009 , 04:28 PM
Quote:
Originally Posted by uncooper
Do you have python-mysqldb installed?
I've installed a MySQL-Python interface package now, which has got rid of that error message, thanks.

Now when I run fpdb.py I'm getting this:

Code:
No HUD_config.xml found, using HUD_config.xml.example.
A HUD_config.xml will be written.  You will probably have to edit it.Traceback (most recent call last):
  File "fpdb.py", line 465, in <module>
    me = fpdb()
  File "fpdb.py", line 377, in __init__
    self.load_profile()
  File "fpdb.py", line 269, in load_profile
    self.settings['db-password'])
  File "/home/James/fpdb/pyfpdb/fpdb_db.py", line 62, in connect
    self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database, use_unicode=True)
  File "/usr/lib64/python2.5/site-packages/MySQLdb/__init__.py", line 74, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib64/python2.5/site-packages/MySQLdb/connections.py", line 169, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'fpdb'@'localhost' (using password: YES)")
The installation documentation mentioned something about copying a .conf file to ~/.fpdb/profiles/default.conf, but I can't find this file.

EDIT::False alarm, got it working

Last edited by j4mesmck; 04-18-2009 at 04:45 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-18-2009 , 04:44 PM
Quote:
Originally Posted by j4mesmck
I've installed a MySQL-Python interface package now, which has got rid of that error message, thanks.

Now when I run fpdb.py I'm getting this:

Code:
No HUD_config.xml found, using HUD_config.xml.example.
A HUD_config.xml will be written.  You will probably have to edit it.Traceback (most recent call last):
  File "fpdb.py", line 465, in <module>
    me = fpdb()
  File "fpdb.py", line 377, in __init__
    self.load_profile()
  File "fpdb.py", line 269, in load_profile
    self.settings['db-password'])
  File "/home/James/fpdb/pyfpdb/fpdb_db.py", line 62, in connect
    self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database, use_unicode=True)
  File "/usr/lib64/python2.5/site-packages/MySQLdb/__init__.py", line 74, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib64/python2.5/site-packages/MySQLdb/connections.py", line 169, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'fpdb'@'localhost' (using password: YES)")
The installation documentation mentioned something about copying a .conf file to ~/.fpdb/profiles/default.conf, but I can't find this file.
http://fpdb.wiki.****************/Install+in+Ubuntu

All the way to the bottom, the section "Configuring fpdb".

You need to copy HUD_config.xml.example to HUD_config.xml and edit the parts relating to your database and user/pass information.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-18-2009 , 05:28 PM
Quote:
Originally Posted by uncooper
http://fpdb.wiki.****************/Install+in+Ubuntu

All the way to the bottom, the section "Configuring fpdb".

You need to copy HUD_config.xml.example to HUD_config.xml and edit the parts relating to your database and user/pass information.
OK, thanks, I've got it to run now, but the HUD doesn't seem to be working.

Do We need to edit the site_path= in the HUD_Config.xml to something like:

Code:
site_path="/home/James/.wine/drive_c/Program Files/PokerStars/"
Also, where does the HH_path= need to point to? <- EDIT: Fount it now

Thanks

EDIT:: Got the Hud working now

Last edited by j4mesmck; 04-18-2009 at 05:43 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-20-2009 , 12:10 PM
Hi i have been testing out fpdb for stud.

with the mucked cards display i try to look at previous hands but am unable to. It would be good if you could look at the previous hands, not just the first 3 cards if u know what I mean.

I think the display is cool just need to be able to see the previous hands.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-20-2009 , 05:53 PM
Quote:
Originally Posted by uncooper
I have the tracker working on OS X, if you have specific questions about the install instructions I should be able to help. Feel free to PM me.

@devs: As for HUD on Mac, I did read through the python docs that were linked earlier but I just don't have the background to easily get the window title and locations. I have someone who I'll talk to later today who may be able to help with that part.
PM sent!
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-22-2009 , 09:28 PM
I just tried to import some hh from bulk that were exported from PTStud. It gives me this error:

C:\Documents and Settings\Travis\Desktop\fpdb_0.11\pyfpdb\fpdb.py:2 41: DeprecationWarning: use gtk.UIManager
self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)
Traceback (most recent call last):
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.11\pyfpdb\GuiBulkIm port.py", line 75, in load_clicked
(stored, dups, partial, errs, ttime) = self.importer.runImport()
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.11\pyfpdb\fpdb_impo rt.py", line 159, in runImport
(stored, duplicates, partial, errors, ttime) = self.import_file_dict(file, self.filelist[file][0], self.filelist[file][1])
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.11\pyfpdb\fpdb_impo rt.py", line 231, in import_file_dict
(stored, duplicates, partial, errors, ttime) = self.import_fpdb_file(file, site)
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.11\pyfpdb\fpdb_impo rt.py", line 300, in import_fpdb_file
category = fpdb_simple.recogniseCategory(firstline)
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.11\pyfpdb\fpdb_simp le.py", line 1255, in recogniseCategory
raise FpdbError("failed to recognise category, line:"+line)
fpdb_simple.FpdbError: 'failed to recognise category, line:PokerStars Game #27200636177: RAZZ LIMIT ($3/$6) - 2009/04/17 17:36:14 ET'

Any Ideas?

Thanks,

Travis
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-22-2009 , 11:38 PM
Quote:
Originally Posted by RainmanTrail
...
fpdb_simple.FpdbError: 'failed to recognise category, line:PokerStars Game #27200636177: RAZZ LIMIT ($3/$6) - 2009/04/17 17:36:14 ET'
Here's the first line of one of my razz HHs:
PokerStars Game #27386457407: Razz Limit ($1/$2) - 2009/04/22 20:26:57 ET

Looks like the code that is trying to decode the first line of the HH is case sensitive. This might (or might not) be easy to fix--I'll take a look in the morning.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-23-2009 , 12:08 AM
Quote:
Originally Posted by Eratosthenes
Here's the first line of one of my razz HHs:
PokerStars Game #27386457407: Razz Limit ($1/$2) - 2009/04/22 20:26:57 ET

Looks like the code that is trying to decode the first line of the HH is case sensitive. This might (or might not) be easy to fix--I'll take a look in the morning.
Should be pretty easy to fix, but i'm curious - where did the HH come from?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-23-2009 , 04:55 AM
I am still experiencing the crashing problem with the mucked-cards display, but now I have seen the HUD crash with as few as six tables open. (Earlier on it worked with up to eight, I think.) When that happened I re-started the HUD; it promptly crashed again.

There is absolutely nothing relevant -- nothing remotely unusual -- in the output (and no X error) or in the error logs, which I won't quote here as I'm sure it would be a waste of time. It looks as if the HUD process simply terminates without reporting anything. Would a developer be interested in sprinkling the code with prints so that I can re-create the problem and submit the results?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-23-2009 , 06:57 PM
Quote:
Originally Posted by RainmanTrail
I just tried to import some hh from bulk that were exported from PTStud. It gives me this error:

fpdb_simple.FpdbError: 'failed to recognise category, line:PokerStars Game #27200636177: RAZZ LIMIT ($3/$6) - 2009/04/17 17:36:14 ET'
Sorrow is correct. The code is case sensitive, it is looking for Razz, not RAZZ.

The joys of open source, is you can look at the code. Simply open the file listed in the error message (fpdb_simple.py) with your favorite text editor (gvim), or for windows impaired (notepad)

If you got these files as an export from PStud, it looks like it changed the word. Try using the original files.

p.s. I have been importing stud hi hands without a problem.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-25-2009 , 12:10 AM
Hey guys, I don't speak python but was wondering about an idea of using a centralized server? Not for everyone to pour data into, but for the individual. I run a server here at home, I run linux on everything but of course I have to use MS for a program I use and any oddball poker sites. Other than lag time would there be any issues with this sort of setup?

I'm self taught so not really sure if I could provide much assistance, I've already got a lot of php scripts that would need cleaning up for others to use with this, but I remember previously reading we're trying to avoid forks etc.

Last thing, pretty sure I haven't seen this discussed for MS users. Its what I started on before I saw the light. http://www.uniformserver.com/
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-25-2009 , 02:20 AM
@Ramthebuffs:
Are you aware of running something like creating a network between a virtual machine running a windows client inside a linux host (using something like 2x application server) and thus having the windows applications running in the linux environment?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-25-2009 , 02:41 AM
yeah, I've got virtualbox running on a couple of my machines now. I'd rather the db be on my server tho. Then it would be 1 location I could hit from anywhere. Usually at home from a *nix or ms OS but if I'm out i'd rather it stay at home and not worry about moving a big db around etc.

I'm not really sure how I could install fpdb in my vbox and combine my db other than my original question tho.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-25-2009 , 02:52 AM
Quote:
Originally Posted by Ramthebuffs
yeah, I've got virtualbox running on a couple of my machines now. I'd rather the db be on my server tho. Then it would be 1 location I could hit from anywhere. Usually at home from a *nix or ms OS but if I'm out i'd rather it stay at home and not worry about moving a big db around etc.

I'm not really sure how I could install fpdb in my vbox and combine my db other than my original question tho.
If the db server has a public ip address then changing the line in HUD_Config.xml:
Code:
<database db_ip="localhost" ...
to
Code:
<database db_ip="x.x.x.x" ...
Where x.x.x.x is the ip address should work for you.

I've not done this myself, but i'm pretty sure one of the other devs uses this setup.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-25-2009 , 09:05 AM
Quote:
Originally Posted by sorrow
If the db server has a public ip address then changing the line in HUD_Config.xml:
Code:
<database db_ip="localhost" ...
to
Code:
<database db_ip="x.x.x.x" ...
Where x.x.x.x is the ip address should work for you.

I've not done this myself, but i'm pretty sure one of the other devs uses this setup.
My main fpdb db runs on a server. That server is a mythtv box (an open source PVR) that is a reasonably speedy dual core box and runs mysql to support Mythtv anyway. It is on 24x7 and has very little cpu usage, so it is a natural to hold my fpdb db.

You need to make the config change that sorrow suggested. The default configuration of mysql doesn't give any access to remote users. Give yourself access like this:
Code:
$ mysql -u root -p ROOTPASSWORD
mysql> grant all on fpdb.* to fpdb@"192.168.1.%" identified by "fpdb";
mysql> flush privileges;
mysql> quit
Needless to say, you'll need to adjust the network address, usernames, etc.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-27-2009 , 09:33 AM
I have been trying to use fpdb for tournaments. I am finding that it does not work in some tourneys. Especially freerolls, i have never got it to work for freerolls. that is ok though because freerolls don't really matter too much.

but i dont think i have got the new version to work in a regular tournament. The previous version did work. I get error number 1 in the tournaments.

I also get 'failed to read a single hand'.

It also says that it is a 'value error'.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-28-2009 , 05:20 PM
No matter what i do when i install ftdb this is the error i get, can anyone let me know how to fix this?
Sorry i should mention im running windows XP as well. I did a search on this forum for the answer for a while and couldnt find anything, reading whole thread now to see if i can find the answer before someone replies


Traceback (most recent call last):
File "C:\Documents and Settings\Owner\Desktop\fpdb_0.11\pyfpdb\fpdb.py", line 465, in <module>
me = fpdb()
File "C:\Documents and Settings\Owner\Desktop\fpdb_0.11\pyfpdb\fpdb.py", line 377, in __init__
self.load_profile()
File "C:\Documents and Settings\Owner\Desktop\fpdb_0.11\pyfpdb\fpdb.py", line 269, in load_profile
self.settings['db-password'])
File "C:\Documents and Settings\Owner\Desktop\fpdb_0.11\pyfpdb\fpdb_db.py ", line 62, in connect
self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database, use_unicode=True)
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: (1045, "Access denied for user 'fpdb'@'localhost' (using password: YES)")
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-28-2009 , 06:33 PM
I "used" to think I knew something about software and computers, but not after trying to install this. I went to the wiki and followed the instructions to the letter... (I think I've done it three times now) Nothing...

When I click on the fpdb.py file, it just attempts to pop up a black screen/box and nothing happens. I have installed postgress (before this for another program). I deleted all my old db's in postgress and set up a new one "fpdb".

I d'led all the python and installed it, and the other graphing files and installed them. I am totally frustrated and have now spent two days just trying to do the simple procedure of installing the program and getting it to open up.

I am running it on Vista. I have everything set to "run as administrator". No firewalls on, but my brain is to the point of burning the computer... this is driving me nuts. Where do I turn for some help to get this at least up and running. I see throughout this thread about copying this file and that file, and renaming this and that. How can a simple person with some computer knowledge get this going.

Thanks

Dog
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-29-2009 , 07:40 AM
studhand, and anyone else getting "access denied for user fpdb@localhost":

How to properly configure MySQL and FPDB:

http://fpdb.wiki.****************/Howto+Setup+MySQL

1meandog: i don't know how to setup postgres, but a few people have it working. If you do IRC, check out the freenode #fpdb chat channel
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m