Piler Archival Server Installation at Jakson

https://community.spiceworks.com/how_to/138923-how-to-install-mailpiler-on-centos-7

   1  sestatus 
   2  vi /etc/sysconfig/selinux -  disable 
   3  reboot 

Install MariaDB

   7  yum search  mariadb-devel mariadb-libs 
   8  yum search  mariadb-devel.x86_64 mariadb-libs.x86_64
   9  yum install  mariadb-devel.x86_64 mariadb-libs.x86_64

Remove Postfix

  10  yum -y remove postfix && yum -y update
  11  yum -y install epel-release gcc make wget libzip sysstat 
  12  yum -y install tre tre-devel python python-devel MySQL-python openssl openssl-devel 
  13  yum -y install http://sphinxsearch.com/files/sphinx-2.3.2-1.rhel7.x86_64.rpm
     15  yum install https://centos7.iuscommunity.org/ius-release.rpm
  16  yum -y install httpd mod_ssl php72u php72u-cli php72u-common php72u-gd php72u-mbstring php72u-mysqlnd php72u-pdo php72u-ldap 
21  yum install mariadb-server
  17  systemctl restart mariadb && systemctl enable mariadb
 
  23  mysql_secure_installation  - Set root password 
  24  yum -y install tcp_wrappers tcp_wrappers-devel catdoc poppler poppler-utils unrtf tnef libpst 
  25  cd && wget https://bitbucket.org/jsuto/piler/downloads/xlhtml-0.5.1-sj-mod.tar.gz && tar xfvz xlhtml* && cd xlhtml* && ./configure && make && make install
  26  cd
  27  groupadd piler
  28  useradd -g piler -m -s /bin/sh -d /var/piler piler
  29  usermod -L piler
  30  chmod 755 /var/piler
  31  chown -R piler:piler /var/piler/
  32  groupadd piler
  33  useradd -g piler -m -s /bin/sh -d /var/piler piler
  34  usermod -L piler
  35  chmod 755 /var/piler
  36  cd && wget https://bitbucket.org/jsuto/piler/downloads/piler-1.3.5.tar.gz
  37  tar zxvf piler-* && cd piler-* 
  38  ./configure --localstatedir=/var --with-database=mysql 
  39  make
  40  ls
  41  make install 
  42  ldconfig 
  43  make postinstall 

1. Continue? Yes
2. Please enter mysql password for piler [set_new_password]
3. Please enter mysql root password
4. Please enter smtp relay [mailserver.domain.com]
5. Correct? Yes
6. Continue and modify? Yes

  44  echo /usr/local/lib > /etc/ld.so.conf.d/piler.conf
  45  ldconfig -v
  46  hostname
    49  vi  /usr/local/etc/piler/piler.conf  - hostid as hostname
  50  /etc/init.d/rc.piler start 
  51  su - piler
su - piler
indexer --config /usr/local/etc/piler/sphinx.conf --all
reindex -a 
  52  /etc/init.d/rc.searchd start
  53  sed -i '$ a /etc/init.d/rc.piler start' /etc/rc.d/rc.local
  54  sed -i '$ a /etc/init.d/rc.searchd start' /etc/rc.d/rc.local
  55  chmod 755 /etc/rc.d/rc.local
  56  sed -i 's|DirectoryIndex index.html|DirectoryIndex index.html index.php|' /etc/httpd/conf/httpd.conf
  57  sed -i 's|DocumentRoot "/var/www/html"|DocumentRoot "/var/piler/www"|' /etc/httpd/conf/httpd.conf
  58  sed -i 's|ErrorLog "logs/error_log"|ErrorLog "/var/log/httpd/mailarchiver-error.log"|' /etc/httpd/conf/httpd.conf
  59  sed -i '$ a <Directory "/var/piler/www">' /etc/httpd/conf/httpd.conf
  60  sed -i '$ a AllowOverride All' /etc/httpd/conf/httpd.conf
  61  sed -i '$ a Require all granted' /etc/httpd/conf/httpd.conf
  62  sed -i '$ a </Directory>' /etc/httpd/conf/httpd.conf
  63  sed -i '$ a Defaults requiretty' /etc/sudoers
  64  sed -i '$ a Defaults:%apache !requiretty' /etc/sudoers 
  65  apachectl configtest 
  66  systemctl restart httpd
  67  systemctl restart firewalld && systemctl enable firewalld
  68  firewall-cmd --permanent --zone=public --add-service=smtp
  69  firewall-cmd --permanent --zone=public --add-service=http
  70  firewall-cmd --permanent --zone=public --add-service=https
  71  firewall-cmd --reload

  85  cd /var/log//httpd/
    92  less mailarchiver-error.log 
  93  tail -f mailarchiver-error.log
  94  php -v
 101  cp /var/piler/www/config-site.php /usr/local/etc/piler/

http://Ip_address

user admin@local 
default pass - pilerrocks

for LDAP user access /var/piler/www/config.php

$config['ENABLE_LDAP_AUTH'] = 1;
$config['LDAP_HOST'] = 'zimbra.yourdomain.com';
$config['LDAP_MAIL_ATTR'] = 'mail';
$config['LDAP_ACCOUNT_OBJECTCLASS'] = 'zimbraAccount';
$config['LDAP_DISTRIBUTIONLIST_OBJECTCLASS'] = 'zimbraDistributionList';
$config['LDAP_DISTRIBUTIONLIST_ATTR'] = 'zimbraMailForwardingAddress';
$config['LDAP_HELPER_DN'] = 'uid=zimbra,cn=admins,cn=zimbra';
$config['LDAP_HELPER_PASSWORD'] = 'xxxxxxx';

Get password from zimbra Server by

su - zimbra 
zmlocalconfig -s zimbra_ldap_password 
--> zimbra_ldap_password = 8BNztQFG3

In Zimbra (suite your config )

in  /opt/zimbra/common/conf/main.cf
Add 
always_bcc = archive@piler.yourdomain.com
restart zimbra 
Check logs