I have similar problems with GUF and mySQL.
I gave userAuthenticate and userList the proxy role "Authoriser"
and allowed "Authoriser" to use SQL-Method in my SQL-Method.
What happened is that I cannot access "real_password" in
2000-07-11T17:45:33 ERROR(200) GUF
raised an exception (('Unauthorized', 'You are not authorized to access
<em>real_password</em>.', <traceback object at 850dc28>))
In addition, userList is defined as :
"sql_get_user_list()" is simply: "select user_login from users"
The result is: "userList method returned an unsupported type"
2000-07-11T17:40:39 ERROR(200) GUF An exception was raised by
(('Unsupported Type', 'userList method returned an unsupported type',
<traceback object at 8509b80>))
Any ideas ... ???
> I'm trying to add a SQL connection to GUF, and getting an error when
> trying step 8 of the How To ("HOWTO Use GenericUserFolder with an SQL
> "You are not authorized to change change_password_report because you do
> not have proxy roles. "
> The step 8 says (http://www.zope.org/Members/hippy/GUF_SQL_crypt_1_2):
> 8. Set permissions to protect the use database.
> It is now time to setup the permissions on the GUF objects to ensure
> that the SQL methods can only be called the code that we have created.
> Create a user defined role called Authoriser in the acl_users folder do
> not give it any permissions.[ok: created at the folder that contains the
> set the 'Use Database Methods' permission for 'Authoriser' on all the
> SQLMethods created above.[ok]
> set the Proxy role "Authoriser" on:
> change_password_report [oh-oh]
> I'm doing it as a user that have the 'Manager' role at the root of the
> Zope site. The same username exists in the GUF, but I cannot change its
> roles (trying this trashes the connection).
> I'm using GUF 1-2-4. Zope is the 2.1.6, and connected to a PostgreSQL
> 7.0.1 (it works).
> CÚsar A. K. Grossmann
> [EMAIL PROTECTED]
> 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 -