Cacti: Locked out after switching to "Web Basic Auth"

[^rooker]

[PROBLEM]
I've switched my Cacti installation to "Web Basic Authentication", using htaccess/htgroup files.
Unfortunately, I forgot to enable users to be allowed to login using that method.

Now, my Cacti is greeting me with the following error message:

Error: Access Denied, please contact you Cacti Administrator.

[SOLUTION]
As usual, I say thank you to those who document their solutions/findings:
In the Cacti-forums, user "TheWitness" posted the following SQL statement which is used to re-set the authentication method back to internal:

Code: Select all

mysql cacti
update settings set value=1 where name='auth_method';

That's it.
Afterwards, your good ol' login prompt will await you happily