My Zope-MySQL connection is still not quite working. It appears that the request from Zope is reaching MySQL and it if is an UPDATE or INSERT query it executes properly on the MySQL side. However, SELECT queries and similar are not getting their information back to Zope from MySQL. Is there some patch I am missing here? Anybody know how to fix this? FYI: I installed from these rpms ftp://ftp.logicetc.com/pub/Zope/RPMS/MySQL-python-0.2.1-1.i386.rpm ftp://ftp.logicetc.com/pub/Zope/RPMS/Zope-ZMySQLDA-1.2.0-1.i386.rpm This did not install into my Zope installation directory, so I used a symbolic link in my Zope Products directory that points to the directory of MySQLDA install. Could this be the cause? Perhaps information that should be returned from MySQL is getting lost on the return trip. If so, how would I fix it? Any ideas? P. Johnson
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of paul_s_johnson@urscorp.com Sent: Wednesday, January 10, 2001 9:30 AM To: zope@zope.org Subject: [Zope] MySQLDA and MySQL-python - patch needed?
My Zope-MySQL connection is still not quite working. It appears that the request from Zope is reaching MySQL and it if is an UPDATE or INSERT query it executes properly on the MySQL side. However, SELECT queries and similar are not getting their information back to Zope from MySQL. Is there some patch I am missing here? Anybody know how to fix this?
FYI: I installed from these rpms
ftp://ftp.logicetc.com/pub/Zope/RPMS/MySQL-python-0.2.1-1.i386.rpm ftp://ftp.logicetc.com/pub/Zope/RPMS/Zope-ZMySQLDA-1.2.0-1.i386.rpm
This did not install into my Zope installation directory, so I used a symbolic link in my Zope Products directory that points to the directory of MySQLDA install. Could this be the cause? Perhaps information that should be returned from MySQL is getting lost on the return trip. If so, how would I fix it? Any ideas?
The RPMS install the DA where the Zope RPMS install Products. I actually put my products in the same place (RPMS or not) and use symbolic links for the different instances of Zope I have running, so I know symbolic links will work. If DA product is showing not broken in the Control Panel, then it was installed properly. Are you getting any error messages? How do you know the information is not getting back to Zope? When you test the queries on the connection management screen, do you get results? _______________________ Ron Bickers Logic Etc, Inc. rbickers@logicetc.com
Am Donnerstag, 11. Januar 2001 00:16 schrieben Sie:
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of paul_s_johnson@urscorp.com Sent: Wednesday, January 10, 2001 9:30 AM -----snipp----------- FYI: I installed from these rpms
ftp://ftp.logicetc.com/pub/Zope/RPMS/MySQL-python-0.2.1-1.i386.rpm
I was not able to get ZMySQLDA with MySQL-pyhton to run. Instead I used the mysqldb sourcecode that came with ZMySQLDA and symlinked the resulting _mysqlmodule.so into .../lib/python1.5/site-packages/
ftp://ftp.logicetc.com/pub/Zope/RPMS/Zope-ZMySQLDA-1.2.0-1.i386.rpm
This did not install into my Zope installation directory, so I used a symbolic link in my Zope Products directory that points to the -----snipp----------- (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- ----------------------------------- catWorkX GmbH Dipl.-Ing. Holger Lehmann Stresemannstr. 364 22761 Hamburg Tel: +49 (0700) catWorkX Tel: +49 (40) 890 646-0 Fax: +49 (40) 890 646-66 mailto:lehmann@catworkx.de http://www.catworkx.de http://www.catbridge.de
On Wed, 10 Jan 2001 paul_s_johnson@urscorp.com wrote:
My Zope-MySQL connection is still not quite working. It appears that the request from Zope is reaching MySQL and it if is an UPDATE or INSERT query it executes properly on the MySQL side. However, SELECT queries and similar are not getting their information back to Zope from MySQL. Is there some patch I am missing here? Anybody know how to fix this?
FYI: I installed from these rpms
ftp://ftp.logicetc.com/pub/Zope/RPMS/MySQL-python-0.2.1-1.i386.rpm ftp://ftp.logicetc.com/pub/Zope/RPMS/Zope-ZMySQLDA-1.2.0-1.i386.rpm
You might also try: http://www.zope.org/Members/adustman for MySQLdb-0.3.0 and ZMySQLDA-2.0.1, which includes a transactional DA for MySQL servers with BDB tables (3.23.30 recommended). -- andy dustman | programmer | comstar.net is part of the Globix network telephone: 770.485.6025 / 706.549.7689 | icq: 32922760 | pgp: 0xc72f3f1d "Therefore, sweet knights, if you may doubt your strength or courage, come no further, for death awaits you all, with nasty, big, pointy teeth!"
participants (4)
-
Andy Dustman -
Holger Lehmann -
paul_s_johnsonļ¼ urscorp.com -
Ron Bickers