RE: [Zope] MySQL connection woes
One other bizarre symptom: when I test the database connection with a INSERT query it works and inserts data into the designated MySQL table in the query, although there is no indication that it is working in Zope. I changed the user table for the MySQL user cited in the connection string so that all privileges are on and still no luck. P. Johnson >>For a quick test, run the mysql client from the command line. >> >>Let's say your connection string was: >> foodb paul passwd >> >>Start mysql like this: >>$ mysql -u paul -p foodb >> >>And when prompted for the password, enter passwd. >> >>This will ensure mysql is setup correctly. Make sure you do this from >>the same machine that is running Zope, as MySql can be configured for >>different access from different machines. >> >>If you want to play with "null" passwords and such, look at the >>mysql.user and mysql.db tables. Remember to run "mysqladmin >>flush-privileges" after making changes to the user and db tables. > >This last part I did not know, thanks! > >Ok, I am getting closer. I finally found a connection string that Zope >accepts, but now when I test the connection with a query like "SHOW >TABLES;" or a SELECT query it I get the message: > > "There was no data matching this Z MySQL Database Connection >(connected) query." > >- even though I know these tables exist. The connection says that it is >open and it will only accept connection strings of databases that really >exist in MySQL. >INFO: >MySQL user name: root >hostname: www.myhost.com >password: none > >Zope Connection string: [EMAIL PROTECTED] root > >In the grant tables there is the following entries: >In user: [EMAIL PROTECTED] with no privileges >In db: [EMAIL PROTECTED] with all privileges for mydatabase.* except for >Grant_priv > >One other parameter that may have a bearing: the box's name is >station99.ispname.net even though it hosts www.myhost.com (or is it the >other way around?). > >Any suggestions why the connection is not working properly? ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] MySQL connection woes
"Randall F. To: <[EMAIL PROTECTED]> Kern"cc: 01/09/01 12:08 PM >For a quick test, run the mysql client from the command line. > >Let's say your connection string was: > foodb paul passwd > >Start mysql like this: >$ mysql -u paul -p foodb > >And when prompted for the password, enter passwd. > >This will ensure mysql is setup correctly. Make sure you do this from >the same machine that is running Zope, as MySql can be configured for >different access from different machines. > >If you want to play with "null" passwords and such, look at the >mysql.user and mysql.db tables. Remember to run "mysqladmin >flush-privileges" after making changes to the user and db tables. This last part I did not know, thanks! Ok, I am getting closer. I finally found a connection string that Zope accepts, but now when I test the connection with a query like "SHOW TABLES;" or a SELECT query it I get the message: "There was no data matching this Z MySQL Database Connection (connected) query." - even though I know these tables exist. The connection says that it is open and it will only accept connection strings of databases that really exist in MySQL. INFO: MySQL user name: root hostname: www.myhost.com password: none Zope Connection string: [EMAIL PROTECTED] root In the grant tables there is the following entries: In user: [EMAIL PROTECTED] with no privileges In db: [EMAIL PROTECTED] with all privileges for mydatabase.* except for Grant_priv One other parameter that may have a bearing: the box's name is station99.ispname.net even though it hosts www.myhost.com (or is it the other way around?). Any suggestions why the connection is not working properly? ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] MySQL connection woes
I don't know how to create a null login in MySQL, but I know a better solution. The last time I had a problem like yours I created a user in MySQL and used it connect Zope. In mysql you type: GRANT ALL ON my_database.* TO my_user IDENTIFIED BY my_passwd (The .* part is a wildcard meaning all tables in this database.) Then you can connect Zope using a connection string like this: my_user@localhost my_passwd Good luck, Luciano PS. [EMAIL PROTECTED] wrote: > > After following several howtos, tracking numerous threads from this list, > and spending several days losing my mind, I sense that I am finally getting > closer to having Zope and MySQL talking to each other. > > SETUP: > I am running on Linux with Redhat with MySQL 3.22.32 and ZMySQLDA with > ZMySQL-python. The later two are installed such that ZMySQLDA is NOT > broken. I installed using the RPMs supplied by Ron Bickers available on his > FTP site (thanks, Ron) and followed additional instructions supplied on > earlier threads. > > PROBLEM: > My problem now is I can't find a connection string that works. I understand > the connection syntax and tried every possibility. My suspicion is that I > am having a permissions problem with MySQL. I found this former list email: > > >> 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 :) ) > > QUESTION: > Being a relative newbie to this whole thing (Linux, Zope, MySQL, etc.), how > do I create a null login in MySQL with blanket privleges? Could it still be > a faulty ZMySQLDA setup? How do I troubleshoot that possibility? > > Thanks, > > P. Johnson > > ___ > Zope maillist - [EMAIL PROTECTED] > 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 - [EMAIL PROTECTED] 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 )