I found this old thread to reset the admin password.
However, the table structure has changed and I get this error: mysql> update qrm_users set user_password=MD5("qrm") where id=1; ERROR 1146 (42S02): Table 'openqrm.qrm_users' doesn't exist
How can I reset the admin password for openQRM 5.x?
And in additional, how can I reset the password for "Nagios web administration"?
Update
I executed this SQL command and modified the password for user "openqrm". However, I still cannot logon to WebUI.
Hello!
I found this old thread to reset the admin password.
However, the table structure has changed and I get this error:
mysql> update qrm_users set user_password=MD5("qrm") where id=1;
ERROR 1146 (42S02): Table 'openqrm.qrm_users' doesn't exist
How can I reset the admin password for openQRM 5.x?
And in additional, how can I reset the password for "Nagios web administration"?
Update
I executed this SQL command and modified the password for user "openqrm". However, I still cannot logon to WebUI.
mysql> update user_info set user_password=MD5("openqrm") where user_id=0;
Query OK, 1 row affected, 1 warning (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql> select user_name, user_password from user_info where user_id=0;
+-----------+----------------------+
| user_name | user_password |
+-----------+----------------------+
| openqrm | aefbb7cd8b44588190ce |
+-----------+----------------------+
1 row in set (0.00 sec)
THX
Last edit: Thomas 2013-12-26