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

08-29-2008 , 11:14 AM
One, I am not mixing up length or complexity. I was very specific about using the words “the average person” again and again. And keeping things simple both in length and complexity is key. For the average person those two words are often synonymous (especially with regards to computer instructions). This project will not reach a critical mass of people involved until the install is simple and a HUD is include. Having 50 people with this thing up and running is a far cry from thousands of people.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-29-2008 , 07:51 PM
Quote:
Originally Posted by 2tonbobby
The Windows install documentation is 31 steps long. The average person would find that too complicated to undertake. And it is the average person that this project needs. I think the average person would love to do what they are use to doing just clicking one button that says download. Then cha-ching everything, and I do mean everything, is loaded in one simple step. IMHO this project is just too complicated at this point.
As an avg person, I can attest to the level of frustration from going through the steps and watching a black box pop up after clicking on the fpdb.py file and then close and then nothing.

I don't even know where to begin looking for where I screwed up in the process.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-29-2008 , 09:35 PM
Quote:
Originally Posted by Gallopin Gael
I don't even know where to begin looking for where I screwed up in the process.
I just put together a troubleshooting guide, to determine why it isn't running. While putting it together I became even more convinced that we need to get busy on a windows installer and I am going to propose to Steffen that we don't make another release until be have one.

OK, so here is the troubleshooting process:

You could just skip to 5 and see what happens there. It might give you a clue on the rest of this stuff.

1. You rebooted after the install process, right? If not, try rebooting before you start the rest of this torture.

2. Check to see if you have a default.conf file:

open a command line and type:

dir c:\"Documents and Settings"\YOUR_USER_NAME\"Application Data"\fpdb

you should see this:

Directory of c:\Documents and Settings\YOUR_USER_NAME\Application Data\fpdb

08/29/2008 09:15 PM <DIR> .
08/29/2008 09:15 PM <DIR> ..
08/26/2008 09:28 PM 249 default.conf
1 File(s) 249 bytes
2 Dir(s) 21,159,768,064 bytes free

If you don't see a default.conf file. You need to copy the one in the docs dir where you installed fpdb.

3. OK here's a simple way to see if you have the prerequisite libraries installed:

open a command line and type:

C:\Python25\python.exe

and enter.

You should see a >>> prompt of the python interpreter. Here is an annotated interpreter session on my machine, testing that I have the required libraries installed properly.

>>> <----I just hit some enters here to get some spaces
>>>
>>>
>>> import pycairo
Traceback (most recent call last): <---This is failure. There is no pycairo library
File "<stdin>", line 1, in <module>
ImportError: No module named pycairo
>>>
>>>
>>> import cairo <-------This is success, cairo library installed OK. If it didn't, then it is step 28 that went wrong.
>>>
>>>
>>> import pygtk <----- If this failed then step 30 went bad
>>>
>>>
>>> import gtk <----- steps 24-27
>>>
>>>
>>> import MySQLdb <------- 23
>>>
>>>
>>>
>>> import gobject <-------- 29
>>>
>>>
>>>

type cntrl-Z and enter to get out
If you didn't get any errors. Then all the libraries are properly installed. If you did, just repeat the step for the library that didn't install properly.

4. OK, while you have that command line type:

path
and hit enter

You should see something like:

PATH=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\Sys tem32\Wbem;c:\gtk\bin

Only much longer. The key thing is that you see the c:\gtk\bin bit. It should also be separated from the dirs before and after by a semicolon.

5. OK. If everything is fine so far you need to cd to the dir where you installed fpdb. For me that is:

cd Desktop\Download\fpdb\fpdb-alpha2-p68\pyfpdb
and hit enter

type:

