Remove users from drop down list

[Sam Ayoubpour]

Hello Everyone,

 

My question is: How does one remove old users from the drop down list...?

 

Thanks,

Sam.

[Erik Andersson]

Hi

Maybe http://trac.edgewall.org/wiki/TracTickets#Assign-toasDrop-DownList will help you out.

Cheers / Erik

2008/2/14, Sam Ayoubpour <SAyou...@looksmart.net>:

[Sam Ayoubpour]

Thanks Erik, I've seen that page and I'm able to add users but I'm trying to remove users from the drop down list, which I haven't been able to find any documentation on...

 

Sam.

---

From: trac-...@googlegroups.com [mailto:trac-...@googlegroups.com] On Behalf Of Erik Andersson
Sent: Thursday, February 14, 2008 1:43 PM
To: trac-...@googlegroups.com
Subject: [Trac] Re: Remove users from drop down list

[G S]

 

Hi Sam,

 

You are correct the page tells you how to add them but removing should be the opposite.

 

So

DELETE FROM session_attribute WHERE sid='name';

DELETE FROM session WHERE sid='name';

 

Should remove the name from the database.

HOWEVER I have not tried this so please do not just copy and paste and run this on your databse without testing and backups.

[Sam Ayoubpour]

Thanks...

 

---

From: trac-...@googlegroups.com [mailto:trac-...@googlegroups.com] On Behalf Of G S
Sent: Thursday, February 14, 2008 1:53 PM

[Quinn Comendant]

On Thu, 14 Feb 2008 08:49:49 -0800, Sam Ayoubpour wrote:
> How does one remove old users from the drop down
> list...?

The way I've done it is to issue commands directly to the database to remove the sessions for users you want removed. Assuming you're using a SQLITE database, the commands would be:

1. Launch the sqlite command-line client:
sqlite /path/to/your/project/db/trac.db

2. Remove users:
sqlite> delete from session where sid = '<username1>';
sqlite> delete from session where sid = '<username2>';
sqlite> delete from session where sid = '<username3>';

Quinn

[Tareq Takrori]

to view all sessions
 trac-admin /var/www/svn/admin/ session list

to remove a session
trac-admin /var/www/svn/admin/ session delete <username>