Where are you guys getting hands/sec data from?

My bulk imports seem to take ages and I have a tiny database.

Okay, found a couple of bugs and saw the trac-bug reporting but dont get how I shall report a bug :S? There does not seem to be a register-button or something.

Anyways here is what I have found.

It appears that the Player Stats-window ignore when I deselect "Show limits". It still says FL Holdem FTP $5 instead of grouping it. Also, isnt there a way to group each game (without seperating it into FTP/Pokerstars/etc) so I can watch my total stats on each game?

Gonna try edit the config-files etc but I would recommend that you have a GUI interface at least for the most common configs like the nicknames and the import folders.

Again; Real kudos to you and I hope that I can stop consuming your energy with my n00b questions from now on and help you getting the software better. This software is awesome as long as you finally have got it working .

OK, it's not taking ages, it's not working.

Anyone else having problems with yesterdays release?

I have tried Stars, FT and Party but it just never seems to get there.

I have re-created tables a number of times too.

I went back to the previous version which appears to work.

Any ideas?

I'm running Windows XP

EDIT: The dark grey importing status bar is moving left and right very fast compared to the old version when it was moving more slowly and importing correctly.

Mine is doing the same thing (moving fast back and forth). If I bulk import ONE file at a time, it works. A real PIA!! I thought it was just some problem on my computer. I'm running Vista and if I run one file at a time, it's running at 8 or 9 hands/sec, really slow. Someone broke it (latest snapshot) on bulk import... I'm seriously considering going back to the last snapshot as well.

Dog

This is the correct bug tracker. I had to close public access for making new bugs because we were getting huge amounts viagra/etc spam. You can make an account and PM your account details and I'll set you up to make/edit bugs. Or just PM me the bug details and I'll make the bug. I notice that some of those bugs have been fixed and need to be closed--I'll look at closing them later today.

BTW: thanks to whoever closed the remaining spam bugs--I closed a bunch, but got tired.

I think you are right that there isn't a way to see results aggregated over all the sites you play. That would be a good addition. I have not worked on that part of the code, so I don't know how hard that would be to do. That could be added to the tracker as a feature request.

That info shows up in the console window and looks like this:
Putting a live update of this sort of info on the gui is on my things to do list, but isn't bubbling to the top very quickly (mainly because things are getting added faster than they are coming off).

OK, I just imported the dir that I've been using to test bulk importing using the latest snap. I got 94 hands/sec, which is pretty close to the 95-100 that I had been getting. This is on my Linux box, I haven't tested on Windows.
BTW: you can check to see if hands are going in by logging in to the mysql command line client and doing this:

Windows users should have a shortcut in the Start|mysql menu to open the command line client--then just use the same username and password as in your config.

Ekdikeo helped a lot..all good now!

Just wanted to say a big THANK YOU!!!! for the pple who worked on this!!!

