[Dovecot] doveadm expunge -A mailbox Trash savedbefore 30d

[Jerrale G]

  On 8/30/2010 12:06 PM, e-frog wrote:
> On 30.08.2010 17:32, wrote Jerrale G:
>>   On 8/27/2010 11:25 AM, e-frog wrote:
>>> 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.
>> SC Senior Admin
> Uncomment the last line in /etc/dovecot/dovecot-sql.conf.ext and adjust
> the query to your database layout. All doveadm needs is a list of usernames
>
> # Query to get a list of all usernames.
> iterate_query = SELECT username AS user FROM users
>
> There is no need to touch any other file.
>
>
>
Thanks efrog,

Timo or another admin needs to add this in the wiki. I know it is in the 
example sql config file, which is where I got it 
(/usr/share/doc/dovecot/example/dovecot-sql.conf.ext) but it is more 
convenient in the wiki.

I also added the same maildir parameters from the user_query in case the 
iterate_query needed to know where the maildir is:
CONCAT('/home/mail/', mailboxes.domain, '/', mailboxes.username, 
'/mail/') AS maildir

Jerrale G.
SC Senior Admin