Old 30th January 2013, 11: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

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
i found
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
doveadm expunge -A Junk savedbefore 30d
i got
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?

Thank you
Reply With Quote
Sponsored Links


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Error Nolan Installation/Configuration 13 27th November 2014 06:04
ISPConfig 3 Single server issues on POP3/IMAP/ MyDNS vk1003 Installation/Configuration 7 17th July 2012 16:25
ISPConfig3 won't start after update Cracklefish Installation/Configuration 15 28th February 2012 15:11
Connection timed out on intermail outgoing mails gouravgarg Server Operation 6 5th March 2010 21:31
Postfix can't received email from exterior astra2000 Server Operation 5 18th October 2009 00:26

All times are GMT +2. The time now is 15:47.

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