How to monitor a MySQL database from Zabbix via OCBC - Zabbix 6.0.32
I've been trying to connect to a MySQL database and I've used the MySQL and MariaDB drivers, through the MySQL driver and without having certificates it allows me to connect without problem with isql -v and the DSN name, now when I try to use the connection from Zabbix using that same DSN it generates this error: Cannot connect to ODBC DSN: [SQL_ERROR]:[HY000][2026][[unixODBC][MySQL][ODBC 8.0(w) Driver]SSL connection error: No such file or directory], I tried to connect to another database on a test Zabbix server that also uses MySQL and it didn't allow it either; when I installed the MariaDB driver according to the Zabbix documentation, it did allow me to connect to that test Zabbix database, but it didn't allow me to connect to the database that has require_secure_transport = ON.