Z MySQL database adapter
HI I am new to Zope and have been trying to set up a connection from Zope to my Mysql datatbase. Z MySQL database adapter asks that I have the _mysql extension installed. But I can't seem to get it to happen for me. I don't have root permissions on the webhost. Is there anyway for me to install _mysql? Thanks Aaron
Aaron wrote:
HI I am new to Zope and have been trying to set up a connection from Zope to my Mysql datatbase.
Z MySQL database adapter asks that I have the _mysql extension installed. But I can't seem to get it to happen for me.
I don't have root permissions on the webhost. Is there anyway for me to install _mysql?
Thanks Aaron
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
MySQLdb must be installed into the same python that is ued by your zope. So if you have installed Zope yourselb you should be able to install MuSQLdb as well. Otherwise you must ask the admin to do so. Robert
Aaron wrote at 2004-5-2 14:16 -0400:
... Z MySQL database adapter asks that I have the _mysql extension installed. But I can't seem to get it to happen for me.
Do you already have a binary ("_mysql.so" on Unix, "_mysql.pyd" on Window)?. If so, put it in some directory on your PYTHONPATH, e.g. "<ZopeDir>/lib/python". Otherwise, you must generate the "_mysql.so" extension. The source lives on Sourceforge (project "Mysql-python" or "Python-Mysql"). -- Dieter
You need to have installed PyMYSQLd in the python you are using for Zope (that is, run setup.py with that python). On Sun, 2 May 2004, Dieter Maurer wrote:
Aaron wrote at 2004-5-2 14:16 -0400:
... Z MySQL database adapter asks that I have the _mysql extension installed. But I can't seem to get it to happen for me.
Do you already have a binary ("_mysql.so" on Unix, "_mysql.pyd" on Window)?. If so, put it in some directory on your PYTHONPATH, e.g. "<ZopeDir>/lib/python".
Otherwise, you must generate the "_mysql.so" extension. The source lives on Sourceforge (project "Mysql-python" or "Python-Mysql").
-- Dieter
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Dennis Allison wrote at 2004-5-2 11:26 -0700:
You need to have installed PyMYSQLd in the python you are using for Zope (that is, run setup.py with that python).
That is the easiest way provided you have write access to this Python installation. Otherwise, any directory listed by "PYTHONPATH" (or more precisely "sys.path") will do.
On Sun, 2 May 2004, Dieter Maurer wrote: ...
Do you already have a binary ("_mysql.so" on Unix, "_mysql.pyd" on Window)?. If so, put it in some directory on your PYTHONPATH, e.g. "<ZopeDir>/lib/python".
Otherwise, you must generate the "_mysql.so" extension. The source lives on Sourceforge (project "Mysql-python" or "Python-Mysql").
-- Dieter
Whew some success I got past this problem. Now I get the following error: /usr/lib/python2.3/config/Setup.thread: No such file or directory do I need to recompile python to get this file?? Is this something to do with it being threaded? Thanks Aaron On ב', 2004-05-03 at 20:19, Dieter Maurer wrote:
Dennis Allison wrote at 2004-5-2 11:26 -0700:
You need to have installed PyMYSQLd in the python you are using for Zope (that is, run setup.py with that python).
That is the easiest way provided you have write access to this Python installation.
Otherwise, any directory listed by "PYTHONPATH" (or more precisely "sys.path") will do.
On Sun, 2 May 2004, Dieter Maurer wrote: ...
Do you already have a binary ("_mysql.so" on Unix, "_mysql.pyd" on Window)?. If so, put it in some directory on your PYTHONPATH, e.g. "<ZopeDir>/lib/python".
Otherwise, you must generate the "_mysql.so" extension. The source lives on Sourceforge (project "Mysql-python" or "Python-Mysql").
participants (4)
-
Aaron -
Dennis Allison -
Dieter Maurer -
robert rottermann