I'm pretty sure mysql wasn't running, or it hasn't been completely installed, since it didn't appear anywhere in the start menu or in control panel, nor was it in the running processes list in task manager, however the MySQL folder was in program files. I did remember to restart XP after running the installer.

I removed all mysql files, fpdb installer and alpha files (but kept Python, since I do see it in the start menu) and then re-installed the installer, but this time without my zonealarm security suite running. The installation went more smoothly than the first time and I then restarted XP. The mysql folder is back in program files, but mysql still doesnt appear in the start menu or running processes list.

Should I have a mysql link in the start menu after running the fpdb installer? Is there a file in the mysql folder (in program files), that I can use to run mysql or install or configure mysql?

I chose a password for mysql (and the poker db) during instalation, but do not have a mysql username. Do I need one? How do I do that?

What is the .tar file? Is this recommended as opposed to the zip file?

Here is the latest error log. Thanks again for your help!

Traceback (most recent call last):
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 511, in <module>
me = fpdb()
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 424, in __init__
self.load_default_profile()
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 252, in load_default_profile
self.load_profile(defaultpath)
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 330, in load_profile
self.db.connect(self.settings['db-backend'], self.settings['db-host'], self.settings['db-databaseName'], self.settings['db-user'], self.settings['db-password'])
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb_db.py", line 43, in connect
self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database)
File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
return Connection(*args, **kwargs)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

Right click My Computer, select manage
Services and Applications -> Services

You should have MySQL in the services list, does it show its status as Started? If not start it and try running fpdb again.

You may also need to make an exception for localhost for the MySQL process in ZoneAlarm. (Port 3306)

Thank-you, Sorrow and Eartosthenes!

I did find MySQL in the services list but I am unable to start it. I keep getting:
"Could not start the MySQL service on Local Computer. Error 1067: The process terminated unexpectedly."

I tried changing the "Log On" settings in MySQL properties (from the services list in Computer Management) to logon as Administrator including my PC's administrator password. But I still get the error message when I try to start MySQL.

Any other ideas? I feel like I'm getting closer to getting this to work. Persistency pays!

I finally decided to run the install on a windows xp machine to see what it looks like - and i'm getting exactly the same message when trying to start MySQL.

I'll see if i can't track it down.

Can you try running from a command prompt

cd \program files\mysql\mysql 5.0\bin
mysqld --standalone --console

I'm getting:
Files\MySQL\MySQL Server 5.0\bin>mysqld --console --standalone
081029 13:58:00 [ERROR] Can't find messagefile 'C:\Programme\MySQL\MySQL Server
5.0\share\english\errmsg.sys'
081029 13:58:00 [ERROR] Aborting

Which make it look like the installer got the language wrong.

I'll see if i can figure which files need to be edited, for now though you might want to download and run the mysql installer from http://dev.mysql.com/downloads/mysql/5.0.html#win32

Sorrow, From the command prompt, all I could get is:

C:\Documents and Settings\BP>cd \program files\mysql\mysql 5.0\bin
The system cannot find the path specified.
C:\Documents and Settings\BP>cd \
C:\>cd \program files\mysql\mysql 5.0\bin
The system cannot find the path specified.
C:\>cd \program files\mysql\mysql 5.0\bin
The system cannot find the path specified.


Do you recommend the "Windows Essentials" version of MySQL v5.0? Or are extra tools, or another version needed.

Also, should I delete the MySQL folder in Program Files or just install over what I have? (MySQL soes not appear in my Add/Delete Programs and there are no start menu shortcuts, however the MySQL folder in Program Files appeared after I ran the fpdb installer.)

Sorry, didn't copy and paste.

cd \program files\mysql\mysql server 5.0\bin
No idea - I'm guessing the setup.exe version may be easier.

Try installing over the top, if that fails uninstall then delete and see if that makes a difference.

Okay, thanks. This time I got:

C:\>cd \program files\mysql\mysql server 5.0\bin

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqld --standalone --console
081029 2:06:34 [ERROR] Can't find messagefile 'C:\Programme\MySQL\MySQL Server
5.0\share\english\errmsg.sys'
081029 2:06:34 [ERROR] Aborting

I'll try downloading and installing MySQL again tomorrow and see if that does the trick.

Ok, Same error.

c:\program files\mysql\mysql server\5.0\my.ini

Has 2 lines in it that need editing:
basedir=
datadir=

