[HUD] Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013
opened with fpdb with python.exe, pythonw.exe and pythonicon.exe all result in nothing.
error:
2p2 censored my folder name lol
error:
Code:
Traceback (most recent call last): File "C:\Users\Ross\Desktop\Desktop\USE THIS ****ING ONE\pyfpdb\fpdb.py", line 465, in <module> me = fpdb() File "C:\Users\Ross\Desktop\Desktop\USE THIS ****ING ONE\pyfpdb\fpdb.py", line 377, in __init__ self.load_profile() File "C:\Users\Ross\Desktop\Desktop\USE THIS ****ING ONE\pyfpdb\fpdb.py", line 269, in load_profile self.settings['db-password']) File "C:\Users\Ross\Desktop\Desktop\USE THIS ****ING ONE\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)")
python.exe is the correct .exe to open it with.
If the same error regenerates - the MySQL username/password are wrong in the config.
Sorrow, if you recall I had the same problem. You gave me this link at the time and we ended up getting the password to reset. Is this still valid as far as the instructions? This is directly from the MySQL site.
http://dev.mysql.com/doc/refman/5.0/...rmissions.html
Dog
http://dev.mysql.com/doc/refman/5.0/...rmissions.html
Dog
Sorrow, if you recall I had the same problem. You gave me this link at the time and we ended up getting the password to reset. Is this still valid as far as the instructions? This is directly from the MySQL site.
http://dev.mysql.com/doc/refman/5.0/...rmissions.html
Dog
http://dev.mysql.com/doc/refman/5.0/...rmissions.html
Dog
dlsadfoiacvxcpvzvvvvvvvvvvvvvovv
****kkkkkkkkkkkkkkkkkkkkkkkkkk
after i did this
****kkkkkkkkkkkkkkkkkkkkkkkkkk
Code:
Traceback (most recent call last): File "C:\Users\Ross\Desktop\Desktop\USE THIS ****ING ONE\pyfpdb\fpdb.py", line 465, in <module> me = fpdb() File "C:\Users\Ross\Desktop\Desktop\USE THIS ****ING ONE\pyfpdb\fpdb.py", line 376, in __init__ self.config = Configuration.Config(dbname=options.dbname) File "C:\Users\Ross\Desktop\Desktop\USE THIS ****ING ONE\pyfpdb\Configuration.py", line 315, in __init__ db = self.get_db_parameters() File "C:\Users\Ross\Desktop\Desktop\USE THIS ****ING ONE\pyfpdb\Configuration.py", line 476, in get_db_parameters if string.lower(self.supported_databases[name].db_server) == 'mysql': KeyError: 'fpdb'
Code:
class Database: def __init__(self, node): self.db_name = node.getAttribute("fpdb") self.db_server = node.getAttribute("mysql") self.db_ip = node.getAttribute("local host") self.db_user = node.getAttribute("fpdb") self.db_type = node.getAttribute("sql") self.db_pass = node.getAttribute("ihadmypswrdhere")
dlsadfoiacvxcpvzvvvvvvvvvvvvvovv
****kkkkkkkkkkkkkkkkkkkkkkkkkk
after i did this
****kkkkkkkkkkkkkkkkkkkkkkkkkk
Code:
Traceback (most recent call last): File "C:\Users\Ross\Desktop\Desktop\USE THIS ****ING ONE\pyfpdb\fpdb.py", line 465, in <module> me = fpdb() File "C:\Users\Ross\Desktop\Desktop\USE THIS ****ING ONE\pyfpdb\fpdb.py", line 376, in __init__ self.config = Configuration.Config(dbname=options.dbname) File "C:\Users\Ross\Desktop\Desktop\USE THIS ****ING ONE\pyfpdb\Configuration.py", line 315, in __init__ db = self.get_db_parameters() File "C:\Users\Ross\Desktop\Desktop\USE THIS ****ING ONE\pyfpdb\Configuration.py", line 476, in get_db_parameters if string.lower(self.supported_databases[name].db_server) == 'mysql': KeyError: 'fpdb'
Code:
class Database: def __init__(self, node): self.db_name = node.getAttribute("fpdb") self.db_server = node.getAttribute("mysql") self.db_ip = node.getAttribute("local host") self.db_user = node.getAttribute("fpdb") self.db_type = node.getAttribute("sql") self.db_pass = node.getAttribute("ihadmypswrdhere")
class Database:
def __init__(self, node):
self.db_name = "fpdb"
self.db_server = "mysql"
self.db_ip = local host"
self.db_user = "fpdb"
self.db_type = "fpdb"
self.db_pass = "ihadmypswrdhere"
def __init__(self, node):
self.db_name = "fpdb"
self.db_server = "mysql"
self.db_ip = local host"
self.db_user = "fpdb"
self.db_type = "fpdb"
self.db_pass = "ihadmypswrdhere"
<supported_databases>
<database db_ip="localhost" db_name="fpdb-y" db_pass="yourPassword" db_server="mysql" db_type="fpdb" db_user="fpdb"> </database>
</supported_databases>
<database db_ip="localhost" db_name="fpdb-y" db_pass="yourPassword" db_server="mysql" db_type="fpdb" db_user="fpdb"> </database>
</supported_databases>
I can't import Full Tilt hands gyus, i'm using 0.11.3 version.
fpdb-error-log after i tried to bulk import some handhistory files.
In the console i get the DEBUG: import_fpdb_file: failed on self.lines[0]: ... error.
fpdb-error-log after i tried to bulk import some handhistory files.
Code:
/usr/lib/python2.6/site-packages/MySQLdb/__init__.py:34: DeprecationWarning: the sets module is deprecated from sets import ImmutableSet ./fpdb.py:241: DeprecationWarning: use gtk.UIManager self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group) Traceback (most recent call last): File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/GuiBulkImport.py", line 75, in load_clicked (stored, dups, partial, errs, ttime) = self.importer.runImport() File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 162, in runImport (stored, duplicates, partial, errors, ttime) = self.import_file_dict(file, self.filelist[file][0], self.filelist[file][1]) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 234, in import_file_dict (stored, duplicates, partial, errors, ttime) = self.import_fpdb_file(file, site) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 302, in import_fpdb_file site = fpdb_simple.recogniseSite(firstline) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_simple.py", line 1481, in recogniseSite raise FpdbError("failed to recognise site, line:"+line) fpdb_simple.FpdbError: 'failed to recognise site, line:\xff\xfeF\x00u\x00l\x00l\x00 \x00T\x00i\x00l\x00t\x00 \x00P\x00o\x00k\x00e\x00r\x00 \x00G\x00a\x00m\x00e\x00 \x00#\x001\x003\x008\x008\x001\x005\x009\x004\x004\x009\x002\x00:\x00 \x00T\x00a\x00b\x00l\x00e\x00 \x00C\x00u\x00s\x00t\x00e\x00r\x00 \x00(\x00d\x00e\x00e\x00p\x00)\x00 \x00-\x00 \x00$\x000\x00.\x002\x005\x00/\x00$\x000\x00.\x005\x000\x00 \x00-\x00 \x00N\x00o\x00 \x00L\x00i\x00m\x00i\x00t\x00 \x00O\x00m\x00a\x00h\x00a\x00 \x00H\x00/\x00L\x00 \x00-\x00 \x001\x007\x00:\x004\x007\x00:\x002\x005\x00 \x00E\x00T\x00 \x00-\x00 \x002\x000\x000\x009\x00/\x000\x008\x00/\x000\x007\x00' Traceback (most recent call last): File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/GuiBulkImport.py", line 75, in load_clicked (stored, dups, partial, errs, ttime) = self.importer.runImport() File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 162, in runImport (stored, duplicates, partial, errors, ttime) = self.import_file_dict(file, self.filelist[file][0], self.filelist[file][1]) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 234, in import_file_dict (stored, duplicates, partial, errors, ttime) = self.import_fpdb_file(file, site) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 302, in import_fpdb_file site = fpdb_simple.recogniseSite(firstline) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_simple.py", line 1481, in recogniseSite raise FpdbError("failed to recognise site, line:"+line) fpdb_simple.FpdbError: 'failed to recognise site, line:\xff\xfeF\x00u\x00l\x00l\x00 \x00T\x00i\x00l\x00t\x00 \x00P\x00o\x00k\x00e\x00r\x00 \x00G\x00a\x00m\x00e\x00 \x00#\x001\x003\x008\x007\x008\x006\x001\x004\x002\x002\x003\x00:\x00 \x00T\x00a\x00b\x00l\x00e\x00 \x00S\x00o\x00m\x00e\x00r\x00s\x00e\x00t\x00 \x00H\x00i\x00l\x00l\x00s\x00 \x00-\x00 \x00$\x000\x00.\x002\x005\x00/\x00$\x000\x00.\x005\x000\x00 \x00-\x00 \x00N\x00o\x00 \x00L\x00i\x00m\x00i\x00t\x00 \x00O\x00m\x00a\x00h\x00a\x00 \x00H\x00/\x00L\x00 \x00-\x00 \x001\x005\x00:\x000\x009\x00:\x000\x009\x00 \x00E\x00T\x00 \x00-\x00 \x002\x000\x000\x009\x00/\x000\x008\x00/\x000\x007\x00' Traceback (most recent call last): File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/GuiBulkImport.py", line 75, in load_clicked (stored, dups, partial, errs, ttime) = self.importer.runImport() File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 162, in runImport (stored, duplicates, partial, errors, ttime) = self.import_file_dict(file, self.filelist[file][0], self.filelist[file][1]) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 234, in import_file_dict (stored, duplicates, partial, errors, ttime) = self.import_fpdb_file(file, site) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 302, in import_fpdb_file site = fpdb_simple.recogniseSite(firstline) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_simple.py", line 1481, in recogniseSite raise FpdbError("failed to recognise site, line:"+line) fpdb_simple.FpdbError: 'failed to recognise site, line:\xff\xfeF\x00u\x00l\x00l\x00 \x00T\x00i\x00l\x00t\x00 \x00P\x00o\x00k\x00e\x00r\x00 \x00G\x00a\x00m\x00e\x00 \x00#\x001\x003\x008\x007\x009\x005\x007\x008\x005\x000\x008\x00:\x00 \x00T\x00a\x00b\x00l\x00e\x00 \x00V\x00i\x00s\x00t\x00a\x00 \x00R\x00u\x00n\x00 \x00-\x00 \x00$\x000\x00.\x002\x005\x00/\x00$\x000\x00.\x005\x000\x00 \x00-\x00 \x00P\x00o\x00t\x00 \x00L\x00i\x00m\x00i\x00t\x00 \x00O\x00m\x00a\x00h\x00a\x00 \x00H\x00/\x00L\x00 \x00-\x00 \x001\x006\x00:\x000\x002\x00:\x005\x007\x00 \x00E\x00T\x00 \x00-\x00 \x002\x000\x000\x009\x00/\x000\x008\x00/\x000\x007\x00' Traceback (most recent call last): File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/GuiBulkImport.py", line 75, in load_clicked (stored, dups, partial, errs, ttime) = self.importer.runImport() File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 162, in runImport (stored, duplicates, partial, errors, ttime) = self.import_file_dict(file, self.filelist[file][0], self.filelist[file][1]) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 234, in import_file_dict (stored, duplicates, partial, errors, ttime) = self.import_fpdb_file(file, site) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 302, in import_fpdb_file site = fpdb_simple.recogniseSite(firstline) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_simple.py", line 1481, in recogniseSite raise FpdbError("failed to recognise site, line:"+line) fpdb_simple.FpdbError: 'failed to recognise site, line:\xff\xfeF\x00u\x00l\x00l\x00 \x00T\x00i\x00l\x00t\x00 \x00P\x00o\x00k\x00e\x00r\x00 \x00G\x00a\x00m\x00e\x00 \x00#\x001\x003\x009\x004\x006\x003\x006\x001\x004\x004\x000\x00:\x00 \x00T\x00a\x00b\x00l\x00e\x00 \x00H\x00e\x00a\x00t\x00h\x00e\x00r\x00 \x00G\x00r\x00o\x00v\x00e\x00 \x00-\x00 \x00$\x000\x00.\x002\x005\x00/\x00$\x000\x00.\x005\x000\x00 \x00-\x00 \x00P\x00o\x00t\x00 \x00L\x00i\x00m\x00i\x00t\x00 \x00O\x00m\x00a\x00h\x00a\x00 \x00H\x00/\x00L\x00 \x00-\x00 \x001\x007\x00:\x002\x002\x00:\x000\x007\x00 \x00E\x00T\x00 \x00-\x00 \x002\x000\x000\x009\x00/\x000\x008\x00/\x001\x000\x00'
In the console i get the DEBUG: import_fpdb_file: failed on self.lines[0]: ... error.
I had the same issue but not on every file : the older ones are OK.
I think it has something to do with Full Tilt changing the encoding of its HH files (ascii before, utf now).
I made a little change in the source code in order to correct that (not very pretty since I had to convert the uft files to a tmp ascii file, couldn't get to convert "on the fly").
I'm also thinking of coding some sort of tournament info import (the one that goes behind the ouput "import tournament summary : TO DO"), but I have two issues about that :
- I'm pretty new to Python (actually started it looking at the code of fpdb )
- I don't know how to interact with the authors of that program (if they can hear me and answer .... it'd be very kind !!)
For now, I'm thinking about some changes in the DB Model (adding some columns in the Tourney tables to identify such things as Matrix Tournament, BlindsIncreaseSpeed, etc ...).
I'll try and post the changes I made to workaround the encoding issue later when I get home.
Peas.
I think it has something to do with Full Tilt changing the encoding of its HH files (ascii before, utf now).
I made a little change in the source code in order to correct that (not very pretty since I had to convert the uft files to a tmp ascii file, couldn't get to convert "on the fly").
I'm also thinking of coding some sort of tournament info import (the one that goes behind the ouput "import tournament summary : TO DO"), but I have two issues about that :
- I'm pretty new to Python (actually started it looking at the code of fpdb )
- I don't know how to interact with the authors of that program (if they can hear me and answer .... it'd be very kind !!)
For now, I'm thinking about some changes in the DB Model (adding some columns in the Tourney tables to identify such things as Matrix Tournament, BlindsIncreaseSpeed, etc ...).
I'll try and post the changes I made to workaround the encoding issue later when I get home.
Peas.
I had the same issue but not on every file : the older ones are OK.
I think it has something to do with Full Tilt changing the encoding of its HH files (ascii before, utf now).
I made a little change in the source code in order to correct that (not very pretty since I had to convert the uft files to a tmp ascii file, couldn't get to convert "on the fly").
I'm also thinking of coding some sort of tournament info import (the one that goes behind the ouput "import tournament summary : TO DO"), but I have two issues about that :
- I'm pretty new to Python (actually started it looking at the code of fpdb )
- I don't know how to interact with the authors of that program (if they can hear me and answer .... it'd be very kind !!)
For now, I'm thinking about some changes in the DB Model (adding some columns in the Tourney tables to identify such things as Matrix Tournament, BlindsIncreaseSpeed, etc ...).
I'll try and post the changes I made to workaround the encoding issue later when I get home.
Peas.
I think it has something to do with Full Tilt changing the encoding of its HH files (ascii before, utf now).
I made a little change in the source code in order to correct that (not very pretty since I had to convert the uft files to a tmp ascii file, couldn't get to convert "on the fly").
I'm also thinking of coding some sort of tournament info import (the one that goes behind the ouput "import tournament summary : TO DO"), but I have two issues about that :
- I'm pretty new to Python (actually started it looking at the code of fpdb )
- I don't know how to interact with the authors of that program (if they can hear me and answer .... it'd be very kind !!)
For now, I'm thinking about some changes in the DB Model (adding some columns in the Tourney tables to identify such things as Matrix Tournament, BlindsIncreaseSpeed, etc ...).
I'll try and post the changes I made to workaround the encoding issue later when I get home.
Peas.
Adding some more info re tournaments is a good idea and so is importing the tournament summary.
I think we will be trying to nail down the next iteration of the database schema soon. To that end, I've put the schema in the wiki. I have started adding some questions and comments to the discussion page behind the pages for the tables.
New contributors are welcome. Don't worry about being new to python, it is pretty quick to learn and you tell tell from our code that we aren't python experts either.
I can't import Full Tilt hands gyus, i'm using 0.11.3 version.
fpdb-error-log after i tried to bulk import some handhistory files.
In the console i get the DEBUG: import_fpdb_file: failed on self.lines[0]: ... error.
fpdb-error-log after i tried to bulk import some handhistory files.
Code:
/usr/lib/python2.6/site-packages/MySQLdb/__init__.py:34: DeprecationWarning: the sets module is deprecated from sets import ImmutableSet ./fpdb.py:241: DeprecationWarning: use gtk.UIManager self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group) Traceback (most recent call last): File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/GuiBulkImport.py", line 75, in load_clicked (stored, dups, partial, errs, ttime) = self.importer.runImport() File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 162, in runImport (stored, duplicates, partial, errors, ttime) = self.import_file_dict(file, self.filelist[file][0], self.filelist[file][1]) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 234, in import_file_dict (stored, duplicates, partial, errors, ttime) = self.import_fpdb_file(file, site) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 302, in import_fpdb_file site = fpdb_simple.recogniseSite(firstline) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_simple.py", line 1481, in recogniseSite raise FpdbError("failed to recognise site, line:"+line) fpdb_simple.FpdbError: 'failed to recognise site, line:\xff\xfeF\x00u\x00l\x00l\x00 \x00T\x00i\x00l\x00t\x00 \x00P\x00o\x00k\x00e\x00r\x00 \x00G\x00a\x00m\x00e\x00 \x00#\x001\x003\x008\x008\x001\x005\x009\x004\x004\x009\x002\x00:\x00 \x00T\x00a\x00b\x00l\x00e\x00 \x00C\x00u\x00s\x00t\x00e\x00r\x00 \x00(\x00d\x00e\x00e\x00p\x00)\x00 \x00-\x00 \x00$\x000\x00.\x002\x005\x00/\x00$\x000\x00.\x005\x000\x00 \x00-\x00 \x00N\x00o\x00 \x00L\x00i\x00m\x00i\x00t\x00 \x00O\x00m\x00a\x00h\x00a\x00 \x00H\x00/\x00L\x00 \x00-\x00 \x001\x007\x00:\x004\x007\x00:\x002\x005\x00 \x00E\x00T\x00 \x00-\x00 \x002\x000\x000\x009\x00/\x000\x008\x00/\x000\x007\x00' Traceback (most recent call last): File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/GuiBulkImport.py", line 75, in load_clicked (stored, dups, partial, errs, ttime) = self.importer.runImport() File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 162, in runImport (stored, duplicates, partial, errors, ttime) = self.import_file_dict(file, self.filelist[file][0], self.filelist[file][1]) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 234, in import_file_dict (stored, duplicates, partial, errors, ttime) = self.import_fpdb_file(file, site) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 302, in import_fpdb_file site = fpdb_simple.recogniseSite(firstline) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_simple.py", line 1481, in recogniseSite raise FpdbError("failed to recognise site, line:"+line) fpdb_simple.FpdbError: 'failed to recognise site, line:\xff\xfeF\x00u\x00l\x00l\x00 \x00T\x00i\x00l\x00t\x00 \x00P\x00o\x00k\x00e\x00r\x00 \x00G\x00a\x00m\x00e\x00 \x00#\x001\x003\x008\x007\x008\x006\x001\x004\x002\x002\x003\x00:\x00 \x00T\x00a\x00b\x00l\x00e\x00 \x00S\x00o\x00m\x00e\x00r\x00s\x00e\x00t\x00 \x00H\x00i\x00l\x00l\x00s\x00 \x00-\x00 \x00$\x000\x00.\x002\x005\x00/\x00$\x000\x00.\x005\x000\x00 \x00-\x00 \x00N\x00o\x00 \x00L\x00i\x00m\x00i\x00t\x00 \x00O\x00m\x00a\x00h\x00a\x00 \x00H\x00/\x00L\x00 \x00-\x00 \x001\x005\x00:\x000\x009\x00:\x000\x009\x00 \x00E\x00T\x00 \x00-\x00 \x002\x000\x000\x009\x00/\x000\x008\x00/\x000\x007\x00' Traceback (most recent call last): File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/GuiBulkImport.py", line 75, in load_clicked (stored, dups, partial, errs, ttime) = self.importer.runImport() File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 162, in runImport (stored, duplicates, partial, errors, ttime) = self.import_file_dict(file, self.filelist[file][0], self.filelist[file][1]) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 234, in import_file_dict (stored, duplicates, partial, errors, ttime) = self.import_fpdb_file(file, site) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 302, in import_fpdb_file site = fpdb_simple.recogniseSite(firstline) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_simple.py", line 1481, in recogniseSite raise FpdbError("failed to recognise site, line:"+line) fpdb_simple.FpdbError: 'failed to recognise site, line:\xff\xfeF\x00u\x00l\x00l\x00 \x00T\x00i\x00l\x00t\x00 \x00P\x00o\x00k\x00e\x00r\x00 \x00G\x00a\x00m\x00e\x00 \x00#\x001\x003\x008\x007\x009\x005\x007\x008\x005\x000\x008\x00:\x00 \x00T\x00a\x00b\x00l\x00e\x00 \x00V\x00i\x00s\x00t\x00a\x00 \x00R\x00u\x00n\x00 \x00-\x00 \x00$\x000\x00.\x002\x005\x00/\x00$\x000\x00.\x005\x000\x00 \x00-\x00 \x00P\x00o\x00t\x00 \x00L\x00i\x00m\x00i\x00t\x00 \x00O\x00m\x00a\x00h\x00a\x00 \x00H\x00/\x00L\x00 \x00-\x00 \x001\x006\x00:\x000\x002\x00:\x005\x007\x00 \x00E\x00T\x00 \x00-\x00 \x002\x000\x000\x009\x00/\x000\x008\x00/\x000\x007\x00' Traceback (most recent call last): File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/GuiBulkImport.py", line 75, in load_clicked (stored, dups, partial, errs, ttime) = self.importer.runImport() File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 162, in runImport (stored, duplicates, partial, errors, ttime) = self.import_file_dict(file, self.filelist[file][0], self.filelist[file][1]) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 234, in import_file_dict (stored, duplicates, partial, errors, ttime) = self.import_fpdb_file(file, site) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_import.py", line 302, in import_fpdb_file site = fpdb_simple.recogniseSite(firstline) File "/home/micha/Soft/fpdb_0.11.3/pyfpdb/fpdb_simple.py", line 1481, in recogniseSite raise FpdbError("failed to recognise site, line:"+line) fpdb_simple.FpdbError: 'failed to recognise site, line:\xff\xfeF\x00u\x00l\x00l\x00 \x00T\x00i\x00l\x00t\x00 \x00P\x00o\x00k\x00e\x00r\x00 \x00G\x00a\x00m\x00e\x00 \x00#\x001\x003\x009\x004\x006\x003\x006\x001\x004\x004\x000\x00:\x00 \x00T\x00a\x00b\x00l\x00e\x00 \x00H\x00e\x00a\x00t\x00h\x00e\x00r\x00 \x00G\x00r\x00o\x00v\x00e\x00 \x00-\x00 \x00$\x000\x00.\x002\x005\x00/\x00$\x000\x00.\x005\x000\x00 \x00-\x00 \x00P\x00o\x00t\x00 \x00L\x00i\x00m\x00i\x00t\x00 \x00O\x00m\x00a\x00h\x00a\x00 \x00H\x00/\x00L\x00 \x00-\x00 \x001\x007\x00:\x002\x002\x00:\x000\x007\x00 \x00E\x00T\x00 \x00-\x00 \x002\x000\x000\x009\x00/\x000\x008\x00/\x001\x000\x00'
In the console i get the DEBUG: import_fpdb_file: failed on self.lines[0]: ... error.
here are the changes I made in the fpdb_import.py.
Once again, I wish I could do it some other way (without having to use a temporary file), but couldn't succeed.
Changes are at the begining of the import_fpdb_file method.
Basically it consists in trying to read the file with an ascii encoder, if it fails, a bit later in the code, before you try and open the file, you transcode it when necessary.
Code:
def import_fpdb_file(self, file, site): starttime = time() last_read_hand = 0 loc = 0 encodings=("ascii", "utf_16") if file == "stdin": inputFile = sys.stdin data = inputFile else: if os.path.exists(file): # now start iterating in our encodings tuple and try to decode the file for enc in encodings: try: inputFile = open(file, "rU") data=unicode(inputFile.read(), enc) codepage = enc break except Exception: if enc == encodings[-1]: sys.exit(1) continue else: print "File path dos not exists" self.removeFromFileList[file] = True return (0, 0, 0, 1, 0) try: loc = self.pos_in_file[file] except: pass if codepage != "ascii": inputFile = open(file, "rU") outPath="%s%s" %(file,"_tmpfpdb") tmpOut=open(outPath, 'wb') tmpOut.write(unicode(inputFile.read(), "utf_16").encode('ascii')) inputFile.close() tmpOut.close() inputFile = open(outPath,"rU") else: inputFile = open(file,"rU") # Read input file into class and close file inputFile.seek(loc) self.lines = fpdb_simple.removeTrailingEOL(inputFile.readlines()) self.pos_in_file[file] = inputFile.tell() inputFile.close() # Delete tmp file if needed if codepage != "ascii": os.remove(outPath) try: # sometimes we seem to be getting an empty self.lines, in which case, we just want to return. firstline = self.lines[0] except: print "DEBUG: import_fpdb_file: failed on self.lines[0]: '%s' '%s' '%s' '%s' " %( file, site, self.lines, loc) return (0,0,0,1,0)
Code:
import re import codecs
I followed this http://****************/apps/mediawik...tall_in_Ubuntu and worked through everything. Created fpdbuser and made the DB through pgadminIII. Made sure all the python- are installed in synaptic after doing them all listed in guide through terminal. I'm really new with linux.
When I try to run fpdb.py I get this in fpdb-error-log.txt
And HUD-error.txt says this
I did the chmod u+x fpdb.py before doing python fpdb.py. What did I mess up?
When I try to run fpdb.py I get this in fpdb-error-log.txt
pyfpdb/fpdb.py:241: DeprecationWarning: use gtk.UIManager
self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)
self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)
HUD_main starting
Using db name = fpdb
------------------------------------------------------------
Creating hud from hand 163334
site = PokerStars, max = 10, fav seat = 5
found fav seat = 5
found actual seat = 3
adj = [0, 3, 4, 5, 6, 7, 8, 9, 10, 1, 2]
actual seat = 1, x = 668, y= 252
actual seat = 2, x = 661, y= 351
actual seat = 3, x = 497, y= 418
actual seat = 4, x = 298, y= 414
actual seat = 5, x = 68, y= 340
actual seat = 6, x = 105, y= 260
actual seat = 7, x = 106, y= 170
actual seat = 8, x = 23, y= 36
actual seat = 9, x = 643, y= 29
actual seat = 10, x = 673, y= 166
site = PokerStars, max = 10, fav seat = 5
found fav seat = 5
found actual seat = 3
Exception exceptions.KeyError: KeyError(-1208596800,) in <module 'threading' from '/usr/lib/python2.5/threading.pyc'> ignored
Using db name = fpdb
------------------------------------------------------------
Creating hud from hand 163334
site = PokerStars, max = 10, fav seat = 5
found fav seat = 5
found actual seat = 3
adj = [0, 3, 4, 5, 6, 7, 8, 9, 10, 1, 2]
actual seat = 1, x = 668, y= 252
actual seat = 2, x = 661, y= 351
actual seat = 3, x = 497, y= 418
actual seat = 4, x = 298, y= 414
actual seat = 5, x = 68, y= 340
actual seat = 6, x = 105, y= 260
actual seat = 7, x = 106, y= 170
actual seat = 8, x = 23, y= 36
actual seat = 9, x = 643, y= 29
actual seat = 10, x = 673, y= 166
site = PokerStars, max = 10, fav seat = 5
found fav seat = 5
found actual seat = 3
Exception exceptions.KeyError: KeyError(-1208596800,) in <module 'threading' from '/usr/lib/python2.5/threading.pyc'> ignored
I followed this http://****************/apps/mediawik...tall_in_Ubuntu and worked through everything. Created fpdbuser and made the DB through pgadminIII. Made sure all the python- are installed in synaptic after doing them all listed in guide through terminal. I'm really new with linux.
When I try to run fpdb.py I get this in fpdb-error-log.txt
And HUD-error.txt says this
I did the chmod u+x fpdb.py before doing python fpdb.py. What did I mess up?
When I try to run fpdb.py I get this in fpdb-error-log.txt
And HUD-error.txt says this
I did the chmod u+x fpdb.py before doing python fpdb.py. What did I mess up?
<supported_databases>
<database db_ip="localhost" db_name="fpdb" db_pass="" db_server="postgresql" db_type="fpdb" db_user="ray"> </database>
</supported_databases>
<database db_ip="localhost" db_name="fpdb" db_pass="" db_server="postgresql" db_type="fpdb" db_user="ray"> </database>
</supported_databases>
Hi everyone,
I have been reading this thread and think it is awesome so many people are contributing to this open source tracking software.
I want to basically just create a database of players results in "double or nothing" tournaments. In partypoker, these tournaments only go up to £11 buyins, so shouldnt be as bad memory and processing wise as the whole sites playing hands.
Does this software support a lite usuage like this, where you can define the parameters to track as only these types of tournaments (no actual hand history required) that just says where they finished, what the buyin was, and what position they finished?
Kind regards,
Steve
Ps. Sorry, to bother you
I have been reading this thread and think it is awesome so many people are contributing to this open source tracking software.
I want to basically just create a database of players results in "double or nothing" tournaments. In partypoker, these tournaments only go up to £11 buyins, so shouldnt be as bad memory and processing wise as the whole sites playing hands.
Does this software support a lite usuage like this, where you can define the parameters to track as only these types of tournaments (no actual hand history required) that just says where they finished, what the buyin was, and what position they finished?
Kind regards,
Steve
Ps. Sorry, to bother you
<supported_databases>
<database db_name="FPDB" db_server="postgresql" db_ip="localhost" db_user="fpdbuser" db_pass="" db_type="fpdb"> </database>
</supported_databases>
<database db_name="FPDB" db_server="postgresql" db_ip="localhost" db_user="fpdbuser" db_pass="" db_type="fpdb"> </database>
</supported_databases>
Edit: Also using Ubuntu Jaunty x64.
The fpdb-error-log.txt from the pyfpdb folder says
/var/lib/python-support/python2.6/MySQLdb/__init__.py:34: DeprecationWarning: the sets module is deprecated
from sets import ImmutableSet
/usr/lib/python2.6/dist-packages/pytz/__init__.py:32: UserWarning: Module _mysql was already imported from /var/lib/python-support/python2.6/_mysql.so, but /var/lib/python-support/python2.6 is being added to sys.path
from pkg_resources import resource_stream
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/user/FPDB/pyfpdb/fpdb_db.py", line 73, in connect
self.db = psycopg2.connect(database = database)
psycopg2.OperationalError: FATAL: Ident authentication failed for user "user"
from sets import ImmutableSet
/usr/lib/python2.6/dist-packages/pytz/__init__.py:32: UserWarning: Module _mysql was already imported from /var/lib/python-support/python2.6/_mysql.so, but /var/lib/python-support/python2.6 is being added to sys.path
from pkg_resources import resource_stream
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/user/FPDB/pyfpdb/fpdb_db.py", line 73, in connect
self.db = psycopg2.connect(database = database)
psycopg2.OperationalError: FATAL: Ident authentication failed for user "user"
I also set up my postgres for a VM to access it so I could connect to it using my IP from router which works for HEM in a VM. Do I need to set that in .xml same way? I tried doing it and got this.
/var/lib/python-support/python2.6/MySQLdb/__init__.py:34: DeprecationWarning: the sets module is deprecated
from sets import ImmutableSet
/usr/lib/python2.6/dist-packages/pytz/__init__.py:32: UserWarning: Module _mysql was already imported from /var/lib/python-support/python2.6/_mysql.so, but /var/lib/python-support/python2.6 is being added to sys.path
from pkg_resources import resource_stream
Traceback (most recent call last):
File "fpdb.py", line 465, in <module>
me = fpdb()
File "fpdb.py", line 376, in __init__
self.config = Configuration.Config(dbname=options.dbname)
File "/home/user/FPDB/pyfpdb/Configuration.py", line 315, in __init__
db = self.get_db_parameters()
File "/home/user/FPDB/pyfpdb/Configuration.py", line 476, in get_db_parameters
if string.lower(self.supported_databases[name].db_server) == 'mysql':
KeyError: 'fpdb'
from sets import ImmutableSet
/usr/lib/python2.6/dist-packages/pytz/__init__.py:32: UserWarning: Module _mysql was already imported from /var/lib/python-support/python2.6/_mysql.so, but /var/lib/python-support/python2.6 is being added to sys.path
from pkg_resources import resource_stream
Traceback (most recent call last):
File "fpdb.py", line 465, in <module>
me = fpdb()
File "fpdb.py", line 376, in __init__
self.config = Configuration.Config(dbname=options.dbname)
File "/home/user/FPDB/pyfpdb/Configuration.py", line 315, in __init__
db = self.get_db_parameters()
File "/home/user/FPDB/pyfpdb/Configuration.py", line 476, in get_db_parameters
if string.lower(self.supported_databases[name].db_server) == 'mysql':
KeyError: 'fpdb'
I don't know how it works through a vm, but it should work with the credentials I showed above, with db_ip="192.168.1.1" or whatever. I thought this was set up so that the code figured it out and made the correct connection--wrong again.
One of the devs who understands this postgres crap should show up and help you in a bit. Otherwise it is a lot easier to install and set up mysql.
I set up postgresql to read outside machines when I installed it using this guide. http://www.ubuntugeek.com/howto-setu...-pgadmin3.html This part is in my pg_hba.conf
The 192.x.x.x works for HEM when it is in virtualbox linking to the DB of the host ubuntu but playing poker in virtualbox isn't exactly smooth. It's possible I goofed the user account part but then again I did get HEM to find it and it imported hands.
I'll try using mysql and see what happens. I used postgres b/c it was already there even though I read it was designed with mysql in mind.
Edit: Runs fine w/ mysql. GUI popped right up but said I had bad tables so I let it fix and recreate that and reopened it and no warning. Looks like everything is working now.
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
host all all [192.168.x.x] [255etc] md5
host all all [192.168.x.x] [255etc] md5
I'll try using mysql and see what happens. I used postgres b/c it was already there even though I read it was designed with mysql in mind.
Edit: Runs fine w/ mysql. GUI popped right up but said I had bad tables so I let it fix and recreate that and reopened it and no warning. Looks like everything is working now.
I havent checked the whole thread for like a manual how to get this thing working?
Seriously can someone help me outthere?
ty... thanks for a thing that appears 2 be really nice
Seriously can someone help me outthere?
ty... thanks for a thing that appears 2 be really nice
Greetings!
Great work, guys!
I, however, cannot get this to work. I get the quick fraction-of-a-second python box and then nothing. I'm running 32 bit Vista and have installed via the 0.2 Envinstaller and have numpy 1.3.0 and matplotlib. Trying 0.11.3
Here are the codes-
error log:
The end of the HUD_config file:
Part of the fpdb.py file:
part of the configuration.py file:
and part of the database.py file:
I'm hoping it's just some easy configuration thing, but I can't figure it out. I tried for hours to configure it on my own.
Could someone please help? I'm not a programmer, but I'm not a complete novice and can follow instructions pretty well. Thank you.
Great work, guys!
I, however, cannot get this to work. I get the quick fraction-of-a-second python box and then nothing. I'm running 32 bit Vista and have installed via the 0.2 Envinstaller and have numpy 1.3.0 and matplotlib. Trying 0.11.3
Here are the codes-
error log:
Code:
Traceback (most recent call last): File "C:\Users\aura\Documents\fpdb_0.11.3\pyfpdb\fpdb.py", line 465, in <module> me = fpdb() File "C:\Users\aura\Documents\fpdb_0.11.3\pyfpdb\fpdb.py", line 377, in __init__ self.load_profile() File "C:\Users\aura\Documents\fpdb_0.11.3\pyfpdb\fpdb.py", line 266, in load_profile self.settings['postgresql'], KeyError: 'postgresql'
Code:
<supported_databases> <database db_name="fpdb" db_server="postgresql" db_ip="localhost" db_user="fpdb" db_pass="mypassword" db_type="fpdb"> </database> </supported_databases>
Code:
if self.db!=None: self.db.disconnect() self.db = fpdb_db.fpdb_db() #print "end of fpdb.load_profile, databaseName:",self.settings['db-databaseName'] self.db.connect(self.settings['db-backend'], self.settings['postgresql'], self.settings['fpdb'], self.settings['fpdb'], self.settings['mypassword'])
Code:
class Database: def __init__(self, node): self.db_name = "fpdb" self.db_server = "postgresql" self.db_ip = "localhost" self.db_user = "fpdb" self.db_type = "fpdb" self.db_pass = "mypassword"
Code:
class Database: def __init__(self, c, db_name, game): db_params = c.get_db_parameters() if (string.lower(db_params['db-server']) == 'postgresql' or string.lower(db_params['db-server']) == 'postgres'): import psycopg2 # posgres via DB-API import psycopg2.extensions psycopg2.extensions.register_type(psycopg2.extensions.UNICODE) try: if db_params['postgres'] == 'localhost' or db_params['postgresql'] == '127.0.0.1': self.connection = psycopg2.connect(database = db_params['fpdb']) else: self.connection = psycopg2.connect(host = db_params['postgresql'], user = db_params['fpdb'], password = db_params['mypassword'], database = db_params['fpdb'])
Could someone please help? I'm not a programmer, but I'm not a complete novice and can follow instructions pretty well. Thank you.
It seems that the programmers spend a lot of time helping people (me included) in getting this all set up. Maybe the next thing should be an install exe file where people can just fill in the missing blanks and don't have to actually open and edit the config files. I think it would save a lot of postings in the long run.
Dog
Dog
It seems that the programmers spend a lot of time helping people (me included) in getting this all set up. Maybe the next thing should be an install exe file where people can just fill in the missing blanks and don't have to actually open and edit the config files. I think it would save a lot of postings in the long run.
Dog
Dog
I'm not sure where fpdb stands regarding the last update of PS. I am still running without that update. Now, Alex from PS posted that another new update is about to be released this coming week... so... This has more to do with currency again.
Am I right, fpdb still won't read files correctly if we are on the current PS's software because of the USD EUR in the HH's?
Dog
Am I right, fpdb still won't read files correctly if we are on the current PS's software because of the USD EUR in the HH's?
Dog
Feedback is used for internal purposes. LEARN MORE