Hi Team,
I am trying to monitor mariadb replication as per the instruction given at following link https://www.zabbix.com/forum/zabbix-...ql-replication
I added the below line in /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
UserParameter=mysql.seconds-behind-master,SEC=$(mysql -uroot i-p -e 'show slave status\G' | grep Seconds | awk '{print $2}'); if [ "$SEC" = "NULL" ]; then SEC="-1"; fi; echo $SEC
UserParameter=mysql.slave-running,mysql -uroot --e "show slave status" -E | grep "Slave_SQL_Running:" | awk '{print $2}' | grep Yes >/dev/null && echo 1 || echo 0
Restarted Zabbix agent
Attached error is coming once added the item from Zabbix console.
Please help me on this.
Thanks & Regards,
Vijay Maurya,
I am trying to monitor mariadb replication as per the instruction given at following link https://www.zabbix.com/forum/zabbix-...ql-replication
I added the below line in /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
UserParameter=mysql.seconds-behind-master,SEC=$(mysql -uroot i-p -e 'show slave status\G' | grep Seconds | awk '{print $2}'); if [ "$SEC" = "NULL" ]; then SEC="-1"; fi; echo $SEC
UserParameter=mysql.slave-running,mysql -uroot --e "show slave status" -E | grep "Slave_SQL_Running:" | awk '{print $2}' | grep Yes >/dev/null && echo 1 || echo 0
Restarted Zabbix agent
Attached error is coming once added the item from Zabbix console.
Please help me on this.
Thanks & Regards,
Vijay Maurya,
Attached Files