Modify

Opened 14 years ago

Last modified 4 years ago

#2134 new enhancement

Choose users not in the list but with a simple form

Reported by: sdouche Owned by:
Priority: normal Component: PeerReviewPlugin
Severity: blocker Keywords: ldap authentification
Cc: Trac Release: 0.11

Description

If you using LDAP authentification, users aren't stored in sqlite DB. So, the dropdown list is always empty. A simple workaround is to choose manually users with simple form, like original assign to field in new ticket form.

Nevermind, great job !

Attachments (0)

Change History (7)

comment:1 Changed 13 years ago by Sebastian Marek

Type: defectenhancement

comment:2 Changed 13 years ago by Sebastian Marek

Trac Release: 0.100.11

comment:3 Changed 10 years ago by Marc

Owner: changed from Joseph Lombrozo to Marc

comment:4 Changed 9 years ago by Olemis Lang

Owner: changed from Marc to Olemis Lang

comment:5 Changed 7 years ago by anonymous

If you change the query in the dbBackend.py method getPossibleUsers to the query trac uses to get usernames

cursor.execute("""
                 SELECT DISTINCT s.sid, n.value, e.value
                 FROM session AS s
                  LEFT JOIN session_attribute AS n ON (n.sid=s.sid
                   and n.authenticated=1 AND n.name = 'name')
                  LEFT JOIN session_attribute AS e ON (e.sid=s.sid
                   AND e.authenticated=1 AND e.name = 'email')
                 WHERE s.authenticated=1 ORDER BY s.sid
                 """)

Then the user list is populated correctly

Last edited 7 years ago by Ryan J Ollos (previous) (diff)

comment:6 Changed 5 years ago by Cinc-th

In 15205:

New query which removes group names from the user list. The user names are still taken from the permission table.

Refs #2134

comment:7 Changed 4 years ago by Ryan J Ollos

Owner: Olemis Lang deleted

Modify Ticket

Change Properties
Set your email in Preferences
Action
as new The ticket will remain with no owner.

Add Comment


E-mail address and name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.