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 [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> wrote: > 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:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *Namens * > BCWINFO > *Verzonden:* vrijdag 8 februari 2008 12:20 > *Aan:* [email protected] > *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/ >
_______________________________________________ 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/