Change "Programme" to "Program Files" and you should be able to start mysqld, same instructions as previously.

I now have another error with gtk, I suspect its from a previous install of gtk from Gimp

Excellent! I just edited those 2 lines and MySQL is now running.
Sorrow, thanks for fixing that!

If you or anyone can advise, I'm now apparently having a password problem. According to previous posts in this thread, I think the info is correct but last line in the error file is "Access denied for user...":

Traceback (most recent call last):
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 511, in <module>
me = fpdb()
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 424, in __init__
self.load_default_profile()
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 252, in load_default_profile
self.load_profile(defaultpath)
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 330, in load_profile
self.db.connect(self.settings['db-backend'], self.settings['db-host'], self.settings['db-databaseName'], self.settings['db-user'], self.settings['db-password'])
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb_db.py", line 43, in connect
self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database)
File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
return Connection(*args, **kwargs)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'BP'@'localhost' (using password: YES)")


My default.conf in Application Data\fpdb is:

db-backend=2
db-host=localhost
db-databaseName=fpdb
db-user=BP (my PC's Admin name)
db-password=**** (the MySQL Root Password I chose during fpdb install)
tv-combinedStealFold=True
tv-combined2B3B=True
tv-combinedPostflop=True
bulkImport-defaultPath=default
hud-defaultPath=default
imp-callFpdbHud=True


Is this correct?

Will I need to use the "Poker DB User Password" that I also chose during fpdb install?

Do I need to adjust the settings in Computer Management > Services > MySQL > Properties > Log On. Right now I have it set to "Log on as: Local System account".

Thanks so much!

the db-password is the Poker DB password, but i suspect that was never set during setup due to your previous problem

Local System Account is correct, it should work either way though.

From a command prompt:
cd \program files\mysql\mysql server 5.0\bin

mysql -u root -p
(Enter password here - may be blank due to error)
> create database fpdb;
> GRANT ALL PRIVILEGES on fpdb.* to fpdb identified by 'fpdbpassword';
> FLUSH PRIVILEGES;
> exit

Then try and run fpdb again.

Thanks, Sorrow.

From the command prompt I was able to just hit enter instead of the password (all passwords attempted did not work anyway), so I guess I don't have a MySQL root password yet. I entered all of the info and granted all privileges to the Poker DB Password I chose during fpdb install which is now also the same as is in the default.conf file in the Application Data folder.

But fpdb still does not work when I click on fpdb.py in the pyfpdb folder.
The latest error code is below.
Do I need a root password for MySQL?
What should db-user= be in the default.conf file?
Am I missing something obvious?

Traceback (most recent call last):
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 511, in <module>
me = fpdb()
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 424, in __init__
self.load_default_profile()
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 252, in load_default_profile
self.load_profile(defaultpath)
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb.py", line 330, in load_profile
self.db.connect(self.settings['db-backend'], self.settings['db-host'], self.settings['db-databaseName'], self.settings['db-user'], self.settings['db-password'])
File "C:\Program Files\FPDB\fpdb-1.0_alpha8_p137\pyfpdb\fpdb_db.py", line 43, in connect
self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database)
File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
return Connection(*args, **kwargs)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'BP'@'localhost' (using password: YES)")

Its not you its me.... (Note: db-password is the fpdb password, not the root password)

cd to the mysql server /bin folder from command prompt again.

Try:
mysql -u BP -p
(fpdb password)

If that fails, i'm pretty sure we forgot to create the user properly. Teach me to do support from memory.

mysql -u root -p
(root password, still <enter> I think)
> GRANT ALL PRIVILEGES ON fpdb.* TO 'BP'@'localhost' IDENTIFIED BY 'some_pass';

Then try it again with same config file.

FYI, to get the HUD working you'll need to edit HUD_config.xml and add the same username and password

The mysql -u BP -p did not work when I entered the fpdb password.

I tried the second option with 'some_pass' as the fpdb db-password and didnt receive any error messages and then typed "exit", but still no luck in getting fpdb to run.

I then ran the first command again trying the fpdb password but received:
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u BP -p
Enter password: ********
ERROR 1045 (28000): Access denied for user 'BP'@'localhost' (using password: YES)

Then I tried again, but hit enter (no password) and got:
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u BP -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.0.67-community MySQL Community Edition (GPL)
mysql>


Does this mean I have no password for MySQL or the fpdb???

