Mail Piler

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-dev

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

1. groupadd piler
   useradd -g piler -m -s /bin/bash -d /var/piler piler
   usermod -L piler
   chmod 755 /var/piler

1. mysql -u root -p

   CREATE OR REPLACE USER 'piler'@'localhost' IDENTIFIED BY 'superpassword';
   quit;

wget https://bitbucket.org/jsuto/piler/downloads/piler-1.4.1.tar.gz
tar xvzf piler-1.4.1.tar.gz

./configure --localstatedir=/var \
--with-database=mysql \
--enable-tcpwrappers \
--enable-memcached
make
make install
ldconfig

nano /usr/local/etc/piler/manticore.conf.dist

et retirer network_timeout

make postinstall

Please enter the webserver groupname [apache] www-data Please enter smtp relay []

Faire un backup du keyfile: /usr/local/etc/piler/piler.key

nano /usr/local/etc/piler/piler.conf

modifier le hostid

touch /usr/local/etc/piler/MANTICORE

nano /usr/local/etc/piler/manticore.conf

define('RT', 1);

nano /var/piler/www/config.php

$config['SPHINX_MAIN_INDEX'] = 'piler1';

systemctl daemon-reload
systemctl enable rc.piler.service
systemctl enable rc.searchd.service
systemctl start rc.piler.service
systemctl start rc.searchd.service

nano /etc/apache2/sites-enabled/000-default.conf

 DocumentRoot /var/www/piler
 
 
        <Directory /var/piler/www>
                Require all granted
                AllowOverride all
        </Directory

a2enmod rewrite
systemctl restart apache2

nano /usr/local/etc/piler/config-site.php 

config-site.php

$config['ENABLE_IMPORT'] = 1;

nano /usr/local/etc/piler/piler.conf

piler.conf

archive_address=archive@mail-arch.makeitsimple.be
rtindex=1
sphxdb=piler1
sphxhost=127.0.0.1
sphxport=9306

Config MYSQL Recommandée:

innodb_buffer_pool_size = 256M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=64M
innodb_log_file_size=64M
innodb_read_io_threads=4
innodb_write_io_threads=4
innodb_log_files_in_group=2

innodb_file_per_table

Import piler:

mkdir /etc/piler
ln -s /usr/local/etc/piler/piler.conf /etc/piler/piler.conf
ln -s /usr/local/bin/pilerimport /usr/bin/pilerimport
/usr/local/libexec/piler/import.sh