Installing ZMySQLDA on Windows
Hi all! I want to have access to some MySQL databases from Zope, so I've tried to install ZMySQLDa, but it's just been impossible! First I have tried to follow the instructions in http://www.zope.org/Members/philh/mysql which are very easy, but some files mentioned in the how-to aren't there, so I've had to get them from somewhere else. After doing the installation, I got an error. Anyway, the how-to is about ZMySQLDA 1.1.3, which I think is quite old. Then I've tried to follow the instructions in http://www.zope.org/Members/alanpog/zmysqlda_steps , which are for Unix, but anyway it says you have to install MySQLdb, which is not there. I found it somewhere else in a windows binary distribution, but I couldn't finish the installation. So, please, has anyone got some easy instructions to install ZMySQLDA on Windows, and all the necessary files, and these in binary distribution, without having to compile them? I'm desperate! Thanks in advance, Igor Leturia
Here's a document that says how I got it working. It would be nice if this could be turned into a "Howto" on the Zope.org website, but I don't have an account there. --Derek ------------------------- Ever try to get a MySQL server and Zope running under MS-Windows? Here's what I had to do. And no, I didn't find this documented anywhere. This was a bit challenging as I haven't really used MS-Windows for anything other than gaming in about 5 years. 1. Install and start Zope 2. Install and start MySQL server (I'm using mysqld-opt.exe) 3. Install ZMySQLDA (*) You need a Windows program that can handle tarballs, as ZMySQLDA, like most Zope "Products", is not distributed as a .zip file 4. Restart Zope 5. Notice that the ZMySQLDA Product is showing as "broken" in the Zope Control Panel, because you are missing the MySQL-python interface library (distributed separately) 6. Try to install MySQL-python (filename "MySQL-python-0.9.1.win32-py2.1.exe") (*) This will fail, because the Windows installer program will only unpack the files if it can find a "Python Installation" directory to unpack it into. There is no way to specify your Zope Python install as it will only let you choose a Python install that is finds in the registry (I *think*). I.e., you fscking NEED Python to get access to the files. A .zip file was not available for download. 7. Download and install the win32 Python 2.1.2 (to match your Zope 2.5.0's Python) 8. Now install MySQL-python (it should work this time) 9. Restart Zope, and notice that the ZMySQLDA Product is broken, because it is not finding the MySQL-python interface library 10. At this point, you'll need to either (a) have payed attention to the directories the Windows Installers used, or (b) go surfing around your hard drive until you find where Zope, Python, and MySQL-python were placed. For me it was (b). 11. Identify the files needed for MySQL-python. Since MS-Window's package management system doesn't provide an "rpm -ql" equivalent, I guessed this to be C:\Python21\ _mysql.pyd _mysql_exceptions.py _mysql_exceptions.pyc _mysql_exceptions.pyo MySQLdb/ [dir with all contents] ...then I copied those files into the directory C:\Program Files\Demo\lib\python That "Demo" is the name of the directory Zope was installed into. 12. Restart Zope. Is is working? Seems to be... I can talk to the database from Zope. It is correct and stable? Fsck if I know. --Derek
I generally always use ODBC for getting Zope and MySQL to work on Windows, it is much easier to install. Just install the Zope ODBCDA, then install the MySQL ODBC connector, then configure the two and it works every time. Tom => -----Original Message----- => From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Igor => Leturia => Sent: Monday, March 18, 2002 5:27 AM => To: zope@zope.org => Subject: [Zope] Installing ZMySQLDA on Windows => => => Hi all! => => I want to have access to some MySQL databases from Zope, so I've tried => to install ZMySQLDa, but it's just been impossible! => First I have tried to follow the instructions in => http://www.zope.org/Members/philh/mysql which are very easy, but some => files mentioned in the how-to aren't there, so I've had to get them from => somewhere else. After doing the installation, I got an error. Anyway, => the how-to is about ZMySQLDA 1.1.3, which I think is quite old. => Then I've tried to follow the instructions in => http://www.zope.org/Members/alanpog/zmysqlda_steps , which are for Unix, => but anyway it says you have to install MySQLdb, which is not there. I => found it somewhere else in a windows binary distribution, but I couldn't => finish the installation. => So, please, has anyone got some easy instructions to install ZMySQLDA => on Windows, and all the necessary files, and these in binary => distribution, without having to compile them? I'm desperate! => => Thanks in advance, => => Igor Leturia => => _______________________________________________ => Zope maillist - Zope@zope.org => http://lists.zope.org/mailman/listinfo/zope => ** No cross posts or HTML encoding! ** => (Related lists - => http://lists.zope.org/mailman/listinfo/zope-announce => http://lists.zope.org/mailman/listinfo/zope-dev ) =>
I'm gonna remove that page, http://www.zope.org/Members/philh/mysql, since it's way out of date. However I have a ray of sunshine for Zope/Win32/MySQL users. Go here: http://www.cs.fhm.edu/~ifw00065/index.shtml and get the Win32 Installer for Zope/Mysql, it puts the MySQL stuff into your normal Zope hierarchy, it says it works with zope2.4 but I can verify that it works fine with Zope2.5. hth Phil ----- Original Message ----- From: "Igor Leturia" <IGOR@emun.com> To: <zope@zope.org> Sent: Sunday, March 17, 2002 7:27 PM Subject: [Zope] Installing ZMySQLDA on Windows
Hi all!
I want to have access to some MySQL databases from Zope, so I've tried to install ZMySQLDa, but it's just been impossible! First I have tried to follow the instructions in http://www.zope.org/Members/philh/mysql which are very easy, but some files mentioned in the how-to aren't there, so I've had to get them from somewhere else. After doing the installation, I got an error. Anyway, the how-to is about ZMySQLDA 1.1.3, which I think is quite old. Then I've tried to follow the instructions in http://www.zope.org/Members/alanpog/zmysqlda_steps , which are for Unix, but anyway it says you have to install MySQLdb, which is not there. I found it somewhere else in a windows binary distribution, but I couldn't finish the installation. So, please, has anyone got some easy instructions to install ZMySQLDA on Windows, and all the necessary files, and these in binary distribution, without having to compile them? I'm desperate!
Thanks in advance,
Igor Leturia
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (4)
-
Derek Simkowiak -
Igor Leturia -
Phil Harris -
Tom Cameron