HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Dovecot expunge on Ubuntu 12.04 (http://www.howtoforge.com/forums/showthread.php?t=60374)

heri 30th January 2013 10:02

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


All times are GMT +2. The time now is 02:36.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.