1. I understand. root@localhost = the default user = user_id 1

2. Access the SQL table “group_user” direct (use a sql tool)

3. Set for admin = user_id = 1 è the default admin group = group_id = 2  and "rw" in the permission_key field

Van: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Namens BCWINFO
Verzonden: vrijdag 8 februari 2008 12:54
Aan: User questions and discussions about OTRS.org
Onderwerp: Re: [otrs] I lost all admin power into OTRS!!!

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.