Instalasi Grafana sebagai tools untuk monitoring Zimbra Server

$ echo “deb https://repos.influxdata.com/ubuntu focal stable” | sudo tee etc/apt/sources.list.d/influxdb.list<br>$ sudo curl -sL https://repos.influxdata.com/influxdb.key | sudo apt-key add -

$ sudo apt update && sudo apt install influxdb

$ sudo systemctl enable --now influxdb

$ sudo nano /etc/influxdb/influxdb.conf

[http] 
  enabled = true 
  bind-address = “:8086”

$ curl -XPOST "http://localhost:8086/query" --data-urlencode "q=CREATE USER admin WITH PASSWORD 'M4s4dm1n' WITH ALL PRIVILEGES"

$ curl -G http://localhost:8086/query -u admin:StrongPassword —-data-urlencode “q=SHOW DATABASES”

$ sudo apt install telegraf

$ sudo nano /etc/telegraf/telegraf.conf 

[global_tags]
# Configuration for telegraf agent
 [agent]
     interval = "10s"
     debug = false
     hostname = "server-hostname"
     round_interval = true
     flush_interval = "10s"
     flush_jitter = "0s"
     collection_jitter = "0s"
     metric_batch_size = 1000
     metric_buffer_limit = 10000
     quiet = false
     logfile = ""
     omit_hostname = false
###########################################################
#                         OUTPUTS                         # ###########################################################
 [[outputs.influxdb]]
     urls = ["http://influxdb-ip:8086"] # Input valid InfluxDB URL, IP address, and port
     database = "database-name" # Input InfluxDB database name for this host
     timeout = "0s"
     username = "auth-username" # Input InfluxDB http authentication username.
     password = "auth-password" # Input InfluxDB http authentication password.
     retention_policy = ""

$ sudo nano /etc/telegraf.d/zimbra.conf

# Read metrics about cpu usage
[[inputs.cpu]]
  percpu = true
  totalcpu = true
  fielddrop = ["time_*"]

# Read metrics about disk usage by mount point
[[inputs.disk]]
  ignore_fs = ["tmpfs", "devtmpfs"]

[[inputs.diskio]]

[[inputs.kernel]]

[[inputs.mem]]

[[inputs.processes]]

[[inputs.swap]]

[[inputs.system]]

[[inputs.procstat]]
  exe = "memcached"
  prefix = "memcached"

[[inputs.procstat]]
  exe = "java"
  prefix = "java"

[[inputs.procstat]]
  exe = "mysqld"
  prefix = "mysqld"

[[inputs.procstat]]
  exe = "slapd"
  prefix = "slapd"

[[inputs.procstat]]
  exe = "nginx"
  prefix = "nginx"

[[inputs.net]]

[[inputs.exec]]
  commands = ["/opt/zimbra/common/bin/checkzimbraversion.sh"]
  name_override = "zimbra_stats"
  data_format = "value"
  data_type = "string"

# # OpenLDAP cn=Monitor plugin
# # As zimbra user run the next to obatin the password zmlocalconfig -s zimbra_ldap_password ldap_master_url
 [[inputs.openldap]]
   host = "YOURZIMBRASERVERHOSTNAME"
   port = 389
   insecure_skip_verify = true
   bind_dn = "uid=zimbra,cn=admins,cn=zimbra"
   bind_password = "YOURZIMBRALDAPPASSWORD"
   reverse_metric_names = true

 [[inputs.postfix]]
    queue_directory = "/opt/zimbra/data/postfix/spool"
    interval = "1s"

$ sudo nano /opt/zimbra/common/bin/checkzimbraversion.sh

#!/bin/bash

if [ -f /etc/redhat-release ]; then
  rpm -q --queryformat "%{version}" zimbra-core | awk -F. '{print $1"."$2"."$3 }' | awk -F_ '{print $1" "$2 }'
fi

if [ -f /etc/lsb-release ]; then
  dpkg -s zimbra-core | awk -F"[ ',]+" '/Version:/{print $2}' | awk -F. '{print $1"."$2"."$3" "$4}'
fi

$ sudo chmod a+x /opt/zimbra/common/bin/checkzimbraversion.sh

$ sudo chgrp -R telegraf /opt/zimbra/data/postfix/spool/{active,hold,incoming,deferred}
$ sudo chmod -R g+rXs /opt/zimbra/data/postfix/spool/{active,hold,incoming,deferred}
$ sudo usermod -a -G postdrop telegraf
$ sudo chmod g+r /opt/zimbra/data/postfix/spool/maildrop

$ sudo systemctl restart telegraf

$ sudo apt install -y gnupg2 curl software-properties-common

$ curl -fsSL https://packages.grafana.com/gpg.key|sudo gpg --dearmor -o /
> /etc/apt/trusted.gpg.d/grafana.gpg

$ sudo add-apt-repository "deb https://packages.grafana.com/oss/deb stable main"

$ sudo apt update && sudo apt install grafana -y
$ sudo systemctl enable --now grafana-server