Configuring MySql monitoring on multiple ports

[dspoja]

I have installed Zabbix server that is attempting to monitor multiple MySql servers. I am running into issues receiving the information on monitored MySql server because I don't think I completed the configuration correctly. The issue is that each of the MySql servers runs instances on multiple ports. So for example, server 1 runs three instances on ports 3321, 3322 and 3331. I tried following these instructions http://blog.themilkyway.org/2013/11/...ate-app-mysql/, but instead of creating one .my.cnf file, I created one for each of the ports: .my3321.cnf, .my3322.cnf and .my3331.cnf. Inside the files I specified:

[mysql]
user=zabbix
password=123456
port=3321
socket=/var/lib/mysql-3321/mysql.sock
[mysqladmin]
user=zabbix
password=123456
port=3321
socket=/var/lib/mysql-3321/mysql.sock

I restarted zabbix-agent on that host, but I keep getting this error in the Zabbix dashboard:

Received value [mysqladmin: connect to server at 'localhost' failederror: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]

Clearly, I did not configure something correctly. Do you have a set of instructions to follow to configure MySql server running on a single host and running instances on multiple ports? Please let me know if I need to provide more information.
Thank you very much for your help.

[somecallmetim]

Have you made any headway?

I too have mysqld_multi running 3 instances on different ports/sockets.

So far just trying to figure things out.

[sudo092]

I came to this thread looking for answers recently but ended up figuring out how to do it and created a repo for it.

https://github.com/sud092/zabbix-mysql-multi