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 argsJul 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 argsJul 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