Is there an up-to-date, cogent, step by step information on hooking up a MySQL database to Zope in Windows? The documentation I have seen is Linux-centric in a rather dogmatic fashion. While I use and love Linux at home, at work i must use Windows. We are currently testing several possible application tools - ColdFusion, PHP4 and hopefully Zope. ColdFusion and PHP4 are up and running but even after screwing around for a whole day I can't access a MySQL database with Zope. It's quite frustrating as the Zope "concept" is quite attractive. However, it is quite arcane install-wise on the Windows platform and very poorly documented in comparison to the other products when it comes to database setup. By contrast, I got MySQL on Zope up and running on my Debian Gnu Linux machine at home with one apt-get command, walked away for a few minutes and there it was, ready to use... Now, is this a comment on Windows vs Linux or on the quality of installation / implementation on the Windows side of Zope? __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
Hi Michael, tough its Sunday and you are probably in church and not able to read this answer here is what I did the other day: Software needed: - python 1.5 http://www.python.org/1.5/ - distutils http://www.python.org/sigs/distutils-sig/download.html - MySQLdb http://www.zope.org/Members/adustman/Products/MySQLdb - ZMySQLDA http://www.zope.org/Members/adustman/Products/ZMySQLDA - Visual Studio or any other C++ compiler (have done it only with VS) - If you have no Python yet installed next to the one in zope do so. This might not be necessary. Maybe distutils can also be use with Zope's python installation. I just have not done so. - Install the distutils. If you have more than one version of Python installed you will be asked into which one. - Install MySQLdb. A directory MySQL-python-0.9.0 will be created. Change to it. - load _mysql.c into an editor. Delete all \n between line 193 and line 211. (otherwise VS generates a ton of errors) - Issue the command python setup.py build. Make sure the Python V1.5.2 is called! If not add path to the command line. - Issue the command python setup.py install --prefix k:\Programmme\Zope where the Prefix must point to your Zope installation. - Install ZMySQLDA That's it. If you have a question, I am happy to try to answer. Robert ----- Original Message ----- From: "Michael Sullivan" <johnnygaruda@yahoo.com> To: <zope@zope.org> Sent: Sunday, June 24, 2001 4:42 AM Subject: [Zope] A tale of two systems....
Is there an up-to-date, cogent, step by step information on hooking up a MySQL database to Zope in Windows?
The documentation I have seen is Linux-centric in a rather dogmatic fashion. While I use and love Linux at home, at work i must use Windows. We are currently testing several possible application tools - ColdFusion, PHP4 and hopefully Zope. ColdFusion and PHP4 are up and running but even after screwing around for a whole day I can't access a MySQL database with Zope. It's quite frustrating as the Zope "concept" is quite attractive. However, it is quite arcane install-wise on the Windows platform and very poorly documented in comparison to the other products when it comes to database setup.
By contrast, I got MySQL on Zope up and running on my Debian Gnu Linux machine at home with one apt-get command, walked away for a few minutes and there it was, ready to use...
Now, is this a comment on Windows vs Linux or on the quality of installation / implementation on the Windows side of Zope?
__________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/
_______________________________________________ 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 )
On Sat, 23 Jun 2001, Michael Sullivan wrote:
Is there an up-to-date, cogent, step by step information on hooking up a MySQL database to Zope in Windows?
The documentation I have seen is Linux-centric in a rather dogmatic fashion.
And I never, ever do any sort of development on Windows, so consequently I can't support it or even tell you how to install ZMySQLDA on Windows, save to install it in your Zope home directory, whatever that corresponds to on Windows. But if you know how to do that, then you are almost done. You still need MySQLdb, and there is a third-party Windows installer for that. I have no idea whether or not the Windows Zope binary package can find it or not, since if it's anything like the standard UNIX installation, it will go into the system-wide Python installation and not Zope's built-in Python installation. -- Andy Dustman PGP: 0xC72F3F1D @ .net http://dustman.net/andy I'll give spammers one bite of the apple, but they'll have to guess which bite has the razor blade in it.
[Michael Sullivan]
Is there an up-to-date, cogent, step by step information on hooking up a MySQL database to Zope in Windows?
Not quite what you asked for, but get the mySQL ODBC driver working, then you don't have to do anything specific about mySQL within Zope, just us a Zope ODBC data source and you'll be all set. I use ODBC to get Zope talking to SQLAnywhere, Access, Interbase, and (previously) mySQL. The only hitch I've had is that sometimes you have to set up the connect string manually and sometimes the one in the ODBC setup works, so just experiment. Otherwise, it works well. Cheers, Tom P
But this only works if you are hosting Zope on Windows, right? From what I understand, there is no ODBC adaptor for any of the *nix platforms.. Mybe somebody here knows.. What is the best way of getting access to a ODBC datasource from a Zope instance hosted on Linux? Is there a (perhaps third party) ODBC driver that runs on Linux that is cross-compatible? -Chris
[Michael Sullivan]
Is there an up-to-date, cogent, step by step information on hooking up a MySQL database to Zope in Windows?
Not quite what you asked for, but get the mySQL ODBC driver working, then you don't have to do anything specific about mySQL within Zope, just us a Zope ODBC data source and you'll be all set.
I use ODBC to get Zope talking to SQLAnywhere, Access, Interbase, and (previously) mySQL. The only hitch I've had is that sometimes you have to set up the connect string manually and sometimes the one in the ODBC setup works, so just experiment. Otherwise, it works well.
Cheers,
Tom P
[Chris Beaumont]
But this only works if you are hosting Zope on Windows, right? From what I understand, there is no ODBC adaptor for any of the *nix platforms..
That's true, Chris, but he made a point of using Windows instead of Linux.
Mybe somebody here knows.. What is the best way of getting access to a ODBC datasource from a Zope instance hosted on Linux?
Sorry, that one I can't help with. Cheers, Tom P
On Mon, 25 Jun 2001, Chris Beaumont wrote:
But this only works if you are hosting Zope on Windows, right? From what I understand, there is no ODBC adaptor for any of the *nix platforms..
Mybe somebody here knows.. What is the best way of getting access to a ODBC datasource from a Zope instance hosted on Linux?
Is there a (perhaps third party) ODBC driver that runs on Linux that is cross-compatible?
http://www.iodbc.org/ http://www.unixodbc.org/ http://www.jepstone.net/FreeODBC/ Oleg. ---- Oleg Broytmann http://www.zope.org/Members/phd/ phd@phd.pp.ru Programmers don't die, they just GOSUB without RETURN.
Mybe somebody here knows.. What is the best way of getting access to a ODBC datasource from a Zope instance hosted on Linux?
Is there a (perhaps third party) ODBC driver that runs on Linux that is cross-compatible?
-Chris I don't know anything about them, but these look kind of interesting:
On Mon, 25 Jun 2001, Chris Beaumont wrote:
But this only works if you are hosting Zope on Windows, right? From what I understand, there is no ODBC adaptor for any of the *nix platforms..
mxODBC works on UNIX. http://www.lemburg.com/files/python/mxODBC.html -- Andy Dustman PGP: 0xC72F3F1D @ .net http://dustman.net/andy I'll give spammers one bite of the apple, but they'll have to guess which bite has the razor blade in it.
participants (7)
-
Andy Dustman -
Chris Beaumont -
Eric Walstad -
Michael Sullivan -
Oleg Broytmann -
Robert Rottermann -
Thomas B. Passin