[Zope] Re: MySQLDA and MySQL-python - patch needed?

[paul_s_johnson@urscorp.com]

Brian,

I finally got it working. Here's what I did:

I uninstalled all of ZMySQLDA and MySQL-python (formerly MySQLdb - this
name change didn't help any although in the big picture it probably needed
to be done) deleting any trace of it. I then followed all the directions
starting from here:

http://www.zope.org/Members/adustman/MySQLdb - This is the MySQL-python
module.

I used the version of ZMySQLDA that Andy Dustman points to here (there's
more than one floating about and I may have latched onto a
MySQL-python-incompatible one at some point):

http://www.zope.org/Members/adustman/ZMySQLDA - installing this is just of
matter of untarring in the correct Zope directory.

To install MySQL-python I followed the directions that Andy lays out in his
README.txt.  It required that I had to install the rpms mysql-devel and
python-devel which I tracked down at http://rpmfind.net for my flavor of
Linux (RedHat) and MySQL (3.22.32). Once these were installed I was able to
build it exactly as Andy stipulates.

Being a Linux/Zope newbie this seemed daunting but it was more painless
that I originally anticipated.

With these installed I was then getting the error "_mysql module not found"
(or something like that). The python of Zope was not finding the modules I
just built from my main system python. I changed my Zope start-up script
appending the PYTHONPATH variable to include the path where the module
installed to. I added these lines:

PYTHONPATH=$PYTHONPATH:/usr/lib/python1.5/site-packages
export PYTHONPATH

BINGO everything then worked.

Hope that helps.

My hunch is that there is some version incompatibilities going on between
MySQL-python and ZMySQLDA that prevent MySQL query results from returning
to Zope.

BTW, thanks to everyone that responded to my emails for help. Even though
none of them was the exact answer I needed they all supplied some missing
critical piece of the puzzle. Opensource is a cool thing, but none of it
would amount to much without lists like this to help folks out.  Keep it
coming.

-PSJ

>Hello All,
>
>I have the exact same problem.  I am running slack 7.1 and I have
>installed all of the goodies (i.e. zope, python, mysql, etc.) from
>the source code.  After finally figuring out that my /etc/ld.so.conf
>was not seeing the mysqlclient libraries i was able to compile
>MySQLdb-python modules and ZMySQLDA says that it is installed
>properly.  But I have the same issues with the SELECT queries
>returning no data (There was no data matching this test_sql query. )
>That is straight from Zope.  When I INSERT data to my columns in the
>table it works fine though.  I have verified this from the console.
>Please advise if there are any suggestions.  Thanks.
>
>Brian L Gautreau