I already have postgres setup from a previous software. I deleted my old db in it, and created (as instructed on the wiki) a new db and named it "fpdb".

Everything including python is on my computer (Vista). When I go to the most recent fpdb.zip, unzip it and click on fpdb.py (once again as stated on the wiki), the black "dos" box pops up for a millisecond and disappears. Then nothing. Someone must see something I am doing wrong. It appears to never actually want to install itself. Then will come the importing of HH's. That ought to be fun.

Is there something (config file) that I am supposed to copy somewhere. This seems like a helluva lot of work just to do a simple install of the program, let alone then hope it works. TIA to anyone that sees an obvious miscue on my part. It would be the first mistake I've made in 50 years

DOG

1meandog, these are the instructions to configure fpdb to use postgresql. You'll need to adjust some of the values to reflect the database, username, and password you have created. Additionally, if you don't have a HUD_config.xml file you will need to copy HUD_config.xml.example to HUD_config.xml in the main directory, so you can edit the relevant parts.

Thank you very much. When you say "main directory", I assume you mean the directory that I unzipped the file? I need to move that, as I did it under my "downloads" directory, and I also assume I can stick that under the "Programs" directory with the name "FPDB", or will the installation create it's own directory?

I don't have a HUD_config.xml, but I do see the "example" file that needs the changes you mentioned, and "saved as".

One other clarification.... When I originally (before fpdb) set up postgresql, I set it up with "adr" as the user, and the default "postgres" as the password. I want to make sure that I am not confusing 'user' with 'database'. I am going to use "adr" as user, default password "postgres" and I already created a db in Admin III named "fpdb". Does that sound like what I am supposed to have?

Again, thanks

Dog

I did everything as you explained it. Still nothing. I am sure it is some simple thing that I have overlooked....

But, as an addendum before leaving, I must add that while I understand that this program is quite good. And, it has very detailed and well thought out workings, it seems a shame that there is not a simple installer file that would let the non-programmer average poker player try this out. Poker players are not by default programmers. They should not have to be extracting files, moving files, installing databases (outside of the program itself), modifying and creating config files, etc etc. For me, if that is what is required, I'll wait for the finished product in a couple years when there is a REAL installation file that sets the program up on my computer.

I followed the instructions on the wiki. Unfortunately, it forgot to mention about changing the config file. Thanks to a 2+2 member, a valiant effort was made, but did not succeed.... I give up and wish you well on your project... see you in a year or so when it's easier to install.

Dog

fpdb is looking for the HUD_config.xml file in:
%HOMEPATH%\application data\fpdb

aka (on NT I think VISTA is the same)
C:\Documents and Settings\<logged_in_user>\Application Data\fpdb


