Once you have installed ZMySQLDA in your Zope root directroy, you'll get a folder in /lib/python/Products/ZMySQLDA. Then all you need to do is restart zope. Hopefully the ZMySQLDA will not be broken. To confirm that MySQLdb module is working, try at the python interpretter
import MySQL, if you get a Trace Back erro there is no module named MySQL then ZMySQLDA will not work.
hth Norman -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Gitte Wange Sent: Tuesday, March 27, 2001 2:49 PM To: Norman Khine Cc: ghaley@mail.venaca.com; Zope Mailing List Subject: RE: [Zope] Using Zope and MySQL On 27 Mar 2001 15:31:19 +0100, Norman Khine wrote:
You can find the MySQLdb module from http://dustman.net/andy/python
You should then extract and build this, before you install ZMySQLDA which should be installed in your Zope root.e
Okay I installed the MySQLdb module and it went well I have extracted the ZMySQLDA tarball in the Zope root dir. But how do I build it ? The readme file says nothing ... Gitte
Norman
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of ghaley@mail.venaca.com Sent: Tuesday, March 27, 2001 3:33 PM To: Gitte Wange Cc: Phil Harris; zope@zope.org Subject: Re: [Zope] Using Zope and MySQL
Gitte,
You should get into the habit of checking the mail list archives.
This very question was posed about two weeks ago (by me -- and maybe I should follow my own advice more, too :) ), and there were a number of replies and my own follow-ups to them. One of them contained a link to a site where you can download a package called MySQLdb which you can use to build the database driver that ZMySQLda needs in order to work.
I don't have the link handy right here, but if you check the mail list archive you should not have any trouble if you search with ZMySQL, or maybe even a search on just MySQL will bring up all the threads that treat this.
Happy zoping.
ciao! greg.
Gregory Haley DBA/Web Programmer Venaca, LLC.
On 27 Mar 2001, Gitte Wange wrote:
On 27 Mar 2001 13:30:47 +0100, Phil Harris wrote:
Ooh, an faq.
Search the list for how to fix this, but here goes anyway.
Basically edit the MySQLModule.c file and change the lines in
questions
(384, 1125,1147) and remove the & from after the '=' sign.
This fixes it everytime in my books.
YMMV
Phil
Thanks it helped ! :-)
But know there is another problem: I start python and tries to import MySQL.
But guess what - it can't.
Now the readme file said something about change -lm to -lgcc and I did but it didn't helt. Any good ideas ?
Gitte
----- Original Message ----- From: "Gitte Wange" <gitte@mmmanager.org> To: "Phil Harris" <phil.harris@zope.co.uk> Cc: <zope@zope.org> Sent: Tuesday, March 27, 2001 12:16 PM Subject: Re: [Zope] Using Zope and MySQL
On 27 Mar 2001 13:04:36 +0100, Phil Harris wrote:
What error are you getting when compiling?
In the ZMySQLDA/src directory I enter (as the readme file says): make -f Makefile.pre.in boot
This goes well
Then I enter make and the error output is a follows: gcc -fPIC -I/usr/local/mysql/include -I/usr/include/mysql -g -O2 -I/usr/include/python1.5 -I/usr/include/python1.5 -DHAVE_CONFIG_H -c ./MySQLmodule.c ./MySQLmodule.c: In function `pythonify_row': ./MySQLmodule.c:238: warning: assignment from incompatible pointer
type
./MySQLmodule.c: In function `pythonify_res_fields': ./MySQLmodule.c:384: invalid lvalue in unary `&' ./MySQLmodule.c: In function `STH_fetchdict': ./MySQLmodule.c:1125: invalid lvalue in unary `&' ./MySQLmodule.c:1147: invalid lvalue in unary `&' make: *** [MySQLmodule.o] Error 1
What is wrong ?
----- Original Message ----- From: "Gitte Wange" <gitte@mmmanager.org> To: "Peter Bengtsson" <peter@grenna.net> Cc: <zope@zope.org> Sent: Tuesday, March 27, 2001 12:01 PM Subject: Re: [Zope] Using Zope and MySQL
I run Linux
I have tried to compile the ZMySQLDA but it fails everytime. Yes I have installed the MySQL_devel package
Gitte
On 27 Mar 2001 11:15:28 +0100, Peter Bengtsson wrote: > Welcome to hell! > > Getting Zope to work with MySQL can be either very very easy,
and very
very
> difficult. > It all depends on how well you read the README's and HOWTO's. > > Are you using Win32 or *nix? > ZMySQLDA is almost never a problem. The most pain on the mailing list is > about the mysql-python bit. > > What's the traceback (when you click the little broken box in > Control_Panel/Products) > > Peter > > ----- Original Message ----- > From: "Gitte Wange" <gitte@mmmanager.org> > To: <zope@zope.org> > Sent: Tuesday, March 27, 2001 8:16 AM > Subject: [Zope] Using Zope and MySQL > > > > Hello, > > Yesterday I tried to setup Zope with MySQL, but the Product I found on > > Zope.org to do this, didn't work. > > Now is there anyone who knows how to setup Zope with MySQL ?? > > > > Regards, > > > > -- > > ************************ > > Gitte Wange Jensen > > > > System Squid Developer > > MMManager Aps > > +45 29 72 79 72 > > > > gitte@mmmanager.org > > ************************ > > > > > > _______________________________________________ > > 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 )
-- ************************ Gitte Wange Jensen
System Squid Developer MMManager Aps +45 29 72 79 72
gitte@mmmanager.org ************************
_______________________________________________ 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 )
-- ************************ Gitte Wange Jensen
System Squid Developer MMManager Aps +45 29 72 79 72
gitte@mmmanager.org ************************
_______________________________________________ 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 )
_______________________________________________ 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 )
-- ************************ Gitte Wange Jensen System Squid Developer MMManager Aps +45 29 72 79 72 gitte@mmmanager.org ************************ _______________________________________________ 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 )