fpdb.py
and hit enter
You should see the fpdb main screen. If not you should get a human readable error message in the command line window. What is it?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-29-2008 , 09:59 PM
Quote:
Originally Posted by Eratosthenes
.. While putting it together I became even more convinced that we need to get busy on a windows installer and I am going to propose to Steffen that we don't make another release until be have one.
..
I am certainly above average, when it comes to PC's, and I opened the install readme, and immediately closed it and deleted the download. Far too complex for the average (or above average) PC user. I am also waiting for a installer package.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-29-2008 , 10:40 PM
make a release including postgresql support and windows installation utilities / scripts will take care of themselves imo.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-30-2008 , 04:13 AM
Quote:
Originally Posted by Eratosthenes
I just put together a troubleshooting guide, to determine why it isn't running. While putting it together I became even more convinced that we need to get busy on a windows installer and I am going to propose to Steffen that we don't make another release until be have one.
I'll give this a shot in the morning after my fantasy draft.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-30-2008 , 12:24 PM
Quote:
Originally Posted by _dave_
make a release including postgresql support and windows installation utilities / scripts will take care of themselves imo.
this.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-30-2008 , 01:46 PM
I took a look at the installation instructions, but at this point it really is
tl:dr

Quote:
Installing in Windows
These instructions were made with Windows XP. They should also work with Windows NT / 2000 / 2003 / Vista and 2008. Please report any differences to gmic at users.****************.

If you're still using Win3/95/98/ME then you should switch to GNU/Linux, *BSD or WinXP.

An Installer will be made at some point.


1. Click here to open the MySQL Download Page. Click on the "No, thanks..." link to see the download links for the MySQL installer.

2. Click on one of the HTTP or FTP download links to download the zip file (mysql-5.0.67-win32.zip).

3. Unzip the setup file to a folder of your choice and double-click on it. On the welcome screen click "Next".

4. As the setup type "Typical" should be selected. Then click "Next". On the following screen click "Install" and installation will begin.

5. Before the installation ends an ad for MySQL Enterprise edition will appear. Just click "Next" two times.

6. Now make sure that "Configure the MySQL Server now" is checked and click "Finish".

7. You are now looking at the MySQL Configuration Wizard. Click "Next".

8. Make sure "Detailed Configuration" is selected. Then click "Next. Now "Developer machine" should be selected. Click "Next".

9. On this screen "Multifunctional Database should be selected. Click "Next". On the next screen (InnoDB Tablespace) just click "Next".

10. Now "Decision Support" should be selected. Click "Next". Now make sure "Enable TCP/IP Networking" IS selected. Then click "Next".

11. Here "Standard Character Set" should be selected. Click "Next". Now make sure "Install As Windows Service" is selected.

12. Now choose a root password. This will NOT be the password for your poker database. Click "Next".

13. On this last screen of the Configuration Wizard just click "Execute." A few success messages will appear. Click "Finish".

14. Now click the Windows Start Button and then click "Run". Click into the white space of the new window, type cmd and hit ENTER.

15. In the newly appeared console window type cd "%PROGRAMFILES%\MySQL\MySQL Server 5.0\bin" and hit ENTER.

16. Type mysql --user=root --password=yourPassword and hit ENTER (replace yourPassword with your chosen root password).

17. A few lines followed by mysql> will appear. This is the MySQL command prompt.

18. We will now create your poker database. Type CREATE DATABASE fpdb; and hit ENTER. "Query OK" says we were successful.

19. Type the following, replace newPassword with a password of your choice and hit ENTER:

GRANT ALL PRIVILEGES ON fpdb.* TO 'fpdb'@'localhost' IDENTIFIED BY 'newPassword' WITH GRANT OPTION;

20. Again it says "Query OK". Type exit and hit ENTER to exit the MySQL prompt. Leave this window open. We will need it later.

21. Click here, save the file python-2.5.2.msi where you want and double-click on it. In case of a warning window click "Execute".

22.Click "Next" three times. Python will install. Then click finish.

23. Click here, save MySQL-python-1.2.2.win32-py2.5.exe to a folder of your choice and double click it. In case of a warning window click "Execute". Click "Next" three times. The Python API for MySQL will install. Click "Finish".

24. In the console window (which we left open) now type: mkdir c:\gtk and hit ENTER. Leave the window open again, we'll need it.

