RE: [otrs] How do I remove Customer Users ?

I found that a relatively easy way to do this is to use mysqldump (if using mysql) to a sql script and simply edit out the information regarding the customer users. Then re-import the database after dropping/recreating it.

I have done something similar to this to create a "template" database only containing the table information that I wanted from my testing, for example I kept the agent users, groups, queues, and other assorted table data; but, eliminated users and ticket specific data inserts. Remember that you will may encounter problems with the root@localhost in the script so I just copied/replaced the known password string for another agent user and changed it after the fact through the web ui. I also ran into the problem that I needed to re-run the mysql security grant to make the database accessible through the appropriate user.

The MySQL syntax should be something like:

GRANT ALL PRIVILEGES ON dbname.* TO otrs@localhost IDENTIFIED BY "PasswordHere" WITH GRANT OPTION;

I think this is in the 1.3 documentation in section 1.2.2

I hope this helps

Brad West
Network/Systems Engineer
Spang & Company
bwest@spang.com

-----Original Message-----
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Duarte Cordeiro
Sent: Wednesday, September 14, 2005 10:57 AM
To: User questions and discussions about OTRS.org
Subject: RE: [otrs] How do I remove Customer Users ?

Well, OTRS doesn't allows you to delete anything! :)
You can... delete the database and create a new one. Or think that invalid users are deleted users :)

Or... you can wait for the feature I requested: a check box that allows us to hide the invalid users/queues/groups/etc/etc...

Duarte

-----Original Message-----
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of John Hennessy
Sent: quarta-feira, 14 de Setembro de 2005 15:44
To: otrs@otrs.org
Subject: [otrs] How do I remove Customer Users ?

Hi, I am running OTRS for the first time and would like to know how to
delete Customer Users.

I am logged in as the Admin user and have entered the Customer area. I
can search on users with "*", select the users in question and change
their "Valid" status to "invalid". I can not however find how to remove
them.

OTRS 2.02-01
MySQL 4.0.18-log
Apache 2.0.49
RedHat Linux 9 (Shrike)

Any advice is appreciated.

John.

_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting f|r Ihr OTRS System?
=> http://www.otrs.de/