MySQL Monitoring failing on Zabbix 7.0.0Alpha4

[kbcetn]

Using the instructions posted at https://www.zabbix.com/integrations/mysql#mysql_agent2, I created the users (one localhost, and one @%), both with the same access and password and both on two separate servers - the monitoring server itself, and an external server. I'm able to mysql -p -u zbx_monitor -h localhost and -h <ip_addr> with the appropriate password and show databases without issues. Neither is a slave so that comes up empty. In both cases, I get Unsupported Item Key on all the MySQL facts. Checking the logs, I see "WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version." but nothing to indicate what the server is attempting. When I turn the debug level up, I get a flood of data, but nothing indicating that the connection is failing or what the problem might be. Even mysql_ping fails. Any suggestions?

[kbcetn]

In order to use the MySQL for Zabbix 2 agent, you have to install it separately in Ubuntu.

Let's turn this into a bug report.

Zabbix should report errors that will help the installer if the installer attempts to use an agent that's not installed.

What fixed it? In my case...

# apt install zabbix-agent2

[kbcetn]

FYI - I'm running Ubuntu 22.04.1 and MySQL 8.0.34 on the Zabbix server. I tried it again on another Ubuntu 22.04.1 with MySQL 8.0.34 at AWS following the instructions as best I could. Unfortunately, I'm just not getting what I'm doing wrong. Any suggestions?

[kbcetn]

From the logs on the Zabbix server attempting to look at its MySQL server:

/var/log/zabbix/zabbix_server.log: 14840:20230923:010431.021 item "Zabbix server:zabbix[process,connector worker,avg,busy]" became not supported: No "connector worker" processes started.
/var/log/zabbix/zabbix_server.log: 14831:20230923:013332.778 executing housekeeper
/var/log/zabbix/zabbix_server.log: 14831:20230923:013332.790 housekeeper [deleted 0 hist/trends, 0 items/triggers, 0 events, 0 problems, 0 sessions, 0 alarms, 0 audit, 0 records in 0.010839 sec, idle for 1 hour(s)]
/var/log/zabbix/zabbix_server.log: 14829:20230923:013624.824 discovery rule "Zabbix server:mysql.db.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Unsupported item key.
/var/log/zabbix/zabbix_server.log: 14829:20230923:013626.822 discovery rule "Zabbix server:mysql.replication.discovery["{$MYSQL.DSN}","{$MYSQL.USER}","{$MYSQL.PASSWORD}"]" became not supported: Unsupported item key.
/var/log/zabbix/zabbix_server.log: 14840:20230923:013637.367 item "Zabbix server:mysql.buffer_pool_efficiency" became not supported: Cannot evaluate function: not enough data at "last(//mysql.innodb_buffer_pool_reads) /
/var/log/zabbix/zabbix_server.log:( last(//mysql.innodb_buffer_pool_read_requests) +
/var/log/zabbix/zabbix_server.log:( last(//mysql.innodb_buffer_pool_read_requests) = 0 ) ) * 100 *
/var/log/zabbix/zabbix_server.log:( last(//mysql.innodb_buffer_pool_read_requests) > 0 )".
/var/log/zabbix/zabbix_server.log: 14841:20230923:013638.368 item "Zabbix server:mysql.buffer_pool_utilization" became not supported: Cannot evaluate function: not enough data at "last(//mysql.innodb_buffer_pool_pages_total) -
​

[kbcetn]

Even with a wrong password, I get the same thing as above. Not sure what to make of this, but it's a clue.

[kbcetn]

In order to use the MySQL for Zabbix 2 agent, you have to install it separately in Ubuntu.

Let's turn this into a bug report.

Zabbix should report errors that will help the installer if the installer attempts to use an agent that's not installed.

What fixed it? In my case...

# apt install zabbix-agent2