Now click here and save the gtk zip file gtk+-bundle-2.12.11.zip to a folder of your choice. Unzip its contents to C:\gtk

25. Now right-click "My Computer" (on your Desktop) and click on "Properties". Now click on the tab "Advanced".

26. Click the button "Environ Variables". In the lower list of the new window click on "Path" (possibly you need to scroll).

27.Now click on the"Edit" button and a new window will pop up. To the value of the variable append ;C:\gtk\bin Click Ok three times.

28. Click here, save the file pycairo-1.4.12-1.win32-py2.5.exe to a folder of your choice and double click on it. In case of a warning window click "Execute". Now click "Next" three times. The pycairo graphics library API for Python will install. Click "Finish".

29. Click here, save the file pygobject-2.14.1-1.win32-py2.5.exe to a folder of your choice and double click on it. In case of a warning click "Execute". Now click "Next" three times. The Python Gobject API will install. Click "Finish".

30. Click here, save the file pygtk-2.12.1-2.win32-py2.5.exe to a folder of your choice and double click on it. In case of a warning click "Execute". Now click "Next" three times. The Python API for Gtk+ will install. Click "Finish".

31. In the console window now type: mkdir "%homepath%\Application Data\fpdb" and hit ENTER. Copy the file "default.conf" from the docs folder of your fpdb git to the directory C:\%homepath%\Application Data\fpdb\.

32. Now open the file "default.conf" in WordPad (Start > Programs > Accessoirs > WordPad) and replace the password in the dbpassword line with your chosen password for the fpdb user.

33. Now start FPDB by double-clicking on the file fpdb.py in the folder fpdb. A console window should open up and shortly thereafter the fpdb application window should be visible. Click on the menu "Database" and select "Create or Recreate Tables".

Congratulations! Your fpdb installation is complete! Now you can use the bulk importer to import your hands into fpdb.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-30-2008 , 03:30 PM
I hope I'll make some of you happy when I say that I have started to script an installer for fpdb. Right now I don't see a reason why a first version shouldn't be out in the next 48 hours. (I'll let you know if I get stuck in a major way.)

2tonbobby was all for it so behold good Sirs your one-click-install is on it's way.
This means it will set the root password for mysql for you and do some other stuff without asking (no, I am not blowing up your PC). This is the fastest way to get an installer out there and it will probably not work out for everybody because of specific computer setups.
With some more days time I will try to make it fool proof and more communicative, e.g. so that you can choose your root password yourself for example.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-30-2008 , 05:19 PM
Quote:
Originally Posted by One
I hope I'll make some of you happy when I say that I have started to script an installer for fpdb. Right now I don't see a reason why a first version shouldn't be out in the next 48 hours. (I'll let you know if I get stuck in a major way.)

2tonbobby was all for it so behold good Sirs your one-click-install is on it's way.
This means it will set the root password for mysql for you and do some other stuff without asking (no, I am not blowing up your PC). This is the fastest way to get an installer out there and it will probably not work out for everybody because of specific computer setups.
With some more days time I will try to make it fool proof and more communicative, e.g. so that you can choose your root password yourself for example.
Good news...looking forward to it.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-30-2008 , 06:26 PM
Still having problems with pygtk under Mac

galileayfpdb glpunzi$ port installed py25-mysql py25-mysql gtk2
The following ports are currently installed:
py25-mysql @1.2.2_0+mysql5 (active)
py25-mysql @1.2.2_0+mysql5 (active)
gtk2 @2.12.9_0+x11 (active)
galileayfpdb glpunzi$

In theory, I have all installed. Some advice?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-30-2008 , 06:34 PM
I forgot the error sorry :P

galileayfpdb glpunzi$ python fpdb.py
Traceback (most recent call last):
File "fpdb.py", line 21, in <module>
import pygtk
ImportError: No module named pygtk
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-30-2008 , 07:53 PM
Hi,
I'm back from Leeds now. First, if anyone wants more regular updates of fpdb than the alpha releases but doesn't want to use git pls send me an email and I'll send them.

