Q: How to change the Airwave GUI password, when default username "admin" was changed and I do not remember what it was?
How to change the Airwave GUI password, when i do not remember username too?
A: Use the below steps to reset the password when we remember the username:
From the CLI:
# dbc "update users set password='2cf94b0aea63ebf7bf41c90fe500603e' where username ='admin';" The password will be 'admin'
If you use a name other than 'admin', you can change your user's password by modifying the where clause above. For example, to change joemontana's password to admin, this would work:
# dbc "update users set password='2cf94b0aea63ebf7bf41c90fe500603e' where username ='joemontana';" The password will be 'admin'
However in the instance, where you do not remember the username, could use the below insert command to create new username and password:
# dbc "INSERT INTO users (username, password, role_id, password_format, login_attempts, is_enabled) VALUES ('testing', '2cf94b0aea63ebf7bf41c90fe500603e', '5', 'md5', '0', '1');"
The user name will be 'testing', password will be 'admin' with Administrator role.
Example:
[root@localhost mercury]# dbc "INSERT INTO users (username, password, role_id, password_format, login_attempts, is_enabled) VALUES ('testing', '2cf94b0aea63ebf7bf41c90fe500603e', '5', 'md5', '0', '1');"
INSERT 0 1
[root@localhost mercury]#
Note: Password used in the above commands is the hashed version of admin, username and password will be "testing" and "admin" respectively. However, its recommended to change the password from the AMP setup --> Users tab upon login.