Not everything works well on Python 2 yet. My guess is that you need to downgrade back to 1.5.. ::-----Original Message----- ::From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Olaf ::Zanger ::Sent: Thursday, March 08, 2001 8:42 AM ::To: zope@zope.org ::Subject: [Zope] ZMySQL and MySQLdb :: :: ::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 ) ::

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 )