View Single Post
  #1  
Old 30th January 2013, 10:02
heri heri is offline
Junior Member
 
Join Date: May 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Dovecot expunge on Ubuntu 12.04

Helo,
i set up a system following
The Perfect Server - Ubuntu 12.04 LTS (Apache2, BIND, Dovecot, ISPConfig 3)

Not to leave trashed mails i tried to remove them in a script with dovecot expunge.

This failed with the following errors:

1. For a single user
Code:
doveadm expunge -u user@xyz mailbox Junk savedbefore 30d
i found
Quote:
Jan 30 08:37:08 ipc3 dovecot: auth-worker: Error: mysql: Query failed, retrying: Unknown column 'disabledoveadm' in 'where clause'
Jan 30 08:37:08 ipc3 dovecot: auth-worker: Error: sql(user@xyz): User query failed: Unknown column 'disabledoveadm' in 'where clause'
in /var/log/mail.err

Searching for "disabledoveadm" i found this bugtracker entry
http://bugtracker.ispconfig.org/inde...s&task_id=2346 proposing to add "disabledoveadm" column to the mail_user table.

Adding this field the command worked for a single user.
Can it become a problem to add this field?


2. For all users
Code:
doveadm expunge -A Junk savedbefore 30d
i got
Quote:
Jan 30 08:55:48 ipc3 dovecot: auth-worker: Error: mysql: Query failed, retrying: Table 'dbispconfig.users' doesn't exist
Jan 30 08:55:48 ipc3 dovecot: auth-worker: Error: sql: Iterate query failed: Table 'dbispconfig.users' doesn't exist (using built-in default iterate_query: SELECT username, domain FROM users)
Is a possible solution to add a query to
Quote:
/etc/dovecot/dovecot-sql.conf
like
Code:
iterate_query = SELECT email AS user FROM mail_user
Or if not, what should be the correct way to delete trashed emails?

Thank you
Helmut
Reply With Quote
Sponsored Links