This isn't in production yet as I'm still playing with it and breaking it apparently :)

So, now that I have no admin how do I rectify that? The software is installed on a CentOS box, so is there a way to do it from the command line?

You can change it directly in the MySQL database ;)

Unfortunately I am currently answering from the phone and cannot look at our osTicket installation. I will look up the command next week ;)

run the following sql query:update ost_staff set isadmin = '1' where username='admin';Where admin is your admin username.  If that doesn't work then we need to figure out what group id is your 'admin' group.  To do that you can run this query:select * from ost_groups;The group_name field holds the names of your groups so if you have an obvious admin you can get the id that way.  Then you can update your user's group with the following query: update ost_staff set group_id = 'X';where X = the number of your admin group.

Awesome thanks! I was able to set my account back to admin using the update ost_staff set isadmin query.

Very welcome.I'll mark this thread as resolved and close the

thread.  Please feel free to start a new thread if you have another

question, comment, suggestion, etc.

Write a Reply...