Can't Empty Inbox that is Over quota
I have been trying to update my Postix/Dovecot/MySQL?Postfixadmin installation
I am currently on Dovecot. 2.3.2.1
I used the guide set forth in Purplehat.org http://purplehat.org/ which is what got me in trouble as I am in between with setup. (He went off to Maria-db and NGINX I stayed with Apache and MySQL
What has happened is may Dovecot Mailboxes are super super saturated. adI inadvertently allowed email from an alarm
Quota name Type Value Limit % User quota STORAGE 239754 5120 4682 User quota MESSAGE 882 -
I tried to empty with the command sudo doveadm expunge -A mailbox INBOX ALL
I get this error
Error: auth-master: userdb list: User listing returned failure doveadm: Error: Failed to iterate through some users.
My dovecot configurations is
# 2.3.21 (47349e2482): /usr/local/etc/dovecot/dovecot.conf # Pigeonhole version 0.5.21 (f6cd4b8e) # OS: FreeBSD 13.2-RELEASE-p4 amd64 ufs # Hostname: triggerfish.theoceanwindow.com dict { quota = mysql:/usr/local/etc/dovecot/dovecot-dict-sql.conf.ext } first_valid_gid = 110 first_valid_uid = 110 hostname = triggerfish.theoceanwindow.com last_valid_gid = 110 last_valid_uid = 110 lmtp_rcpt_check_quota = yes mail_location = maildir:/usr/local/virtual/%d/%n mail_plugins = quota managesieve_notify_capability = mailto managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date index ihave duplicate mime foreverypart extracttext imapsieve vnd.dovecot.imapsieve namespace inbox { inbox = yes location = mailbox Drafts { auto = subscribe special_use = \Drafts } mailbox Junk { auto = subscribe special_use = \Junk } mailbox Sent { auto = subscribe special_use = \Sent } mailbox "Sent Messages" { special_use = \Sent } mailbox Trash { auto = subscribe special_use = \Trash } prefix = separator = / type = private } passdb { args = /usr/local/etc/dovecot/dovecot-sql.conf.ext driver = sql } plugin { expire = Trash imapsieve_mailbox1_before = file:/usr/local/virtual/sieve/rspamd/rspamd-learn-spam.sieve imapsieve_mailbox1_causes = COPY imapsieve_mailbox1_name = Junk imapsieve_mailbox2_before = file:/usr/local/virtual/sieve/rspamd/rspamd-learn-ham.sieve imapsieve_mailbox2_causes = COPY imapsieve_mailbox2_from = Junk imapsieve_mailbox2_name = * imapsieve_mailbox3_before = file:/usr/local/virtual/sieve/global/read.sieve imapsieve_mailbox3_causes = COPY imapsieve_mailbox3_name = Trash mail_home = /usr/local/virtual/%d/%n mail_log_events = delete undelete expunge copy mailbox_delete mailbox_rename mail_log_fields = uid box msgid size quota = dict:User quota::proxy::quota quota_exceeded_message = Storage quota for this account has been exceeded, please try again later. quota_grace = 10%% quota_max_mail_size = 100M quota_rule = *:storage=1G quota_rule2 = Trash:storage=+30%% quota_rule3 = Sent:storage=+30%% quota_warning = storage=95%% quota-warning 95 %u quota_warning2 = storage=80%% quota-warning 80 %u quota_warning4 = -storage=100%% quota-warning -100 %u sieve = /usr/local/virtual/%d/%n/.dovecot.sieve sieve_before = /usr/local/virtual/sieve/global/default.sieve sieve_dir = /usr/local/virtual/%d/%n/sieve sieve_global = /usr/local/virtual/sieve/global/ sieve_global_dir = /usr/local/virtual/sieve/global/ sieve_global_extensions = +vnd.dovecot.pipe +vnd.dovecot.environment sieve_pipe_bin_dir = /usr/local/virtual/sieve/rspamd sieve_plugins = sieve_imapsieve sieve_extprograms } pop3_client_workarounds = outlook-no-nuls oe-ns-eoh postmaster_address = admin@theoceanwindow.com protocols = imap pop3 lmtp sieve service auth { unix_listener /var/spool/postfix/private/auth { group = mail mode = 0666 user = postfix } unix_listener auth-userdb { group = mail mode = 0666 user = vmail } } service dict { unix_listener dict { group = vscan mode = 0660 user = vscan } } service lmtp { unix_listener /var/spool/postfix/private/dovecot-lmtp { group = postfix mode = 0660 user = postfix } } service quota-warning { executable = script /usr/local/virtual/bin/quota-warning.sh unix_listener quota-warning { user = vscan } user = dovecot } ssl_ca =
Sorry about the colors. I am at whit ends with the system and dont have the energy to take on apple mail formating
I imagine I have messed up a Mysql query?
Thanks for bearing with me
Begin forwarded message:
From: Jason Hirsh kasdivi@mac.com Subject: Can't Empty Inbox that is Over quota Date: June 3, 2024 at 8:15:53 PM EDT To: dovecot@dovecot.org
I have been trying to update my Postix/Dovecot/MySQL?Postfixadmin installation
I am currently on Dovecot. 2.3.2.1
I used the guide set forth in Purplehat.org http://purplehat.org/ which is what got me in trouble as I am in between with setup. (He went off to Maria-db and NGINX I stayed with Apache and MySQL
What has happened is may Dovecot Mailboxes are super super saturated. adI inadvertently allowed email from an alarm
Quota name Type Value Limit % User quota STORAGE 239754 5120 4682 User quota MESSAGE 882 -
I tried to empty with the command sudo doveadm expunge -A mailbox INBOX ALL
I get this error
Error: auth-master: userdb list: User listing returned failure doveadm: Error: Failed to iterate through some users.
Is there anyway I can remove Dovecot from my server and reinstalll it? It is so messed up I don’t care about losing data
Jasion Hirsh
On 06/06/2024 04:11 EEST Jason Hirsh via dovecot dovecot@dovecot.org wrote:
Begin forwarded message:
From: Jason Hirsh kasdivi@mac.com Subject: Can't Empty Inbox that is Over quota Date: June 3, 2024 at 8:15:53 PM EDT To: dovecot@dovecot.org
I have been trying to update my Postix/Dovecot/MySQL?Postfixadmin installation
I am currently on Dovecot. 2.3.2.1
I used the guide set forth in Purplehat.org http://purplehat.org/ which is what got me in trouble as I am in between with setup. (He went off to Maria-db and NGINX I stayed with Apache and MySQL
What has happened is may Dovecot Mailboxes are super super saturated. adI inadvertently allowed email from an alarm
Quota name Type Value Limit % User quota STORAGE 239754 5120 4682 User quota MESSAGE 882 -
I tried to empty with the command sudo doveadm expunge -A mailbox INBOX ALL
I get this error
Error: auth-master: userdb list: User listing returned failure doveadm: Error: Failed to iterate through some users.
Is there anyway I can remove Dovecot from my server and reinstalll it? It is so messed up I don’t care about losing data
um.. you have multiple issues.
First of all, try
sudo doveadm expunge -u targetuser mailbox INBOX ALL
-A means all users, and it only works if your userdb iteration works.
If you truly do not care about user data and want just get rid of it, you can just rm -rf /path/to/user/home
Aki
participants (2)
-
Aki Tuomi
-
Jason Hirsh