Installing and testing SphinxSE with MariaDB

To use SphinxSE with MariaDB you need to first download and install Sphinx.

If Sphinx is not part of your distribution, here is a short description of how to do this:

First install libexpat (If not, you will get warning checking for libexpat... not found. On Suse this is package libexpat-devel.

Install and configure Sphinx. Here is an example of how to this:

cd /usr/local/src
tar xvfz sphinx-0.9.9.tar.gz
cd sphinx-0.9.9
./configure --prefix=/usr/local
make
make install

If you get problems with MariaDB/MySQL not being detected, use options:

 --with-mysql            compile with MySQL support (default is enabled)
 --with-mysql-includes   path to MySQL header files
 --with-mysql-libs       path to MySQL libraries

to tell configure where your MySQL/MariaDB installation is.

To check that things works in MariaDB, do the following:

cd installation-dir/mysql-test
./mysql-test-run --suite=sphinx

If the above test doesn't pass, check the logs in the 'var' directory. If there is a problem with the sphinx installation, the reason can probably be found in the log file at:

var/log/sphinx.sphinx/searchd/sphinx.log