How to change the password for GUI user without access to the GUI on MAA

Products

• Malware Analysis Software - MA

Issue/Introduction

Resolution

​Login to the MAA Appliance using the g2 user or the Command Line option from the MAA local console.

Change to root context:
[email protected]:~# sudo -s

Show the password for mysql:
[email protected]:~# cat /root/mysql.root.pw

Start the mysql CLI:
[email protected]:~# mysql -u root -p

Show a table of all users:
mysql> select * from users;

The output will look like this:
+-----+---------------------+-------------------+--------------------------+----------+-------+
| uid | date_added          | label             | email                    | username | state |
+-----+---------------------+-------------------+--------------------------+----------+-------+
|   3 | 0000-00-00 00:00:00 | Administrator     | [email protected] | admin    |     0 |
|   4 | 2014-12-02 15:45:46 | SecurityAnalytics | [email protected]              | SA       |     0 |
+-----+---------------------+-------------------+--------------------------+----------+-------+
2 rows in set (0.00 sec)

Get the uid for the user you want to reset the password for. (In our example the uid 3 for user "admin").  Now, set the password back to the default value "admin" using this command: 
mysql> update ui_creds set pw = "$2a$12$ii50LBgnXMEDqUPE7GOZ1u9TQsPW8XxVaX8sQd0y41/vrF6s3zUDi" where uid = 3;

The response will be:
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Exit mysql CLI:
mysql> quit;

Logout from the CLI /SSH session and try log into the UI with the password "admin".