[Zope] Using Zope and MySQL
Norman Khine
khine@btinternet.com
Tue, 27 Mar 2001 15:31:19 +0100
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.
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 )