====== Mail Piler ======

===== Installation des prérequis =====

<code bash>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</code>


===== Installation de Manticore =====

<code bash>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
</code>


===== Création des accès/droits =====

  - <code bash>groupadd piler
useradd -g piler -m -s /bin/bash -d /var/piler piler
usermod -L piler
chmod 755 /var/piler</code>

  - <code bash>mysql -u root -p</code> <code mysql>CREATE OR REPLACE USER 'piler'@'localhost' IDENTIFIED BY 'superpassword';
quit;</code>

===== Installation de Piler =====

<code bash>wget https://bitbucket.org/jsuto/piler/downloads/piler-1.4.1.tar.gz
tar xvzf piler-1.4.1.tar.gz</code>

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

<code bash>nano /usr/local/etc/piler/manticore.conf.dist</code>
 et retirer network_timeout


<code bash>make postinstall</code>
 Please enter the webserver groupname [apache] www-data
 Please enter smtp relay []

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

<code bash>nano /usr/local/etc/piler/piler.conf</code>
 modifier le hostid

touch /usr/local/etc/piler/MANTICORE

<code bash>nano /usr/local/etc/piler/manticore.conf</code>
define('RT', 1);

<code bash>nano /var/piler/www/config.php</code>
 $config['SPHINX_MAIN_INDEX'] = 'piler1';

<code bash>systemctl daemon-reload
systemctl enable rc.piler.service
systemctl enable rc.searchd.service
systemctl start rc.piler.service
systemctl start rc.searchd.service</code>

<code bash>nano /etc/apache2/sites-enabled/000-default.conf</code> <code apache2> DocumentRoot /var/www/piler


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

<code bash>
a2enmod rewrite
systemctl restart apache2
</code>

<code bash>
nano /usr/local/etc/piler/config-site.php </code><file - config-site.php>
$config['ENABLE_IMPORT'] = 1;</file>

<code bash>nano /usr/local/etc/piler/piler.conf</code><file - piler.conf>
archive_address=archive@mail-arch.makeitsimple.be
rtindex=1
sphxdb=piler1
sphxhost=127.0.0.1
sphxport=9306
</file>

Config MYSQL Recommandée:
<code>
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</code>

Import piler:
<code bash>
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
</code>