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
Recent comments
1 day 17 hours ago
2 days 2 hours ago
2 days 5 hours ago
2 days 6 hours ago
2 days 7 hours ago
2 days 9 hours ago
2 days 10 hours ago
2 days 12 hours ago
3 days 4 hours ago
3 days 4 hours ago