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

08-11-2009 , 01:02 AM
opened with fpdb with python.exe, pythonw.exe and pythonicon.exe all result in nothing.

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)")
2p2 censored my folder name lol

Last edited by dorado29; 08-11-2009 at 01:04 AM. Reason: fml
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-11-2009 , 01:21 AM
Quote:
Originally Posted by dorado29
opened with fpdb with python.exe, pythonw.exe and pythonicon.exe all result in nothing.

error:

Code:
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'fpdb'@'localhost' (using password: YES)")
Make sure you've deleted the error log before you try and open fpdb.

python.exe is the correct .exe to open it with.

If the same error regenerates - the MySQL username/password are wrong in the config.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-11-2009 , 01:57 AM
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
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-11-2009 , 02:10 AM
Quote:
Originally Posted by 1meandog4u
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
We had additional permissions problems, but your final problem ended up being that you were editing the wrong config file Dog, i suspect the same issue here.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-11-2009 , 04:58 PM
dlsadfoiacvxcpvzvvvvvvvvvvvvvovv

****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'
after i did this

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")

Last edited by dorado29; 08-11-2009 at 05:08 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-11-2009 , 07:12 PM
Quote:
Originally Posted by dorado29
dlsadfoiacvxcpvzvvvvvvvvvvvvvovv

****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'
after i did this

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")
I'm not sure why you are hot wiring the Configuration module, but it should look like this:
Quote:
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"
You just need to change your HUD_config.xml to:
Quote:
<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 think you mentioned earlier that the whole config file showed up on one line in notepad. If you open it in wordpad or a programming editor it might look better.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-12-2009 , 05:20 AM
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.


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.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-13-2009 , 12:39 PM
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.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-13-2009 , 03:33 PM
Quote:
Originally Posted by PassThePeas
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.
Best way to talk to devs is #fpdb on freenode or the mailing list (on sourceforge, which seems to be down right now).

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.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-13-2009 , 09:37 PM
Quote:
Originally Posted by NightSky
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.


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

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)
One thing is needed : you have to import the codecs module : after the import re line for instance (at the begining of the file):
Code:
import re
import codecs

Last edited by PassThePeas; 08-13-2009 at 09:43 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-15-2009 , 10:51 AM
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
Quote:
pyfpdb/fpdb.py:241: DeprecationWarning: use gtk.UIManager
self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)
And HUD-error.txt says this
Quote:
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
I did the chmod u+x fpdb.py before doing python fpdb.py. What did I mess up?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-15-2009 , 02:43 PM
Quote:
Originally Posted by Mr_Pathetic
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?
All this is OK. Just the depreciation warning and the informational messages about starting a HUD. Your HUD didn't show up? What does the database line look like in your HUD_config.xml? Mine looks like this (for postgres):
Quote:
<supported_databases>
<database db_ip="localhost" db_name="fpdb" db_pass="" db_server="postgresql" db_type="fpdb" db_user="ray"> </database>
</supported_databases>
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-15-2009 , 04:05 PM
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
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-15-2009 , 05:08 PM
Quote:
<supported_databases>
<database db_name="FPDB" db_server="postgresql" db_ip="localhost" db_user="fpdbuser" db_pass="" db_type="fpdb"> </database>
</supported_databases>
Nothing showed. This is what the xml looks like. I capitalized DB name in pgadmin so I did it in the xml if that matters.

Edit: Also using Ubuntu Jaunty x64.

The fpdb-error-log.txt from the pyfpdb folder says
Quote:
/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"

Last edited by Mr_Pathetic; 08-15-2009 at 05:37 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-15-2009 , 05:50 PM
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.
Quote:
/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'
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-15-2009 , 06:38 PM
Quote:
Originally Posted by Mr_Pathetic
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.
Postgres does something I don't understand--I think it is a unix thing only, so doesn't affect windows users. If you are connecting to a local unix (linux, etc) db, it connects via a unix pipe using your login credentials and will fail if you supply proper credentials in the db connection string.

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.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-15-2009 , 06:56 PM
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
Quote:
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
host all all [192.168.x.x] [255etc] md5
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.

Last edited by Mr_Pathetic; 08-15-2009 at 07:09 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-21-2009 , 06:17 AM


i really wanted to link this at full size, but it is .. HUGE...
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-21-2009 , 07:10 AM
Quote:
Originally Posted by ekdikeo


i really wanted to link this at full size, but it is .. HUGE...
Nice
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-21-2009 , 01:46 PM
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
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-21-2009 , 01:49 PM
Quote:
Originally Posted by Recteur
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
The wiki is here.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-21-2009 , 05:07 PM
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:
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'
The end of the HUD_config file:
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>
Part of the fpdb.py file:
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'])
part of the configuration.py file:
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"
and part of the database.py file:
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'])
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.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-21-2009 , 10:45 PM
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
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-22-2009 , 02:48 AM
Quote:
Originally Posted by 1meandog4u
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
Installers are not exactly the easiest thing to get together .. I should probably update my big ZIP file that has everything, though, now that matplotlib has been updated to work right.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-22-2009 , 11:01 AM
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
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m