Connecting a Zope-Server to a MySQL-Server
Hi! I'm trying to get a Zope-Server to work with a remote MySQL-Server (both Suse-Linux, but I could use Windows2000 as a Zope Server if necessary) - and that seems to be a hell of a problem. Until now everything went fairly easy, but now I seem to have to: - install Python 1.5 or greater first (how do I do that?) - ensure that I have MySQL installed on your machine, INCLUDING THE FILES AND LIBRARIES NECESSARY TO DEVELOP MySQL APPLICATIONS (but I don't know what these F&L's are and I need the MySQL-Server on a remote machine) - build Zope from source - download and install MySQLdb, a newer driver to MySQL than the one that comes with ZMySQLDA - patch ZMySQLDA: copy ZMySQLDA.patch to the top-level zope dir and then patch -p1 <ZMySQLDA.patch it (what does that mean?) Isn't there an easier way? Confused Horst _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
On Tue, 29 May 2001, Horst Wald wrote:
Hi!
I'm trying to get a Zope-Server to work with a remote MySQL-Server (both Suse-Linux, but I could use Windows2000 as a Zope Server if necessary) - and that seems to be a hell of a problem. Until now everything went fairly easy, but now I seem to have to:
- install Python 1.5 or greater first (how do I do that?)
You almost certainly have it already. If you are using a pre-compiled Zope package, it has Python 1.5.2 packaged with it. Most Linux distributions come with at least Python 1.5.2. SuSE might have 2.0. Try running python from a shell and see what happens...
- ensure that I have MySQL installed on your machine, INCLUDING THE FILES AND LIBRARIES NECESSARY TO DEVELOP MySQL APPLICATIONS (but I don't know what these F&L's are and I need the MySQL-Server on a remote machine) - build Zope from source - download and install MySQLdb, a newer driver to MySQL than the one that comes with ZMySQLDA - patch ZMySQLDA: copy ZMySQLDA.patch to the top-level zope dir and then patch -p1 <ZMySQLDA.patch it (what does that mean?)
Isn't there an easier way?
That infomation is somewhat out of date and I think only applies to ZMySQLDA-1.1.x. For a precompiled package (linux-i386), see: http://www.zope.org/Members/adustman Also see: http://prdownloads.sourceforge.net/mysql-python/ZMySQLDA-2.0.7b2.linux-i386.... and http://sourceforge.net/project/showfiles.php?group_id=22307 If you have to compile MySQLdb yourself anyway, read README. You'll need a working C compiler (gcc), distutils (get from www.python.org for versions of Python older than 1.6), and MySQL libraries and include files (it looks like for SuSE, you need the package mysqldev). -- Andy Dustman PGP: 0xC72F3F1D @ .net http://dustman.net/andy "I'd rather listen to Newton than to Mundie. He may have been dead for almost three hundred years, but despite that he stinks up the room less." -- Linus T.
participants (2)
-
Andy Dustman -
Horst Wald