A couple of times now when an old employee has returned after re-activating their account in AD they still show as inactive in Jira.
Login to MySQL server
mysql -u root -p
MariaDB [(none)]> use jiradb;
Database changed
MariaDB [jiradb]> select active from cwd_user where user_name = 'johns';
+--------+
| active |
+--------+
| 1 |
+--------+
1 row in set (0.01 sec)
MariaDB [jiradb]> select active from cwd_user where user_name = 'janed';
+--------+
| active |
+--------+
| 0 |
+--------+
1 row in set (0.00 sec)
MariaDB [jiradb]> update cwd_user set active = 1 where user_name = 'janed';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [jiradb]> select active from cwd_user where user_name = 'janed';
+--------+
| active |
+--------+
| 1 |
+--------+
1 row in set (0.01 sec)
The JIRA service needs to be restarted on the Jira server.