[Zope] Installation Product

[Norman Khine]

hello,
The setup.py file for the MySQL-python will need to point to where your
mysql include and library files are.

For example on UNIX they usually are in /usr/local/lib/mysql/lib and
/usr/local/include/mysql/include, there is an entry for Window$ in the
setup.py something like

elif sys.platform == "win32":
    include_dirs = [r'c:\mysql\include']
    library_dirs = [r'c:\mysql\lib\opt']
    libraries = [mysqlclient, 'zlib', 'msvcrt', 'libcmt',
                 'wsock32', 'advapi32']
    runtime_library_dirs = []
    extra_objects = [r'c:\mysql\lib\opt\mysqlclient.lib']

so really you have to make sure that these point to the correct paths.

Then in order to check if you can connect to mysql from the python command
prompt
>> import MySQLdb
>>

if this works then, and you don't get any traceback errors then you should
install MySQLDA into your zope root

hth

Norman



-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Garry
Steedman
Sent: Friday, June 22, 2001 11:52 AM
To: Solenn CROGUENNEC; zope@zope.org
Subject: Re: [Zope] Installation Product


have you installed BOTH of the following:

MySQLdb or mysql-python: the python/MySQL interface AND
zmysqlda: the Zope Database adapter

both packages are available on sourceforge (though i suspect, perhaps
someone else can confirm, that there are problems on windows?) and are
documented,

http://sourceforge.net/projects/mysql-python

also have a look at the How-To "ZMySQLDA on Win32":

http://www.zope.org/Members/philh/mysql

cheers,

Garry

On 22 Jun 2001, at 10:37, Solenn CROGUENNEC wrote:

To:             	zope@zope.org
From:           	Solenn CROGUENNEC <scroguennec@oreka.com>
Subject:        	[Zope] Installation Product
Date sent:      	Fri, 22 Jun 2001 10:37:49 +0100

> Hello,
>
> We work actually on the platform Windows.
> We want to download a product which called 'MySQL Database Interface'.
> We download the product and we record on the hard disk on
> C:/Zope/lib/python/products.                                   The
> problem is, when we restart the server Zope, the product doesn't
> appear on the list of Products.                                   We
> thinks there are variables to change on the setup file like
> include_dirs = ['/usr/include/mysql']
> library_dirs = ['/usr/lib/mysql']
> but we don't know what directories will put.
> Could you help us ?
>
> Thanks
>
> Valérie & Solenn
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> 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 )


+-------------------------------------------+
  Garry Steedman      mailto:gs@styrax.com
  Styrax Associates  http://www.styrax.com/

  "The Good Man has no shape."
+-------------------------------------------+

_______________________________________________
Zope maillist  -  Zope@zope.org
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 )