[Zope] ZMySQLDA fails to compile

[David Parker]

Configuration: Mandrake 7.02 with the following;   Zope 2.1.6-1 python 1.5.2 MySQL-python 0.2.1-1 Mysql 3.22.32 All the above were installed using binary RPMs except for Mysql database. The path to mysql is /usr/web/databases/mysql I have a symbolic link to mysql at /usr/local/mysql   I've downloaded and extracted ZMySQLDA  1.1.4 to /usr/share/zope   From the following location /usr/share/zope/lib/python/Products/ZMySQLDA/src I've executed make -f Makefile.pre.in boot make   (I've tried editing Setup using the default and following two paths)   # MySQLmodule MySQLmodule.c -I/usr/local/mysql/include -I/usr/include/mysql -L/u sr/local/mysql/lib -L/usr/lib/mysql -lmysqlclient -lm # MySQLmodule MySQLmodule.c -I/usr/local/mysql/include -L/usr/local/mysql/lib -l mysqlclient -lm MySQLmodule MySQLmodule.c -I/usr/web/databases/mysql/include -L/usr/web/database s/mysql/lib -lmysqlclient -lm   I get the following error every time...   (mysql.h exists at /usr/web/databases/mysql/include/mysql/mysql.h)   [root@davweb src]# make gcc -fPIC  -I/usr/local/mysql/include -O3 -fomit-frame-pointer -fno-exceptions - fno-rtti -pipe -s -mpentium -mcpu=pentium -march=pentium -ffast-math -fexpensive -optimizations -I/usr/include/python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG_H  -c ./MySQLmodule.c ./MySQLmodule.c:160: mysql.h: No such file or directory ./MySQLmodule.c:166: parse error before `MYSQL' ./MySQLmodule.c:166: warning: no semicolon at end of struct or union ./MySQLmodule.c:167: warning: data definition has no type or storage class ./MySQLmodule.c:170: parse error before `}' ./MySQLmodule.c:170: warning: data definition has no type or storage class ./MySQLmodule.c:174: parse error before `MYSQL_RES' continues............