Quote:
Originally Posted by YoureToast
The bottom line is that there are way too many steps for the average user to get this thing rolling. At this stage, its fine but eventually that is an issue that needs to be addressed.
Only in low end OS' that come without full software manager (Windows, MacOSX)
Seriously though, you're completely right. I will add some error notifications so that for example a missing config file will not make a black window appear and disappear but display an error message in the GUI. Also Michael is working on the installer so hopefully the next alpha will be alot easier.


Please be patient however, we appreciate your pain, but you also have to see our side: we've already spent hundreds of (unpaid) hours on this, and we have to balance your needs, our own needs, and last but not least "the big picture" of making sure fpdb makes meaningful progress on actual functionality. If you look past the installation you'll see that progress is being made.

Quote:
Originally Posted by Lord_ZealoN
I forgot the error sorry :P

galileayfpdb glpunzi$ python fpdb.py
Traceback (most recent call last):
File "fpdb.py", line 21, in <module>
import pygtk
ImportError: No module named pygtk
I didn't realse MacOSX has ports - is this on "original" MacOS or did you have to install third party software e.g. from FreeBSD?
In any case, check for a port for pygtk - installing that and it's dependencies might already fix it.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-30-2008 , 09:31 PM
I am a big fan of open source software. I am also happy this project, from the beginning, is tackling multiple games (not just Hold'em) and multiple operating systems. That is no small feat. The hard work is recognized and appreciated. Kudos to the people at the forefront of this project.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-30-2008 , 09:59 PM
Quote:
Originally Posted by Lord_ZealoN
I forgot the error sorry :P

galileayfpdb glpunzi$ python fpdb.py
Traceback (most recent call last):
File "fpdb.py", line 21, in <module>
import pygtk
ImportError: No module named pygtk
Here is the poo on pygtk for mac. Getting it going looks not easy. To get this to work you will have to install both gtk and pygtk.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-30-2008 , 10:27 PM
Quote:
Originally Posted by Eratosthenes
You should see the fpdb main screen.
you're my hero

Thank you.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-31-2008 , 05:45 AM
Seems like problems with GTK was solved. Was needed to uninstall pygtk, clean the port, and export PYTHONPATH with the sitepackages for python 2.5

Now, I'm fighting gainst MYSQL.

I will post a Step by Step installation for MacOS when ready.

EDITED:
Port (MacPorts) is a third party. http://www.macports.org/

EDITED2:

I think, you use a layer between DB communication and RDBMS.

Could be interesting to add sqlite to his layer for example, to avoid the installation of MySql for the first installation for example.

Last edited by Lord_ZealoN; 08-31-2008 at 05:50 AM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-31-2008 , 06:33 AM
The installation process is incredibly frustrating and difficult.

I get error when I try to run fpdb.py. What should I do?


Traceback (most recent call last):
File "C:\fpdb\pyfpdb\fpdb.py", line 27, in <module>
import GuiBulkImport
File "C:\fpdb\pyfpdb\GuiBulkImport.py", line 20, in <module>
import fpdb_import
File "C:\fpdb\pyfpdb\fpdb_import.py", line 21, in <module>
import MySQLdb
ImportError: No module named MySQLdb
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-31-2008 , 06:34 AM
This error is for python-mysql not installed.

What OS you use?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-31-2008 , 06:50 AM
OK, I missed a step and fixed it.

When I try to import hand histories, (I save it temporarily in C:\newhud), I click on Import -> Bulk IMport -> Browse (finding my directory)? I can't find anyway reliable to determine my path, because everytime I click on, the file name of a hand history is selected (instead of the path). I get this in the path to auto-import box C:\newhud\083120080201616_HH20080831......... (it should be a path, not a file name)

ANyway, I try to type in my path manually in the box, (C:\newhud), when I click start autoimport, I get this message.

Traceback (most recent call last):
File "C:\fpdb\pyfpdb\GuiAutoImport.py", line 67, in startClicked
self.pipe_to_hud = subprocess.Popen(command, bufsize = 1, stdin = subprocess
.PIPE)
File "C:\Python25\lib\subprocess.py", line 594, in __init__
errread, errwrite)
File "C:\Python25\lib\subprocess.py", line 816, in _execute_child
startupinfo)
WindowsError: [Error 193] %1 is not a valid Win32 application

