admin account locked how to unlock

[stpinms]

Dear Team Cacti ,
As we are using Cati new version 1.2.15 and configured user lock option if tried more than 3 wrong attempts. Admin account itself locked, kindly let us know the commands or procedure to unlock the same. Other users able to log in but not having admin privileges to change the settings.

and shall we have more than 1 admin account. ???

appreciation for soon reply.

Regards
Suryakanth
Karnataka India

[cigamit]

You will have to modify the database.

Code: Select all

UPDATE user_auth SET locked = '', enabled = 'on' where username = 'admin'

[stpinms]

its giving an error

mysql> UPDATE user_auth SET locked = '', enabled = 'on' where username = 'admin'
-> ;
ERROR 1146 (42S02): Table 'mysql.user_auth' doesn't exist


Kindly help

[stpinms]

Avilable users listed below for your information .

mysql> select user,host from user;
+---------------+-----------+
| user | host |
+---------------+-----------+
| cactiuser | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+---------------+-----------+
4 rows in set (0.00 sec)

[stpinms]

mysql> UPDATE user_auth SET locked = '', enabled = 'on' where username = 'admin';
ERROR 1146 (42S02): Table 'mysql.user_auth' doesn't exist

[stpinms]

have fixed the issue and able to login now. Thanks for support.