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