I also get
"failed to read settings table - please recreate tables " in first line of the console.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-31-2008 , 07:00 AM
Quote:
Originally Posted by Bab00nf1sh
OK, I missed a step and fixed it.

When I try to import hand histories, (I save it temporarily in C:\newhud), I click on Import -> Bulk IMport -> Browse (finding my directory)? I can't find anyway reliable to determine my path, because everytime I click on, the file name of a hand history is selected (instead of the path). I get this in the path to auto-import box C:\newhud\083120080201616_HH20080831......... (it should be a path, not a file name)

ANyway, I try to type in my path manually in the box, (C:\newhud), when I click start autoimport, I get this message.

Traceback (most recent call last):
File "C:\fpdb\pyfpdb\GuiAutoImport.py", line 67, in startClicked
self.pipe_to_hud = subprocess.Popen(command, bufsize = 1, stdin = subprocess
.PIPE)
File "C:\Python25\lib\subprocess.py", line 594, in __init__
errread, errwrite)
File "C:\Python25\lib\subprocess.py", line 816, in _execute_child
startupinfo)
WindowsError: [Error 193] %1 is not a valid Win32 application

I also get
"failed to read settings table - please recreate tables " in first line of the console.
When you opened for the first Time FPDB, did you "Database>>Create recreate tables"?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-31-2008 , 09:40 AM
Quote:
Originally Posted by Lord_ZealoN
Could be interesting to add sqlite to his layer for example, to avoid the installation of MySql for the first installation for example.
I'm glad you mentioned this. One mentioned sqlite to me a couple of days ago and it has been running around in my head since.

Sqlite now comes standard with python installations, so anybody that has a modern version of python has sqlite. Therefore, somebody that just wants to try fpdb could do so without the bother of a heavier-duty db manager. Sqlite is blazing fast but does not handle large databases very well, so it is not useful for guys with big dbs--I have no idea how many hands it takes for Sqlite to start having a problem, it might be a lot.

I am going to work on postgres integration this afternoon, I will look at sqlite at the same time. (umm, when I say "work on postgres", do immediately assume that there will be postgres support later today--I first want to see exactly how painful this could be.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-31-2008 , 09:51 AM
I think sqlite can move some hundreds of MB without problems. And, a hand, don't must be greater than 1kb.

I think is factible.


Quote:
Originally Posted by Eratosthenes
I'm glad you mentioned this. One mentioned sqlite to me a couple of days ago and it has been running around in my head since.

Sqlite now comes standard with python installations, so anybody that has a modern version of python has sqlite. Therefore, somebody that just wants to try fpdb could do so without the bother of a heavier-duty db manager. Sqlite is blazing fast but does not handle large databases very well, so it is not useful for guys with big dbs--I have no idea how many hands it takes for Sqlite to start having a problem, it might be a lot.

I am going to work on postgres integration this afternoon, I will look at sqlite at the same time. (umm, when I say "work on postgres", do immediately assume that there will be postgres support later today--I first want to see exactly how painful this could be.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-31-2008 , 10:28 AM
Quote:
Originally Posted by Bab00nf1sh
WindowsError: [Error 193] %1 is not a valid Win32 application
This is my bad. fpdb is trying to start the HUD and sending a bad command to windows. Worked on Linux! I have fixed this, but have not pushed it up to the git tree yet--I will post here when this fix is in the git tree. It will be fixed in the next release. That release will also have a useful HUD for both Windows and Linux.

Quote:
Originally Posted by Bab00nf1sh
I also get
"failed to read settings table - please recreate tables " in first line of the console.
When you open fpdb for the first time you need to go to the Database menu and select Create or Recreate tables. This will set up a new empty database--it will also wipe out any data in a previous fpdb database.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
08-31-2008 , 01:55 PM
any plans to make a install wizard ?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m