
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/ _______________________________________________ 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/