Upgrading piler enterprise#

Revision #2

Publication date: 2025-JAN-24

Before doing anything, be sure to read the release notes to see what has changed

Upgrading procedure from 1.6.2 to 1.7.2#

Have a backup of /etc/piler directory#

Upgrade piler-ee package with dpkg or rpm#

Update your license file (/etc/piler/piler.lic)#

Upgrade the database:#

for i in /var/piler/sphinx/piler $(find /var/piler/sphinx/* -type d); do
  mysql --defaults-file=/etc/piler/.my.cnf $(basename $i) < /usr/share/piler/db-upgrade.sql
  mysql --defaults-file=/etc/piler/.my.cnf $(basename $i) <<< "rename table archiving_rule to exclusion_rule"
done

Update the rewrite rules in /etc/piler/piler-nginx.conf according to /etc/piler/piler-nginx.conf.dist#

Upgrade the minio python client#

pip3 install minio==7.1.12

If using sphinxsearch, then perform these steps:#

a) add the following to /etc/piler/config-site.php:

$config['DIR_SPHINX'] = '/var/piler/sphinx/';

b) be sure to have the following in /etc/piler/piler.conf:

sphinxdir=/var/piler/sphinx

c) Create the following symlink:

ln -sf /etc/piler/sphinx.conf /etc/piler/manticore.conf

Restart nginx:

systemctl restart nginx

Then check /var/log/mail.log or /var/log/maillog to verify that everything is running fine.

Upgrading procedure from 1.7.2 to 1.8.4#

Make sure you have php 8.x installed#

Have a backup of /etc/piler directory#

Upgrade piler-ee package with dpkg or rpm#

Upgrade the database:#

for i in /var/piler/sphinx/piler $(find /var/piler/sphinx/* -type d); do
  mysql --defaults-file=/etc/piler/.my.cnf $(basename $i) < /usr/share/piler/db-upgrade.sql
done

If you use Manticore, then run:

for i in /var/piler/manticore/piler $(find /var/piler/manticore/* -type d); do
   mysql --defaults-file=/etc/piler/.my.cnf $(basename $i) < /usr/share/piler/db-upgrade.sql
done

Update the rewrite rules in /etc/piler/piler-nginx.conf according to /etc/piler/piler-nginx.conf.dist#

Add the following new variables to /etc/piler/piler.conf:

max_message_size=50000000
max_smtp_memory=500000000

You may adjust the above values to your environment.

Update the pidfile variable in /etc/piler/piler.conf:

pidfile=/var/piler/run/piler.pid

Add the following to /etc/piler/config-site.php:

$config['SPHINX_HOSTNAME_READONLY'] = '127.0.0.1:9307';

Install the pycryptodome package

pip install pycryptodome==3.20.0

Generate an encryption key:

openssl rand -base64 24

Add it to /etc/piler/piler.conf

crypt_key=..........

Also add it to /etc/piler/config-site.php:

$config['ENCRYPTION_KEY'] = '.......';

Restart nginx:

systemctl restart nginx

Then check /var/log/mail.log or /var/log/maillog to verify that everything is running fine.