[Zope] problem connecting to mysql

[Helmut Ahninger]

Chris McDonough wrote:

> Helmut,
>
> Try databasename@localhost user password

thank u for your quick reply, but i tried all this combinations - no sucess

>
> Helmut Ahninger wrote:
> >
> > hy
> >
> > i installed the mysqldb sucessfully (just exactly like the howto on
> > http://www.zope.org/Members/alanpog/zmysqlda_steps
> > explains) and checked all version numbers.
> >
> > i restarted zope and the Product ZMySQLDA is not broken
> >
> > then i want to make a database connection with the
> > z_mysql_database_connection
> > i type as connection string:    database user password
> >
> > and get the following result:
> >
> > invalid connection string:
> > Traceback (innermost last):
> >    File /usr/local/Zope-2.1.4-src/lib/python/ZPublisher/Publish.py, line
> > 214, in publish_module
> >    File /usr/local/Zope-2.1.4-src/lib/python/ZPublisher/Publish.py, line
> > 179, in publish
> >    File /usr/local/Zope-2.1.4-src/lib/python/Zope/__init__.py, line 202,
> > in zpublisher_exception_hook
> >      (Object: ElementWithAttributes)
> >    File /usr/local/Zope-2.1.4-src/lib/python/ZPublisher/Publish.py, line
> > 165, in publish
> >    File /usr/local/Zope-2.1.4-src/lib/python/ZPublisher/mapply.py, line
> > 160, in mapply
> >      (Object: addConnection)
> >    File /usr/local/Zope-2.1.4-src/lib/python/ZPublisher/Publish.py, line
> > 102, in call_object
> >      (Object: addConnection)
> >    File /usr/local/Zope-2.1.4-src/lib/python/Products/ZMySQLDA/DA.py,
> > line 123, in addConnection
> >      (Object: ElementWithAttributes)
> >    File
> > /usr/local/Zope-2.1.4-src/lib/python/Shared/DC/ZRDB/Connection.py, line
> > 129, in __init__
> >      (Object: RoleManager)
> >    File
> > /usr/local/Zope-2.1.4-src/lib/python/Shared/DC/ZRDB/Connection.py, line
> > 158, in edit
> >      (Object: RoleManager)
> >    File
> > /usr/local/Zope-2.1.4-src/lib/python/Shared/DC/ZRDB/Connection.py, line
> > 227, in connect
> >      (Object: RoleManager)
> >    File /usr/local/Zope-2.1.4-src/lib/python/Products/ZMySQLDA/db.py,
> > line 155, in __init__
> >  BadRequest: (see above)
> >
> > what am i doing wrong ?
> > please if u have had the same problem or know the answer send me an
> > email
> >
> > thank u in advance
> >
> > Helmut Ahninger
> > helmut@jouh.at
> >
> > _______________________________________________
> > 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 )
>
> --
> Chris McDonough - Digital Creations, Inc.
> Publishers of Zope - http://www.zope.org
>
> _______________________________________________
> 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 )