Hi ALL: my SQL: user_query=select concat('*bytes=',trim(TRAILING 'S' FROM quota)) as quota_rule,concat('/home/data/domains/',maildir) as mail ,conca t('/home/data/domains/',homedir) as home,uidnumber as uid,gidnumber as gid from mailbox where username='%u' password_query= select username as user ,password,uidnumber as userdb_uid,gidnumber as userdb_gid,concat('*bytes=',trim(TRAILING 'S' FROM quota)) as userdb_quota_rule from mailbox where username='%u'
And quota : plugin { quota = maildir:User quota }
I got this Error for debug:
Jul 27 10:26:13 mail dovecot: imap-login: Login: user=fy@5dshu.com, method=PLAIN, rip=123.65.246.154, lip=123.65.246.151, mpid=11407, session=<pwBJftDFHQB7Qfaa> Jul 27 10:26:13 mail dovecot: imap: Debug: Loading modules from directory: /usr/lib/dovecot/modules Jul 27 10:26:13 mail dovecot: imap: Debug: Module loaded: /usr/lib/dovecot/modules/lib10_quota_plugin.so Jul 27 10:26:13 mail dovecot: imap: Debug: Added userdb setting: mail=/home/data/domains/5dshu.com/fy/Maildir/ Jul 27 10:26:13 mail dovecot: imap: Debug: Added userdb setting: plugin/quota_rule=*bytes=52428800 Jul 27 10:26:13 mail dovecot: imap(fy@5dshu.com): Debug: Effective uid=1000, gid=1000, home=/home/data/domains/5dshu.com/fy Jul 27 10:26:13 mail dovecot: imap(fy@5dshu.com): Debug: Quota root: name=User quota backend=maildir args= Jul 27 10:26:13 mail dovecot: imap(fy@5dshu.com): Error: user fy@5dshu.com: Initialization failed: Failed to initialize quota: Invalid quota root quota: Invalid rule *bytes=52428800: Invalid rule Jul 27 10:26:13 mail dovecot: imap(fy@5dshu.com): Error: Invalid user settings. Refer to server log for more information
Jul 27 10:25:22 mail dovecot: lda: Debug: Added userdb setting: mail=/home/data/domains/5dshu.com/fy/Maildir/ Jul 27 10:25:22 mail dovecot: lda: Debug: Added userdb setting: plugin/quota_rule=*bytes=52428800 Jul 27 10:25:22 mail dovecot: lda(fy@5dshu.com): Debug: Effective uid=1000, gid=1000, home=/home/data/domains/5dshu.com/fy Jul 27 10:25:22 mail dovecot: lda(fy@5dshu.com): Debug: Quota root: name=User quota backend=maildir args= Jul 27 10:25:22 mail dovecot: lda(fy@5dshu.com): Error: user fy@5dshu.com: Initialization failed: Failed to initialize quota: Invalid quota root quota: Invalid rule *bytes=52428800: Invalid rule Jul 27 10:25:22 mail dovecot: lda(fy@5dshu.com): Fatal: Invalid user settings. Refer to server log for more information. Jul 27 10:25:22 mail postfix/pipe[11384]: B3860322100: to=fy@5dshu.com, relay=dovecot, delay=2.3, delays=2.3/0/0/0.03, dsn=4.3.0, status=deferred (temporary failure)
What is problem by config?? pls give help , To this question I have been working for a few days . Thank you so much!
fy