[Zope] GUF + SQL connection problem

[Mario Premke]

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 )
>