MariaDB starting with 10.0
The CONNECT handler was introduced in MariaDB 10.0.
The CONNECT handler must be enabled like any other plugin, for instance using the INSTALL PLUGIN command:
INSTALL PLUGIN CONNECT SONAME 'ha_connect';
If the package is missing, you get an error such as
/usr/lib64/mysql/plugin/ha_connect.so missing . You will have to install the connect package
mariadb-connect-engine-10.0 from the MariaDB repository.
sudo apt-get install mariadb-connect-engine-10.0
To be visible the ha_connect.dll or ha_connect.so, ha_connect.so.0, ha_connect.so.0.0.0 libraries must be placed in the standard MariaDB plugin directory, which is automatically done when using the standard INSTALL commands. However, a few additional requirements must be fulfilled. When the CONNECT library is loaded, MariaDB has changed the current directory to its data directory. Therefore, if tracing is desired, the connect.ini file, the configuration file used by CONNECT must be copied in the MariaDB data directory. Currently, the connect.ini file is just used to set the CONNECT trace on or off and could be:
Change 0 to 1 or 2 (more trace) if a console tracing is desired. Note that to test this handler, MariaDB should be executed with the
--console parameter because CONNECT prints some error and trace messages on the console. In some Linux versions, this is re-routed into the error.log file.