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 <em>real_password</em>.', <traceback object at 850dc28>)) In addition, userList is defined as : <dtml-return "sql_get_user_list()"> "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', <traceback object at 8509b80>)) 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 ckant@usa.net http://members.xoom.com/ckant/
_______________________________________________ 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 )