[Zope] GUF and userList problems

[Michal Bukovjan]

That should work. You could try either to return the query object directly (in
comments they say it is possible),
and make sure that there are no spaces in the string returned from database.
I was solving similar problem with PostgreSQL, when the username field was
defined as CHAR(20), it always returned 20 characters regardless of the actual
length of the username, the username was padded with spaces. Switching to
VARCHAR solved my problem.
Or you could try to strip the username.

Michal Bukovjan

"Mabe, Brad" wrote:

> Greetings,
> I am having problems with GUF authentication after including a call to a sql
> method from within the GUF supplied userList method.  I have GUF installed
> correctly, and able to authenticate from a static list of users I created in
> the userList method. When I attempt to call a sql method from within
> userList, all authentications fail.  Even for the list of static users.
>
> My sql method, "SQL_get_users", is very simple:
> select user_account from user
>
> My modified userList Method is as follows:
> <dtml-in SQL_get_users>
> <dtml-var user_account>
> </dtml-in>
> jorge
> fred
> mongo
>
> I have verified that the sql method returns users by selecting the
> "User_list" tab from within the acl_users folder. I have tried numerous
> things, but I cannot get any of the users to authenticate after adding the
> <dtml-in> statement.  If I comment out the <dtml-in> statement, the users
> jorge, fred, and mongo can once again authenticate.  At first I thought
> maybe one of the sql method supplied users was conflicting with either
> jorge, fred, or mongo in some way so I took out the <dtml-var user_account>
> line, essentially calling the sql method but not returning anything from it.
> Still couldn't authenticate anyone.
>
> Has anyone been successful in getting GUF userList to work with a sql
> method?  I have read through hippys how-to and think I have done everything
> he has suggested.
>
> Systems specifics are:
> Microsoft Windows NT 4.0 server, service pack 5
> Zope version 2.1.6
> GUF version 1.2.2
> Microsoft Access 2000
>
> Any help at this point will be appreciated.  I'm really pulling my hair out
> over this.
>
>        -=Brad=-
>
> _______________________________________________
> 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 )