go to that directory and edit the HUD_config.xml file with your favorite text editor. (gvim if you have it, notepad if you don't)

The DOS box is closing because fpdb.py is throwing an error and exiting. To keep the box open: Open a CMD window (Start>Run Type in CMD click Okay) then navigate to the directory where fpdb.py is and run it. The CMD window will stay open and error messages should be displayed.

I did everything you said. I found the file, on Vista it was slightly different, but I found it...

\USER_Name\AppData\Roaming\fpdb

I made the changes to the config example file, then "saved as" without the "example" so that it was the correct config file name... . I opened the "run" and then "cmd" which opened the dos window. I went to where fpdb.py was located, which in my case was...

c:\Program Files\fpdb\fpdb.py

I double clicked and nothing. Another black box opened and shut quickly and when I went back to the CMD box it had nothing displaying as far as an error. And, I did remember to reboot Windows before attemping to run the fpdb.py

I am "almost" sure that it is somehow related to the changes I made to the config file. I am probably doing something wrong with postgres. Either a wrong password, although I never changed it from the default "postgres" as they recommended. When I originally installed postgres, somewhere I had to use/makeup a name for the postgres. I used "adr" and could not figure out where in the config file that belonged, if it DID belong there. Very tired and frustated at all this work.

Three days of this is too much. You and others have tried to help to no avail. Either I'm stupid, or this beyond simple lay people's understanding. I really do appreciate the efforts made by you, dha123, and the others, but as you can see... none of the additional steps were mentioned anywhere on the wiki. This seems like a lot of stuff to go thru to just get it opened. And I did not even mention the installing of python and the other mapping/graphing program.

I'm tired and done fooling with it. I just wanna play poker.

Thanks again, one and all. I will wait for the finished product and a "one-file installation file".

Dog

PM Sent ....

As of few days, fpdb isn't working for me anymore. I can start autoimport, but nothing happens and when I try to stop autoimport the whole program hangs.
This is the error log:

Is gtk still in your path?

It's not in /fpdb/pyfpbd if that's what you mean?

it wouldn't function in the slightest if gtk wasn't working. That single error is normal, we haven't bothered to update the gui to use the current methods gtk uses to create menus .. is there any useful output in the command prompt window that it runs in?

Well, the first unusual thing is reading the config file takes ages (over 8 mins).

I think there was always an error reading some file, but even after clearing out my HH folder the problem persisted. Ofcourse I can't duplicate the eroor right now as all of a sudden the HUD seems to work again. I'll be sure to post again if this happens more often.

I'd like to make it so that my HUD aggregates stats from mulitiple stakes. I assume this would be easy to do. Can anyone point me to the location in the code where I might be able to do this?

Thanks

Travis

Sorry for the non help but why would you want this? Do you mean just different stakes or do you mean different like mix 6-max, FR and HU?
The latter is def. worse to mix but the first doesn't sound like a very good idea either imo.

Btw is anyone working on autorates? I've been toying around with it in a Perl script, maybe my code could be helpful for devs who know both perl and python. Do you plan on implementing the autorating on an SQL level or in Python code?

i want to aggregate games like 2/4 and 3/6 and 5/10. Not Full ring and HU

THE WTSD stat isn't accurate. It's running at about 8 or 9% too high. Is this because it's really showing how often it goes to 7th st?

Noone is looking at it currently. I'd be interested to see what you've done - i think most of the devs have written in perl at some point.

There is an autorates sql table, but i'm not sure where it would finally be implemented.

The HUD stats are only pulled from the HudCache table, and are stored based on the stakes. Most of that code is in Hud.py - its doable but you'd need to hack a bit.

This is possible. I'm not a stud player myself. Eratosthenes?

Ugh, sorry but I haven't read through the entire thread. I am having trouble getting the program to work, is there a troubleshooter/FAQ thing I can look through?

At the moment I have everything installed, MYSQL, the fpdb environment installer thing, downloaded the .11 build, ran fpdb.py, but it says that it cannot parse the HUD XML in the roaming file. "See error log files".

I got something like this:

It also said it failed to load libs for graphing, etc, even though I've installed both other apps.

Meh, I use HEM which doesn't track stud games so I'm really trying to get this work, but I have no clue what I'm doing wrong as I really just followed the instructions and am too bad at computers to do anything else.

Im getting this same error and fpdb is not working in tournament's or SnG's just in ring games is there a patch to this?

Hi,

I'm trying to run this promising program (FPDB v 0.11) on Windows Vista using Postgresql. I have given python.exe full administrative priviliges to prevent UAC problems. FPDB seems to create all database tables just fine, but the tables remain empty on both auto-import and bulk-import. When i try to bulk import my Full Tilt Poker handhistories, it shows:

DEBUG: import_fpdb_file: failed on self.lines[0]: 'C:\Users\Bulldozer\Documents\FT20090518 Winner (6 max) - $0.02-$0.05 - No Limit Hold'em.txt' 'default' '[]' '6009'

It seems to detect the correct file size, but nothing gets imported. Does anyone else experience this problem? Does anyone know a solution?

Any help would be greatly appreciated! Thanks!

Just wanted to thank Eratosthenes for helping me to get it all to work properly. You were a great help in IRC

Keep the good work up gyus, i think importing/exporting db is pretty important feature for the future how are the plans on implementing it?

I've got one bug, at least what it seems to me, the Graph is workling well but when i generate it more than one time the old doesnt disappear so if you generate it few times they become pretty slim cause there is no much room left, an option for clearing graph should be nice.

This really look like you haven't rebooted since the environment install, its not finding a bunch of the python libraries, so the path setup is probably wrong.

The error is a standard error message and isn't affecting the program.

What version of fpdb are you using, and what tourneys/sngs (what site etc) are you playing?

Need more info before I can start guessing. Tourneys and SnGs should work for FTP/Stars for the 0.11 release.