Newbie: connection string for ZMySQLDA using MySQLdb
hi, i tried entering the following (using 'Add Z MySQL Database Connection'): user/password user/paasword@myhost but none of them worked and return a 'bad request': <Traceback> Traceback (innermost last): File /usr/local/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /usr/local/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 179, in publish File /usr/local/Zope-2.0.1-src/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook (Object: ElementWithAttributes) File /usr/local/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 165, in publish File /usr/local/Zope-2.0.1-src/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: addConnection) File /usr/local/Zope-2.0.1-src/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: addConnection) File /usr/local/Zope-2.0.1-src/lib/python/Products/ZMySQLDA/DA.py, line 123, in addConnection (Object: ElementWithAttributes) File /usr/local/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/Connection.py, line 124, in __init__ (Object: RoleManager) File /usr/local/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/Connection.py, line 153, in edit (Object: RoleManager) File /usr/local/Zope-2.0.1-src/lib/python/Shared/DC/ZRDB/Connection.py, line 197, in connect (Object: RoleManager) File /usr/local/Zope-2.0.1-src/lib/python/Products/ZMySQLDA/db.py, line 155, in __init__ BadRequest: (see above) </Traceback> What Am I doing wrong? Maarten Slaets Web Developer KPNQwest Belgium http://www.fonky.com/vcard/MaartenSlaets/
On Mon, 25 Oct 1999, Slaets, Maarten wrote:
user/paasword@myhost
database@myhost user password Oleg. ---- Oleg Broytmann Foundation for Effective Policies phd@phd.russ.ru Programmers don't die, they just GOSUB without RETURN.
At 5:03 pm +0200 25/10/99, Slaets, Maarten wrote:
hi,
i tried entering the following (using 'Add Z MySQL Database Connection'): user/password user/paasword@myhost but none of them worked and return a 'bad request':
id:whatever connection string:databasename@database_host.domain username password Those things on the right of the ':' that look like spaces, are spaces. You also need to make sure your MySQL grant tables will recognise 'username' and 'password'. hth tone ------ Dr Tony McDonald, FMCC, Networked Learning Environments Project http://nle.ncl.ac.uk/ The Medical School, Newcastle University Tel: +44 191 222 5888 Fingerprint: 3450 876D FA41 B926 D3DD F8C3 F2D0 C3B9 8B38 18A2
participants (3)
-
Oleg Broytmann -
Slaets, Maarten -
Tony McDonald