[Zope-DB] Zope 2.7.5, ZMySQL2.0.8 and MySQL-Python 1.0.0

[Greg Fischer]

Try the new versions.  Not that those wont work, but I just setup my
system and it was quite easy on the new versions now. 
mysql-python-1.2.0 and mysqlda-2.0.9b3.  All you have to do on the
mysqlpython now is make sure your msyql_config program is in your
path.  I just added my mysql/bin folder and it was good to go.

So, I did:  (are your paths correct?)
/path/to/python setup.py build
/path/to/python setup.py install

Then untarred the DA into:  (same here, right Products path?)
/path/to/zopeinstance/lib/python/Products

Restarted zope and it was ready to go.

Hope that helps,

Greg

On 5/11/05, Nilesh <nileshbillade at yahoo.com> wrote:
> Hello,
>     I am new to the world of Zope and Plone. I am trying to
> install
> the ZMySQLDA database adapter to connect Zope to MySQL. I am
> running
> Zope on a RedHat 9.0 Linux box. I have mysql version 3.23.58
> (which
> came originally with RH 9.0).
> I have Zope version 2.7.5 (and Plone 2.0).
> I downloaded the driver: MySQL-python-1.0.0.tar.gz
> and extracted the MySQL-python-1.0.0 directory to my
> /usr/lib/plone2/lib/python/Products folder (Is that right?)
> 
> I also tried /var/lib/plone2/main/Products where I normally
> install
> my plone products. ('main' is the instance that I am running)
> 
> then I did a cd to the  MySQL-python-1.0.0 directory and
> inside that directory, I ran the following commands:
> 
>  $ export mysqlversion="3.23.58"
>  $ export mysqlclient="mysqlclient_r"
>  $ export mysqloptlibs="ssl crypto"
>  $ python setup.py build
>  $ su
>  # python setup.py install
> 
> After that I downloaded ZMySQLDA-2.0.8.tar.gz and extracted it
> in the
> same Product folder which created a ZMySQLDA folder inside the
> Products folder. Some installation instructions talk about using
> a
> makefile from the 'src' directory inside this, but I don't see a
> 'src' folder inside it. I am assuming that it is precompiled.
> Also the python version (2.3.5) that I used to run the setup
> file is
> the same on which Zope2.7.5 was built.
> 
> After all this I see ZMySQLDA as a BROKEN product in my Product
> management interface with the following message:
> 
> Import Traceback
> 
> Traceback (most recent call last):
>   File "/usr/lib/plone2/lib/python/OFS/Application.py", line
> 654, in
> import_product
>     product=__import__(pname, global_dict, global_dict, silly)
>   File
> "/usr/lib/plone2/lib/python/Products/ZMySQLDA/__init__.py",
> line 91, in ?
>     import DA
>   File "/usr/lib/plone2/lib/python/Products/ZMySQLDA/DA.py",
> line 92,
> in ?
>     from db import DB
>   File "/usr/lib/plone2/lib/python/Products/ZMySQLDA/db.py",
> line 89,
> in ?
>     import _mysql
> ImportError: _mysql: init failed
> 
> Am I missing something very important here. If yes, kindly let
> me
> know. Thanks.
> 
> - Nilesh
> 
> Yahoo! Mail
> Stay connected, organized, and protected. Take the tour:
> http://tour.mail.yahoo.com/mailtour.html
> 
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db
> 


-- 
Greg Fischer
1st Byte Solutions
http://www.1stbyte.com