[Zope] ZMySQL and MySQLdb

[kentj]

The version of Zope that comes with SUSE 7.1 appears to work fine with Python 2.0.
The MYSQL that comes with 7.1 SUSE
is 3.23.32 which is much newer than the 3.22.30.

Olaf Zanger wrote:

> hi there,
>
> i had a zope 2.3 installation under suse 7.0 (python 1.5.2) running
> wonderfully with connection to mysql (don't know the version anymore)
>
> now i installed the same mysql-data,. zope-data on suse 7.1. with mysql
> 3.22.30 and ZMySQL da 1-2-0 and MySQLdb 0.1.2, python 2.0 now
>
> i can use the database, so the data and passwords should be correct.
>
> unfortunately, if i connect to the database i get the error message printed
> in the addendum.
>
> is it possible, that i have to recompile the MySQLdb ?
>
> what else could be the problem?
>
> thanks for help
>
> olaf
>
> addendum
> --------------------
> Zope Error
>
>                 Zope has encountered an error while publishing this resource.
>
>                 BadRequest
>
>                 Invalid connection string: ipOperate soli-con
>
>                 Traceback (innermost last):
>                   File
> /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 222, in
> publish_module
>                   File
> /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 187, in publish
>                   File /home/soli-con/ipOffice/lib/python/Zope/__init__.py,
> line 221, in zpublisher_exception_hook
>                     (Object: RoleManager)
>                   File
> /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 171, in publish
>                   File
> /home/soli-con/ipOffice/lib/python/ZPublisher/mapply.py, line 160, in mapply
>                     (Object: manage_open_connection)
>                   File
> /home/soli-con/ipOffice/lib/python/ZPublisher/Publish.py, line 112, in
> call_object
>                     (Object: manage_open_connection)
>                   File
> /home/soli-con/ipOffice/lib/python/Shared/DC/ZRDB/Connection.py, line 220, in
> manage_open_connection
>                     (Object: RoleManager)
>                   File
> /home/soli-con/ipOffice/lib/python/Shared/DC/ZRDB/Connection.py, line 240, in
> connect
>                     (Object: RoleManager)
>                   File
> /home/soli-con/ipOffice/lib/python/Products/ZMySQLDA/db.py, line 155, in
> __init__
>                 BadRequest: (see above)
>
> --
> soli-con Engineering Zanger, Dipl.-Ing. (FH) Olaf Marc Zanger
> Lorrainestrasse 23, 3013 Bern / Switzerland
> fon:+41-31-332 9782, mob:+41-76-572 9782
> mailto:olaf.zanger@soli-con.com, http://www.soli-con.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 )