@dafyre :Ran Into another problem Now.
Mysql service up/down status is not displayed in host status Tab. But in the graph part all mysql data is fetched from client machine and displayed in Zabbix server .like Mysql Bandwidth ,Mysql Uptime , Mysql operations ect .
Since the service up/down is not being displayed in host status , Cannot execute Actions (remote command & notifications)
All other services like Apache , ssh , telnet , cpu hike , Disk usage , Network usage .. every actions to the above said services are being fetched by zabbix-agent and displayed in zabbix-server GUI.
Checked the Zabbix-server log ,
Data for mysql services are being logged , But not displaying the service UP or down in server GUI.
LOG:
[root@Z3 ~]# tail -f /var/log/zabbix/zabbix_server.log | grep mysql
2259:20170521:151451.735 Sending [mysql.status[Questions]
2261:20170521:151452.738 In substitute_key_macros() data:'mysql.status[Slow_queries]'
2261:20170521:151452.738 End of substitute_key_macros():SUCCEED data:'mysql.status[Slow_queries]'
2261:20170521:151452.738 In get_value() key:'mysql.status[Slow_queries]'
2261:20170521:151452.738 In get_value_agent() host:'2.test.com' addr:'10.132.166.113' key:'mysql.status[Slow_queries]' conn:'unencrypted'
2261:20170521:151452.739 Sending [mysql.status[Slow_queries]
2262:20170521:151453.743 In substitute_key_macros() data:'mysql.status[Uptime]'
2262:20170521:151453.743 End of substitute_key_macros():SUCCEED data:'mysql.status[Uptime]'
2262:20170521:151453.744 In get_value() key:'mysql.status[Uptime]'
2262:20170521:151453.744 In get_value_agent() host:'2.test.com' addr:'10.132.166.113' key:'mysql.status[Uptime]' conn:'unencrypted'
2262:20170521:151453.744 Sending [mysql.status[Uptime]