[Zope] MySQL connection woes

[paul_s_johnson@urscorp.com]

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: mydatabase@www.myhost.com root
>
>In the grant tables there is the following entries:
>In user: root@www.myhost.com with no privileges
>In db: root@www.myhost.com 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?