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

09-18-2008 , 12:50 PM
Quote:
Originally Posted by steffen123
Alpha4 includes a Gentoo ebuild - pls try and feedback
<3

Will try this later this week.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2008 , 01:02 PM
Hi ero, i replaced the file and everything went as planned, hud appeared immediatly after the first hand imported.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2008 , 01:27 PM
Quote:
Originally Posted by Shininggg
Hi ero, i replaced the file and everything went as planned, hud appeared immediatly after the first hand imported.
excellent

Stash a copy of that file away in a safe place in case you clobber it next time you download a release. I will keep thinking about this and try to fix the underlying problem.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2008 , 01:47 PM
Quote:
Originally Posted by Eratosthenes
Everything is normal until you hit the traceback.

I think you need to create an empty database in postgres. Just open pgadmin and open your server. right click and choose new database. needs to have the same name, etc. as in your default.conf and HUD_config.xml.

If you already have a database named fpdb or whatever you chose to name it, then does it have any tables? and which tables?
I do have a database but it contains no tables. It seems like table creation procedure fails to create any.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2008 , 03:01 PM
Quote:
Originally Posted by sugoi
I do have a database but it contains no tables. It seems like table creation procedure fails to create any.
OK, thanks for that update. I agree, it seems to be failing on the first table creation step.

  1. Here is a quick and dirty work-around. You can create the tables in pgadmin.
  2. Open the schema.postgres.sql file in an editor.
  3. Open pgadmin and navigate to the fpdb database.
  4. Open the sql window and paste the contents of the schema.postgres.sql file into the window.
  5. Make damn sure you are in the fpdb database, not something that has valuable data in it!
  6. Push the green arrow button to run the sql. That should create your tables.
I will hop in to windows in a bit and see if I can recreate this problem.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2008 , 06:11 PM
Quote:
Originally Posted by Eratosthenes
This version of the HUD does not handle cascaded tables, so using it with many tables isn't a great idea. Adding support for cascaded table is doable, but you might run in to the same problems you have with PT3. This combination of fpdb/HUD use fewer computer resources than I expected, so it is useful for older creaky computers.
Hey guys, first i want to say congrats on the great project. Second, any idea on when the heavy multitablers will be able to use the hud? From what i saw it's seems not as resource intensive as pt3/hem, so should be quite popular. Thanks.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2008 , 07:18 PM
So does this work on Macs? If so, how?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2008 , 07:28 PM
Quote:
Originally Posted by Eratosthenes
OK, thanks for that update. I agree, it seems to be failing on the first table creation step.

  1. Here is a quick and dirty work-around. You can create the tables in pgadmin.
  2. Open the schema.postgres.sql file in an editor.
  3. Open pgadmin and navigate to the fpdb database.
  4. Open the sql window and paste the contents of the schema.postgres.sql file into the window.
  5. Make damn sure you are in the fpdb database, not something that has valuable data in it!
  6. Push the green arrow button to run the sql. That should create your tables.
I will hop in to windows in a bit and see if I can recreate this problem.
I managed to create the tables manually but now i have a problem with the hud. Autoimport seems to work fine and i see hud's main window but no stats. In hud_config.xml i changed values of db_user and db_pass accordingly to what i have in default.conf. What about db_server (postgres)?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2008 , 07:41 PM
Quote:
Originally Posted by Smile
Hey guys, first i want to say congrats on the great project. Second, any idea on when the heavy multitablers will be able to use the hud? From what i saw it's seems not as resource intensive as pt3/hem, so should be quite popular. Thanks.
Both Steffen and I have tried to go fairly lightly on the resource usage, and we've done a pretty good job so far. One reason that the HUD is not terribly resource intensive is that we have not tried to support cascaded windows. The HUD just sticks stats on the screen and doesn't really worry about what happens under the stats. I think that trying to support cascaded windows could have 2 side effects:
  1. increased resource usage, possibly by a lot
  2. breaking the windows/Linux compatibility
I would not be happy with either of those side effects. With that said, I am not against giving it a shot; I have been doing some thinking and reading about how to sensibly accomplish it. My immediate plans (for the HUD) are to
  1. finish up the Full Tilt support
  2. clean up some of these ugly surprises that some people have gotten
  3. fix bugs/rough edges/things we didn't think about
  4. keep adding stats
  5. mucked cards display
  6. and the big push will be to do a configuration interface, so that stats, appearance, popups, etc can be configured without editing the config file by hand
I don't think that there are many potential multitabling users until we do all that anyway.

