mysql - 我已将 Template DB MySQL 模板添加到 Zabbix 5.0.2 中的 2 个服务器。我可以看到指标标题但看不到指标值

Question

我看到一个独特的问题，我从两个不同的主机部署了“Template DB MySQL”，但无法检索指标值。

我已经创建并测试了"/etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf"文件，并且我已经创建了"/var/lib/zabbix/.my.cnf"文件。我还在文件中包含了文件的路径"/etc/zabbix/zabbix_agentd.conf"。我能够从 zabbiz_agentd CLI 收集指标zabbix_agentd -t Mysql.Server-Status

Mysql.Server-Status [t|{"Aborted_clients":"6","Aborted_connects":"1","Access_denied_errors":"0","Acl_column_grants":"0","Acl_database_grants":"0","Acl_function_grants":"0","Acl_procedure_grants":"0","Acl_package_spec_grants":"0","Acl_package_body_grants":"0","Acl_proxy_users":"0","Acl_role_grants":"0","Acl_roles":"0","Acl_table_grants":"0","Acl_users":"0","Aria_pagecache_blocks_not_flushed":"0","Aria_pagecache_blocks_unused":"15706","Aria_pagecache_blocks_used":"10","Aria_pagecache_read_requests":"27900","Aria_pagecache_reads":"25","Aria_pagecache_write_requests":"242","Aria_pagecache_writes":"242","Aria_transaction_log_syncs":"0","Binlog_commits":"0","Binlog_group_commits":"0","Binlog_group_commit_trigger_count":"0","Binlog_group_commit_trigger_lock_wait":"0","Binlog_group_commit_trigger_timeout":"0","Binlog_snapshot_file":"","Binlog_snapshot_position":"0","Binlog_bytes_written":"0","Binlog_cache_disk_use":"0","Binlog_cache_use":"0","Binlog_stmt_cache_disk_use":"0","Binlog_stmt_cache_use":"0","Busy_time":"0.000000","Bytes_received":"5490960","Bytes_sent":"28215386"--snip--

在调试 4 的代理登录中，我看到以下消息：

820133:20201022:104034.062 Requested [mysql.version["localhost","3306"]] 820133:20201022:104034.062 Sending back [ZBX_NOTSUPPORTED: Item does not allow parameters. 但前端没有显示任何指标。有谁知道这怎么可能发生？

在此先感谢您的帮助！

标签： mysqlzabbix

Answer 1

好的，我发现模板宏 {$MYSQL.USER} 已自动将用户名的第一个字母更正为大写。当我纠正指标开始流入时。