[Dovecot] Trouble with expire plugin

[Timo Sirainen]

On 27.1.2013, at 22.49, Gedalya <gedalya at gedalya.net> wrote:

> I got it working. I know this worked before, I can't specify when it stopped working, but here is the story.
> 
> I have:
> auth_default_realm = domain.com
> 
> in dovecot-sql.conf.ext I had:
> iterate_query = SELECT userid as user, domain FROM email where deleted=0
> 
> Now it's working when I changed it to:
> iterate_query = SELECT concat(userid, '@', domain) as username FROM email where deleted=0

iterate_query = SELECT userid as username, domain FROM email where deleted=0

would have worked too. user = the whole user at domain, while username = without domain. I think I'll leave it like this.

> Is this a bug? The wiki clearly says that iterate_query can take the domain in a separate field, yet dovecot seems to ignore the domain field and use auth_default_realm.

The wiki page was partially wrong though, updated.