Re: [SPAM] Auto-empty trash items older then a certain age

Il 08/11/2012 18:53, Matt Rauch ha scritto:
>   
>
>> -----Original Message-----
>> From: Matt Rauch [mailto:[email protected]]
>> Sent: November-08-12 11:57 AM
>> To: [email protected]
>> Subject: RE: [qmailadmin] [SPAM] Auto-empty trash items older
>> then a certain age
>>
>>> Il 08/11/2012 17:15, Matt Rauch ha scritto:
>>>>> The best way to do this is to run:
>>>>>
>>>>> doveadm expunge -A mailbox Trash savedbefore 30d (if you
>>> use dovecot
>>>>> with MySQL for auth)
>>>>>
>>>>> or
>>>>>
>>>>> doveadm expunge -u [email protected] mailbox Trash
>>> savedbefore 30d (if
>>>>> you use dovecot with vpopmail auth)
>>>>>
>>>>> Any other script, like "find -exec rm", will break user's
>>> quota since
>>>>> is not updating maildirsize file.
>>>>>
>>>>> Form more information see
>>>>>
>>>>> http://wiki2.dovecot.org/Tools/Doveadm/Expunge
>>>>> and
>>>>> http://wiki2.dovecot.org/Plugins/Expire
>>>>>
>>>>> Ciao
>>>>>
>>>> 	Ok so I tested this method with search instead of
>>> expunge to see what
>>>> would hit. if I try the first command (doveadm expunge -A mailbox
>>>> Trash savedbefore 30d), I get an error message:
>>>>
>>>> # doveadm search -A mailbox Trash savedbefore 30d
>>>> doveadm(mattr): Error: User listing returned failure
>>>> doveadm: Error: Failed to iterate through some users
>>>>
>>>> If I use the second option (doveadm expunge -u
>>> [email protected] mailbox
>>>> Trash savedbefore 30d) it works, but I have to specify the
>>> username for each user.
>>>> Is there a way to do it so that it affects all users?
>>> (which I thought
>>>> the -A would do).
>>> The -A need dovecot auth with mysql like this:
>>>
>>> ## vpopmail
>>> ##
>>> # Query to get a list of all usernames.
>>> iterate_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user FROM
>>> vpopmail # driver = mysql connect = host=localhost dbname=vpopmail
>>> user=vpopmail password=mypwd default_pass_scheme = MD5-CRYPT
>>>
>>> user_query = SELECT pw_dir as home, 89 AS uid, 89 AS gid,
>>> concat('*:backend=', pw_shell) as quota_rule FROM vpopmail WHERE
>>> pw_name = '%n' AND pw_domain = '%d'
>>>
>>> password_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user,
>>> pw_passwd AS password, concat('*:backend=', pw_shell) as
>>> userdb_quota_rule FROM vpopmail WHERE pw_name = '%n' AND
>> pw_domain =
>>> '%d'
>>>
>>> What kind of dovecot authentication are you using?
>> I'm not entirely sure to be honest with you. Are you able to
>> tell from the output of dovecot -n?
>>
>> imap# dovecot -n
>> # 2.0.9: /usr/local/etc/dovecot/dovecot.conf
>> # OS: FreeBSD 6.0-RELEASE-p5 i386
>> auth_mechanisms = plain login cram-md5
>> auth_verbose = yes
>> base_dir = /var/run/dovecot/
>> default_client_limit = 1005
>> default_login_user = dovecot
>> default_process_limit = 500
>> disable_plaintext_auth = no
>> dotlock_use_excl = yes
>> first_valid_uid = 89
>> last_valid_uid = 89
>> log_path = /dev/stderr
>> log_timestamp =
>> passdb {
>>    args = webmail=127.0.0.1
>>    driver = vpopmail
>> }
>> plugin {
>>    quota = maildir
>> }
>> protocols = imap
>> service auth {
>>    user = root
>> }
>> ssl_cert = </var/qmail/control/servercert.pem
>> ssl_key = </var/qmail/control/servercert.pem
>> userdb {
>>    args = quota_template=quota_rule=*:backend=%q
>>    driver = vpopmail
>> }
>> verbose_proctitle = yes
>>
>> Matt
>>
> Did some more digging and it looks like I can't use the -A flag if the
> userdb is vpopmail. I would have to bypass and use the sql directly. Not
> sure how I feel about that on a live mail server right now.
>

With userdb in vpopmail you can't use -A

At this page http://wiki2.dovecot.org/Plugins/Expire you can find a 
trick for do it:

http://wiki2.dovecot.org/Plugins/Expire

Ciao

-- 
Alessio Cecchi is:
@ ILS -> http://www.linux.it/~alessice/
on LinkedIn -> http://www.linkedin.com/in/alessice
Assistenza Sistemi GNU/Linux -> http://www.cecchi.biz/
@ PLUG -> ex-Presidente, adesso senatore a vita, http://www.prato.linux.it


!DSPAM:509c8c4c33996121420632!