Reset Cacti's database. Completely.

[^rooker]

I wanted a clean, fresh start with our RRD graphing frontend "Cacti".
I'm running Debian Squeeze (6.0.4) and I've manually upgraded the Cacti installation to v0.8.8a. So the package management was unaware of that change.

In order to reset the settings in the MySQL database, do the following:

1) Drop (or rename?) the MySQL database.
I've used phpMyAdmin for this task.
In phpMyAdmin, just select the Cacti database on the left hand side. Usually the database name is "cacti" (=default name).

Option 1: "Drop"
After you've selected the "cacti" database, the last tab on the right is red and labeled "Drop".

Option 2: "Rename"
Under the "Operations" tab, you will find a "rename database to:" option.
Use this to get the database out of the way

2) Reinitialize the database:
There are step-by-step instructions on the cacti website for installing and configuring the database, but I wanted to use the convience provided by the package management:

Code: Select all

dpgk-reconfigure cacti

You will be asked a few questions, like your MySQL admin account, etc.
Answer them properly and you're done!

If you now reload the Cacti page on your server, you will be greeted with the initial install dialog.
That's it.