Zabbix Agent 2 SQL connection issue

[Kevin Penn]

Hi all,

I am trying to get the SQL health of a MariaDB database using zabbix agent 2

i have it working on one server

but a semi identical one configured the same (and with the same databases) i am getting this error

[Mysql] Cannot fetch data: commands out of sync. Did you run multiple statements at once?.

I cant see what i have done wrong

i have the similar config on both servers

the sql account works on both

the firewall rules are both the same

the server that works is on a local network and the other a remote network

the agent 2 works for general linux bits - but just not SQL

any ideas?

[Kevin Penn]

turned out to be something simple - needed the full server name including the .co.uk in the grants