[rt-users] Adding users

[Izz Abdullah]

I have a question then regarding this.  We are at the point now we are ready to move our 3.8.6 database to our 4.0.2 installation.  I am using LDAP authentication in the new install, but it was not being used in the 3.8.6 install.  At some point in the past, the group here imported ALL LDAP users into MySQL so that accounts would already be created for them.  I had planned to go in and run a sql script I have put together to delete all MySQL local users (except for a few in IT, and the needed Nobody, RT_System, root, etc.) directly.  Can someone point me in a 'better' way to do this using the API?  These are all unprivileged users, and maintaining history correlation for the accounts in which I will remove is not an issue (e.g. it is ok that old tickets will not have an owner associated with them).

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Thomas Sibley
Sent: Monday, November 07, 2011 8:46 AM
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Adding users

On 11/06/2011 07:11 PM, Jim T wrote:
> I have to add about 80 users to RT. These will be unprivileged users
> that will use the SelfService link to create tickets. I have succesfully
> imported the users directly into MySQL on a test system with phpMyAdmin.
> However I can't find where to "Allow this user to access RT" in any of
> the db fields. Does anybody know how I can achieve this?

As others have said, but I want to stress: don't users directly in the
DB.  Besides flags like Disabled, you'll also probably miss the acl
equivalence group, group membership records, cached group membership
records, etc.  Things will behave very poorly with that information
missing.  If you've already done this on a production system where you
can back out the changes, please run rt-validator which may be able to
fix some of the problems.

Thomas
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
*  Barcelona, Spain  November 28 & 29, 2011