[Zope] Using Zope and MySQL

Norman Khine khine@btinternet.com
Tue, 27 Mar 2001 16:31:26 +0100


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 )