I`ve got 4 questions:

-Is it possible to review a certain hand? Like the big losses after a session?
-Is there an option or do u plan it to filter stats for the hud, by how many players were involved?
- What is that Variance number?
-The flop cbt n looks pretty small in all cases...sg shold be wrong I guess..

TY!!!

Questions are good - after using something for a while you get used to foibles, to the point where you dont notice them - fresh eyes are always welcome.

I'd never considered remembering the positions of the player stats window (i'm not even sure how hard it would be). The next thing likely to change in that screen is the ability to show/hide stat columns. That is 'on the list' but not high in my priorities.
The last 12 months have been spent replacing a lot of the code that prevented this from happening. The first release of that code publicly was < 4 weeks ago.

Good mixed game support in the hud is a goal of at least 1 of the devs, but we've only just got to the point where discussion on how to deal with mixed games 'correctly' in the code is possible.

I'm sure it will come soon - but soon is a relative term.

Excellent that its working for you. How did you fix the error?
As other have said - most of the devs run fpdb from a console, and the hh/sec output appears there.

Note to self - add this output to the logging file too.

Not yet - this is more difficullt than it appeared with the current setup.

Lots of choices need to be made about equivalence (NL100+ante = NL100 ?) - I only really play 1 site, so its not on my list - i'm sure its on one of the other devs thogh.
A start has been made on this Main->Preferences actually allows the config file to be edited in the gui. It hasn't had much testing though.
Auto or bulk import?

There is still an issue i'm seeing with the hud where stat windows wont appear until a) I bulk import 1 file b) Rebuild the hud cache

Its proving to be a tough nut to crack.

Session Viewer is the very early pass at viewing sessions. The code is still seriously broken, but might partially work if you don't have too many hh's imported.

There isn't yet a way to view a hand(s) after import. This is something I really want to be able to do, so will come real soon now (tm)

There are some hud filters, and I believe # seats is thoertecally doable, but there isnt' a giu way to do it yet.

Variance: https://****************/apps/mediawi...riance_mean.3F

Flop cbet is wrong at the moment, hope to have it fixed by next snapshot

Thanks

Sorrow

re: seat filter:

right click fpdb menu, select Players->Seats Exact or Custom. I'm not sure which option does which, and the names don't make sense, but one of those two options will do what you want

is it possible to run fpdb from an external hard drive? i have a solid state (very small) hard drive with ubuntu

I do. I'm running Windows Vista. I backup FPDB on an external drive "G:" When I had some problems with the current snapshot, I just jumped over to the backup copy on the external drive. It worked perfect till I got the newest snapshot working, then I switched back.

It's actually a good way to keep previous snapshots, IMHO. Anything goes wrong with a new snapshot, it's easy to go backwards..

Dog

Sure.

There are a few ways to do it, all writing happens into the mysql/postgres database. That database can exist on another machine if you want.

You'd need to configure whatever database you choose to put its storage on the external disk. I can't comment on the performance but it should work fine.

Sorrow.

Bulk, right after recreating the tables I tried to do a bulk import before testing the HUD.

So far I havn't managed to import a single hand on Stars, FT or Party.

Mostly Razz hands BTW.

I will try meandog's one file at a time method later if I get chance.

Is there anything useful in the log/ directory - it should be in $APPDATA/fpdb/log

Delete logging.out, and any error files - then bulk import 1 file and let me know what messages you get.

Sorrow

Well, in previous versions the log was stored directly in ~/.fpdb/, now it looks for it in subfolder "log" which didn't exist, so I created it and moved the file.

No log directory

No logging.out or fpdb-error files either

Can you create it please - its supposed to be done automatically, but hasn't for at least 1 user (a couple of posts ago)

Double click test2.py to show the path to config directory.

Sorrow

Hi guys--

I played around with bulk importing this morning to see if I could duplicate this mysterious freezing thing. I pointed the bulk importer at a dir that has mostly stud8 and razz hands from Stars.

At the end, I got this report:
This db had about 35k hands in it when I started this import and those hands went in at about 43/sec. So the 39/s I got here is close to that. I used the mysql server in my mythtv box, which is a 3+ year old core duo 1.8GHz. This is the about the speed I've been getting with that db server.

The interesting thing is that it took 5.5 min to rebuild the hudcache. If this had been the 500k db that Dog has on a somewhat slower server, it could easily take 20-30 min, depending on how that operation scales. So it is possible to think that the BI has hung, when really it is crunching the hudcache. I don't really think this is the problem with the imports, so I'll mess around some more looking for the problem.

Right now there is no hand reviewer, or any way to use the gui to find interesting hands from recent play. I have been thinking about a reviewer for a pretty long time and will get started on it when the other things get solidified. Some of the other guys have ideas about reviewers, too.

Hi -- I'm trying to install on ubuntu, and I'm somehow managing to screw this up. Maybe someone could give me a pointer to my mistake.

1)
I setup the database "fpdb" in mysql, and gave grant privileges to fpdbuser. Here is the verification from mysql.

-----------------------------------------------
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| fpdb |
| hibernate |
| mysql |
| quartz |
| sampledata |
+--------------------+
6 rows in set (0.00 sec)

mysql> show grants for fpdbuser@localhost;
+-----------------------------------------------------------------------------------------------------------------+
| Grants for fpdbuser@localhost |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'fpdbuser'@'localhost' IDENTIFIED BY PASSWORD '*BDBF85B0BE2BA0CE0F68C4083C01412AD16F35DB' |
| GRANT ALL PRIVILEGES ON `fpdb`.* TO 'fpdbuser'@'localhost' WITH GRANT OPTION |
+-----------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

-----------------------------------------------------------



2) Then I edit the HUD_config.xml file. Specifically I change the final input to:
<supported_databases>
<database db_ip="localhost" db_server="mysql" db_name="fpdb" db_user="fpdbuser" db_pass="poker"> </database>
</supported_databases>

(where "poker" is the incredibly secure password I used when granting the fpdbuser privileges -- not sure how to verify this though). I've also tried adding db_type="fpdb", but that didn't seem to change the results.

3) The problem :P
When I now try and run ./fpdb.py I get returned this info/errors:

Python 2.6...
/usr/lib/python2.6/dist-packages/pytz/__init__.py:32: UserWarning: Module _mysql was already imported from /usr/lib/pymodules/python2.6/_mysql.so, but /usr/lib/pymodules/python2.6 is being added to sys.path
from pkg_resources import resource_stream

Reading configuration file /home/dylan/.fpdb/HUD_config.xml

config : ERROR Error parsing /home/dylan/.fpdb/HUD_config.xml. See error log file.
Traceback (most recent call last):
File "/home/dylan/fpdb/pyfpdb/Configuration.py", line 471, in __init__
doc = xml.dom.minidom.parse(file)
File "/usr/lib/python2.6/xml/dom/minidom.py", line 1918, in parse
return expatbuilder.parse(file)
File "/usr/lib/python2.6/xml/dom/expatbuilder.py", line 924, in parse
result = builder.parseFile(fp)
File "/usr/lib/python2.6/xml/dom/expatbuilder.py", line 207, in parseFile
parser.Parse(buffer, 0)
ExpatError: not well-formed (invalid token): line 630, column 9
press enter to continue


I don't know much of anything about xml, but it looks like its complaining about the line that was edited in the HUD_config.xml file.

Thanks in advance.

Feeling very silly, just found the log directory and files elsewhere "fpdb-errors"
says:

fpdb starting ...C:\fpdb\pyfpdb\GuiBulkImport.py:88: GtkWarning: gtk_tree_path_append_index: assertion `index >= 0' failed
sitename = self.cbfilter.get_model()[self.cbfilter.get_active()][0]
C:\fpdb\pyfpdb\GuiBulkImport.py:88: GtkWarning: gtk_tree_model_get_iter: assertion `path->depth > 0' failed
sitename = self.cbfilter.get_model()[self.cbfilter.get_active()][0]
Traceback (most recent call last):
File "C:\fpdb\pyfpdb\GuiBulkImport.py", line 88, in load_clicked
sitename = self.cbfilter.get_model()[self.cbfilter.get_active()][0]
IndexError: could not find tree path


Hope this helps.....

Is that exactly the line from HUD_config.xml?

&, >, <, ", ' in a password can screw things up.

gedit will do syntax highlighting to help fix errors.