Thomas - 2013-12-26

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