Retention Rules Build / Query

[Thomas Helmrich]

Hi,

i have a question regarding the retention rules:

i defined a rule with following data:

from: [e-mail]
to: [e-mail]
Subject: Menu
Retention Period: 14

I except, that those should end into an AND query, so the message only gets a retention of 14 when from, to and Subect are matching.

Currently, the message get a retention period of 14, when one of the definition is matching (like an OR).

Is that the excepted behaviour or an bug?

Thanks!
Thomas

[Janos SUTO]

It’s definitely not the expected behaviour, they are supposed to be in a Boolean AND relation. I’ll check it for myself, and let you know.

[Janos SUTO]

I couldn’t reproduce it. I have the following retention rule returning 10 days when the email matches the following:

From: [e-mail]
To: [e-mail]
Subject: test

MariaDB [piler]> select * from retention_rule;
+----+--------+--------------+--------------+---------+------+-------+------+-----------------+-----------------+------------------+-----------------+------+------+-----------+
| id | domain | from         | to           | subject | body | _size | size | attachment_name | attachment_type | _attachment_size | attachment_size | spam | days | folder_id |
+----+--------+--------------+--------------+---------+------+-------+------+-----------------+-----------------+------------------+-----------------+------+------+-----------+
|  1 |        | [e-mail] | [e-mail] | test    |      | >     |    0 |                 |                 | >                |               0 |   -1 |   10 |         0 |
+----+--------+--------------+--------------+---------+------+-------+------+-----------------+-----------------+------------------+-----------------+------+------+-----------+

test1.eml:

From: [e-mail]
To: [e-mail]
Date: Wed, 9 Dec 2020 10:35:24 +0100
Subject: test email
Message-ID: <akakaka@akaka10006>

akakakak asjsjsjs

test2.eml:

From: [e-mail]
To: [e-mail]
Date: Wed, 9 Dec 2020 10:35:24 +0100
Subject: some subject
Message-ID: <akakaka@akaka10006>

akakakak asjsjsjs

test3.eml:

From: [e-mail]
To: [e-mail]
Date: Wed, 9 Dec 2020 10:35:24 +0100
Subject: other things
Message-ID: <akakaka@akaka10006>

akakakak asjsjsjs

‌

Now let’s run pilertest against them.

piler returns 10 days for test1.eml as it should:

# pilertest -m test1.eml 
locale: C
build: 1001
parsing...
post parsing...
message-id: <akakaka@akaka10006> / 2fd0ac77bf34a6ce34d39052611ed2fabc3f8c115ff38951b969e57cee1ba39d
from: *[e-mail] bela acts hu  (acts.hu)*
sender: * ()*
to: *[e-mail] sanyi aaa fu  (aaa.fu )*
journal recipients: **
reference: **
subject: *test email*
body: *akakakak asjsjsjs *
sent: 1607506524, delivered-date: 0
hdr len: 127
body digest: 34ea2a903e889057df4e8eb3d8c7a1dead0535566893d3142892305690626231
rules check: (null)
folder: 0
retention period: 1608370524 (10 days)
attachments:
direction: 1
spam: 0
1st received line: 

‌

And it returns the default 2557 days for the other 2 emails:

# pilertest -m test2.eml 
locale: C
build: 1001
parsing...
post parsing...
message-id: <akakaka@akaka10006> / 2fd0ac77bf34a6ce34d39052611ed2fabc3f8c115ff38951b969e57cee1ba39d
from: *[e-mail] bela acts hu  (acts.hu)*
sender: * ()*
to: *[e-mail] jhjjjhjh aaa fu  (aaa.fu )*
journal recipients: **
reference: **
subject: *some subject*
body: *akakakak asjsjsjs *
sent: 1607506524, delivered-date: 0
hdr len: 132
body digest: 34ea2a903e889057df4e8eb3d8c7a1dead0535566893d3142892305690626231
rules check: (null)
folder: 0
retention period: 1828431324 (2557 days)
attachments:
direction: 1
spam: 0
1st received line: 

and

# pilertest -m test3.eml 
locale: C
build: 1001
parsing...
post parsing...
message-id: <akakaka@akaka10006> / 2fd0ac77bf34a6ce34d39052611ed2fabc3f8c115ff38951b969e57cee1ba39d
from: *[e-mail] hjkjjkk bbb fu  (bbb.fu)*
sender: * ()*
to: *[e-mail] sanyi aaa fu  (aaa.fu )*
journal recipients: **
reference: **
subject: *other things*
body: *akakakak asjsjsjs *
sent: 1607506524, delivered-date: 0
hdr len: 131
body digest: 34ea2a903e889057df4e8eb3d8c7a1dead0535566893d3142892305690626231
rules check: (null)
folder: 0
retention period: 1828431324 (2557 days)
attachments:
direction: 0
spam: 0
1st received line: 

Can you build the latest master (and not install it), and run pilertest from the build dir?

[Thomas Helmrich]

iam on current master.
ok - what i see is, when domain is defined, it seems to do the mismatch?
Regarding Subject: Ist it a Wildcard on test, so test must only appear? or is it a exact match on subject test

wiil provide a debug set!

[Thomas Helmrich]

On first try outs, it looks like the set of “domain” with the other fields did the issue

[Janos SUTO]

It must only appear. The domain part should be relevant for the discontinued saas feature. I suggest not to use it.