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:
> ...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
> 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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
> 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-return ret>
> ----- Original Message -----
> From: "Andy McKay" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> 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
> > to the letter in installing SQL for GUF and no matter what I do I cannot
> > 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
> > just me?
> > Thanks.
> > Andy McKay
> > _______________________________________________
> > 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 maillist - [EMAIL PROTECTED]
> ** No cross posts or HTML encoding! **
> (Related lists -
> http://lists.zope.org/mailman/listinfo/zope-dev )
Zope maillist - [EMAIL PROTECTED]
** No cross posts or HTML encoding! **
(Related lists -