Our point of sale database is based on MariaDB. Fortunately for us the Mysql connector seems to still work. Unfortunately the pre-compiled packaged version does not work for FileMaker, and for whatever reason Apple is happy to have Actual Technologies charge for what should be an open source and freely available driver.
I actually have no idea why the pre-packaged connector driver does not work, it hasn’t worked since the 3.0 driver, however, I was able to compile a driver that worked for for the 5.0. I have now been able to compile one for on BigSur and M1.
Must install Mysql, and download the connector source. Install CMake and x-code command line tools. I do not know if I needed to download the iodbc and install it or if it comes installed with the system, however I did install the m1 native versions of everything.
In the end I had to use a a command to fix the driver to point to the correct version of Mysql. This probably will not work on non ARM based processors.
otool -L /usr/local/lib/libmyodbc8a.so was the trick to find what the @rpath was and then I needed to use install_name_tool -change @rpath/libmysqlclient.21.dylib /usr/local/mysql/lib/libmysqlclient.21.dylib /usr/local/lib/libmyodbc8a.so
cmake -G “Unix Makefiles” -DODBC_INCLUDES=/usr/local/iODBC/include
Leave a Reply