Locked out of Cacti

[phatrik]

I seem to be locked out of Cacti for some reason. So here's what I did on the Mysql database to try to correct the problem:

- I tried resetting the admin password: UPDATE user_auth set password = Password('PASSWORD_HERE') WHERE username = admin;
- I tried UPDATE user_auth set password = MD5('PASSWORD_HERE') WHERE username = admin;
- I tried UPDATE user_auth set password = Password('') WHERE username = admin; (blanking the password)


All of those lead to the same result: when I try logging in, I still get authentication failure. I thought maybe someone turned on LDAP but based on the output I see in mysql the value for 'realm' is 0 so I don't think so. Is there a config somewhere I'm missing which restricts logins to the admin account by IP? Also, I thought about maybe adding myself another user through the database, any thoughts on that?

TIA

[gandalf]

Save the user table.
Then, replace that table by the table defined in cacti.sql
Have a fresh start (user-wise)
R.