[Zope] Zope with MySQL

[Andy Dustman]

On Wed, 16 Feb 2000, Stephen Bolinger wrote:

> Hi.  I just installed Zope, and I'm having a little difficulty installing
> either of the modules to connect to a MySQL database.  I have tried both
> ZMySQLDA-1.1.3 and MySQLdb-0.1.0.  I am always ending up with the same
> error:
> 
> gcc -fpic  -I/usr/local/mysql/include -I/usr/include/mysql -g -O2 -I/usr/loc
> al/include/python1.5 -I/usr/local/include/python1.5 -DHAVE_CONFIG_H -c
> ./MySQLmodule.c
> ./MySQLmodule.c: In function `pythonify_row':
> ./MySQLmodule.c:238: warning: assignment from incompatible pointer type
> ./MySQLmodule.c: In function `pythonify_res_fields':
> ./MySQLmodule.c:384: invalid lvalue in unary `&'
> ./MySQLmodule.c: In function `STH_fetchdict':
> ./MySQLmodule.c:1125: invalid lvalue in unary `&'
> ./MySQLmodule.c:1147: invalid lvalue in unary `&'
> make: *** [MySQLmodule.o] Error 1
> 
> Both modules give me similar errors, the one above is from ZMySQLDA-1.1.3.
> I'm running Linux 6.0 and I I have python1.5 installed.  Any ideas?

MySQLmodule (which comes with ZMySQLDA) doesn't work with MySQL-3.22. I
have a newer interface (MySQLdb) which does. There's a nice HOWTO on how
to patch ZMySQLDA to use it at:

http://www.zope.org/Members/alanpog/zmysqlda_steps 

-- 
andy dustman       |     programmer/analyst     |      comstar.net, inc.
telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d
"Therefore, sweet knights, if you may doubt your strength or courage, 
come no further, for death awaits you all, with nasty, big, pointy teeth!"