Re: [Zope] ZMySQLDA fails to compile

[David Parker]

I fixed my own problem. The version of MySQL that I installed from source appended an extra directory (mysql) to the include and lib directories. I modified my Setup to reflect the full paths below. /usr/web/databases/mysql/include/mysql /usr/web/databases/mysql/lib/mysql   I then ran into a problem where I could not import MySQL from python. I kept getting; ImportError: libmysqlclient.so.6 Turns out I had to modify /etc/ld.so.conf to reflect the full path to the libmysqlclient.so.6 object, then run ldconfig, then I could import MySQL into python.....   David ----- Original Message ----- From: David Parker To: [EMAIL PROTECTED] Sent: Tuesday, May 23, 2000 10:38 AM Subject: [Zope] ZMySQLDA fails to compile 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............