Error Instalasi Cacti with Mysql Server 8

Error Instalasi Cacti with Mysql Server 8

   15.59       serigalajantan

---

Yang harus di Install :

- apt install rrdtool -y

- apt install snmpd snmp snmp-mibs-downloader libsnmp-dev

- php dan apache2 mysql-server

buat database :

create database rrdtooldb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

flush privileges;

quit

edit file : sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

tambahkan :

default-time-zone = "Asia/Jakarta"

collation-server      = utf8mb4_unicode_ci

max_heap_table_size=128M

tmp_table_size=128M

join_buffer_size=256M

innodb_buffer_pool_size=2048M

innodb_flush_log_at_timeout=3

innodb_read_io_threads=32

innodb_write_io_threads=16

innodb_buffer_pool_instances=17

innodb_io_capacity=5000

innodb_io_capacity_max=10000

sisanya ikuti disini :

https://kifarunix.com/easily-install-and-setup-cacti-on-ubuntu-20-04/

Read More

ERROR create.sql.gz: No such file or directory.

ERROR create.sql.gz: No such file or directory.

   15.19       serigalajantan

---

 Solusi pada saat installasi ZABBIX ketika membuat file databased

d

dimana beberapa tutorial menyarankan perintah seperti ini :

$ cd /usr/share/doc/zabbix-server-mysql
$ zcat create.sql.gz | mysql -u zabbix_user -p zabbix_db

dan ternyata perintah tersebut salah.
Yang benar adalah :

d

$ cd /usr/share/zabbix-server-mysql
$ zcat schema.sql.gz | mysql -u zabbix_user -p zabbix_db

Membuat Super User didatabase

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'root';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

Membuat  User didatabase

mysql> CREATE USER 'nama-user'@'localhost' IDENTIFIED BY 'password-user';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'nama-user'@'%' WITH GRANT OPTION;

d

dd

Read More