#1  
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

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
Reply

Bookmarks

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
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
MySQL Error Nolan Installation/Configuration 12 16th February 2011 03:15
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 10:22.


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