Help - Database Connection String
I have successfully installed Zope 1.10.3 , MySQL 3.21.31 and ZMySQLDA 1.1.3 on Linux Mandrake 5.2. Zope is working fine. However, when adding a ZMySQLDA database connector, I get an error message: - invalid connection string when I use mysql test as connection string. I tried several strings - still invalid. Can anyone help... Best regards...
"Emmanuel M. Viado" wrote:
I have successfully installed Zope 1.10.3 , MySQL 3.21.31 and ZMySQLDA 1.1.3 on Linux Mandrake 5.2. Zope is working fine.
However, when adding a ZMySQLDA database connector, I get an error message: - invalid connection string when I use mysql test as connection string. I tried several strings - still invalid.
The connections string is of the format: databasename@hostname username password such that: test@localhost webmaster letmein where: o test is the name of the database you want to connect to o localhost because the database is on the same machine o webmaster is the user set up to access the database from the web o letmein is the password used by the webmaster user. Of course, you would have to have the user set up in mysql as well. Cheers, Bill Anderson
try db@host username password for instance assuming db = aspire host = localhost username= phil password= 123456 then the connect string would be aspire@localhost phil 123456 if there is no password then leave it out, also if the host is left out then localhost is assumed. HTH Phil phil@philh.org ----- Original Message ----- From: Emmanuel M. Viado <emviado@mnl.sequel.net> To: <zope@zope.org> Sent: Saturday, July 03, 1999 4:34 PM Subject: [Zope] Help - Database Connection String
I have successfully installed Zope 1.10.3 , MySQL 3.21.31 and ZMySQLDA 1.1.3 on Linux Mandrake 5.2. Zope is working fine.
However, when adding a ZMySQLDA database connector, I get an error message: - invalid connection string when I use mysql test as connection string. I tried several strings - still invalid.
Can anyone help...
Best regards...
_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope
(For developer-specific issues, use the companion list, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
participants (3)
-
Bill Anderson -
Emmanuel M. Viado -
Phil Harris