Help with Agent login, database

mpev

Running v1.18.2 and LDAP Plugin 0.6.2

We have a Director that's an occasional Agent. He tried to log in today as an Agent and he gets a message that he has to change his password. If he tries to enter the existing password and a new password it says his old password is wrong.

I think this is because he did change the password when I was setting it up and hadn't set the Authentication Backend to LDAP, it was on Use Any Available. It's now on LDAP.

From the searching I've done I think I need to go to the staff table in the database and set change_passwd to 0. My problem is I don't know how I'm getting to the staff table. Sorry, I'm used to GUIs and SSMS.

I know this isn't strictly an osTicket problem but one of my lack of knowledge, however I appreciate any help you can provide.

Thanks,

mpev

OK, making progress, I'm now in MySQL and the value for 'change_passwd' is 1 in the ost_staff table for this username.

Based on this thread, https://forum.osticket.com/d/102654-ad-auth-agent-required-to-change-password I should change this to 0 but I can't find the correct syntax to do so.

mpev

Now waiting on an update from the Director but was able to figure out the command.

Would it be out of order to put the details here, in case they help someone else?

KevinTheJedi

mpev

Sure, why not?

Cheers.

mpev

What's the worst that could happen, right?

Bold text is commands to be entered
Open an SSH session to the osTicket server
mysql -u {db username} -p
You may be able to pass the password in the above line but it wouldn't work for me, same with the database name
Enter the password
USE {database name};
The following are because I'm not well-versed in mySQL so I need to figure out what's available
SHOW TABLES;
Based on other posts here I know I need the ost_staff table
SHOW COLUMNS from ost_staff;
So now I know that it's the change_passwd field that I'm looking for
SELECT change_passwd from ost_staff WHERE username = '{username}';
This shows the current value of the field for the username in question, in our case it's '1'
UPDATE ost_staff SET change_passwd = 0 WHERE username = '{username};
This sets the value of the field to 0
exit
and we're done. Close the SSH session.

Hope this helps someone, probably future me!