similar to: Optimal quota method for SQL

Hi all, I'm setting up a new email server based on the softwares list below: * Postfix * Dovecot 2.0.9 * MySQL * Postfixadmin 2.3.6 My current problem is I'm unsure whether quota feature is well configured or not. In order to test and validate, I use Roundcubemail GUI which provides percentage of the space used by the mailbox (quota should be applied per mailbox). Here, my

Hello all I am trying to get quota working with dict and mysql but i get an error. This is my dovecot.conf file ( relevant part ) i hope ;-) ###################### protocol imap { listen = *:143 imap_client_workarounds = delay-newmail outlook-idle netscape-eoh tb-extra-mailbox-sep imap_max_line_length = 65536 mail_plugins = quota imap_quota } protocol pop3 { listen = *:110

I'm having problems with dovecot quota configuration. If I Include the driver mysql in dovecot-sql.conf I'm getting this error: dovecot: dict: Error in configuration file /etc/dovecot/dovecot-sql.conf line 1: Unknown setting: driver dovecot: dict: Failed to initialize dictionary 'quotadict' If I Don't include it: dovecot: auth(default): Fatal: sql: driver not set in

Dear all, On a new server (postfix dovecot postfixadmin Centos) I did define quota=0 in postfixadmin However suddenly a user with more than 9Gb of mail got his mailbox new/cur empty and maillog shows: Sep 3 15:43:56 mail16 dovecot: lda(brouwerb at scholarium.nl): Error: sieve: msgid=<alpine.LRH.2.20.1509031543050.16381 at streaming2.antenna.nl>: failed to store into mailbox

Hello, imap-quota plugin always returns empty quota: a1 GETQUOTA "" * QUOTA "" () a1 OK Getquota completed. a2 GETQUOTAROOT INBOX * QUOTAROOT "INBOX" a2 OK Getquotaroot completed. quota_rule and quota_rule2 for this user are defined in db as following: '*:storage=5000000' '*:messages=50000' Quota for LDA is working OK. I am using

