Re: Sieve Scripts via SQL Dicts in Dovecot 2.4 not working?

26 Aug 2025

      On 26/08/2025 10:30, niklas.meyer--- via dovecot wrote:
...
No one has a clue here? Did no one use Sieve Mysql Maps?

dovecot mailing list --dovecot@dovecot.org
To unsubscribe send an email todovecot-leave@dovecot.org
Hi Niklas
I'm not using Sieve Mysql maps, but I did take a look at the output you
posted.
In your debug log I can see two lookups for before2 and for after2, e.g.

Aug 15 12:22:24 43664c142e0a dovecot:
lmtp(frittenjonas@derlinkman.de)<2407><mPFNN2AKn2hnCQAAhwrv7A>:
Debug: sieve: storage before2: dict: dict(proxy): Looking up
'priv/sieve/name/active'

Aug 15 12:22:24 43664c142e0a dovecot:
lmtp(frittenjonas@derlinkman.de)<2407><mPFNN2AKn2hnCQAAhwrv7A>:
Debug: sieve: storage before2: dict: dict(proxy): Looking up (async)
'priv/sieve/name/active'

Not sure what governs async vs. non async or why there are two lookups.
What I did notice is that the before2 lookups gave "found" each time,
but after2 gave "not found" each time. I think that is the cause of the
overall failure you then got on sieve.

Aug 15 12:22:24 43664c142e0a dovecot:
lmtp(frittenjonas@derlinkman.de)<2407><mPFNN2AKn2hnCQAAhwrv7A>:
Debug: sieve: storage after2: dict: dict(proxy): Lookup finished for
'priv/sieve/name/active': not found
Aug 15 12:22:24 43664c142e0a dovecot:
lmtp(frittenjonas@derlinkman.de)<2407><mPFNN2AKn2hnCQAAhwrv7A>:
Debug: sieve: storage after2: dict: dict(proxy): Lookup finished for
'priv/sieve/name/active': not found
Aug 15 12:22:24 43664c142e0a dovecot:
lmtp(frittenjonas@derlinkman.de)<2407><mPFNN2AKn2hnCQAAhwrv7A>:
Debug: sieve: storage after2: dict: script 'active': Script 'active'
not found at path priv/sieve/name/active

maybe the queries are not returning the expected data.
best regards
John
On 26/08/2025 10:30, niklas.meyer--- via dovecot wrote:
No one has a clue here? Did no one use Sieve Mysql Maps?

dovecot mailing list -- [1]dovecot@dovecot.org
To unsubscribe send an email to [2]dovecot-leave@dovecot.org
Hi Niklas
I'm not using Sieve Mysql maps, but I did take a look at the output you
posted.
In your debug log I can see two lookups for before2 and for after2, e.g.
1. Aug 15 12:22:24 43664c142e0a dovecot:
   lmtp([3]frittenjonas@derlinkman.de)&lt;2407>&lt;mPFNN2AKn2hnCQAAhwrv7A>:
   Debug: sieve: storage before2: dict: dict(proxy): Looking up
   'priv/sieve/name/active'
1. Aug 15 12:22:24 43664c142e0a dovecot:
   lmtp([4]frittenjonas@derlinkman.de)&lt;2407>&lt;mPFNN2AKn2hnCQAAhwrv7A>:
   Debug: sieve: storage before2: dict: dict(proxy): Looking up (async)
   'priv/sieve/name/active'
1.
Not sure what governs async vs. non async or why there are two lookups.
What I did notice is that the before2 lookups gave "found" each time, but
after2 gave "not found" each time. I think that is the cause of the
overall failure you then got on sieve.
1. Aug 15 12:22:24 43664c142e0a dovecot:
   lmtp([5]frittenjonas@derlinkman.de)&lt;2407>&lt;mPFNN2AKn2hnCQAAhwrv7A>:
   Debug: sieve: storage after2: dict: dict(proxy): Lookup finished for
   'priv/sieve/name/active': not found
1. Aug 15 12:22:24 43664c142e0a dovecot:
   lmtp([6]frittenjonas@derlinkman.de)&lt;2407>&lt;mPFNN2AKn2hnCQAAhwrv7A>:
   Debug: sieve: storage after2: dict: dict(proxy): Lookup finished for
   'priv/sieve/name/active': not found
1. Aug 15 12:22:24 43664c142e0a dovecot:
   lmtp([7]frittenjonas@derlinkman.de)&lt;2407>&lt;mPFNN2AKn2hnCQAAhwrv7A>:
   Debug: sieve: storage after2: dict: script 'active': Script 'active'
   not found at path priv/sieve/name/active
maybe the queries are not returning the expected data.
best regards
John
References
Visible links

mailto:dovecot@dovecot.org
mailto:dovecot-leave@dovecot.org
mailto:frittenjonas@derlinkman.de
mailto:frittenjonas@derlinkman.de
mailto:frittenjonas@derlinkman.de
mailto:frittenjonas@derlinkman.de
mailto:frittenjonas@derlinkman.de

Re: Sieve Scripts via SQL Dicts in Dovecot 2.4 not working?

John Fawcett