Quote:
Originally Posted by Eratosthenes
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?
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)")