[Zope] ZMySQLDA

[Dirk Datzert]

Hi Ben ,

have you downloaded both python libs ZMySQLDA and MySQL-python ?
look that my _mysql is in lowercase and with a underline before.

If have MySQL-python from http://sourceforge.net/projects/mysql-python
ZMySQLDA from http://www.zope.org/Members/adustman/Products/ZMySQLDA

What is with the unix rights for zope-user ?

Regards,
Dirk


Ben Ocean schrieb:

> At 10:52 PM 1/2/02 +0100, you wrote:
> >My _mysql.so is in :
> >
> >/usr/lib/python2.1/site-packages/_mysql.so
> >/usr/lib/python2.1/site-packages/_mysql_exceptions.py
> >/usr/lib/python2.1/site-packages/_mysql_exceptions.pyc
> >
> >/usr/lib/python2.1 is your /usr/local/lib/python
> >
> >in my db.py is the following import:
> >
> >import _mysql
> >from _mysql_exceptions import OperationalError, NotSupportedError
> >MySQLdb_version_required = (0,9,0)
> >
> >try
> >
> >python db.py
> >
> >Does this give an mysql-relevant error ??
>
> #python db.py
> python: can't open file 'db.py'
> #find / -name "db.py"
> /home/httpd/ZopeInstallation/OtherProducts/ZMySQLDA/db.py
> /home/httpd/ZopeInstallation/Zope_software_home/lib/python/Products/ZGadflyDA/db.py
> #pwd
> /home/virtuals/mercury/html/GlobalRequestPatch
> #cd /home/httpd/ZopeInstallation/OtherProducts/ZMySQLDA/
> #python db.py
> Traceback (most recent call last):
>    File "db.py", line 106, in ?
>      import MySQL, regex, sys
> ImportError: No module named MySQL
>
> >I have ZMySQLDA 2.0.8
> >
> >Hope this helps. I had similar problems with MySQL. I had an old ZMySQLDA
> >version.
> >Don't know if that is your problmen.
>
> I have the most recent. The problem is with this module MySQL. Where do I
> get it?
> TIA,
> BenO