Retention rule not working

[Uwe Kiewel]

I have created following retention rules:

MariaDB [piler]> select retention_rule.from,days from retention_rule where id in (25,26);
+--------------------+------+
| from               | days |
+--------------------+------+
| ^newsletter.*$     |   30 |
| /^newsletter@.*$/i |   29 |
+--------------------+------+

relevant data in v_messages: MariaDB [piler]> select v_messages.from from v_messages where piler_id='40000000562f15d33ad10b84003bc8b4d1e2'; +---------------------------+ | from | +---------------------------+ | [e-mail] |

Log entry: Oct 27 07:12:26 mailarchiv piler[4842]: 40000000562f15d33ad10b84003bc8b4d1e2: from=journal@xxxxxxxxxx size=218430/40936, attachments=0, reference=, message-id=[e-mail], retention=36500, delay=0.07, delays=0.06/0.01/0.00/0.01/0.00/0.00, status=stored

Why is the default of 35600 days used and not 30/29 day as definied in the from-based retention rule?

[eXtremeSHOK]

from=journal@

your retention rule states newsletter@

[Uwe Kiewel]

so from-based retention rules are not working in Office 365 environment, due to the sender (from) is always from=journal@mydomain?

if I look to the piler database, from is correct as stated in the description. from=[e-mail]

[Janos SUTO]

The 'from' based retention rules should work with o365 as well. The parser doesn't care about the envelope sender / recipient addresses (ok, it cares a little), rather it parses the email headers. However it processes the headers, so they may look a little bit different than you might think.

Take such a message, and run pilertest against it to see what piler thinks about the message. Then compare the from: values with your rules. I suspect that you need a space right after ^. If it doesn't work, then show me pilertest output (the body is not interesting now).

[Uwe Kiewel]

Ok, I got ist. The from line in the email header contains lot's of bullshit beside the email address. Based on the newsletter mail in the 1st post, the from line looks like:

from: tchibo privatcard [e-mail] newsletter news tchibo ch (news.tchibo.ch)

So, will ich check for "newsletter@" in the from I must not use ^newsletter in regex.

I am not sooooo familiar with regex. What would you advice to cover the szenario "retention for newsletters is 30 days"?

newsletter@ /newsletter@/ /^(.)newsletter@(.)$/

any other?

Thanks!

[Janos SUTO]

OK, then try to fix the from address in the retention_rule table simply to [e-mail]

Then run pilertest again, and check if it's any better. Look for the retention related line.

[Uwe Kiewel]

Just putting newsletter@ is the right way. We can resolve this issue. No bug.

[Uwe Kiewel]

not a bug. Regex was wrong

[Uwe Kiewel]

closed. not a bug