Hi all,
Keep getting an 'invalid connection string' error when trying to make a database connection from Zope. Weird thing is that I first moved a working build to another machine, which resulted in it not working anymore. Did a clean install of Zope 2.1.6 (Source), MySQL 3.22.32 and all necessary Zope products (ZMySQLDA 1.2.0) using the same packages used in the working install. Still no dice. Same setup :(
Well, I've solved the problem by installing Zope from RPMs and having it connect to MySQL via TCP/IP instead of the default unix socket. So don't connect to 'localhost', connect to your machine's hostname.
File /usr/share/zope/lib/python/Products/ZMySQLDA/db.py, line 155, in __init__ BadRequest: (see above)
Why is Zope looking for files in '/usr/share' all of a sudden? It didn't in the first install. I haved searched the mailinglist archives already, tried stuff suggested there with similar problems. Still no dice :(
But this still isn't solved. Where can I specify the path it shouldn't be looking for the ZMySQLDA stuff if it ain't in '/usr/share/zope'?
Traceback (innermost last): File /2ndhome/devel/proj/euhf/zope/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /2ndhome/devel/proj/euhf/zope/lib/python/ZPublisher/Publish.py, line 179, in publish File /2ndhome/devel/proj/euhf/zope/lib/python/Zope/__init__.py, line 202, in zpublisher_exception_hook (Object: ElementWithAttributes) File /2ndhome/devel/proj/euhf/zope/lib/python/ZPublisher/Publish.py, line 165, in publish File /2ndhome/devel/proj/euhf/zope/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: addConnection) File /2ndhome/devel/proj/euhf/zope/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: addConnection) File /2ndhome/devel/proj/euhf/zope/lib/python/Products/ZMySQLDA/DA.py, line 124, in addConnection (Object: ElementWithAttributes) File /2ndhome/devel/proj/euhf/zope/lib/python/Shared/DC/ZRDB/Connection.py, line 129, in __init__ (Object: RoleManager) File /2ndhome/devel/proj/euhf/zope/lib/python/Shared/DC/ZRDB/Connection.py, line 158, in edit (Object: RoleManager) File /2ndhome/devel/proj/euhf/zope/lib/python/Shared/DC/ZRDB/Connection.py, line 227, in connect (Object: RoleManager) File /usr/share/zope/lib/python/Products/ZMySQLDA/db.py, line 155, in __init__ BadRequest: (see above)