iRODS + MariaDB setup fails when using the MySQL 9.1 ODBC driver

[korydraughn]

MariaDB doesn't appear to like the MySQL 9.1 ODBC driver. Notice the error message about mysql_native_password.

Database Port: 3306
Database Name: ICAT
Database User: irods
-------------------------------------------

Please confirm [yes]: 
2024-12-04 16:24:53,512 - Warning: Cannot control echo output on the terminal (stdin is not a tty). Input may be echoed.

2024-12-04 16:24:53,547 - Error encountered running setup_irods:
Traceback (most recent call last):
  File "/var/lib/irods/scripts/irods/database_connect.py", line 221, in get_database_connection
    return pyodbc.connect(connection_string, ansi=True)
pyodbc.OperationalError: ('08004', "[08004] [MySQL][ODBC 9.1(a) Driver]Authentication plugin 'mysql_native_password' cannot be loaded: /usr/local/mysql/lib/plugin/mysql_native_password.so: cannot open shared object file: No such file or directory (2059) (SQLDriverConnect)")

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/irods/scripts/setup_irods.py", line 529, in main
    setup_server(irods_config,
  File "/var/lib/irods/scripts/setup_irods.py", line 125, in setup_server
    database_interface.setup_database_config(irods_config)
  File "/var/lib/irods/scripts/irods/database_interface.py", line 176, in setup_database_config
    if database_already_in_use_by_irods(irods_config):
  File "/var/lib/irods/scripts/irods/database_interface.py", line 73, in database_already_in_use_by_irods
    with contextlib.closing(database_connect.get_database_connection(irods_config)) as connection:
  File "/var/lib/irods/scripts/irods/database_connect.py", line 237, in get_database_connection
    raise IrodsError('%s\n%s' % (message, str(e)))
irods.exceptions.IrodsError: pyodbc encountered an error connecting to the database:
('08004', "[08004] [MySQL][ODBC 9.1(a) Driver]Authentication plugin 'mysql_native_password' cannot be loaded: /usr/local/mysql/lib/plugin/mysql_native_password.so: cannot open shared object file: No such file or directory (2059) (SQLDriverConnect)")

I've tried using the MySQL 8.4 ODBC driver and MariaDB 3.2.4 ODBC driver. Neither worked.