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 the warning checking for libexpat... not found. On Suse the package is called libexpat-devel, on Ubuntu the package is called libexpat1-dev.

Once libexpat is installed, 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 run into problems with MariaDB/MySQL not being detected, use the following 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

The above will tell the configure script where your MySQL/MariaDB installation is.

After installing Sphinx, you can check that things are working in MariaDB by doing 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.