Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > > >

Notices

Free Software Discussion of Free / Freeware / Donationware / Open Source poker software and Free Graphics mods

Reply
 
Thread Tools Display Modes
Old 02-03-2010, 05:29 PM   #2576
h3r34dalootty
centurion
 
Join Date: Feb 2010
Location: Colorado
Posts: 108
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

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.
h3r34dalootty is offline   Reply With Quote
Old 02-03-2010, 06:06 PM   #2577
uncooper
centurion
 
Join Date: Oct 2007
Posts: 124
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by zsolesz0001 View Post
Hi!

I`ve installed everything, except psycopg2./that1 didn`t seem to do anything/
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.......

I`ve installed all 3 of these.......


TY!
This might be a PYTHONPATH issue. Anyone have the Windows solution?
uncooper is offline   Reply With Quote
Old 02-03-2010, 08:36 PM   #2578
sqlcoder
stranger
 
Join Date: Nov 2009
Posts: 14
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

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
sqlcoder is offline   Reply With Quote
Old 02-03-2010, 09:07 PM   #2579
1meandog4u
old hand
 
1meandog4u's Avatar
 
Join Date: Apr 2007
Location: Ontario, CA (California not Canada)
Posts: 1,286
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

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
1meandog4u is offline   Reply With Quote
Old 02-03-2010, 09:24 PM   #2580
h3r34dalootty
centurion
 
Join Date: Feb 2010
Location: Colorado
Posts: 108
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

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

Last edited by h3r34dalootty; 02-03-2010 at 09:48 PM.
h3r34dalootty is offline   Reply With Quote
Old 02-03-2010, 09:48 PM   #2581
h3r34dalootty
centurion
 
Join Date: Feb 2010
Location: Colorado
Posts: 108
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

h3r34dalootty is offline   Reply With Quote
Old 02-03-2010, 10:47 PM   #2582
h3r34dalootty
centurion
 
Join Date: Feb 2010
Location: Colorado
Posts: 108
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

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!!?!?!
h3r34dalootty is offline   Reply With Quote
Old 02-04-2010, 03:46 AM   #2583
ekdikeo
old hand
 
Join Date: Aug 2006
Posts: 1,307
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by El helado Patata View Post
I am not a big fan of downloading and installing a bunch of software to slow my computer down. Python is okay but then I need 2-3 extra software for it to work? Ohhh this could be a dealbreaker for a lot of people (not sure yet myself).
Installing software does not slow your computer down, that's what your computer does.
ekdikeo is offline   Reply With Quote
Old 02-04-2010, 05:22 AM   #2584
zsolesz0001
enthusiast
 
Join Date: Oct 2008
Posts: 75
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by h3r34dalootty View Post
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!!?!?!
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....
zsolesz0001 is offline   Reply With Quote
Old 02-04-2010, 09:23 AM   #2585
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by El helado Patata View Post
Tried to set it up with Postgres and first tried to copy the text in "http://****************/apps/mediawiki/fpdb/index.php?title=Howto_Setup_PostgreSQL" but have no idea where to "2. Add new login role using (run these commands in psql):"?

Shall I select "Database" and then "postgres" and run "CREATE ROLE fpdb LOGIN ENCRYPTED PASSWORD 'md51c27e7e3fef55aa28edfdc33f0b75b17' NOINHERIT CREATEDB VALID UNTIL 'infinity';
COMMENT ON ROLE fpdb IS 'fpdb db owner';
" or what?

And then "CREATE DATABASE fpdb WITH ENCODING = 'UNICODE' OWNER=fpdb;
COMMENT ON DATABASE fpdb IS 'database for fpdb project';" on postgres? I just got the error "ERROR: CREATE DATABASE cannot be executed from a function or multi-command string

********** Error **********

ERROR: CREATE DATABASE cannot be executed from a function or multi-command string
SQL state: 25001

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

Quote:
Originally Posted by El helado Patata View Post
Another note; UNICODE is not one of the options when creating a new DB.
I would e genuinely surprised if unicode wasn't an option for postgres - what version do you have installed.
Quote:
Originally Posted by Joseph Hewes View Post
Is this PyLab?
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

Quote:
Originally Posted by 1meandog4u View Post
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
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.

Quote:
Originally Posted by h3r34dalootty View Post
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..
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'

Quote:
Originally Posted by uncooper View Post
This might be a PYTHONPATH issue. Anyone have the Windows solution?
That definetly looked like a PYTHONPATH issue

Quote:
Originally Posted by zsolesz0001 View Post
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....
Where are you at right now? What step listed above?
sorrow is offline   Reply With Quote
Old 02-04-2010, 11:37 AM   #2586
El helado Patata
grinder
 
El helado Patata's Avatar
 
Join Date: Feb 2006
Posts: 651
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by sorrow View Post
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.
El helado Patata is offline   Reply With Quote
Old 02-04-2010, 11:56 AM   #2587
zsolesz0001
enthusiast
 
Join Date: Oct 2008
Posts: 75
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by sorrow View Post

Where are you at right now? What step listed above?
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..
zsolesz0001 is offline   Reply With Quote
Old 02-04-2010, 12:10 PM   #2588
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by El helado Patata View Post
Isnt python etc installed with the windows installer? Think it said that it was.
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.

Quote:
Originally Posted by El helado Patata View Post
Btw, would you be up for a teamviewer-session if I paid?
I'm not personally interested, but one of the other guys might.
Quote:
Originally Posted by El helado Patata View Post
Creating the DB just with all the standard options?

Checked and there is not a UNICODE-alternative in postgres 8.4 at least.
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
sorrow is offline   Reply With Quote
Old 02-04-2010, 12:22 PM   #2589
1meandog4u
old hand
 
1meandog4u's Avatar
 
Join Date: Apr 2007
Location: Ontario, CA (California not Canada)
Posts: 1,286
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
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.
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
1meandog4u is offline   Reply With Quote
Old 02-04-2010, 12:30 PM   #2590
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by zsolesz0001 View Post
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..
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
sorrow is offline   Reply With Quote
Old 02-04-2010, 12:54 PM   #2591
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by 1meandog4u View Post
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'm sure this will happen down the road, but it isn't something i'd hold my breath for.
Quote:
Originally Posted by 1meandog4u View Post
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
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
sorrow is offline   Reply With Quote
Old 02-04-2010, 01:12 PM   #2592
zsolesz0001
enthusiast
 
Join Date: Oct 2008
Posts: 75
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by sorrow View Post
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
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>)
zsolesz0001 is offline   Reply With Quote
Old 02-04-2010, 01:45 PM   #2593
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by zsolesz0001 View Post
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
sorrow is offline   Reply With Quote
Old 02-04-2010, 02:08 PM   #2594
1meandog4u
old hand
 
1meandog4u's Avatar
 
Join Date: Apr 2007
Location: Ontario, CA (California not Canada)
Posts: 1,286
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by sorrow View Post
Rebuilding the hudcache to use a smaller range of dates will improve performance.

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.

1meandog4u is offline   Reply With Quote
Old 02-04-2010, 02:12 PM   #2595
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by 1meandog4u View Post
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.
sorrow is offline   Reply With Quote
Old 02-04-2010, 02:33 PM   #2596
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by 1meandog4u View Post
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.

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.
sorrow is offline   Reply With Quote
Old 02-04-2010, 02:38 PM   #2597
sorrow
old hand
 
sorrow's Avatar
 
Join Date: Apr 2008
Location: Perth, Western Australia
Posts: 1,531
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by sorrow View Post
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
My bad, that link is for the wrong download - http://****************/projects/fpdb...r.exe/download
sorrow is offline   Reply With Quote
Old 02-04-2010, 02:40 PM   #2598
Joseph Hewes
self-banned
 
Join Date: Aug 2007
Location: Food and Stuff
Posts: 2,466
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Gracias, sorrow.
Joseph Hewes is offline   Reply With Quote
Old 02-04-2010, 03:25 PM   #2599
1meandog4u
old hand
 
1meandog4u's Avatar
 
Join Date: Apr 2007
Location: Ontario, CA (California not Canada)
Posts: 1,286
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

Quote:
Originally Posted by sorrow View Post
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.
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
1meandog4u is offline   Reply With Quote
Old 02-04-2010, 05:41 PM   #2600
El helado Patata
grinder
 
El helado Patata's Avatar
 
Join Date: Feb 2006
Posts: 651
Re: Free/open source poker tracking software: FPDB - (v 0.11.2-bug fixes) - 03-JUL-2009

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?
El helado Patata is offline   Reply With Quote

Reply
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Forum Jump


All times are GMT -4. The time now is 08:05 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © 2008-2017, Two Plus Two Interactive
 
Poker Players - Streaming Live Online