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
userAuthenticate :
2000-07-11T17:45:33 ERROR(200) GUF
http://134.96.119.88:8080/portal_folder/acl_users/userAuthenticate
raised an exception (('Unauthorized', 'You are not authorized to access
real_password.', ))
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
http://134.96.119.88:8080/portal_folder/acl_users/userList
(('Unsupported Type', 'userList method returned an unsupported type',
))
Any ideas ... ???
Mario
> 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
> Database"):
>
> "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):
>
> [snip]
> 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
> GUF]
>
> 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]
> userAuthenticate
> userList
> userRoles
>
> [snip]
>
> 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).
>
> TIA
> --
> César A. K. Grossmann
> [EMAIL PROTECTED]
> http://members.xoom.com/ckant/
>
> ___
> 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 )
