- Edited
You just run a simple UPDATE statement manually.
UPDATE table_name SET column_name = value WHERE conditions;You would replace the table name, column name, value, and conditions with what you need.
Cheers.
Can't Login with AD Credentials to run Updater Script
KevinTheJedi Would it look something like this? I apologize for all of my questions. I'm really trying to learn and understand. Thank you for your patience.
UPDATE ost_staff SET backend = NULL WHERE -insert first and last name- ldap;
Everything is good up until the WHERE conditions. You would want WHERE staff_id = your_id where “your_id” is your staff ID.
Cheers.
- Edited
KevinTheJedi So it would look like: UPDATE ost_staff SET backend = NULL WHERE staff_id = 1
Would this be the same for the password? UPDATE ost_staff SET passwd = 'PASSWORD' WHERE staff_id = 1 ?
Do you happen to have a site where you describe being able to 'hash' the Bcrypt hashes with 8 round entropy? I tried searching for one but I get a lot of info on how long it would take to crack a password, etc.
Yes and yes however for the password query you would wrap the value in single or double quotes (ie. passwd = 'hashed_password').
I don’t want to post a link as I don’t want to advertise 3rd party sites on here. It’s very simple though; just google “bcrypt hash generator”.
Cheers.
- Edited
KevinTheJedi Once I've done those two things, I should be able to log in to the portal using my username and newly created password? Thank you again for your help. I can't tell you how much I appreciate it.
EDIT: This is what I get when I type in the NULL line:
It doesn't seem to like it.
You are missing the trailing ; as shown in my example and referenced article in my previous reply. Every query has to end with a semi-colon.
Yes, once you run the two queries then you should be good to login.
Cheers.
KevinTheJedi I ended up going in a different direction and recovered our osTicket instance through a backup VM. Is there a way to create a local user within the osTicket Agent panel versus changing a user through the database?
For example, could I create a local user this way?
Thank you.
Yea you are looking at the exact screen to add an agent. To make admin check the box for admin.
Cheers.
KevinTheJedi Thank you! I was able to create a 'local' admin user (instead of an 'ldap' admin user) and I double-checked that it said 'local' for that user in the database. Now when I upgrade the system, I should be fine to use the local account to get back in. Thanks for everything!
6 days later
KevinTheJedi I'm going to retry our osTicket upgrade today and I just had a follow up question. I have read that I should upgrade the plugins before running the upgrade script, is that correct? Will it wipe out the information so that I have to type it all in again or will the information in those plugins carry over to the new version? I hope that makes sense. Thank you.
Simply replace the existing plugin files on the server with the latest downloads; that’s all you need to do. It will keep configs; this is why you need latest plugins so the upgraders for those plugins can run and make sure the data is converted properly.
Cheers.
KevinTheJedi Thank you very much. That answered my question.