OK, then click on a message, the hover the mouse over the download link
on the lower preview pane. It reveals the message id, eg. 123. Then
run the following sql query, and check if the from and:
select id, piler_id, `from` from metadata where id=123;
select id, `to` from rcpt where id=123;
These queries should reveal the From: and To/Cc: header values
from the email. Check if they actually match with the email.
You may retrieve the email with the pilerget utility, or simply
download it.
Janos
On 2023-10-07 17:32, Andreas wrote:
Hi Janos,
no, I do not get any result.
Login as an auditor, hit the search button, and you should be able to
see some results.
Yes; i see 1000 records.
Then click on a message, observe the From: address,
| and type it to the search bar (no wildcard, nothing fancy, just the
| email address), and you should be able to see the same message in
| the search results.
No results.
the query.log entry is:
/* Sat Oct 07 15:28:23.418 2023 conn 131 real 0.000 wall 0.000 found 0
*/ SELECT id FROM main1,dailydelta1,delta1 WHERE MATCH('@sender
jobXalertXhaysXde ') ORDER BY sent DESC;
The error message in the UI is:
Empty search result. Try adding the wildcard character(*) after a word
snippet (min. 5 characters), eg. duplic* to find "duplicate",
"duplicated", etc.
Any idea?
Andreas
----- Ursprüngliche Mail -----
| Von: "Janos SUTO" <s...@acts.hu>
| An: "Piler User" <piler-user@list.acts.hu>
| CC: "Andreas" <pi...@apconsulting.de>
| Gesendet: Samstag, 7. Oktober 2023 17:19:50
| Betreff: Re: Version Upgrade/ Date Migration
| On 2023-10-07 07:35, Andreas wrote:
|
|>
|> 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;
|
| Login as an auditor, hit the search button, and you should be able to
| see some results. Then click on a message, observe the From: address,
| and type it to the search bar (no wildcard, nothing fancy, just the
| email address), and you should be able to see the same message in
| the search results.
|
| Also every time you try a search query, then check the mail log for
the
| sphinx query and results.
|
| Janos
(null)
