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 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:* 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/

Dear Peter, what SQL Tool? Any tip? On Feb 8, 2008 10:51 AM, Peter van Beugen wrote:

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

Dear LQ. I found it!!! I have a structure like explorer. The left site, a lot of DBs? I could not find anything like OTRS... On Feb 8, 2008 2:59 PM, LQ Marshall wrote:

...

what SQL Tool? Any tip?

I think you said you were using M$-SQL which implies that there is an install of the MS SQL Query Analyzer on the server. If it was not installed you can install it from the install CD, but it is loaded by default.

gl

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

Ok LQ. I have edited Config.pm: # database settings # # ---------------------------------------------------- # # DatabaseHost # (The database host.) $Self->{'DatabaseHost'} = 'localhost'; # Database # (The database name.) $Self->{'Database'} = 'otrs'; # DatabaseUser # (The database user.) $Self->{'DatabaseUser'} = 'otrs'; # DatabasePw # (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{'DatabasePw'} = 'hot'; # DatabaseDSN I think that this tells me that the name of my database is really OTRS as I thought. Right? However, unhappily, I still could not find it into SQL Querry Analizer. What a hell! On Feb 9, 2008 3:39 AM, LQ Marshall wrote:

The database could be named nearly anything. If you have access to OTRS files the database is referenced in the Config.pm http://config.pm/ file (it's in the Kernel dir). Don't know if the win32 version uses the same structure though.

Probably will have to look for the DB name and then go back to Query analyzer. You may also have the Enterprise admin tool (which may be described as QA on steroids).

LQ

config.pm: it looks like a default otrs/mysql installation as you cannot find the otrs db in mssql: is it possible that a mysql server is running on this machine? regards, Peter ________________________________ Van: otrs-bounces@otrs.org namens BCWINFO Verzonden: za 9-2-2008 20:47 Aan: User questions and discussions about OTRS.org Onderwerp: Re: [Spam] Re: [otrs] I lost all admin power into OTRS!!! Ok LQ. I have edited Config.pm: # database settings # # ---------------------------------------------------- # # DatabaseHost # (The database host.) $Self->{'DatabaseHost'} = 'localhost'; # Database # (The database name.) $Self->{'Database'} = 'otrs'; # DatabaseUser # (The database user.) $Self->{'DatabaseUser'} = 'otrs'; # DatabasePw # (The password of database user. You also can use bin/CryptPassword.pl # for crypted passwords.) $Self->{'DatabasePw'} = 'hot'; # DatabaseDSN I think that this tells me that the name of my database is really OTRS as I thought. Right? However, unhappily, I still could not find it into SQL Querry Analizer. What a hell! On Feb 9, 2008 3:39 AM, LQ Marshall wrote: The database could be named nearly anything. If you have access to OTRS files the database is referenced in the Config.pm http://config.pm/ file (it's in the Kernel dir). Don't know if the win32 version uses the same structure though. Probably will have to look for the DB name and then go back to Query analyzer. You may also have the Enterprise admin tool (which may be described as QA on steroids). LQ

You can set the password for a user with otrs/bin/otrs.setPassword 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. On Feb 8, 2008 9:42 AM, Peter van Beugen 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: 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/