[Zope] problem connecting to mysql

[Chris McDonough]

You can connect to the database from the mysql command line utility?

Helmut Ahninger wrote:
> 
> 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 )
> 
> _______________________________________________
> 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