So i want this program badly, and will figure it out.

1. Download the installer...

2. I have PostgreSQL 8.3

Now i have no idea what to do? lets make it simple folks.

This might be a PYTHONPATH issue. Anyone have the Windows solution?

I see a few people struggling with postgres - I will try to play poker rather than code in the next few days, but I'll look into adding something to make it a bit easier during the weekend / next week or two ...

For now all I can say is look at :
http://****************/apps/mediawik...tup_PostgreSQL

Step 1 - you can skip if you already have postgres

Step 2 - in your Start Menu postgres should have created a number of options, one of which is to run psql, which is a simple command line interface that runs in a DOS window. (If you're comfortable running these commands in some other tool, feel free to try - I don't know if it's possible.)
Run psql (I think you need to give your postgres password)
2a. do the "create role ..." command
2b. you can skip the comment command if you like

3a. do the "create database ..." command
3b. again you can skip the comment command if you like

Step 4. Assuming you have a recent snapshot, run run_fpdb.py which is in the top directory when you have unzipped it - in the Dos window that opens it will tell you where it is reading the HUD_config.xml file from.
4a. close fpdb and use something like notepad to edit the HUD_config file to fill in your db details
(or you can try to do this with the (primitive) Main menu - Preferences option. Another option is to download Windows XML Notepad from microsoft.com if you don't mind yet another download - I hate to say it about a M$ product but it does the job nicely.)
If the commands in steps 2 and 3 have worked properly you should have a database called fpdb, with username and password set to fpdb, so set these values in the database part of the config (near the end of the file).

If that doesn't help enough, you can always ask more questions on this thread or in the mailing list.

Personally I think postgres is the best of the 3 databases we are trying to support, so it's good if you can use it. For those struggling with it, you could just start with the sqlite db built into python, it may not be up to doing the hud for people playing 10 tables or something, but I believe it can handle a 100K hand db ok, and I've just been playing 2 tables and using it without any bother.
Or go for mysql if you find that easier to set up - that is the db most people use for fpdb.

sc

When do you think I'll have problems with the size of my db? I'm using MYsql and I'm estimating I have over 400K hands. I did notice recently that it is "locking up" maybe once every couple of days.

I'm playing 6 tables, and have a few years of stats... About 1500 to 2000 hands a day, sometimes less when I have to mow the lawn, trim a tree... or other "honey-do's".

My database is so big, I can't install the most recent ver12 for 2010 because it would take me 12 hours (I know cuz I had to recently restore it in early January... sigh... THEN right after that you released a new snapshot and said, "You will have to rebuild your database..." Grrrrrrrrrrr

BTW, do we have to use the new config file with that new snapshot? If we do, more cut-n-pasting with table locations etc. work... work... work...

Dog

windows xp

start/programs/postgreSQL8.3 / start service

Okay so postgreSQL8.3 is running, now where do i go from here to get it full installed? what other programs do i need installed?

Please somemone help

step by step please..

Has to be the most frustrating thing i've ever done. Anyone with any knowledge of this product just put it in the lamest step by step directions for me please? i'm going on tilt without even playing!!?!?!

Installing software does not slow your computer down, that's what your computer does.

I can`t help u....but u are not alone...after I ran through this whole thread...I`ve installed those programs a bunch of times, did a few system restores as well...without much success....

Could you possibly post a screenshot of what you are actually doing here please?

I would e genuinely surprised if unicode wasn't an option for postgres - what version do you have installed.
PyLab is the combination of numpy (numerical python) scipy (scientific libraries for python) and matplotlib (visualisation libraries) and IPython (don't remember - not used in fpdb)

http://www.scipy.org/PyLab for the blurb

The import is a _lot_ quicker now Dog, after 100k hands I was still importing at >70h/sec on a laptop. Previous imports can slow down to < 10h/sec at that point - Friendly bet says it takes less than 5 hours, and probably closer to 2.

As I mentioned in the announcement post - stats are still wrong in some areas - no different than before, just different situations that are wrong.

Unfortunately - for a while at least reimporting is going to be necessary. There are quite a few stats we'd like to record but aren't yet. Baby steps.

Have you looked at the install page yet?

The basic process is:
1) Install a database server (Postgres or MySQL)
2) Create a database called fpdb in that server
3) Give permissions to a user to read and write to the database 'fpdb'
4) Install python (this is a programming language and interpreter)
5) Install database access library for python (psycopg for Postgres or MySQLdb for a MySQL server)
6) Install pygtk and associated libraries for the gui components (We use the widget set known as gtk+)
7) Install pylab with gtk+ support (which is a set of math/plotting libraries)
8) Copy the config file HUD_config.xml to $APPDATA/fpdb ($APPDATA is different on different machines)
9) Edit the config file and edit the '<database' section of the config file with the appropriate settings (inc username and password) for the database you set up in steps 2 and 3
10) Double click fpdb.py or run_fpdb.py
11) Go to database menu and 'create or recreate tables'

