sysown / proxysql-nagios Goto Github PK

Error: Template 'pull-alerts' specified in service definition could not be not found

Hello
found a wierd behaviour of proxysql-nagios plugin

When all servers are shunned
mysql> select hostgroup_id, hostname , port , status  from runtime_mysql_servers ;
+--------------+------------+------+---------+
| hostgroup_id | hostname   | port | status  |
+--------------+------------+------+---------+
| 1            | 10.1.14.30 | 3308 | SHUNNED |
| 1            | 10.1.14.17 | 3306 | SHUNNED |
| 1            | 10.1.14.19 | 3306 | SHUNNED |
+--------------+------------+------+---------+

the query that is used in the plugin - for checking hg - does not work properly.

mysql> SELECT hostgroup_id hg,count(status) cnt from runtime_mysql_servers WHERE status = "ONLINE";
+----+-----+
| hg | cnt |
+----+-----+
| NULL | 0   |
+----+-----+
1 row in set (0.00 sec)

mysql> SELECT hostgroup_id hg,count(status) cnt from main.runtime_mysql_servers WHERE status = "ONLINE" GROUP BY hg having cnt ;
Empty set (0.00 sec)


It does return len(output_values) == 0 and check ends as OK 

/opt/plugins # /opt/plugins/proxysql-nagios2  -t hg -i 1 --runtime -c 0 -w 1
OK - ProxySQL Hostgroups: ALL OK

Can you please check it and advise how to solve it?

Best Regards Kuba Chrzan