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
doveadm expunge -u user@xyz mailbox Junk savedbefore 30d
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'
Searching for "disabledoveadm" i found this bugtracker entry
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
doveadm expunge -A Junk savedbefore 30d
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
iterate_query = SELECT email AS user FROM mail_user
Or if not, what should be the correct way to delete trashed emails?