Sender/trapper data not appearing

[magpacc11]

Hello.

I'm trying to monitor a MySQL database, setup on a different server to my Zabbix installation.

I have imported a template, the items all appear as 'Enabled', but no data is appearing. Also there are no errors in server log. Most of the items are 'Trapper' type.

I have attached agentd.conf as a txt (which is on the database server (192.168.2.192)).
And zabbix_server.conf as a txt (installed on zabbix server (192.168.2.38)).

It should be noted that I have setup items with the default template, with 'Zabbix Agent' type, and these are working successfully.

Please let me know if anything else will help. I'd greatly appreciate any help.

Thank you

[magpacc11]

Would really appreciate any help if anyone can. Thank you all.

[AvaTTaR]

How actually you are monitoring database? The ODBC monitoring don`t need zabbix-agent, it use local unixODBC to connect to database, share your items configuration to understand what actually you trying to do.

[magpacc11]

Thank you for the reply.

I've imported a template to monitor the the database (unless anyone can recommend a more suitable MySQL template). The items are mostly 'Zabbix trapper' but are not collecting data. Example item attached.

[AvaTTaR]

hmm, as I see this may need some additional configuration on the agent side - can you send me the link to a template you are using?
And also you can fined some other templates here: https://share.zabbix.com/search?sear...l&search_cat=1
there are some good of them, but make sure you read the instruction for them.

[magpacc11]

I am using this one: https://share.zabbix.com/databases/m...ysql-800-items

I have done the Valuemappings and left the host as 127.0.0.1 as this is the Zabbix server. I am unsure what this means:


my $zabbix_sender = '/usr/bin/zabbix_sender';
my $agent_config = '/etc/zabbix/zabbix_agentd.conf';
Also define UserParameter in the zabbix_agent.conf in database side for perl script like this example:

UserParameter=mysql[*],/opt/mysql_check.pl $1 $2 $3 $4

[AvaTTaR]

Did you add the mysql_check.pl on the 192.168.2.192 ? And what are you getting in the log of agent on 192.168.2.192 ?

[magpacc11]

Yes I have added the UserParameter line into zabbix_agentd.conf on 192.168.2.192.

There is nothing in the log except an error on 'Active checks'.

Which part of the agentd.conf needs to be configured to get this working?

Thank you again

[AvaTTaR]

I`m not really sure for that one template, maybe try other one for mysql, or ask your question in comments here: https://share.zabbix.com/databases/m...ysql-800-items