CentOS 7
MariaDB-connect-engine 10.1.13-1.el7.centos
unixODBC 2.3.1-11.el7

You environment says you're using connect engine 10.1.13 with the server 10.1.12, how did it happen? It isn't really supposed to work like that.

I just did the repository installation.
yum install MariaDB-connect-engine

/etc/yum.repos.d/mariadb10.repo
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Right. Please upgrade the server as well.

serg, if our plugins require the identical version of the server, do you think maybe storage engine RPMs should pull the server as a dependency?

Elena, I can install a compatible version with 10.0.12?
It will not be very simple I update the server before I have to approve it in whole system 10.01.13 and this can take a long time.

Thanks

Yes, you can use 10.1.12 repo instead of the latest 10.1
http://yum.mariadb.org/10.1.12/centos7-amd64

elenst, depends on the plugin. But storage engines — yes, they should, absolutely.

Thanks everyone,
you been doing a great job.

I use docker mariadb:latest

root@master:/# apt-get update
root@master:/# apt-get install mariadb-plugin-connect

ended with

Setting up mariadb-server-10.5 (1:10.5.11+maria~focal) ...
debconf: unable to initialize frontend: Dialog
debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 76.)
debconf: falling back to frontend: Readline
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of stop.
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of start.
Setting up mariadb-server (1:10.5.11+maria~focal) ...
Setting up libodbc1:amd64 (2.3.6-0.1build1) ...
Setting up odbcinst1debian2:amd64 (2.3.6-0.1build1) ...
Setting up odbcinst (2.3.6-0.1build1) ...
Setting up unixodbc (2.3.6-0.1build1) ...
Setting up mariadb-plugin-connect (1:10.5.11+maria~focal) ...
Processing triggers for libc-bin (2.31-0ubuntu9.2) ...
Processing triggers for mariadb-server-10.5 (1:10.5.11+maria~focal) ...
debconf: unable to initialize frontend: Dialog
debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 76.)
debconf: falling back to frontend: Readline
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of restart.

root@master:/# ls -l /usr/lib/mysql/plugin/ha*
rw-rr- 1 root root 104992 Jun 18 12:21 /usr/lib/mysql/plugin/ha_archive.so
rw-rr- 1 root root 76200 Jun 18 12:21 /usr/lib/mysql/plugin/ha_blackhole.so
rw-rr- 1 root root 1856304 Jun 18 12:21 /usr/lib/mysql/plugin/ha_connect.so
rw-rr- 1 root root 104920 Jun 18 12:21 /usr/lib/mysql/plugin/ha_federated.so
rw-rr- 1 root root 145984 Jun 18 12:21 /usr/lib/mysql/plugin/ha_federatedx.so
rw-rr- 1 root root 150104 Jun 18 12:21 /usr/lib/mysql/plugin/ha_sphinx.so
rw-rr- 1 root root 175904 Jun 18 12:21 /usr/lib/mysql/plugin/handlersocket.so

M:285017 [ci4]>INSTALL SONAME 'ha_connect';
ERROR 1126 (HY000): Can't open shared library '/usr/lib/mysql/plugin/ha_connect.so' (errno: 13, cannot open shared object file: No such file or directory)

restart of server of no avail

what to do?

I see, restart lost /usr/lib/mysql/plugin/ha_connect.so, of course, so this is not the way. Why didn't it work in the first place? I could then make a new container to have it permanently.

I thought the problem might have been that the client was started earlier in a separate process, but this is obviously nonsense and can be proven easily wrong:

...
debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 76.)
debconf: falling back to frontend: Readline
invoke-rc.d: could not determine current runlevel
invoke-rc.d: policy-rc.d denied execution of restart.
root@master:/# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 296
Server version: 10.5.10-MariaDB-1:10.5.10+maria~focal-log mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

M:285017 [(none)]>INSTALL SONAME 'ha_connect';
ERROR 1126 (HY000): Can't open shared library 'ha_connect.so' (errno: 8, API version for STORAGE ENGINE plugin CONNECT not supported by this version of the server)
.

on https://mariadb.com/kb/en/installing-the-connect-storage-engine/ I read:

If you do not have the ODBC library installed, then you may get an error about a missing library when you attempt to install the plugin.

So ...

root@master:/# apt-get update

root@master:/# apt-get install unixODBC
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package unixODBC

Ok, better read all:

root@master:/# apt-get install libodbc1
Reading package lists... Done
Building dependency tree
Reading state information... Done
libodbc1 is already the newest version (2.3.6-0.1build1).
libodbc1 set to manually installed.
0 upgraded, 0 newly installed, 0 to remove and 23 not upgraded.
root@master:/# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 707
Server version: 10.5.10-MariaDB-1:10.5.10+maria~focal-log mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

M:285017 [(none)]>INSTALL SONAME 'ha_connect';
ERROR 1126 (HY000): Can't open shared library 'ha_connect.so' (errno: 8, API version for STORAGE ENGINE plugin CONNECT not supported by this version of the server)

run select * from information_schema.all_plugins. Likely your ha_connect.so isn't compatible with the server

OK, that explains it:

M:285017 [ci4]>select * from information_schema.all_plugins WHERE PLUGIN_LIBRARY  LIKE '%ha_connect.so%'\G

Empty set (0.005 sec)

How come? I use the official docker container. How to install then?

M:285017 [ci4]>select version();

+-------------------------------------------+

| version()                                 |

+-------------------------------------------+

| 10.5.10-MariaDB-1:10.5.10+maria~focal-log |

+-------------------------------------------+

If I read the Dockerfile correctly, it only installs mariadb-server and mariadb-backup. You need to install mariadb-plugin-connect.

Oh thank you very much and I'm sorry for bothering you! Case closed.

Oh thank you very much and I'm sorry for bothering you! Case closed.