Peter my dear friend. Let's try to talk the same language, hehehehe.
1.) I was an admin user. But now, I'm just a common user. Trying to
understand the concept of groups and roles I just f*c*ed all. I tried the
user root@localhost and admin but no success too. System tells me that they
aren't a valid user!
2.) I believe that I have access to the tables. But I'm not using MySQL. I'm
using a paid version (the server that received OTRS already had Microsoft
SQL Server installed and running).
3.) Could you please help me to do that? I'm an IT infrastructure guy and
have some trouble operating SQL.
On Feb 8, 2008 9:42 AM, Peter van Beugen
Can you still login as the default admin user (userid =1)?
Do you have access to the MySQL tables?
I believe the admin rights can be reset by changing a value in the group_user table
The default admin user_id = 1
The default admin group = group_id = 2
In the group_user table
User_id = 1 must have a value with
Group_id = 2 and
"rw" in the permission_key field
Regards,
Peter
*Van:* otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *Namens * BCWINFO *Verzonden:* vrijdag 8 februari 2008 12:20 *Aan:* otrs@otrs.org *Onderwerp:* [otrs] I lost all admin power into OTRS!!!
Hello everyone!
I'm having a lot of fun with OTRS. Very useful system to our company. But now I have a little problem. Changing a lot of permissions (Groups, Roles, etc.) I lost the option Admin with all users. Is there any way to recover this option?
_______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/