==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.2
- Deployed with iRedMail Easy or the downloadable installer? Downloadable installer
- Linux/BSD distribution name and version: Centos 7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): LDAP
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hello Zhang!
We have a problem with the iRedMail installation. Don't know which setting caused this (it started with users created after 1.11.2019), but this is what I figured out:

We use local MySQL, not remote. Is it related to this problem - old but similar? https://forum.iredmail.org/topic12223-i … ailed.html

The quota is not updating for new users. There is no new row in MySQL table iredadmin.used_quota. The error in the log:

quota-status(info@domain.si): Error: dict-client: server returned failure: 1587119900 (reply took 0.001 secs)

If I manually update the quota with command:

doveadm quota recalc -u info@domain.si

I get the following error in dovecot.log

dict(11504): Error: sql dict: commit failed: The user specified as a definer ('root'@'%') does not exist

dovecot-used-quota.conf has the right user and db settings.

connect = host=127.0.0.1 port=3306 dbname=iredadmin user=iredadmin password=***

The problem is "solved" if I do the following:

Change MySQL user settings -> from root@localhost to root@%

So this means that dovecot wants to connect with root user to "%" wildcard? So is there some settings that overrides the connection user in dovecot-used-quota.conf?

Thank you very much for your help!
Tom