Ah ah success.... while searching the mail archives I found this. I wasnt imagining it, there is an ODBC problem in 2.2. This patch solves it:
Hi guys -
For those of you (I've mostly heard ODBC adapter users) having authorization problems with your SQL methods, heres the scoop:
Database connections use one of two classes in the framework for wrapping up result data returned from queries. One of those classes (that understands results in RDB format) was missing a required security assertion.
The results returned by the ODBC adapter were bitten by this - probably there are other adapters that could be affected.
I've attached a patch file for the file: lib/python/Shared/DC/ZRDB/RDB.py
...as well as an updated version of the whole file (since I know a lot of you will be on Windows w/o patch :) Either patch or replace the file and restart Zope to fix the problem.
This is also checked in for a 2.2.1 release that will probably happen after a few weeks when enough people have upgraded to shake out any other problems.
----- Original Message ----- From: "Andy McKay" <AndyM@activestate.com> To: <zope@zope.org> Sent: Thursday, July 20, 2000 2:59 PM Subject: [Zope] Fw: [Zope] GUF, 2.2 and SQL
Ok heres more.... if I look up a bogus username it works fine. If I look up a valid username it bombs. Its not running the method that is the problem, its accessing the recordset returned. Has something else changed here?
<dtml-call "REQUEST.set('ret', '')">
<dtml-in "sql_get_role(username=username)"> <dtml-call "REQUEST.set('ret', ret + ' ' + _['sequence-item'].roles)"> </dtml-in>
<dtml-return ret>
----- Original Message ----- From: "Andy McKay" <AndyM@activestate.com> To: <zope@zope.org> Sent: Thursday, July 20, 2000 2:41 PM Subject: [Zope] GUF, 2.2 and SQL
Hi.
Well Ive done a clean install of GUF and 2.2. Ive followed the instructions to the letter in installing SQL for GUF and no matter what I do I cannot get the damn thing to work.
I have even set all users to have access to all things. And that doesnt work. Has anyone else had this total failure at getting anywhere, or is it just me?
Thanks.
Andy McKay
_______________________________________________ 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 )