Dear piler-users,
mariadb is a popular mysql replacement, and some of you prefer it
instead
of the stock mysql packages your distributions ship.
However it appears that the latest version of piler (from 0.1.24)
segfaults
as soon as it starts, and reaches the database.
It seems that it's a strange problem, and (so far) only centos is
affected
(and probably redhat, too) both on 32-bit and 64-bit. I also tested
with
mariadb-5.5.32 on debian 7.1 64-bit, and it works just fine.
If you insist on both centos and mariadb, (and followed Adrian's and
Jan
Carel's excellent guide at
https://extremeshok.com/2013/08/28/rhel-centos-redhat-mailpiler-sphinx-mariadb-mysql/)
and experience the same segfault issue, then try the following.
It's tested on centos 6.4 64-bit:
1. remove Mariadb:
/etc/init.d/mysql stop
yum remove Maria*
mv /etc/yum.repos.d/MariaDB.repo /tmp/
2. install stock mysql packages:
yum install mysql-devel
3. recompile piler
"cd to piler-source"
./configure --localstatedir=/var --enable-starttls --enable-tcpwrappers
--with-database=mysql
make clean all
make install
ldd /usr/local/sbin/piler
4. save the working mysql so file:
cp /usr/lib64/mysql/libmysqlclient_r.so.16 /usr/local/lib
ldconfig
5. remove the stock mysql packages, and install mariadb:
yum remove mysql*
mv /tmp/MariaDB.repo /etc/yum.repos.d/
yum install -y MariaDB-{server,test,devel,common,compat,client}
/etc/init.d/mysql start
6. restart piler: it should work by now again.
/etc/init.d/rc.piler restart
If your shpinx packages was removed during the process, then
download it again, and reinstall it:
wget http://sphinxsearch.com/files/sphinx-2.0.9-1.rhel6.x86_64.rpm
yum localinstall sphinx-2.0.9-1.rhel6.x86_64.rpm
I'll check for the percona version of mysql for possible issues,
and let you know my findings.
Best regards,
Janos
