Cannot Update Piler from 1.3.9 build 998 to 1.3.10 on Ubuntu 20.04

[Francesco Barcella]

1. Downloaded .deb file

   wget https://bitbucket.org/jsuto/piler/downloads/piler_1.3.10-focal-7fc8f74_amd64.deb 2. Stopped services

   sudo /etc/init.d/rc.piler start ... stopping piler stopping piler-smtp 3. Installed the

   ``` sudo dpkg -i piler_1.3.10-focal-7fc8f74_amd64.deb Selecting previously unselected package piler. (Reading database ... 116363 files and directories currently installed.) Preparing to unpack piler_1.3.10-focal-7fc8f74_amd64.deb ... Unpacking piler (1.3.10-focal-7fc8f74) ... Setting up piler (1.3.10-focal-7fc8f74) ...

   Configuration file '/etc/init.d/rc.piler' ==> File on system created by you or by a script. ==> File also in package provided by package maintainer. What would you like to do about it ? Your options are: Y or I : install the package maintainer's version N or O : keep your currently-installed version D : show the differences between the versions Z : start a shell to examine the situation The default action is to keep your current version. *** rc.piler (Y/I/N/O/D/Z) [default=N] ? y Installing new version of config file /etc/init.d/rc.piler ...

   Configuration file '/etc/init.d/rc.searchd' ==> File on system created by you or by a script. ==> File also in package provided by package maintainer. What would you like to do about it ? Your options are: Y or I : install the package maintainer's version N or O : keep your currently-installed version D : show the differences between the versions Z : start a shell to examine the situation The default action is to keep your current version. *** rc.searchd (Y/I/N/O/D/Z) [default=N] ? y Installing new version of config file /etc/init.d/rc.searchd ... DEBUG: adding setuid permissions to piler binaries DEBUG: Generating piler.key DEBUG: Making an ssl certificate DEBUG: fixing /var/run/piler ownership DEBUG: Checking for /var/piler/customer DEBUG: Checking for /etc/piler/config-site.php DEBUG: Checking for /etc/piler/sites DEBUG: Checking for /etc/piler/sites/customer-sites.php DEBUG: postinstall has finished Processing triggers for systemd (245.4-4ubuntu3.7) ...

   ```

2. When Navigate Piler web interface

   Error: SQLSTATE[HY000] [1045] Access denied for user 'piler'@'localhost' (using password: YES) on database: piler

‌

‌

What I’m wrong ?

[Janos SUTO]

What was the previous package you used?

[Francesco Barcella]

I followed this guide

https://patrik.kernstock.net/2020/08/mailpiler-installation-guide/

[Janos SUTO]

Well, the problem is that you installed 1.3.9 to /usr/local, however the deb package uses /usr as the install prefix. So you need to fix your deployment and put your configs, keys, pem files, etc. to the new path, eg. /etc/piler dir, and preferably remove the old deployment’s config. Be sure to keep the data!

[Francesco Barcella]

it do no seem an easy task , should be easier to unpack the deb and edit preinstall e postinstall and the folder to be able to update the current installation ? Or may be to move on a new installation done in a proper way ?

[Janos SUTO]

Well, in that case the latter seems to be a good option.

[Janos SUTO]

No news is good news.