Finishing all those tasks is a few weeks away (hey, I have to play 4-6 hours of poker every day, too). Then I could start getting serious about handling windows that pop up unexpectly.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2008 , 07:53 PM
Quote:
Originally Posted by sugoi
I managed to create the tables manually but now i have a problem with the hud. Autoimport seems to work fine and i see hud's main window but no stats. In hud_config.xml i changed values of db_user and db_pass accordingly to what i have in default.conf. What about db_server (postgres)?
here's the default.conf I used for testing postgres
Code:
db-backend=3 
db-host=localhost 
db-databaseName=fpdb-p 
db-user=postgres 
db-password= 
imp-callFpdbHud=True 
tv-combinedStealFold=True 
tv-combined2B3B=True 
tv-combinedPostflop=True 
bulkImport-defaultPath=default 
hud-defaultPath=default
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2008 , 07:58 PM
Quote:
Originally Posted by sugoi
In hud_config.xml i changed values of db_user and db_pass accordingly to what i have in default.conf. What about db_server (postgres)?
Set it to 'postgresql' or 'mysql' (depending on your DBMS).
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2008 , 08:07 PM
Quote:
Originally Posted by wbrennan
So does this work on Macs? If so, how?
Steffen has been in contact with someone who says he has it running on a mac. (Sounds like my cousin's wife's friend knows someone who heard about someone who had it running on a mac.) Steffen asked him to write some how to instructions, but we haven't heard anything. I think Steffen would jump right on this if someone sent him on old mac mini that you aren't using.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-18-2008 , 08:21 PM
Quote:
Originally Posted by Pomtidom
Set it to 'postgresql' or 'mysql' (depending on your DBMS).
no, look more carefully at my reply to sugoi.

db-backend=3 is postgres (=2 is mysql)

STOP

I have lost the thread about who is having what problems. If you can import ok, then your default conf is OK. You also need to configure the HUD_config.xml file that is in the same folder as the fpdb files. Look in the HUD How To for how to configure that.

Edit: Oh, yeah, and I promise we'll combine these config files soon. Steffen just has to agree to put his stuff in my file.

Last edited by Eratosthenes; 09-18-2008 at 08:24 PM. Reason: to make a foolish promise
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-19-2008 , 06:33 AM
Quote:
Originally Posted by Eratosthenes
no, look more carefully at my reply to sugoi.

db-backend=3 is postgres (=2 is mysql)
Are you sure about this? He is asking about HUD_config.xml not default.conf.

In HUD_config.xml.example the db_server is set to "mysql" and when I grep the source for db_server:
Code:
rob@desktop /data/poker/fpdb $ grep -R 'db_server' *
pyfpdb/Database.py:        if   c.supported_databases[db_name].db_server == 'postgresql':
pyfpdb/Database.py:        elif c.supported_databases[db_name].db_server == 'mysql':
pyfpdb/Configuration.py:        self.db_server = node.getAttribute("db_server")
Please correct me if I'm wrong and keep up the great work

[edit]
Just saw here that they are setting the db_server attribute to "mysql" too. So put mysql or postgresql in db_server in HUD_config.xml and 2 or 3 in db_backend in ~/.fpdb/default.conf
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-19-2008 , 07:58 AM
Quote:
Originally Posted by Pomtidom
[edit]
Just saw here that they are setting the db_server attribute to "mysql" too. So put mysql or postgresql in db_server in HUD_config.xml and 2 or 3 in db_backend in ~/.fpdb/default.conf
yes, you have it figured out. Here are a couple of working database lines that work in my HUD_config.xml:

This one connects to a database named fpdb on a mysql server on a remote computer:
<database db_ip="192.168.1.100" db_name="fpdb" db_pass="mythtv" db_server="mysql" db_type="fpdb" db_user="mythtv"> </database>


This one connects to a database named fpdb-p on a postgres server on the local computer:
<database db_ip="localhost" db_name="fpdb-p" db_pass="" db_server="postgresql" db_type="fpdb" db_user="postgres"> </database>
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-19-2008 , 03:29 PM
Couple of questions on installation:
I have followed (I think) all of the appropriate instructions from the install page and the thread. I am left with a couple things though:

Should I place the release folder in any particular place?
I don't have a homepath environment variable, so part of the instructions are cloudy. Where do I make the Application Data\fpdb?
I missed all the git stuff, is that just like a repository tool (similar to say CVS or such)?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-19-2008 , 05:22 PM
fnord_too,

1. It doesn't matter where you put the fpdb release folder.

2. Which operating system do you use?

3. Git is a repository tool.


@ALL

I will release an installer for the fpdb environment (including MySQL) in the next 24 hours. It is working already but is in a very raw state. I'm running Windows XP so that's the operating system it works on for sure. I am fairly confident that it works on Windows 2000. I need to check out if it will run on Windows Vista. Once it is released you'll be able to download it on the fpdb sourcefourge download page.

For people who didn't try to run fpdb at at all there will then be only 2 things to do.
1. Download and install FPDB Environment Installer
2. Download fpdb zip file and decompress it to a location of your choice.
I hope this will be simple enough for everyone to understand.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-19-2008 , 05:38 PM
I am using XP

