3.2 on new Centos 8 Server w/Mariadb 10.4

Tried to run indexer.

ERROR: index ‘main’: sql_connect: MySQL source wasn’t initialized. Wrong name in dlopen? (DSN=mysql://sphinx:***@localhost:3306/prod_db).

I saw the article and I read the thread from January but still at a loss. Has anyone been able to get 3.2 indexer working with Mariadb 10.4 on Centos 8 without this error?

No problems setting up 3.2 and all past versions of Manticore/Sphinx on Centos 6 and 7 with rpm’s.

MariaDB-devel-10.4.10-1.el8.x86_64
MariaDB-shared-10.4.10-1.el8.x86_64
MariaDB-common-10.4.10-1.el8.x86_64
MariaDB-client-10.4.10-1.el8.x86_64
MariaDB-server-10.4.10-1.el8.x86_64
/usr/lib64/libmysqlclient.so exists just like it does on my Centos 7 server.

The only difference I see between Centos 7 and Centos 8 installation is that there is no “MariaDB-compat-10.4.7-1.el8.centos.x86_64.rpm” or “MariaDB-compat-10.4.7-1.el8.rhel.x86_64.rpm” for version 8 of those distros.

Any ideas? Thx

Try

yum install mysql-libs

Hi, Manticore is compiled for RHEL/CentOS 8 against MySQL8, it will look for /usr/lib64/libmysqlclient.so.21 ( the version that comes with MySQL8).
The problem is you have installed MariaDB 10.4 (I suspect from MariaDB repo as CentOS ships with 10.3) and there’s no compat package (so far) from either MariaDB or MySQL on CentOS8. mysql-libs (from MySQL8) will conflict with MariaDB 10.4 packages. One way to fix this is to download&install mysql-libs rpm with --nodeps (as it has a dependency on mysql-common which will put libmysqlclient.so.21 in /usr/lib64) or compile Manticore against MariaDB 10.4.

On next version we’ll switch for CentOS 8 build from compiling against mysql-devel/mysql-libs to mariadb-connector-c-devel/mariadb-connector-c (which works with both MySQL and MariaDB).