Greetings to all, I'm working on getting OTRS config'd and I mistakenly removed root's admin permissions. How do I fix this? Thanks, Tom -- Thomas Earl Network Engineer & Designer Communications Access Center (CAC) 1631 Miller Road Flint, Michigan, 48503 248-705-7408 (cell) 810-239-3112 (office) "Life is not a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside, thoroughly used up, totally worn out, and loudly proclaiming...'Wow! What a ride!!'" --Jack Wilson
Thomas Earl wrote:
Greetings to all,
I'm working on getting OTRS config'd and I mistakenly removed root's admin permissions. How do I fix this?
Thanks,
Tom
-- Thomas Earl Network Engineer & Designer Communications Access Center (CAC) 1631 Miller Road Flint, Michigan, 48503 248-705-7408 (cell) 810-239-3112 (office)
"Life is not a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside, thoroughly used up, totally worn out, and loudly proclaiming...'Wow! What a ride!!'" --Jack Wilson
_______________________________________________ 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 oder Consulting für Ihr OTRS System? => http://www.otrs.de/
are you talking about to the database? Where were they removed?
I mistakenly removed permissions from root (and not given it to any other users) to the admin section. I fixed it this morning by dropping and rebuilding the otrs database. All fixed. Thanks for replying. Tom -- Thomas Earl Network Engineer & Designer Communications Access Center (CAC) 1631 Miller Road Flint, Michigan, 48503 248-705-7408 (cell) 810-239-3112 (office) "Life is not a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside, thoroughly used up, totally worn out, and loudly proclaiming...'Wow! What a ride!!' --Jack Wilson
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Jesse Sent: Saturday, December 04, 2004 12:21 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Root has lost admin permissions
Thomas Earl wrote:
Greetings to all,
I'm working on getting OTRS config'd and I mistakenly removed root's admin permissions. How do I fix this?
Thanks,
Tom
-- Thomas Earl Network Engineer & Designer Communications Access Center (CAC) 1631 Miller Road Flint, Michigan, 48503 248-705-7408 (cell) 810-239-3112 (office)
"Life is not a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside, thoroughly used up, totally worn out, and loudly proclaiming...'Wow! What a ride!!'" --Jack Wilson
_______________________________________________ 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 oder Consulting für Ihr OTRS System? => http://www.otrs.de/
are you talking about to the database? Where were they removed? _______________________________________________ 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 oder Consulting für Ihr OTRS System? => http://www.otrs.de/
Thomas Earl wrote:
I mistakenly removed permissions from root (and not given it to any other users) to the admin section.
I fixed it this morning by dropping and rebuilding the otrs database.
You could have fixed it using some other account which has admin privileges. If not - only by editing database manually. It's a bit involving. When you connect to database you should issue command: SELECT id FROM groups WHERE name = 'admin'; And it would return you ID of 'admin' group, which is 2 on my system, and I presume it is the same on all other clean installs of version 1.3.x. Then you would add missing record using INSERT INTO group_user (user_id, group_id, permission_key, permission_value, create_by, create_time, change_by, change_time) VALUES (1, 2, 'rw', 1, 1, current_timestamp, 1, current_timestamp); or update existing one with UPDATE group_user SET permission_value = 1 WHERE user_id = 1 AND group_id = 2 AND permission_key = 'rw'; Maybe it would be a good idea to create a script which could be used in emergencies such as this.
participants (3)
-
Damir Dzeko -
Jesse -
Thomas Earl