[Case 84537] Dovecot Auto Expunge Trash errors.

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,219
463
Please feel free to open a support ticket using the link in my signature, and reference case CPANEL-138, so we can take a closer look.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,219
463
The beginning of the thread mentions resetting the dict.sqlite database. Can someone detail how to do that. Thanks.
I've seen the issue resolved through the use of the "/scripts/dovecot_auto_expunge_trash" command. The second time running the command shows no error messages after running it the first time to correct the issue.

Thank you.
 

kdean

Well-Known Member
Oct 19, 2012
377
65
78
Orlando, FL
cPanel Access Level
Root Administrator
That's just the same script that runs nightly and while yes it doesn't show anything the second time it doesn't fix or reset the database. I think it doesn't show anything on second run because the first run still does process email even with the dict errors. So, still looking for how to rest the dict.sqlite properly. Thanks.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,219
463
That's just the same script that runs nightly and while yes it doesn't show anything the second time it doesn't fix or reset the database. I think it doesn't show anything on second run because the first run still does process email even with the dict errors. So, still looking for how to rest the dict.sqlite properly. Thanks.
Could you verify if the domain names affected by this issue are listed in the /etc/trueuserdomains file on the system?

Thank you.
 

kdean

Well-Known Member
Oct 19, 2012
377
65
78
Orlando, FL
cPanel Access Level
Root Administrator
Could you verify if the domain names affected by this issue are listed in the /etc/trueuserdomains file on the system?
If you're referring to the "does not exist. Removing stale entries" issue, then no the domain names aren't appearing there. It seems that no add-on domains appear there. They do all appear in /etc/userdomains.

The dict errors seem randomly appear for any trueuserdomain mailbox. I've never noticed a pattern there.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,219
463
You can run the following command if you are simply attempting to regenerate the "/var/cpanel/dovecot/dict.sqlite" file after removing it:

Code:
/usr/local/cpanel/scripts/builddovecotconf
Thank you.
 

kdean

Well-Known Member
Oct 19, 2012
377
65
78
Orlando, FL
cPanel Access Level
Root Administrator
Thanks for the dict.sqlite rebuild instructions.

I take it there's a problem that's being looked into for the add-on domains not appearing in trueuserdomains or maybe expunge needs to use userdomains instead. I'm wondering if in the meantime I should edit /scripts/dovecot_auto_expunge_trash to use loaduserdomains() instead of loadtrueuserdomains() if that's the problem with the "domain does not exist. Removing stale entries" issue.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,219
463
I take it there's a problem that's being looked into for the add-on domains not appearing in trueuserdomains or maybe expunge needs to use userdomains instead.
Yes, case CPANEL-3698 was opened to address an issue where if an email account was created using an addon domain,
it's trash would never expire. The issue is addressed in cPanel version 56:

Fixed case CPANEL-3698: Support trash expiration for addon domains.

Thank you.