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 ************************
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 )
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 ************************
What error are you getting when compiling? ----- 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 )
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 ************************
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 ----- 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 ************************
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 ************************
-- ************************ Gitte Wange Jensen System Squid Developer MMManager Aps +45 29 72 79 72 gitte@mmmanager.org ************************
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 ************************
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 )
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 ************************
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 )
We will never be able to help you unless you provide the content of the exception that gets thrown when you attempt to import MySQL. We can't just guess at the problem. --sam 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 ************************
-- ************************ 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 )
-- --------------------------------------------------------- The ONLY thing that seems to band all nations together, is that their governments are universally bad.... --unknown
On 27 Mar 2001 17:01:24 -0800, sam gendler wrote:
We will never be able to help you unless you provide the content of the exception that gets thrown when you attempt to import MySQL. We can't just guess at the problem.
Sorry Here the error: ------ 2001-03-27T15:51:28 ERROR(200) Zope Couldn't import Products.ZMySQLDA Traceback (innermost last): File /usr/local/Zope-2.3.0-linux2-x86/lib/python/OFS/Application.py, line 530, in import_products (Object: string) File /usr/local/Zope-2.3.0-linux2-x86/lib/python/Products/ZMySQLDA/__init__.py, line 91, in ? File /usr/local/Zope-2.3.0-linux2-x86/lib/python/Products/ZMySQLDA/DA.py, line 91, in ? File /usr/local/Zope-2.3.0-linux2-x86/lib/python/Products/ZMySQLDA/db.py, line 89, in ? ImportError: No module named _mysql Well I haven't - as mentioned earlyer - build the .py files because the readme file doesn't say anything about building. Gitte
--sam
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 ************************
-- ************************ 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 )
-- --------------------------------------------------------- The ONLY thing that seems to band all nations together, is that their governments are universally bad.... --unknown
-- ************************ Gitte Wange Jensen System Squid Developer MMManager Aps +45 29 72 79 72 gitte@mmmanager.org ************************
I've been very fortunate, it seems...I'm totally new to Python/Zope/MySQL and I got the lot working without a glitch. I'm running FreeBSD4.2, but I can't think that things should be that much harder on Linux....here's how I did it.... - Python 2 installed and running OK - Zope 2.3.0 installed and running OK ...I assume you got this far, maybe different versions though... - Installed mysql-client-3.23.35 (not a Zope product, but the client part of the MySQL suite) from a package...I think this package is available for Linux too...This is needed to be able to do the following step. I chose the package and not the source not to embarras myself hunting down system specific compile options and paths and stuff... - Got hold of MySQL-python-0.3.5.tar.gz (ZOPE DA) from zope.org I think...Untarred the lot and read the README file....there's some special mention of Linux and other package-based releases of mysql(client) installed in the previous step...seems you MIGHT have to look for a 'developers' package too, but I tried without and it worked. I noticed README could cause some confusion on exactly what you need to install first...it says 'MySQL 3.22.19 or higher', but I understood I need (in my case) only mysql-client-3.23.35 or something similar...you don't need something like mysql-server-xx.xx.xx, cause the server could be run anywhere else. Of course, you could install the server too, but that's an entirely different matter. So make sure you've got the 'server' thingie installed from the previous step, and maybe something like mysql-devel-3.23.35, in your case. - So up to now I didn't compile anything. mysql-client was a package, and MySQL-python from the previous step is just sitting there untarred. The README mentions stuff you might need to hack in setup.py, but I didn't touch it, and I don't think you'd need to. Then I just did as they say in the README: python setup.py build and python setup.py install. The whole cadoodle just went fine. - I stopped my Zope (./stop from zope folder) and restarted it (./start). - Connected to Zope as admin, and saw the item 'Z mySQL Database Connection' added to the add new items box. Needless to say, I've been able to really use the mySQL connection in Zope. It seems you've downloaded another version/distribution of the Zope mySQL DA that you've had to 'make'. Have you tried 'gmake'? Otherwise, go for the MySQL-python-0.3.5.tar.gz file I used. lemme know if it works...
On 27 Mar 2001 15:04:12 +0200, Gerrie Roos wrote:
I've been very fortunate, it seems...I'm totally new to Python/Zope/MySQL and I got the lot working without a glitch. I'm running FreeBSD4.2, but I can't think that things should be that much harder on Linux....here's how I did it....
- Python 2 installed and running OK - Zope 2.3.0 installed and running OK ...I assume you got this far, maybe different versions though... - Installed mysql-client-3.23.35 (not a Zope product, but the client part of the MySQL suite) from a package...I think this package is available for Linux too...This is needed to be able to do the following step. I chose the package and not the source not to embarras myself hunting down system specific compile options and paths and stuff... - Got hold of MySQL-python-0.3.5.tar.gz (ZOPE DA) from zope.org I think...Untarred the lot and read the README file....there's some special mention of Linux and other package-based releases of mysql(client) installed in the previous step...seems you MIGHT have to look for a 'developers' package too, but I tried without and it worked. I noticed README could cause some confusion on exactly what you need to install first...it says 'MySQL 3.22.19 or higher', but I understood I need (in my case) only mysql-client-3.23.35 or something similar...you don't need something like mysql-server-xx.xx.xx, cause the server could be run anywhere else. Of course, you could install the server too, but that's an entirely different matter. So make sure you've got the 'server' thingie installed from the previous step, and maybe something like mysql-devel-3.23.35, in your case. - So up to now I didn't compile anything. mysql-client was a package, and MySQL-python from the previous step is just sitting there untarred. The README mentions stuff you might need to hack in setup.py, but I didn't touch it, and I don't think you'd need to. Then I just did as they say in the README: python setup.py build and python setup.py install. The whole cadoodle just went fine. - I stopped my Zope (./stop from zope folder) and restarted it (./start). - Connected to Zope as admin, and saw the item 'Z mySQL Database Connection' added to the add new items box.
Okay actually I just build the Mysql_python I restarted Zope but the connection isn't in the list of new items. Where did you untar the MySQL_python package ? Gitte
Needless to say, I've been able to really use the mySQL connection in Zope. It seems you've downloaded another version/distribution of the Zope mySQL DA that you've had to 'make'. Have you tried 'gmake'? Otherwise, go for the MySQL-python-0.3.5.tar.gz file I used.
lemme know if it works...
-- ************************ Gitte Wange Jensen System Squid Developer MMManager Aps +45 29 72 79 72 gitte@mmmanager.org ************************
participants (7)
-
Gerrie Roos -
ghaley＠mail.venaca.com -
Gitte Wange -
Norman Khine -
Peter Bengtsson -
Phil Harris -
sam gendler