Hi Janos,
also here thank you for the quick reply.
|
| 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.
|
OK, I did te changes manually.
Diff is fine now.
|> 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.
I can retrieve messages properly, both mails with and wizhout attachment.
As far as I can see the maisl are all verified.
Then I just ignore the error messages.
|
|
|> 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?
|
This is the topic really bothering me. This is still not working.
Currently I only have the audit user as I did not yet proceed with installation
(wanted to be shure that migration works before going on).
I can see in the file query.log the following queries:
/* Sat Oct 07 05:27:27.075 2023 conn 112 real 0.000 wall 0.000 found 0 */
SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH(' apconsulting') ORDER BY
sent DESC;
/* Sat Oct 07 05:30:23.492 2023 conn 113 real 0.000 wall 0.000 found 0 */
SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH(' *apconsulting*') ORDER BY
sent DESC;
with advanced search i find entries like
/* Sat Oct 07 05:31:27.427 2023 conn 114 real 0.000 wall 0.000 found 0 */
SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('@rcpt apconsulting.de ')
ORDER BY sent DESC;
/* Sat Oct 07 05:32:17.605 2023 conn 115 real 0.000 wall 0.000 found 0 */
SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('@subject Test ') ORDER BY
sent DESC;
all of them above without query result.
only these queries work:
/* Sat Oct 07 05:33:16.686 2023 conn 116 real 0.023 wall 0.024 found 519 */
SELECT id FROM main1,dailydelta1,delta1 WHERE sent BETWEEN 1690840800 AND
1693519199 ORDER BY sent DESC;
/* Sat Oct 07 05:34:21.063 2023 conn 117 real 0.001 wall 0.001 found 537 */
SELECT id FROM main1,dailydelta1,delta1 WHERE sent>=1690840800 ORDER BY sent
DESC;
I am not sure qhat other information you need to give me additional advise.
Thank you
Andreas
| Janos
(null)
