mysql items not working

[veehexx]

I've attempted to configure mysql checks with zabbix, using the built-in checks, and followed various guides on configuring them.
i'm still struggling to get it working.

long story short, if i run a test on the sql server, then i get results.
zabbix_agentd -t "mysql.status[Bytes_sent]"

mysql.status[Bytes_sent] [t|944637332]

via the zabbix server to that host (mysql runs on a different server than zabbix), results in 1 of 4 errors:
most of the mysql checks get

"cannot convert value to numeric type"

slow queries gets

"Value "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)" of type "string" is not suitable for value type "Numeric (unsigned)""

mysql.ping gets

Value "mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
0" of type "string" is not suitable for value type "Numeric (unsigned)"

and mysql uptime gets

Value "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)" of type "string" is not suitable for value type "Numeric (unsigned)"

[Atsushi]

You need to configure it to be able to connect to the MySQL server using the Zabbix user on the OS.
For example, create .my.cnf in the Zabbix user's home directory.

/var/lib/zabbix/.my.cnf

[client]
user = zabbix
password = password

[veehexx]

and thats done on the a zabbix client and not the zabbix server (in this case, the mysql server)?

https://pastebin.com/RdkFCmCb

the mysql checks are assigned to the mySQL server host.

still getting the same errors.

[veehexx]

...i forgot to add:
if i ssh into mysql host, and run 'zabbix_agentd -t mysql.status[Bytes_received]', then i do get output.

mysql.status[Bytes_received] [t|690856434]

just the zabbix webui is showing an error on that entry of 'cannot convert value to numeric type'

[veehexx]

got this sorted... SELinux getting in the way, on mysql server.

I've not got as far as looking for a proper selinux rule for it, i've just gone for passive mode for testing which has got things working.

[cpotter]

got this sorted... SELinux getting in the way, on mysql server.

I've not got as far as looking for a proper selinux rule for it, i've just gone for passive mode for testing which has got things working.

We have done :

# semodule -l | grep zabbix
# semodule -e zabbix Perhaps it can help

Best,