dovecot maildir quota user_query select
Hi,
template files opensuse_dovecot-sql.conf.master, fedora_dovecot-sql.conf.master, debian_dovecot-sql.conf.master in the directory ispconfig3_install/install/tpl contain bad CONCAT expression for mailbox (maildir) user quotas.
current bad SQL query:
user_query = SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('maildir:storage=', floor(quota/1024)) AS quota, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE email = '%u' AND disable%Ls = 'n'
proper SQL query:
user_query = SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', floor(quota/1024)) AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE email = '%u' AND disable%Ls = 'n'
My system is CentOS 5.5 with dovecot 1.2.16 and ISPConfig 3.0.3.2. This bug also affects ISPConfig 3.0.3.3rc1
But file debian6_dovecot-sql.conf.master contains this expression:
user_query = SELECT email AS user, maildir AS home, CONCAT('*:storage=', quota , 'B') AS quota_rule FROM mail_user WHERE email = '%u' AND disable%Ls = 'n'