That definetly looked like a PYTHONPATH issue

Where are you at right now? What step listed above?

Isnt python etc installed with the windows installer? Think it said that it was.

Btw, would you be up for a teamviewer-session if I paid?

Creating the DB just with all the standard options?

Checked and there is not a UNICODE-alternative in postgres 8.4 at least.

Well...I`m at the point close to giving it up...
So...I got postgres already for HM. I did the things in postgres /copy pasted frm http://****************/apps/mediawik...tup_PostgreSQL
but I didn`t edit HUD_config.xml , because I didn`t find it.

I didn`t install psycopg. I downloaded it from here http://initd.org/pub/software/psycopg/ and run setup.py but it didnt `seem to do anything

installed everything I think and and tried to run fpdb and got this:
Tried to run FPDB and got the following message:
Note: error output is being diverted to fpdb-error-log.txt and HUD-error txt. Any major will be reported there only.
Unable to load PYGTK modules required for GUI. Please install PyCairo, PyGObject, and PyGTK from.......

Thats it..

I was detailing the required steps if you were to configure manually

The windows installer is supposed to install and set up most of it, excluding pylab, but we've had lots of subtle failures.

I'm not personally interested, but one of the other guys might.
http://www.postgresql.org/docs/curre...multibyte.html - tells me you need to replace 'UNICODE' with 'UTF8'

I've updated the wiki to reflect this.

Sorrow

The importing is good news, timewise. I have plenty of memory (computer, not me), a dual core processor, and it was ranging from 10hands/sec to a max of 17hands/sec.

Still think I'll gain little advantage over the previous version to fool with it at this point. I'll wait for the stats to get fixed. I did notice in the GUIplayerstats.py that someone noted the possible addition of a pop-up down the road, to be able to configure that columns ourself?

I still would like to know, from anyone running this successfully, or a developer. With 400 to 500k hands currently in my db at what point is the db going to be a problem. Am I close? At some point I know I have to cut off history, but hopefully MySql can handle a million hands and not freeze up. Any opinions? Anyone?

Thx

Dog

Can you double click test1.py in the pyfpdb/ folder that you have extracted please?

You should see something like:

python is working!

press return to finish

If that is successful, then try test2.py and let me know the results.

Sorrow

I'm sure this will happen down the road, but it isn't something i'd hold my breath for.
The biggest db I know of (other than yours) is 200k hands. (He just told me that he imported all hands in under 2 hours - linux + postgres setup) so... you're in uncharted territory.

At 500k hands, there is probably 1M+ records in one of the tables, which shouldn't be a major issue, but the bigger the database gets the longer some of the queries are going to take.

Rebuilding the hudcache to use a smaller range of dates will improve performance.

There is also a mysql optimise command that can be triggered by running 'Rebuild DB indexes' from the Database menu - I have no idea how long that would take on your database though.

Sorrow

THx again!!
Test1 says python is working
Test2 Error << type `exceptions.importError`>, ImportError <`DLL load failed: The specified module could not be found.`,> <traceback object at 0x00F5C0D0>)

Ok - the pygtk libraries either aren't installed, or need reinstalling.

The packages are pygtk, pycairo, and pygobject.

The installer package:
http://****************/projects/fpdb...2.exe/download

Should contain those packages - I don't recommend running it fully, as I think it will install mysql.

Install those packages and you should be able to run test2.py successfullly

Sorrow

I'm not all that concerned (yet) but when I tried to "rebuild hud cache" this is the error I got. Tried it three times, same results. I will try the Mysql next.

Thats new.

I'll see what i can dig up.

Quick check seems to indicate that an open transaction is preventing mysql from proceeding.

Could you stop fpdb, and restart the mysql service and retry the hudcache rebuild?

Sorrow.

My bad, that link is for the wrong download - http://****************/projects/fpdb...r.exe/download

Gracias, sorrow.

That did it. Ran the hudcache rebuild. Not too bad on the time considering the 500k hands, approx... it took 13 minutes total.

Thx again,,,

Dog

I dont have any test1 and test2 in that folder?! I had the same message as the guy above. Where can they be found?

Btw, when I point and click-created a db in postgresql i did not got to choose a password. Is that the standard postgres-password or is it individual?