[Zope] ZMySQLDA

[Ronald Offerman]

> Hi,
> 
> I'm playing with Zope, and have been trying to get Zope to talk to MySQL
> using the MySQLDA.
> 
> I'm running RedHat 5.2
> 
> Since there were caveats about having MySQL development enabled, and
> such, I downloaded the source distribution for MySQL and made it. It
> appears to be working very nicely.
> 
> When I follow the procedures outlined in the README, the following
> happens:
> 
> I run make -f Makefile.pre.in boot and everything works correctly.
> 
> I then run make and get the following error.
> gcc -fPIC -g -O2 -I/usr/include/python1.5 -I/usr/include/python1.5
> -DHAVE_CONFIG
> _H  -I/usr/local/mysql/include -I/usr/include/mysql -c ./MySQLmodule.c
> ./MySQLmodule.c: In function `pythonify_row':
> ./MySQLmodule.c:238: warning: assignment from incompatible pointer type
> gcc -shared  MySQLmodule.o  -L/usr/local/mysql/lib -L/usr/lib/mysql
> -lmysqlclien
> t -lm -o MySQLmodule.so
> ld: cannot open -lmysqlclient: No such file or directory
> make: *** [MySQLmodule.so] Error 1
> 
> I did a locate on mysqlclient, and coudln't find the file. though I did
> find some called libmysqlclient. So I changed the both Setup and
> Setup.in to reflect that other name. however, I still get the above
> error.
> 
> Any help would be greatly appreciated.

You almost made it ;=)
The -lmysqlclient does refer to the libmysqlclient you found, but you should only modify the path pointing to it. This is done in the Setp[.in] just before the -lmysqlclient; modify the '-L/<path-to-the-libmysqlclient>', if have this set to -L/usr/local/lib/mysql.

[ZDP] Maybe this is something for the FAQ?

-- 
<- Ronald Offerman | ron@offerman.cx
<- Root Powered Carrot Munchers Ltd. Inc. SA AG BV

"This is Linux Country. On a quiet night, you can hear Windows NT reboot!"
"Daddy, why do those people have to use Microsoft Windows?"
"Don't stare, son; it's not polite."
"M$ Windows NT, an accident waiting to happen"
"What goes up, must come down. Ask any system administrator."
".sig too big? Flame me, I'm cold!"