New ZMysql adapter connection problem
Hi, I'm test 2.7.3 out and I cannot create a connection to my database. I am using the new adapter ZMySQLDA-2.0.9b2 <http://sourceforge.net/projects/mysql-python/> .and I loaded MySQL-python.exe-0.9.2.win32-py2.3.exe pointing it to the bin directory of my zope installation. It added it to my product list but when I try to make a connection I see the following: Traceback (innermost last): * Module ZPublisher.Publish, line 175, in publish_module_standard * Module ZPublisher.Publish, line 132, in publish * Module Zope.App.startup, line 204, in zpublisher_exception_hook * Module ZPublisher.Publish, line 101, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 39, in call_object * Module Products.ZMySQLDA.DA, line 106, in manage_addZMySQLConnection * Module Shared.DC.ZRDB.Connection, line 64, in __init__ * Module Shared.DC.ZRDB.Connection, line 97, in edit * Module Products.ZMySQLDA.DA, line 126, in connect * Module Products.ZMySQLDA.db, line 183, in __init__ AttributeError: server_capabilities (Also, an error occurred while attempting to render the standard error message.) I also tried a password option but still no connection. I know I could do the above in 2.6.1. Thanks, Larry
On Tue, 28 Dec 2004 12:58:02 -0500, Larry McDonnell <larry@technologyinedu.com> wrote:
I'm test 2.7.3 out and I cannot create a connection to my database. I am using the new adapter ZMySQLDA-2.0.9b2 .and I loaded MySQL-python.exe-0.9.2.win32-py2.3.exe pointing it to the bin directory of my zope installation. It added it to my product list but when I try to make a connection I see the following:
Module Products.ZMySQLDA.db, line 183, in __init__ AttributeError: server_capabilities (Also, an error occurred while attempting to render the standard error message.)
A well-known bug in MySQLdb-0.9.2 that occurs with Python-2.2 and newer. I recommend using 1.1.7 or newer, or 1.0.0. There may be some new Windows packages in the next few days; however, I depend on people to contribute these because I cannot build them myself. -- Computer interfaces should never be made of meat. Using GMail? Setting Reply-to address to <> disables this annoying feature.
Andy Dustman wrote:
On Tue, 28 Dec 2004 12:58:02 -0500, Larry McDonnell <larry@technologyinedu.com> wrote:
I'm test 2.7.3 out and I cannot create a connection to my database. I am using the new adapter ZMySQLDA-2.0.9b2 .and I loaded MySQL-python.exe-0.9.2.win32-py2.3.exe pointing it to the bin directory of my zope installation. It added it to my product list but when I try to make a connection I see the following:
Module Products.ZMySQLDA.db, line 183, in __init__ AttributeError: server_capabilities (Also, an error occurred while attempting to render the standard error message.)
I posted a patch for this ages ago. Know how to use google? ;-)
A well-known bug in MySQLdb-0.9.2 that occurs with Python-2.2 and newer. I recommend using 1.1.7 or newer, or 1.0.0. There may be some new Windows packages in the next few days; however, I depend on people to contribute these because I cannot build them myself.
What's the official work on what version of MySQLdb and ZMySQLDA you should use with Zope 2.7 (which uses Python 2.3)? cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk
On Wed, 12 Jan 2005 13:07:38 +0000, Chris Withers <chris@simplistix.co.uk> wrote:
Andy Dustman wrote:
A well-known bug in MySQLdb-0.9.2 that occurs with Python-2.2 and newer. I recommend using 1.1.7 or newer, or 1.0.0. There may be some new Windows packages in the next few days; however, I depend on people to contribute these because I cannot build them myself.
What's the official work on what version of MySQLdb and ZMySQLDA you should use with Zope 2.7 (which uses Python 2.3)?
MySQLdb-1.0.1 should work fine, though I prefer that you use 1.1.8. Since ZMySQLDA actually uses the _mysql module (C API), and most of the differences between 1.0 and 1.1 are in the Python layer, I don't think it really makes that much difference. ZMySQLDA hasn't been updated in two years because, AFAIK, there aren't any bad issues in 2.0.8 or 2.0.9b2. I might revisit ZMySQLDA in the next month or so. If there *are* issues, then report them here: https://sourceforge.net/tracker/?group_id=22307&atid=374932 -- Computer interfaces should never be made of meat. Using GMail? Setting Reply-to address to <> disables this annoying feature.
Andy Dustman wrote:
MySQLdb-1.0.1 should work fine, though I prefer that you use 1.1.8. Since ZMySQLDA actually uses the _mysql module (C API), and most of the differences between 1.0 and 1.1 are in the Python layer, I don't think it really makes that much difference.
ZMySQLDA hasn't been updated in two years because, AFAIK, there aren't any bad issues in 2.0.8 or 2.0.9b2. I might revisit ZMySQLDA in the next month or so.
Any chance of Windows builds appearing for MySQLdb-1.0.1 and ZMySQLDA 2.0.9b2? Also, could 2.0.9b2 become 2.0.9? l0( cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk
On Tue, 18 Jan 2005 18:41:23 +0000, Chris Withers <chris@simplistix.co.uk> wrote:
Any chance of Windows builds appearing for MySQLdb-1.0.1 and ZMySQLDA 2.0.9b2?
Sure, there's a chance. There's a zero chance of me building them, since I have neither the tools nor the inclination, but a non-zero chance of someone else building them, and if they let me know about it, I'll make it available for download on SourceForge.
Also, could 2.0.9b2 become 2.0.9? l0(
Just scratch out the "b2" and you'll be fine. I'm working on some small issues for MySQLdb-1.1.9, which wlil almost certainly become 1.2.0, and then maybe I can think about ZMySQLDA. -- Computer interfaces should never be made of meat. Using GMail? Setting Reply-to address to <> disables this annoying feature.
Andy Dustman wrote:
Any chance of Windows builds appearing for MySQLdb-1.0.1 and ZMySQLDA 2.0.9b2?
Sure, there's a chance. There's a zero chance of me building them, since I have neither the tools nor the inclination, but a non-zero chance of someone else building them, and if they let me know about it, I'll make it available for download on SourceForge.
Give me the code and tell me how, I'll give it a go :-) I have MSVC++ 6.0... cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk
Larry McDonnell wrote:
Hi,
I'm test 2.7.3 out and I cannot create a connection to my database. I am using the new adapter ZMySQLDA-2.0.9b2 <http://sourceforge.net/projects/mysql-python/> .and I loaded MySQL-python.exe-0.9.2.win32-py2.3.exe pointing it to the bin directory of my zope installation. It added it to my product list but when I try to make a connection I see the following:
Traceback (innermost last):
* Module ZPublisher.Publish, line 175, in publish_module_standard * Module ZPublisher.Publish, line 132, in publish * Module Zope.App.startup, line 204, in zpublisher_exception_hook * Module ZPublisher.Publish, line 101, in publish * Module ZPublisher.mapply, line 88, in mapply * Module ZPublisher.Publish, line 39, in call_object * Module Products.ZMySQLDA.DA, line 106, in manage_addZMySQLConnection * Module Shared.DC.ZRDB.Connection, line 64, in __init__ * Module Shared.DC.ZRDB.Connection, line 97, in edit * Module Products.ZMySQLDA.DA, line 126, in connect * Module Products.ZMySQLDA.db, line 183, in __init__
AttributeError: server_capabilities (Also, an error occurred while attempting to render the standard error message.)
I also tried a password option but still no connection. I know I could do the above in 2.6.1.
Thanks, Larry
------------------------------------------------------------------------
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
I know the problem but have no Zope with MySQL access handy. There is a facility to limit the number of rows that are returned that does not work anymore (why I never bothered to find out). You just have to switch it of (I think by setting it to 0). You find it in one of the ZMySQLDB or ZSQL tabs. If you need further help, tell me. Robert
participants (4)
-
Andy Dustman -
Chris Withers -
Larry McDonnell -
robert