Hello list, I believe I found a bug with quota. The dovecot quota replies with incorrect values when the mailbox is above 2GB. du -ks returns 2005764bytes dovecot IMAP on the same user/directory: 1 getquotaroot inbox * QUOTAROOT "INBOX" "user" * QUOTA "user" (STORAGE 1096 2000000)* QUOTAROOT "INBOX" "user" * QUOTA "user" (STORAGE 1096

Hello, there are problems with quota dict when multiple dovecot deliver processes are launched in parallel. It can be reproduced by sending a mail with multiple different recipients - the mail is delivered OK to all recipients, but the quota are not updated correctly in sql. I looked at the code and it seems that the problem is somewhere in dict cache. If I configure in Postfix max number of

Dear all, I have postfix delivering to dovecot lda (via spamassinassin). I have configured the quota plugin, but it does not seem to respect the details in the quota table in mysql. The query I have used looks correct to me, and the user can connect to the database. I wonder if someone might put me straight on the misconfiguration. Best wishes, j. # Relevant portions of dovecot -n:

Hi! Please help me with this. The problem exists when quota-warning is executing: LOG: Jan 10 10:15:06 lmtp(85973): Debug: none: root=, index=, control=, inbox=, alt= Jan 10 10:15:06 lmtp(85973): Info: Connect from local Jan 10 10:15:06 lmtp(85973): Debug: Loading modules from directory: /usr/local/lib/dovecot Jan 10 10:15:06 lmtp(85973): Debug: Module loaded:

Hello So what i have: centos 5.6 postfix 2.3.3 dovecot 2.0.13 postfixadmin 2.3.3 roundcube 0.5.3 All general things are working right now i can send receive email with ssl connections etc... Now i'm trying to configure additional options like quota and some other plugins like sieve, trash, expire and deleted-to-trash. Configuration of quota is on first place. I have read wiki regarding quota

Hello, which solution will be working or will be working better (performance). Using dovecot 1.2.6 (plugin section contains quota_rule = *:storage=500M:messages=10000 and i need override this default quota for some users) A) passdb sql(SELECT userid AS user, pw AS password, quota AS userdb_quota_rule FROM users WHERE userid = '%u') + userdb static (uid=500 gid=500 home=/home/mail/%d/%n

Hi, I've configured a global quota rule, with low limits for testing purpose: quota_rule = *:storage=10M:messages=10 Why is the percentage value always 0? What does 'enforcing' mean in this context? Is it not only relevant if one uses fs-quota? Jan 21 17:54:44 vh3 dovecot: IMAP(user at test.tld): Quota root: name=user backend=dict args=:proxy::quotadict Jan 21 17:54:44 vh3 dovecot:

Following this guide: http://sys4.de/en/blog/2013/04/08/postfix-dovecot-mailbox-quota/ I can't seem to get it to work, as soon as I add the smtpd_recipient_restrictions setting to postfix I can no longer send mail at all. I get the message SMTP Error (450): Failed to add recipient "postmaster at example.com" (4.7.1 : Recipient address rejected: Internal error occurred. Refer to

Hello, when dovecot is started, it prints the following error to the console: ILoading modules from directory: /usr/local/dovecot/lib/dovecot/imap IModule loaded: /usr/local/dovecot/lib/dovecot/imap/lib10_quota_plugin.so IEffective uid=65534, gid=65534, home= Idict quota: user = dump-capability, uri = proxy:/var/run/dovecot/dict-server:quotadict Enet_connect_unix(/var/run/dovecot/dict-server)

Hello, i'm using dict quota stored in mysql (/etc/dovecot/dovecot-dict-quota.conf): connect = host=localhost dbname=vmail user=dovecot password= # CREATE TABLE quota ( # username varchar(100) not null, # bytes bigint not null default 0, # messages integer not null default 0, # primary key (username) # ); map { pattern = priv/quota/storage table = quota username_field =

when I enabled quota plugin the following error occured : net_connect_unix(/usr/local/var/run/dovecot/dict-server) failed: Permission denied Any ideas? My config are as follows : .. dict { #quota = mysql:/etc/dovecot-dict-quota.conf quotadict = mysql:/usr/local/etc/dovecot-dict-quota.conf } .. quota = dict:storage=81920:messages=5000 proxy::quotadict /usr/local/etc/dovecot-dict-quota.conf:

Hi Timo, quota dict seems to be broken with 1.2.alpha1 MAP(robert at schetterer.com): read(/var/run/dovecot/dict-server) failed: Remote disconnected dovecot: Sep 24 18:43:16 Error: dict: Error in configuration file /etc/dovecot/dovecot-dict-quota.conf line 1: Unknown setting: driver dovecot: Sep 24 18:43:16 Error: dict: Failed to initialize dictionary 'quotadict'

Hi, I am trying to get quota working properly on dovecot 1.2.3 with postfix admin, amavisd-new, mysql, and postfix. So far I can see the db getting updated when messages are added and deleted from the mailbox. The problem I am having is that I have imported a bunch of messages from the old mail server that was running uw-imap and mbox to the doevcot machine using maildir++. As a result the

Hi Timo, I'm playing with Dovecot v1.2.beta2 currently. When the dict process was started via deliver(?) and Dovecot is killed (kill $PID_OF_DOVECOT) after delivering only one message, it logs: Fatal: io_loop_handle_add: epoll_ctl(1, 10): Bad file descriptor If the dict process was not started or deliver has delivered more than one message, the error doesn't occur. I'm not using

Hi I just configure dovecot with the second dictionary for the domain quota dict { quotadict = mysql:/usr/local/etc/dovecot-quota.conf quota_domain = mysql:/usr/local/etc/dovecot-quota-domain.conf } plugin { quota = dict:user::proxy::quotadict quota2 = dict:domain:%d:proxy::quota_domain } and the dovecot-quota-domain.conf looks like this : connect = host=xxx dbname=xxx