1. Failed: cannot calculate delta (speed per second) for value of type "string": cannot convert value to numeric type
40315:20190531:133515.906 item "moola:mysql.status[Com_delete]" became not supported: Preprocessing failed for: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock.
path is /var/lib/zabbix/.my.cnf <- zabbix has ownership and validated through runuser -l zabbix (random sql command using --defaults-file=path)
So there is no connectivity issues, or permissions as it is executed locally.
The only difference between the zabbix server DB and this is that the node with the zabbix-agent in this case is using a remote DB on the same local network being 10.1.X.X
The local zabbix DB gets queried no problem
The remote DB from zabbix-agent on another node seems to keep trying to perform a local lookup of the sql server rather than load the .my.cnf file
The userparameters file is loaded and matches the working copy on zabbix-server
seems like the host IP parameter is not passed from the config file and defaults to local host since everything else seems to be working properly
40315:20190531:133515.906 item "moola:mysql.status[Com_delete]" became not supported: Preprocessing failed for: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock.
path is /var/lib/zabbix/.my.cnf <- zabbix has ownership and validated through runuser -l zabbix (random sql command using --defaults-file=path)
So there is no connectivity issues, or permissions as it is executed locally.
The only difference between the zabbix server DB and this is that the node with the zabbix-agent in this case is using a remote DB on the same local network being 10.1.X.X
The local zabbix DB gets queried no problem
The remote DB from zabbix-agent on another node seems to keep trying to perform a local lookup of the sql server rather than load the .my.cnf file
The userparameters file is loaded and matches the working copy on zabbix-server
seems like the host IP parameter is not passed from the config file and defaults to local host since everything else seems to be working properly