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
Helmut, Try databasename@localhost user password 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
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 )
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
Chris McDonough wrote:
You can connect to the database from the mysql command line utility?
yes, i tried a lot of things (privileges of mysql,zope) but with no success :( maybe there is another source of the problem ? (mysql, apache) bye Helmut
Helmut, I doubt it. It's probably a username/password/databasename issue. My suggestion would be to set up mysql to accept a null login (no username, no password), create a database in there called "test" and connect with the connection string "test@localhost" Helmut Ahninger wrote:
Chris McDonough wrote:
You can connect to the database from the mysql command line utility?
yes, i tried a lot of things (privileges of mysql,zope) but with no success :( maybe there is another source of the problem ? (mysql, apache)
bye
Helmut
_______________________________________________ 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
Chris McDonough wrote:
Helmut,
I doubt it. It's probably a username/password/databasename issue.
My suggestion would be to set up mysql to accept a null login (no username, no password), create a database in there called "test" and connect with the connection string "test@localhost"
thank u, this was the point to my problem. I have tried a nologin mysql and it worked with database@myhost !!! :) so i know i have a grant table problem in mysql (no big deal - i hope :) ) bye and thank u again Helmut Ahninger
participants (2)
-
Chris McDonough -
Helmut Ahninger