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