search for: quota_kb

...: Fatal: sql: driver not set in configuration file /etc/dovecot/dovecot-sql.conf dovecot: auth(default): Fatal: sql: driver not set in configuration file /etc/dovecot/dovecot-sql.conf Now What??? How Should I configure quota ? My SQL has a mail db with a user table. The table has email, password, quota_kb fields. my dovecot.conf: ---------------- protocols = imap imaps pop3 pop3s log_timestamp = "%Y-%m-%d %H:%M:%S " mail_location = maildir:/home/vmail/%d/%n/Maildir disable_plaintext_auth = no ssl_cert_file = /etc/ssl/certs/dovecot.pem ssl_key_file = /etc/ssl/private/dovecot.pem namespace...

...nfiguration the default mailbox quota is set to "*:storage=100M". When I create a mailbox with 250M specified in the database, dovecot is applying the default quota rather than that specified in the database. So in the database I have a test user with the following entry password,email,quota_kb [hash], test at example.org, 25000 If I turn debugging on for mail and auth I see the following logged when the user logs in (logs pasted at the end in a bid to maintain some readability) If I check the quota with doveadm I get the limit back of 102400 which is the default mailbox size rather tha...

...process and now i want to add quotasettings for each individual user. at the moment i have the problem that only global quota is effective and no userquota which is stored in usertable. This is my mysql-usertable: login varchar(255) password varchar(64) home varchar(128) uid int(11) gid int(11) quota_kb varchar(10) active char(1) In my main-dovecot.conf i have quota/imap_quota activated for pop/imap and protocol lda This is the auth-section which contains passdb/userdb auth default { mechanisms = plain login passdb sql { args = /etc/dovecot-sql.conf } userdb sql { args = /...

...entication table, to include per user quota's. Only then will the query I specified really work. In your present database, add the quota field and insert a KB value. This value will then be used when the authentication query is executed. In the example SQL query I posted, I used a tabled called quota_kb. One way to test the whole setup is to enable all the debug and verbose option in your config file, and then check the logs to see what its doing. Maybe including your sql.conf file will help solve your problem. From what I see your quota config is correct, you just need to add the quota field in...

...ody , Since my version 1.2. I have a problem with the management of quotas. select * from virtual_users; +----+-----------+----------------------------------+---------------------------+----------+----------------+ | id | domain_id | password | email | quota_kb | quota_messages | +----+-----------+----------------------------------+---------------------------+----------+----------------+ | 1 | 1 | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | xxxxxx at domain.com | 10000000 | 0 | .................. Before my time in 1.2. I did this for...

...ot: auth(default): client in: CONT<hidden> Oct 26 14:00:31 host dovecot: auth(default): cache(me): expired Oct 26 14:00:31 host dovecot: auth-worker(default): sql(me): query: SELECT user, clear as password, home as userdb_home, uid as userdb_uid, gid as userdb_gid, concat('*:storage=',quota_kb,' :messages=',quota_num) AS userdb_quota_rule,concat('storage=',round(quota_kb*0.90),' /etc/postfix/quotawarn.sh storage 90') AS userdb_quota_warning, concat('messages=',round(quota_num*0.90) ,' /etc/postfix/quotawarn.sh messages 90') AS userdb_quota_warning2...

...s My default configurations quota configurations: plugin: quota: maildir:User quota quota_rule: *:storage=2G Customized Use Configurations at the Mysql level: user_query = SELECT 5000 AS uid,5000 AS gid,'/vmail/%d/%n' as home, \ concat('*:storage= ', virtual_users.quota_kb) AS quota_rule \ from virtual_users LEFT JOIN virtual_domains ON virtual_users.domain_id=virtual_domains.id \ where virtual_users.user='%n' and virtual_domains.name='%d' When I change quota at the SQL level (per user), that quota becomes active o...

...ains.id \ where virtual_users.user='%Ln' and virtual_domains.name='%Ld' and virtual_users.status = 1 and virtual_domains.status = 1; user_query = SELECT 5000 AS uid,5000 AS gid,'/vmail/%Ld/%Ln' as home, \ concat('*:storage= ', virtual_users.quota_kb) AS quota_rule \ from virtual_users LEFT JOIN virtual_domains ON virtual_users.domain_id=virtual_domains.id \ where virtual_users.user='%Ln' and virtual_domains.name='%Ld' Is this the correct way of assuring lowercase use all over the place?...

...e=95%% /usr/local/bin/quota-warning.sh 95 quota_warning2 = storage=80%% /usr/local/bin/quota-warning.sh 80 } ============ dovecot-sql.conf ============ driver = mysql connect = host=localhost dbname=mail user=mail password=mail user_query = SELECT 1 AS gid, concat('maildir:storage= ', quota_kb) AS quota FROM users WHERE user = 'testuser'; I test my configuration and don't show errors , however, dovecot never show me my quota configuration. I will be omitting something ? Cheers. -- -------------------------------------------------------- LCC Wilberth de Jes?s P?rez...

I can't seem to find the magic combination to get dovecot to ignore the trash folder when counting quota. I've got 1.0rc15 and using maildir quotas. Not being able to trash messages when over quota is quite annoying. the docs suggest the following: plugin { quota = maildir:storage=10240:ignore=Trash } but as my quotas are defined per user via mysql DB, I'm thinking that I need a

Hello, I've got quotas set up on an all-user basis on my system, it's a Postfix, Dovecot, Mysql virtual users setup. Currently I have each user getting a 1GB quota with these settings in 90-quota.conf: plugin { quota_rule = *:storage=1G quota_rule2 = Trash:storage=+100M } plugin { quota = maildir:User quota } While this works it's not what I want for all users. Say I add a

...ow much space is available, then it crashes again. I've tried adding an extra "quota" field to my mysql userdb to handle quotas, but with the same result. mysql-query looks like this (as described in the wiki): user_query = SELECT home, uid, gid, 'dirsize:storage=' || quota_kb AS quota FROM users WHERE userid = '%u' As with the settings in dovecot.conf, Ive tried various combinations of dict, dirsize and so on, but without any luck. This is what the entries in my crashdump file looks like: Host Name: SD-Server Date/Time: 2006-11-09 00:06:17.151...