dovecot - Aug 2010 - doveadm expunge -A mailbox Trash savedbefore 30d

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

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)

Could you explain the iterate_query in any kind of sql. I'm guessing to 
just use the query, correctly, that's failing as iterate_query= and put 
it in the service auth file which includes password_query and 
user_query. then, I'm guessing to add something like:

iteratedb {
driver = sql
args = /path/to/sql.conf
}

The wiki2 only says:

"When the SQL userdb module is used make sure that the iterate_query 
setting in /etc/dovecot/dovecot-sql.conf.ext matches your database layout."

it should give an example query. I don't know if its wanting to list the 
fields or the contents of a field.

Thanks,

Jerrale G
Jerrale G.
SC Senior Admin