Hello Andreas,

On 2023-10-04 19:35, Andreas Pampel wrote:

I then restored the database I received from my old provder and
migrated this to what I thought is the newest version:
* as described here https://www.mailpiler.org/wiki/current:upgrade and
after that
* as described here https://bitbucket.org/jsuto/piler/src/master/util/
 db-upgrade.sql [1]
All statements were processed without errors

When I compare the structure there are small differences. See attached
files:
* piler_apconsulting.sql is the migrated database
* piler.sql is the database that was installed with the docker

Do I need to run additional sql statements?
If yes: Where can I find them?

I've just run a quick diff against the 2 files, and it turns out 3 tables
are missing from the old structure, eg. deleted, `group`, and usergroup.
Also the v_messages view seems to be different, be sure to drop it, and
recreate it. See /usr/share/piler/db-util.sql for the database schema.

In the following i restored all files in /var/piler/store and the keys
and adpoted the config files.
While reindexing i got several identical error messages "Failed to
inflate invalid or incomplete deflate data".
I am not sure if the db differences are the root cause for this. If
not: what do I need to do?

Not sure. Can you retrieve any message properly? Perhaps some without
attachments. If not, then verify that piler.key and piler.conf iv
parameters match.


When i check the ui with the auditor user, i see e-mails and they are
validated (good!). I can filter them on date, but I can not filter
them using string nor using the advanced search (except the dates).

Enter some subject words, then hit the red search button, and check
the logged sphinx query. Also try to login as an auditor and do the
same search. What happens?

Janos

Reply via email to