For comparison, I have another MariaDB SQL server that I can connect to using MySQL 8.0, but this new one I'm trying to get into Orion is giving me fits.
On the Orion polling server, I can connect to the target host in ODBC Data Source Administrator using both the MariaDB 3.1 and MySQL 8 drivers, but when I try to connect in the Application Component monitor, I get the following error.
Unexpected error occurred. pypyodbc.OdbcNoLibrary: 'ODBC Library is not found. Is LD_LIBRARY_PATH set?'
My connection string (one of many variations I've tried):
Driver={MariaDB ODBC 3.1 Driver};Port=3306;Server=${IP};DataBase={information_schema};Uid=${USER};Pwd=${PASSWORD};
Here is the ODBC connection, validating using DSN:
Here is the ODBCINST.ini and a list of my ODBC 64 bit drivers on my polling engine.
For the community, what am I missing? I'm stumped at this point...