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" <[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
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" <[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
> 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  -  [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]
> 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]
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 )

Reply via email to