These mysql errors are a little mysterious to me, but I think this indicates that mysql is not running. You need to start it in the system services area of the control panel--I don't have windows right now, so I can't be more specific. The other thing that occurs to me is that you might not have restarted XP after running the installer.

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?

Quote:

Originally Posted by Eratosthenes

You can test if mysql is running by opening the mysql client that is somewhere in your start menu. Just give it your username and password and you should see a prompt like this:
mysql>
exit and enter makes it go away.

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?

I'm pretty sure mysql wasn't running, or it hasn't been
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?

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!

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

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

No idea - I'm guessing the setup.exe version may be easier.

Quote:

Originally Posted by Clemenza

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

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

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

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

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?

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.

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.

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.

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.

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.