[Zope-DB] how to use mySQL with zope

[Charlie Clark]

Dear Vaibhav,

please post to the list. I'm no database expert and I haven't used MySQL 
for over a year (PostgreSQL is a much better DB and easier to use in my 
opinion). Also please do not post HTML text where possible as it is more 
difficult for us to read.

That said: the error has nothing to do with Zope simply with installing the 
MySQL driver for Python.

NOTE: Error message when running the setup.py file to build mysql Database 
driver 

-------------------------------------------------------------------- 
------------------------------------------------------------------- 

[sos at cad48 MySQL-python-0.9.2]$ python setup.py build 
running build 
running build_py 
creating build 
creating build/lib.linux-i686-2.2 
copying CompatMysqldb.py -> build/lib.linux-i686-2.2 
copying _mysql_exceptions.py -> build/lib.linux-i686-2.2 
creating build/lib.linux-i686-2.2/MySQLdb 
copying MySQLdb/__init__.py -> build/lib.linux-i686-2.2/MySQLdb 
copying MySQLdb/converters.py -> build/lib.linux-i686-2.2/MySQLdb 
copying MySQLdb/connections.py -> build/lib.linux-i686-2.2/MySQLdb 
copying MySQLdb/cursors.py -> build/lib.linux-i686-2.2/MySQLdb 
copying MySQLdb/sets.py -> build/lib.linux-i686-2.2/MySQLdb 
copying MySQLdb/times.py -> build/lib.linux-i686-2.2/MySQLdb 
creating build/lib.linux-i686-2.2/MySQLdb/constants 
copying MySQLdb/constants/__init__.py -> 
build/lib.linux-i686-2.2/MySQLdb/constants 
copying MySQLdb/constants/CR.py -> 
build/lib.linux-i686-2.2/MySQLdb/constants 
copying MySQLdb/constants/FIELD_TYPE.py -> 
build/lib.linux-i686-2.2/MySQLdb/constants 
copying MySQLdb/constants/ER.py -> 
build/lib.linux-i686-2.2/MySQLdb/constants 
copying MySQLdb/constants/FLAG.py -> 
build/lib.linux-i686-2.2/MySQLdb/constants 
copying MySQLdb/constants/REFRESH.py -> 
build/lib.linux-i686-2.2/MySQLdb/constants 
copying MySQLdb/constants/CLIENT.py -> 
build/lib.linux-i686-2.2/MySQLdb/constants 
running build_ext 
building '_mysql' extension 
creating build/temp.linux-i686-2.2 
gcc -DNDEBUG -g -O3 -Wall -Wstrict-prototypes -fPIC -I/usr/include/mysql 
-I/usr/local/include/mysql -I/usr/local/mysql/include/mysql 
-I/usr/include/python2.2 -c _mysql.c -o build/temp.linux-i686-2.2/_mysql.o 
/usr/local/mysql/include/mysql: Permission denied 
error: command 'gcc' failed with exit status 

It seems that you do not have the necessary permissions to compile the 
driver. Once you've solved this problem you should *always* test the driver 
directly from Python. If you still have problems then you should use the 
MySQL list at sourceforge.

Regards

Charlie Clark

On 2004-02-23 at 05:58:00 [+0100], you wrote:
> Hi Charlie,
> 
> i am using zope(2.6.4) and mySQL database(3.23.39) on red hat linux8.0.
> I am using ZMySQLDA 2.0.7 and Mysql-python 9.0.2 as database adapters and 
> database driver.
> i have successfully installed the database adapter(it's available in the 
> drop down menu of Zope).
>                
> But when i am trying to install the database driver i am getting a error 
> message(I am including the error message as a html file attachment).
> 
> Please tell me the possible reason for this error.
> 
> Thanks in advance.