Re: [Zope] MySQLDA and MySQL-python - patch needed?
On Wed, 10 Jan 2001 [EMAIL PROTECTED] 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!" ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] MySQLDA and MySQL-python - patch needed?
Am Donnerstag, 11. Januar 2001 00:16 schrieben Sie: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] 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:[EMAIL PROTECTED] http://www.catworkx.de http://www.catbridge.de ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] MySQLDA and MySQL-python - patch needed?
Paul S. Johnson URS Corporation 700 Third Street South Minneapolis, MN 55415-1199 612-373-6389 "Ron Bickers"To: [EMAIL PROTECTED], [EMAIL PROTECTED] rbickers@logcc: icetc.com Subject: RE: [Zope] MySQLDA and MySQL-python - patch needed? Sent by: zope-admin@zo pe.org 01/10/01 05:16 PM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, January 10, 2001 9:30 AM To: [EMAIL PROTECTED] 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. On my box only DA is symlinked to a different location. The rest of my products reside in a child directory of the main Zope installation. I am only running one Zope instance. This shouldn't be a problem, right? 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? From Zope management database connection Test tab, on valid SELECT queries it tells me that there was no data matching my query. On invalid SELECT queries (ones on nonexistent tables or columns) Zope raises the correct error originating from MySQL, such as "Error Value: (1146, "Table 'somedatabase.sometable' doesn't exist")". The trial queries I am testing through Zope all work from the MySQL command line so I know they do in fact return data. It appears that error messages are making it back to Zope from MySQL but real query results are not. I did some more searching and see that two other posters on this list have also had this identical problem, but no solutions have been posted (at least that I can find). ONE IDEA: I had already spent some time on installing DA before I found your RPMs. Previous to this I was trying some older, more complicated methods outlined on Zope.org and started installing some of the necessary components for installation. I did clean up before installing from the RPMs, but perhaps I missed somethi
RE: [Zope] MySQLDA and MySQL-python - patch needed?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, January 10, 2001 9:30 AM To: [EMAIL PROTECTED] 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. On my box only DA is symlinked to a different location. The rest of my products reside in a child directory of the main Zope installation. I am only running one Zope instance. This shouldn't be a problem, right? 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? From Zope management database connection Test tab, on valid SELECT queries it tells me that there was no data matching my query. On invalid SELECT queries (ones on nonexistent tables or columns) Zope raises the correct error originating from MySQL, such as "Error Value: (1146, "Table 'somedatabase.sometable' doesn't exist")". The trial queries I am testing through Zope all work from the MySQL command line so I know they do in fact return data. It appears that error messages are making it back to Zope from MySQL but real query results are not. I did some more searching and see that two other posters on this list have also had this identical problem, but no solutions have been posted (at least that I can find). ONE IDEA: I had already spent some time on installing DA before I found your RPMs. Previous to this I was trying some older, more complicated methods outlined on Zope.org and started installing some of the necessary components for installation. I did clean up before installing from the RPMs, but perhaps I missed something and some residue lingers. I know how to uninstall RPMs, but other than that how do I make sure I have a clean slate before trying to install anew? I think there is quite a number of mod dependencies here. Also I am confused on a basic piece of Zope configuration: my box has its own python and Zope has its own python, why two and are they sharing modules? If you want to add a module for both installs of python do I have to install in both? If I install a python module in my box's python can Zope's python find and use it? I am confused on this basic question. I also did this as (contributed previously to the list) to fix a install but broken DA. Directory, site-packages, now exists in two locations. Is this a problem? Seems that because of how my Zope was installed had problems... I copied all files from /usr/lib/python1.5/site-packages/ to /usr/local/zope/lib/python/Products/ZmySQLDA and all was sweet. Day 5 of the insanity continues. -PSJ ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] MySQLDA and MySQL-python - patch needed?
I haven't been following this thread, so I apologize in advance for any redundancy. Several weeks ago I had an existing mysql fail as you describe after I upgraded mysqldb in /usr/lib/python. I fixed it by moving ZMySQLDA/MySQLdb-0.1.2/_mysqlmodule.so up one level as described in README.txt. Bill. On Thu, 11 Jan 2001 [EMAIL PROTECTED] wrote: From Zope management database connection Test tab, on valid SELECT queries it tells me that there was no data matching my query. On invalid SELECT queries (ones on nonexistent tables or columns) Zope raises the correct error originating from MySQL, such as "Error Value: (1146, "Table 'somedatabase.sometable' doesn't exist")". The trial queries I am testing through Zope all work from the MySQL command line so I know they do in fact return data. It appears that error messages are making it back to Zope from MySQL but real query results are not. ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] MySQLDA and MySQL-python - patch needed?
A binary distribution comes with python built-in so that it will run without the installer having to also go get python. PYTHONPATH is the key to understanding module sharing. Unless you (or the packager) change something, a binary Zope uses only the modules in the built-in python (or, at least, has the built-in lib/python first in PYTHONPATH). In the same vein, the two pythons don't share modules unless you change somemthing, e.g. PYTHONPATH (or maybe both their PYTHONPATHs end in /usr/local/python). Just to double check what's going on in your Zope, use this code to create an external method and visit it with your browser. import sys def sysPath(self): buff = '' for dir in sys.path: buff = '%s\n%s' % (buff, dir) return buff Bill. On Thu, 11 Jan 2001 [EMAIL PROTECTED] wrote: dependencies here. Also I am confused on a basic piece of Zope configuration: my box has its own python and Zope has its own python, why two and are they sharing modules? If you want to add a module for both installs of python do I have to install in both? If I install a python module in my box's python can Zope's python find and use it? I am confused on this basic question. ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] MySQLDA and MySQL-python - patch needed?
On my box only DA is symlinked to a different location. The rest of my products reside in a child directory of the main Zope installation. I am only running one Zope instance. This shouldn't be a problem, right? This should not be a problem. From Zope management database connection Test tab, on valid SELECT queries it tells me that there was no data matching my query. On invalid SELECT queries (ones on nonexistent tables or columns) Zope raises the correct error originating from MySQL, such as "Error Value: (1146, "Table 'somedatabase.sometable' doesn't exist")". The trial queries I am testing through Zope all work from the MySQL command line so I know they do in fact return data. It appears that error messages are making it back to Zope from MySQL but real query results are not. Are you saying that the valid select queries are suppose to return data, but in the test screen they don't? If you can run a query and get a response, that's a pretty strong indication that both the module and the DA are installed correctly. It's quite possible that the binary RPMs only work properly with certain versions of MySQL for whatever reason. Perhaps if you compile the module from the src RPM (http://dustman.net/andy/python/MySQLdb/0.2.1/MySQL-python-0.2.1-1.i386.rpm) you can eliminate one more factor. You'll probably need to have MySQL-devel installed as well as python-devel. The only reason I point to an older version of Andy's module is because that's what I'm using and I know it works for me. RPMs, but perhaps I missed something and some residue lingers. I know how to uninstall RPMs, but other than that how do I make sure I have a clean slate before trying to install anew? I think there is quite a number of mod dependencies here. Also I am confused on a basic piece of Zope configuration: my box has its own python and Zope has its own python, why two and are they sharing modules? If you want to add a module for both You could probably have many versions of python that share modules. I'm using my everyday python for Zope, but I know that's not possible for some, because Zope needs certain options that the "default" version may not have compiled in. If your Zope is running, the MySQLDA product isn't broken, and you can run queries on the test page, then I can't see how it's a python or Zope problem. I may just be blind, though. I also did this as (contributed previously to the list) to fix a install but broken DA. Directory, site-packages, now exists in two locations. Is this a problem? As long as the python you're using for Zope can find the module you expect it to find, you should be fine. Seems that because of how my Zope was installed had problems... I copied all files from /usr/lib/python1.5/site-packages/ to /usr/local/zope/lib/python/Products/ZmySQLDA and all was sweet. Day 5 of the insanity continues. I must have been very lucky with my installation since I've never had these kinds of problems getting it running, but I see that many have. ___ Ron Bickers Logic Etc, Inc. [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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] 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? P. Johnson ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] MySQLDA and MySQL-python - patch needed?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, January 10, 2001 9:30 AM To: [EMAIL PROTECTED] 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. [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )