Cacti

Install

Prerequisites

• sudo apt update

Install Apache & MariaDB

• sudo apt install -y apache2 mariadb-server mariadb-client php-mysql libapache2-mod-php

Install PHP Extensions

• sudo apt install -y php-xml php-ldap php-mbstring php-gd php-gmp

Install Snmp

• sudo apt install -y snmp php-snmp rrdtool librrds-perl

Configuration

Database Tuning

• vi /etc/mysql/mariadb.conf.d/50-server.cnf

collation-server = utf8mb4_unicode_ci
max_heap_table_size = 128M
tmp_table_size = 64M
join_buffer_size = 64M
innodb_file_format = Barracuda
innodb_large_prefix = 1
innodb_buffer_pool_size = 512M
innodb_flush_log_at_timeout = 3
innodb_read_io_threads = 32
innodb_write_io_threads = 16
innodb_io_capacity = 5000
innodb_io_capacity_max = 10000

Set Timezone

• vi /etc/php/7.2/apache2/php.ini

AND

• vi /etc/php/7.2/cli/php.ini

date.timezone = Europe/Berlin
memory_limit = 512M
max_execution_time = 60

Restart MariaDB

• sudo systemctl restart mariadb

Create Database

• sudo mysql -u root -p
  • create database cacti;
  • GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'cactipassword';
  • flush privileges;
  • exit

Importmysql_test_data_tiemzone

• sudo mysql -u root -p mysql < /usr/share/mysql/mysql_test_data_timezone.sql

Grant the permission to cactiuser

• sudo mysql -u root -p
  • GRANT SELECT ON mysql.time_zone_name TO cactiuser@localhost;
  • flush privileges;
  • exit