Editing ISGEC - Piler Archive Server

'''Procedure :'''

 setenforce 0
 hostnamectl set-hostname piler.isgec.com
 
 yum install  mariadb-devel.x86_64 mariadb-libs.x86_64
 yum -y remove postfix && yum -y update
 yum -y install epel-release gcc make wget libzip sysstat
 yum -y install tre tre-devel python python-devel MySQL-python openssl openssl-devel
 yum -y install http://sphinxsearch.com/files/sphinx-2.3.2-1.rhel7.x86_64.rpm   //python - to restructure docs
 yum install https://centos7.iuscommunity.org/ius-release.rpm 
 yum install https://repo.ius.io/ius-release-el$(rpm -E '%{rhel}').rpm
 yum -y install httpd mod_ssl php72u php72u-cli php72u-common php72u-gd php72u-mbstring php72u-mysqlnd php72u-pdo php72u-ldap
 yum -y install tcp_wrappers tcp_wrappers-devel catdoc poppler poppler-utils unrtf tnef libpst
 yum install mariadb-server
 
 systemctl restart mariadb && systemctl enable mariadb

 mysql_secure_installation  - Set root password 

 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
 groupadd piler
 useradd -g piler -m -s /bin/sh -d /var/piler piler
 usermod -L piler	//lock account		
 chmod 755 /var/piler
 cd && wget https://bitbucket.org/jsuto/piler/downloads/piler-1.3.5.tar.gz
 tar zxvf piler-* && cd piler-*
 ./configure --localstatedir=/var --with-database=mysql
 make
 make install
 ldconfig	//creating necessary links
 make postinstall
 echo /usr/local/lib > /etc/ld.so.conf.d/piler.conf

 vi  /usr/local/etc/piler/piler.conf  - hostid as hostname
 /etc/init.d/rc.piler start

su - piler
 /etc/init.d/rc.searchd start
 sed -i '$ a /etc/init.d/rc.piler start' /etc/rc.d/rc.local
 sed -i '$ a /etc/init.d/rc.searchd start' /etc/rc.d/rc.local
 chmod 755 /etc/rc.d/rc.local
 sed -i 's|DirectoryIndex index.html|DirectoryIndex index.html index.php|' /etc/httpd/conf/httpd.conf
 sed -i 's|DocumentRoot "/var/www/html"|DocumentRoot "/var/piler/www"|' /etc/httpd/conf/httpd.conf
 sed -i 's|ErrorLog "logs/error_log"|ErrorLog "/var/log/httpd/mailarchiver-error.log"|' /etc/httpd/conf/httpd.conf
 sed -i '$ a <Directory "/var/piler/www">' /etc/httpd/conf/httpd.conf
 sed -i '$ a AllowOverride All' /etc/httpd/conf/httpd.conf
 sed -i '$ a Require all granted' /etc/httpd/conf/httpd.conf
 sed -i '$ a </Directory>' /etc/httpd/conf/httpd.conf
 sed -i '$ a Defaults requiretty' /etc/sudoers
 sed -i '$ a Defaults:%apache !requiretty' /etc/sudoers 

 apachectl configtest 
 systemctl restart httpd
 systemctl restart firewalld && systemctl enable firewalld
 firewall-cmd --permanent --zone=public --add-service=smtp
 firewall-cmd --permanent --zone=public --add-service=http
 firewall-cmd --permanent --zone=public --add-service=https
 firewall-cmd --reload
 
 cp /var/piler/www/config-site.php /usr/local/etc/piler/
 /etc/init.d/rc.searchd stop
 /etc/init.d/rc.piler stop

 mkdir -p /home/piler
 rsync -av /var/piler/ /home/piler/
 ln -s /var/piler /home/piler
 chown piler.piler /home/piler
 /etc/init.d/rc.searchd start
 /etc/init.d/rc.piler start

 /etc/init.d/rc.searchd status
 /etc/init.d/rc.piler status

 yum install sshfs
 mkdir /old_mails

//with screen command

 sshfs -o allow_other,uid=1000,gid=1000 192.168.25.190:/opt/zimbra/store/0/ /old_mails/           // To mount dirs and files 

 /etc/init.d/rc.piler start
 /etc/init.d/rc.searchd start

 pilerimport -d /old_mails/

 vi /var/piler/www/config.php 
 $config['ENABLE_LDAP_AUTH'] = 1;
 $config['LDAP_HOST'] = 'zimbra.isgec.com';
 $config['LDAP_PORT'] = 389;
 $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'] = 'wQyIzBhr';
 $config['LDAP_AUDITOR_MEMBER_DN'] = '';
 $config['LDAP_ADMIN_MEMBER_DN'] = '';
 $config['LDAP_BASE_DN'] = '';

//On Zimbra Server
 vi  /opt/zimbra/common/conf/main.cf
 always_bcc = archive@piler.isgec.com

su - zimbra
zmcontrol restart 


That’s almost it for Piler – Browse to http://Piler.domain.local:8080 to access the web interface.

Default Login Details:
User: administrator/admin
Password: pilerrocks


Logs:

Mail logs - /var/log/maillog
Error Logs - mailarchiver-error.log


192.168.25.199
P@ssw0rd@2020