[Case 84537] Dovecot Auto Expunge Trash errors.

[cPanelMichael]

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.

 

[kdean]

The beginning of the thread mentions resetting the dict.sqlite database. Can someone detail how to do that. Thanks.

 

[cPanelMichael]

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]

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]

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]

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]

You can run the following command if you are simply attempting to regenerate the "/var/cpanel/dovecot/dict.sqlite" file after removing it:

/usr/local/cpanel/scripts/builddovecotconf

Thank you.

 

[kdean]

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]

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.