[Dovecot] Dovecot 1.0 rc15 + Quota by user using mysql
Hi all,
I installed the Dovecot on a Debian by apt-get, it's all working except quota by user..
I have a database with all quotas in bytes, and that lines in /etc/dovecot/dovecot-sql.conf :
driver = mysql connect = host=127.0.0.1 dbname=mailserver user=USER password=PASS default_pass_scheme = CRYPT password_query = SELECT email as user, password FROM view_users WHERE email='%u'; #Quota: user_query = SELECT home AS maildir, 5000 AS uid, 5000 AS gid, CONCAT('dirsize:storage=', ROUND( view_users.quota / 1024) ) AS quota FROM view_users WHERE email='%u';
and in /etc/dovecot/dovecot.conf :
protocol imap { mail_plugins = quota imap_quota }
protocol pop3 { pop3_uidl_format = %08Xu%08Xv mail_plugins = quota }
plugin { #quota = maildir:ignore=Trash }
But when I open the webmail I have no limit quotas!
If I put
quota = maildir:storage=101480
in plugin the quota works fine at 100MB, but in all users...
Is the query right? There is another way to configure quotas by user in Dovecot 1.0 using mysql?
Sorry my bad English, and thank you all!
Hi all, I installed the Dovecot on a Debian by apt-get, it's all working except quota by user.. I have a database with all quotas in bytes, and that lines in /etc/dovecot/dovecot-sql.conf :
driver = mysql connect = host=127.0.0.1 dbname=mailserver user=USER password=PASS default_pass_scheme = CRYPT password_query = SELECT email as user, password FROM view_users WHERE email='%u'; #Quota: user_query = SELECT home AS maildir, 5000 AS uid, 5000 AS gid, CONCAT('dirsize:storage=', ROUND( view_users.quota / 1024) ) AS quota FROM view_users WHERE email='%u';
Try this: ..,concat('maildir:storage=', quota) AS quota ..
PS. Take dovecot from backports. 1.0rc15 is a bit buggy..
Regards
Didn't work...
Download this Version -> 1:1.0.13-1~bpo40+1 ?
can you help me to update my dovecot? I have postfix+amavisd+clamav+spamassassin and dovecot using sieve plugin to redirect spam e-mails to a spam folder... Will I have to update my configuration files?
thank you
On Tue, 27 May 2008 23:32:10 +0200, Tomasz Suchodolski <suchodolski.tomasz@gmail.com> wrote:
Hi all, I installed the Dovecot on a Debian by apt-get, it's all working except quota by user.. I have a database with all quotas in bytes, and that lines in /etc/dovecot/dovecot-sql.conf :
driver = mysql connect = host=127.0.0.1 dbname=mailserver user=USER password=PASS default_pass_scheme = CRYPT password_query = SELECT email as user, password FROM view_users WHERE email='%u'; #Quota: user_query = SELECT home AS maildir, 5000 AS uid, 5000 AS gid, CONCAT('dirsize:storage=', ROUND( view_users.quota / 1024) ) AS quota FROM view_users WHERE email='%u';
Try this: ..,concat('maildir:storage=', quota) AS quota ..
PS. Take dovecot from backports. 1.0rc15 is a bit buggy..
Regards
participants (2)
-
Lucas Carlessi
-
Tomasz Suchodolski