cacti

[juc1]

Hi all,

I am thinking of installing cacti on my Debian 5 - any views on this?

Thanks

[suwunk]

Check this out!
[HOW-TO]Install cacti 0.8.7d on debian 5.|Cacti Official Forums and Support

[juc1]

Check this out!
[HOW-TO]Install cacti 0.8.7d on debian 5.|Cacti Official Forums and Support

Ok thanks. Also more here...
Cacti Installation and configuration in Debian

[peleus]

How about CentOS? This is the one that I most certainly trust.

[greenmatter]

Cent OS is good

[juc1]

When installing cacti in Debian 6 it asks

Please provide the password for the administrative account with which this package should create its MySQL database and user. Password of the database's administrative user:

4.jpg

I interpret this to mean the password of the MySQL root user but after entering this I get

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).

6.jpg

So does this mean that Cacti is looking for a user called 'root' as opposed to the root user (who might go by a different name)? If so maybe this won't work because Plesk has renamed my user 'root' to 'admin'. So maybe I need to rename the user 'admin' back to 'root'.

Thanks

[suwunk]

Try this, If you have root password:

$ mysql --user=root -p
Enter password:

You can do the following to reset your root password:

/etc/init.d/mysqld stop
mysqld_safe --skip-grant-tables &
mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("newrootpassword") where User='root';
mysql> flush privileges;
mysql> quit
/etc/init.d/mysqld stop
/etc/init.d/mysqld start

Edit include/config.php and specify the database type, name, host, user and password for your Cacti configuration.

$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "yourusername";
$database_password = "yourpassword";

Change yourusername on $database_username with your sql username.

Cheers

[jeremya]

Hi Juc,

I'm not sure what Cacti is looking for particularly, but i would recommend creating a second user of the db called root before renaming it back. Plesk can be a finicky beast.

[juc1]

Hi Juc,

I'm not sure what Cacti is looking for particularly, but i would recommend creating a second user of the db called root before renaming it back. Plesk can be a finicky beast.

OK thanks. Anyway if I mess something up can I restore the VPS to its original state?

[jeremya]

Hi Juc,

Yes, Linux VPS can use Virtuozzo Power Panel to restore a VPS back the template original. You would need to purchase backups if you want state backups.