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)