[Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d
e-frog
e-frog at gmx.de
Fri Aug 27 18:25:55 EEST 2010
On 27.08.2010 17:16, wrote Jerrale G:
> In the shell:
> ,doveadm(root): Error: User listing returned failure,doveadm: Error:
> Failed to iterate through some users
>
> In the log:
> dovecot: auth: Error: sql: Iterate query failed: Table 'mail.users'
> doesn't exist (using built-in default iterate_query: SELECT username,
> domain FROM users)
>
> Why is dovecot trying to "select username, domain from users" when the
> "service auth" is setup to "select homedir, maildir, sieve_dir, from
> MAILBOXES.... the same with the password query except for selecting
> password from mail.mailboxes.
>
> The expire dictionary is EXACTLY like the example you posted in the wiki2.
>
> I can't remember whether I posted this thread before or not; I remember
> writing it two days ago but I'm not sure if I sent it as I can't find it
> in this "mailing lists" folder.
>
> Jerrale G.
> SC Senior Admin
>
You need to adjust iterate_query setting in
/etc/dovecot/dovecot-sql.conf.ext to your needs
See also:
http://wiki2.dovecot.org/Tools/Doveadm/Expunge?highlight=(iterate_query)
More information about the dovecot
mailing list