apt purge postfix
apt install gnupg2 sysstat python3-mysqldb mariadb-server default-libmysqlclient-dev memcached libapache2-mod-php php-mysql libtre5 libtre-dev openssl libssl-dev  libzip-dev libzip4 build-essential gcc libwrap0 libwrap0

wget https://repo.manticoresearch.com/manticore-repo.noarch.deb
dpkg -i manticore-repo.noarch.deb
apt update
apt install manticore manticore-columnar-lib
systemctl start manticore
systemctl disable manticore

apt install libtre5 wget https://bitbucket.org/jsuto/piler/downloads/piler_1.3.12-focal-eb2b22b2_amd64.deb wget http://mirrors.kernel.org/ubuntu/pool/universe/libz/libzip/libzip5_1.5.1-0ubuntu1_amd64.deb

dpkg -i libzip5_1.5.1-0ubuntu1_amd64.deb dpkg -i piler_1.3.12-focal-eb2b22b2_amd64.deb

cp /etc/piler/piler.conf.dist /etc/piler/piler.conf nano /etc/piler/piler.conf

hostid=piler.yourdomain.com listen_addr=0.0.0.0 listen_port=2525 mysqldb=piler mysqlpwd=verystrongpassword mysqluser=piler

mysql -u root -p create database piler character set 'utf8mb4'; grant all privileges on piler.* to piler@localhost identified by 'verystrongpassword'; flush privileges; quit;

mysql -u piler -p piler < /usr/share/piler/db-mysql.sql

wget http://sphinxsearch.com/files/sphinx-3.4.1-efbcc65-linux-amd64.tar.gz tar xvzf sphinx-3.4.1-efbcc65-linux-amd64.tar.gz cp /sphinx-3.4.1/bin/* /usr/bin

crontab -e -u piler

/ A VERIFIER 5,35 * * * * /usr/local/libexec/piler/indexer.delta.sh 30 2 * * * /usr/local/libexec/piler/indexer.main.sh 40 3 * * * /usr/local/libexec/piler/purge.sh */15 * * * * /usr/bin/indexer –config /usr/local/etc/piler/sphinx.conf –quiet tag1 –rotate */15 * * * * /usr/bin/indexer –config /usr/local/etc/piler/sphinx.conf –quiet note1 –rotate */5 * * * * /usr/bin/find /var/piler/www/tmp -type f -name i.\* -exec rm -f {} \; */5 * * * * /usr/bin/find /var/piler/error -type f|wc -l > /var/piler/stat/error 3 * * * * /usr/local/libexec/piler/watch_sphinx_main_index.sh 2 0 * * * /usr/local/libexec/piler/pilerpurge.py /var/piler/www/ /etc/piler/config-site.php</code>