Actually, here is the command prompt screenshot after I just tried the "mysql -u root -p" and just hit enter when prompted for a password:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\BP>cd \program files\mysql\mysql server 5.0\bin

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.67-community MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES ON fpdb.* TO 'BP'@'localhost' IDENTIFIED BY 'myfpdbpassword'
->

Does this help figure out what the problem is?

someone might want to research if upper-case usernames are accepted in MySQL, i wouldn't know why they wouldn' tbe, but just seems like something that could be a problem.

I had the c:\programme\mysql .. problem, too, but as soon as i fixed that, the service started right up, and i was able to connect using the username and password that i selected when i ran the installation.

When did you select a username during installation?

I recall selecting and confirming a Poker DB Password and a MySQL root password, but no username.

This statement needs a semicolon ( ; ) at the end

That is
mysql> GRANT ALL PRIVILEGES ON fpdb.* TO 'BP'@'localhost' IDENTIFIED BY 'myfpdbpassword';

Weird - didn't get an email notification you'd responded - sorry.

in mysql just to confirm a couple of things.

> show databases;

and make sure fpdb is there.

After the GRANT ALL command, you must:
> FLUSH PRIVILEGES;

Or it won't take, i had that in my original post but forgot in the next couple.

One more thing from within mysql

> use mysql;
> select user, host from user;

It's almost working! Thank-you Sorrow and Eratoshtenes!

I also edited the HUD_config file and added my fpdb password and username. When I clicked on fpdb.py the application opened along with a command prompt indicating that it failed to load graphing and that I need to recreate the tables. After I clicked "Recreate Tables" in the "Database" dropdown menu, the comand prompt said "finished recreating tables". I'm going to continue playing around with it and post again on my progress.

Here is my command prompt after trying all of the above.

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -u root -p
Enter password: (I just clicked "enter")
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.67-community MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases; (It looks like the fpdb database is here)
+--------------------+
| Database |
+--------------------+
| information_schema |
| fpdb |
| mysql |
| test |
+--------------------+
4 rows in set (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON fpdb.* TO 'BP'@'localhost' IDENTIFIED BY 'myfpdbpassword';
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

mysql> use mysql;
Database changed
mysql> select user, host from user;
+------+-----------+
| user | host |
+------+-----------+
| fpdb | % |
| root | 127.0.0.1 |
| | localhost |
| BP | localhost |
| bp | localhost |
| root | localhost |
+------+-----------+
6 rows in set (0.00 sec)

mysql> exit
Bye

C:\Program Files\MySQL\MySQL Server 5.0\bin>

It looks like you are running OK. You could try the bulk importer now.

Fpdb is running fine now. No more MySQL issues.
Thanks everyone for your help!

I ran the bulk importer. The HUD is working well with Stud, Hi/Lo and Razz.

This is an excellent application!

Good to hear.

The graphing wont work without matplotlib, numpy and pylab which aren't included in the windows installer yet. For *nix these are standard packages, but i've not found (nor looked too hard to be honest) a "nice" windows installer for these additional python modules yet.

For the ambitious the home pages:
http://numpy.scipy.org/
http://scipy.org/ (http://prdownloads.****************/s...5.exe?download)
http://matplotlib.****************/

Real multitabling support has been added to the fpdb git tree, mostly due to the work of ekdikeo (yeah, we have 4 developers now--all are welcome). Stat windows will be appropriately hidden when you are using cascaded/stacked tables.

This has been tested on Linux and Windows, though Stars is not popping up tables correctly for me on Linux, it is not a problem with fpdb. This has not been tested on Full Tilt, but I don't see any reason why it won't work on FTP.

The other recent addition that might be interesting to the multitable crowd is preferred seat support on PokerStars. To get that going you need to edit your HUD_config.xml file, find the correct line that looks like this:

<layout fav_seat="5" height="546" max="8" width="792">

and set the fav_seat to the one that you have set up in PokerStars. Note that the example above is for an 8 max table; be sure to select the correct max. Setting fav_seat="0" turns off the feature.

We would be interested in feedback from anybody using these features.

This is not in the main repo yet and is not in a release, so get it with git from my repo with:

git clone git://git.assembla.com/free_poker_tools.git

Lastly, you may think that not much has been done on this recently, but there have been some good "infrastructure" improvements that users don't see but will provide convenience and stability later on, plus some good ease of use things that aren't ready for prime time, like consolidating the config files and improving the windows installer.