mariadb-connector-c doesn't fit

[AchMol]

Hi all, we are using XCA for many years with a remote MariaDB. After we changed some clients to M2 Macs we cannot connect to the database anymore.

We tried to install XCA with Macports, Homebrew and DMG Image. The error ist always nearly the same:

Der folgende Fehler ist aufgetreten:
Authentication plugin 'sha256_password' cannot be loaded: dlopen(/opt/local/lib/mariadb/plugin/sha256_password.so, 0x0002): tried: '/opt/local/lib/mariadb/plugin/sha256_password.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/opt/local/lib/mariadb/plugin/sha256_password.so' (no such file), '/opt/local/lib/mariadb/plugin/sha256_password.so' (no such file) QMYSQL: Unable to connect

The nearest solution was to work with two parallel homebrew installations x86 (/usr/lib...) and arm (/opt/homebrew...). Then XCA founds the necessary libraries but the hard binded version was wrong (3.3.4 installed /3.1.12 expected). To link or to copy the version folder didn't help aswell because of a wrong ssl hash.

XCA starts and runs absolutly normal, the error appears during the db connect.

What can we do to connect to the database again?