[Zope] ZMySQLDA 1.1.4 install problems

2000-06-03 Thread David Parker

I'm attempting to install ZMySQDA-1.1.4 on a RedHat 6.2 box with the
following configuration;

Zope 2.1.6-1
Zope-pcgi 2.1.6-1
Apache 1.3.12-2
Python 1.5.2-13  w/dev
MySQL 3.22.32   w/dev
MySQL-python 1.4-2

ZMySQLDA compiles fine and python imports ok. When I copy MySQLmodule.so
to the products directory and restart Zope, ZMySQLDA does not show up in
the Products list. All the above were installed from RPM binaries.  I
did manage to get ZMySQLDA working on a different machine with some
difficulty. I seem to have hit a different stumbling block this time.

Any suggestions?
David



___
Zope maillist  -  [EMAIL PROTECTED]
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 )




Re: [Zope] ZMySQLDA fails to compile

2000-05-23 Thread 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.2MySQL-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/usr/local/mysql/lib 
  -L/usr/lib/mysql -lmysqlclient -lm
  # MySQLmodule MySQLmodule.c 
  -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient 
  -lm
  MySQLmodule MySQLmodule.c 
  -I/usr/web/databases/mysql/include -L/usr/web/databases/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]# makegcc -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


[Zope] ZMySQLDA fails to compile

2000-05-23 Thread David Parker



Configuration: Mandrake 7.02 with the 
following;
 
Zope 2.1.6-1 python 1.5.2MySQL-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/usr/local/mysql/lib 
-L/usr/lib/mysql -lmysqlclient -lm
# MySQLmodule MySQLmodule.c 
-I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient 
-lm
MySQLmodule MySQLmodule.c 
-I/usr/web/databases/mysql/include -L/usr/web/databases/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]# makegcc -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