[Zope] Using Zope and MySQL

Tue, 27 Mar 2001 09:33:04 -0500 (EST)

	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
> > > ************************
> 
> 
> 
>