Edit - also, I am using postgresql
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-19-2008 , 07:11 PM
Quote:
Originally Posted by Pomtidom
Set it to 'postgresql' or 'mysql' (depending on your DBMS).
Thanks

After the change the hud was able to detect the table i was playing on and opened a window with the table's name. Shortly 6 more (i was playing 6max) windows appeared but after that all hud related windows just hung up. I tried few more times but still the same.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-19-2008 , 07:13 PM
Quote:
Originally Posted by fnord_too
I am using XP

Edit - also, I am using postgresql
Then your default.conf needs to be in C:\Documents and Settings\Username\Application Data\fpdb\default.conf
Replace "Username" with your actual Windows user name. The Application Data folder should already exist, but may not be shown as by default it is hidden. But if the homepath variable is missing there might be sth wrong with your Windows.

To use pgsql you also need to change the backend variable in default.conf from 2 to 3, and in the HUD_config.xml you need to replace mysql with postgresql (its right at the bottom, one of the last lines). Remember that for pgsql you do not need mysql-python, but you do need psycopg2.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-19-2008 , 07:16 PM
Quote:
Originally Posted by Eratosthenes
Steffen has been in contact with someone who says he has it running on a mac. (Sounds like my cousin's wife's friend knows someone who heard about someone who had it running on a mac.) Steffen asked him to write some how to instructions, but we haven't heard anything. I think Steffen would jump right on this if someone sent him on old mac mini that you aren't using.
One thing I can say is that installation will almost certainly involve macports, a MacOSX implementation of the BSDs' ports system (the latter is similar to but not as advanced as Gentoo's portage). If you want to give it a go I suggest you start by installing that and then using it to try and install the dependencies. Fpdb itself works fine in Mac, the only thing to be added is appropriate default paths but that can be done in the config file as well and is trivial in any case. The HUD may or may not require extra work, depending on how GTK interacts with MacOS.

Once I'm home (around 29Sep) I should hopefully sometimes have access to a Mac again to give this another shot if we don't have something by then. I'm hopeful that we will tho
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-19-2008 , 08:03 PM
Quote:
Originally Posted by sugoi
Thanks

After the change the hud was able to detect the table i was playing on and opened a window with the table's name. Shortly 6 more (i was playing 6max) windows appeared but after that all hud related windows just hung up. I tried few more times but still the same.
OK, when you have stat windows up, but aren't updating.

  1. Can you hover over a stat and see a tool tip?
  2. Can you right click on the table main window?
  3. Can you right click and close it?
  4. If it closes, do you get another one when the next hand is imported?
  5. What are you seeing in the terminal window when this is happening?
thanks
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-19-2008 , 08:16 PM
Quote:
Originally Posted by steffen123
One thing I can say is that installation will almost certainly involve macports, a MacOSX implementation of the BSDs' ports system (the latter is similar to but not as advanced as Gentoo's portage).
Just out of curiosity: which part causes the need for this?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-19-2008 , 10:05 PM
Quote:
Originally Posted by Eratosthenes
OK, when you have stat windows up, but aren't updating.

  1. Can you hover over a stat and see a tool tip?
  2. Can you right click on the table main window?
  3. Can you right click and close it?
  4. If it closes, do you get another one when the next hand is imported?
  5. What are you seeing in the terminal window when this is happening?
thanks
1. No
2. No
3. No
4. -

All hud windows hang up right from the start. It looks like the process is running but is too busy to redraw the windows. Maybe im wrong.

5. After few hands are imported i get this (once)
Code:
C:\fpdb\pyfpdb\Hud.py:265: GtkWarning: gdkwindow-win32.c:1089: SetWindowLong fai
led: The operation completed successfully.
  self.window.show_all()
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
09-19-2008 , 10:18 PM
Quote:
Originally Posted by Pomtidom
Just out of curiosity: which part causes the need for this?
In short: Because Apple (like Microsoft) was too lazy, stubborn and/or stupid to include real software management (a la ports/portage) by default.

Longer: Apparently this is hosted by Apple, so I can only guess why they chose to make life hard for you by not including it and by not providing a beginner-friendly graphical interface. In any case, as a result of this developers can either re-invent the wheel for every single application and each OS, like we're having to do with the Windows installer, or you can have one installer system (MacPorts) that can and is being re-used with little effort by thousands of packages.

With ports to install e.g. mysql you type: port install mysql. It then downloads, verifies, and installs not just mysql but also all missing dependencies. No need to google and then count on luck or prayers to ensure you didn't fall in the trap of some fake page

Well, this is assuming MacPorts is any good, I unfortunately don't own a Mac (and if I did, it wouldn't be running MacOS ). But the person I originally started this project for does use MacOS so proper, user-friendly Mac support is a necessary feature for me.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m