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-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Thomas Sibley Sent: Monday, November 07, 2011 8:46 AM To: rt-users@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 -------- RT Training Sessions (http://bestpractical.com/services/training.html) * Barcelona, Spain November 28 & 29, 2011