[Zope] ZMySQLDA product problem?

[Maarten Slaets]

I had exactly the same problem Art. here's how i fixed it:
(i use apache + pcgi on solaris, with mysql in /usr/local/lib/mysql)
put this in Zope.cgi:
LD_LIBRARY_PATH=/usr/local/lib/mysql

according to me, it _is_ the problem that LD_LIBRARY_PATH isn't defined.

Art Hampton wrote:
> 
> Michel Pelletier wrote:
> >
> > > -----Original Message-----
> > > From: Art Hampton [mailto:arth@pacsg.css.mot.com]
> > > Sent: Thursday, December 02, 1999 12:02 PM
> > > To: zope@zope.org
> > > Subject: [Zope] ZMySQLDA product problem?
> > >
> > >
> > > We've been having problems with the ZMySQLDA product, as
> > > installed using
> > > the instructions at
> > > http://yyy.zope.org/Members/alanpog/zmysqlda_steps .
> > >
> > > The product seems to break for some unknown reason.  I've
> > > seen it happen
> > > as a result of the following events:
> > > o  Rebooting the machine (while Zope is running)
> >
> > Uhm.. you do shut down the OS first before rebooting right?
> 
> Of course, we're using shutdown -i 6 under Solaris.
> 
> > > o  Installing another product (including stopping and restarting
> Zope)
> > >
> > > We get the following message in our SQL DB connection:
> > > _______
> > > This object is broken because the ZMySQLDA product that
> > > created it is no
> > > longer
> > > installed or is installed incorrectly. Please contact your product
> > > vendor for assistance.
> >
> > Go to Control_Panel/Products, click on the adapter, click on
> 'traceback'
> > and send us the traceback.
> 
> I was surprised to see something there, given that the connection is
> currently working fine:
> 
> Traceback (innermost last):
>   File "/usr/local/zope/Zope-2.0.1-src/lib/python/OFS/Application.py",
> line 393, in import_products
>     product=__import__(pname, global_dict, global_dict, silly)
>   File "lib/python/Products/ZMySQLDA/__init__.py", line 106, in ?
>     import sys, os, Globals, DA
>   File
> "/usr/local/zope/Zope-2.0.1-src/lib/python/Products/ZMySQLDA/DA.py",
> line 108, in ?
>     from db import DB
>   File
> "/usr/local/zope/Zope-2.0.1-src/lib/python/Products/ZMySQLDA/db.py",
> line 106, in ?
>     import _mysql, regex, sys
> ImportError: ld.so.1: /usr/local/bin/python: fatal: libmysqlclient.so.6:
> open failed: No such file or directory
> 
> Looks like it doesn't know where it should be looking for the library
> (/usr/local/lib/mysql in this case).  What do I need to do?
> 
> Thanks.
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> 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 )

-- 
Maarten Slaets
Web Developer
KPNQwest Belgium
http://www.fonky.com/vcard/MaartenSlaets/