[Dovecot] about dovecot quota ,i will crazy!

fy fy at 5dshu.com
Fri Jul 27 17:31:37 EEST 2012


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 at 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 at 5dshu.com): Debug: Effective uid=1000, gid=1000, home=/home/data/domains/5dshu.com/fy
Jul 27 10:26:13 mail dovecot: imap(fy at 5dshu.com): Debug: Quota root: name=User quota backend=maildir args=
Jul 27 10:26:13 mail dovecot: imap(fy at 5dshu.com): Error: user fy at 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 at 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 at 5dshu.com): Debug: Effective uid=1000, gid=1000, home=/home/data/domains/5dshu.com/fy
Jul 27 10:25:22 mail dovecot: lda(fy at 5dshu.com): Debug: Quota root: name=User quota backend=maildir args=
Jul 27 10:25:22 mail dovecot: lda(fy at 5dshu.com): Error: user fy at 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 at 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 at 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


More information about the dovecot mailing list