Loading the CONNECT Storage Engine
MariaDB starting with 10.0
The CONNECT engine was introduced in MariaDB 10.0.
The CONNECT storage engine is enabled like any other plugin, for instance using the INSTALL SONAME command:
INSTALL SONAME 'ha_connect';
For the INSTALL command to work, the libraries (
ha_connect.so.0.0.0) must be placed in the standard
MariaDB plugin directory, which is automatically done when using the standard install commands.
In some environments, you may get an error about a missing library,
INSTALL SONAME 'ha_connect'; ERROR 1126 (HY000): Can't open shared library '/home/ian/MariaDB_Downloads/10.1.17/lib/plugin/ha_connect.so' (errno: 2, libodbc.so.1: cannot open shared object file: No such file or directory)
In this case, just install the missing library, for example:
sudo apt-get install libodbc1