search for: quota_byt

...private } passdb { args = nopassword=y driver = static } plugin { last_login_dict = file:~/lastlogin mail_log_events = delete undelete expunge copy mailbox_delete mailbox_rename mail_log_fields = uid box msgid size quota = maildir:User quota quota_warning = storage=80%% 80 %u %{userdb:quota_bytes} quota_warning2 = storage=90%% 90 %u %{userdb:quota_bytes} quota_warning3 = storage=95%% 95 %u %{userdb:quota_bytes} sieve = ldap:/etc/dovecot/pigeonhole-ldap.conf sieve_dir = ~/sieve sieve_plugins = sieve_storage_ldap zlib_save = gz zlib_save_level = 6 } service imap { executable...

...n >>>>> mail_log_events = delete undelete expunge copy mailbox_delete >>>>> mailbox_rename >>>>> mail_log_fields = uid box msgid size >>>>> quota = maildir:User quota >>>>> quota_warning = storage=80%% 80 %u %{userdb:quota_bytes} >>>>> quota_warning2 = storage=90%% 90 %u %{userdb:quota_bytes} >>>>> quota_warning3 = storage=95%% 95 %u %{userdb:quota_bytes} >>>>> sieve = ldap:/etc/dovecot/pigeonhole-ldap.conf >>>>> sieve_dir = ~/sieve >>>>>...

I use dovecot version 1.2.15 and i put quota for all users , now i want to give more size for some emails , i already added the quota to user database , and i added the queries from http://wiki.dovecot.org/Quota/1.1 MySQL: user_query = select uid, gid, home, \ concat('*:bytes=', quota_bytes) as quota_rule \ from users where userid = '%u' # MySQL with userdb prefetch: Remember to prefix quota_rule with userdb_ # (just like all other userdb extra fields): password_query = select userid as user, password, \ uid as userdb_uid, gid as userdb_gid, \ concat('*:bytes='...

...driver = static > } > plugin { > last_login_dict = file:~/lastlogin > mail_log_events = delete undelete expunge copy mailbox_delete > mailbox_rename > mail_log_fields = uid box msgid size > quota = maildir:User quota > quota_warning = storage=80%% 80 %u %{userdb:quota_bytes} > quota_warning2 = storage=90%% 90 %u %{userdb:quota_bytes} > quota_warning3 = storage=95%% 95 %u %{userdb:quota_bytes} > sieve = ldap:/etc/dovecot/pigeonhole-ldap.conf > sieve_dir = ~/sieve > sieve_plugins = sieve_storage_ldap > zlib_save = gz > zlib_save_leve...

...g_events = delete undelete expunge copy mailbox_delete >>>>>>> mailbox_rename >>>>>>> mail_log_fields = uid box msgid size >>>>>>> quota = maildir:User quota >>>>>>> quota_warning = storage=80%% 80 %u %{userdb:quota_bytes} >>>>>>> quota_warning2 = storage=90%% 90 %u %{userdb:quota_bytes} >>>>>>> quota_warning3 = storage=95%% 95 %u %{userdb:quota_bytes} >>>>>>> sieve = ldap:/etc/dovecot/pigeonhole-ldap.conf >>>>>>> sieve_dir...

...ovecot2. I've created a MAILBOX parameter table, 'PARAMS', that contains unique <user>@<domain> pairs, with quota data. mysql> select * from PARAMS; +----+------------------------+------------+-------------+------------+ | ai | MAILBOX_user_domain | quota | quota_bytes | quota_msgs | +----+------------------------+------------+-------------+------------+ | 1 | myuser at domain1.com | 1073741824 | 0 | 0 | | 2 | myuser at domain2.com | 1000000000 | 0 | 0 | +----+------------------------+------------+--------...

...file:~/lastlogin >> >> mail_log_events = delete undelete expunge copy mailbox_delete >> >> mailbox_rename >> >> mail_log_fields = uid box msgid size >> >> quota = maildir:User quota >> >> quota_warning = storage=80%% 80 %u %{userdb:quota_bytes} >> >> quota_warning2 = storage=90%% 90 %u %{userdb:quota_bytes} >> >> quota_warning3 = storage=95%% 95 %u %{userdb:quota_bytes} >> >> sieve = ldap:/etc/dovecot/pigeonhole-ldap.conf >> >> sieve_dir = ~/sieve >> >> sieve_plugins...

...d "username" should come from because I don't use this field (or query). The relevant files are: dovecot-sql.conf.ext ==================== password_query = SELECT userid AS user, password, \ home AS userdb_home, uid AS userdb_uid, gid AS userdb_gid, \ concat('*:bytes=', quota_bytes) as userdb_quota_rule \ FROM users WHERE userid = '%u' auth-sql.conf.ext ================= passdb { driver = sql args = /etc/dovecot/dovecot-sql.conf.ext } userdb { driver = prefetch } userdb { driver = sql args = /etc/dovecot/dovecot-sql.conf.ext } 90-quota.conf ========...

...FROM `PARAMS`; > + ? ? ? ? ? ? ? iterate_query = SELECT `MAILBOX_user_domain` AS username FROM `PARAMS`; > > and adding to my user_query, > > ? ? ? ?CREATE PROCEDURE `UserDBQuery`( > ? ? ? ? ? ? ? ?... > ? ? ? ? ? ? ? ?SELECT ... > ? ? ? ? ? ? ? ? ?concat('*:bytes=', quota_bytes, ':messages=10000') AS quota_rule, > ? ? ? ? ? ? ? ? ?... > > Now, at init, > > ? ? ? ?doveadm quota get -A > ? ? ? ? ? ? ? ?Username ? ? ? ? ? ? ? ?Quota name ? ? ?Type ? ? ? ? ? ?Value ? Limit ? % > ? ? ? ? ? ? ? ?myuser at domain1.com ? ? ?User quota ? ? ?STORAGE ?...

...t; mail_log_events = delete undelete expunge copy mailbox_delete > >>>>> mailbox_rename > >>>>> mail_log_fields = uid box msgid size > >>>>> quota = maildir:User quota > >>>>> quota_warning = storage=80%% 80 %u %{userdb:quota_bytes} > >>>>> quota_warning2 = storage=90%% 90 %u %{userdb:quota_bytes} > >>>>> quota_warning3 = storage=95%% 95 %u %{userdb:quota_bytes} > >>>>> sieve = ldap:/etc/dovecot/pigeonhole-ldap.conf > >>>>> sieve_dir = ~/sieve &...

...e undelete expunge copy mailbox_delete >>>>>>>> mailbox_rename >>>>>>>> mail_log_fields = uid box msgid size >>>>>>>> quota = maildir:User quota >>>>>>>> quota_warning = storage=80%% 80 %u %{userdb:quota_bytes} >>>>>>>> quota_warning2 = storage=90%% 90 %u %{userdb:quota_bytes} >>>>>>>> quota_warning3 = storage=95%% 95 %u %{userdb:quota_bytes} >>>>>>>> sieve = ldap:/etc/dovecot/pigeonhole-ldap.conf >>>>>>>...

...? ? ? ? iterate_query = SELECT `MAILBOX_user_domain` AS username FROM `PARAMS`; >> >> and adding to my user_query, >> >> ? ? ? ?CREATE PROCEDURE `UserDBQuery`( >> ? ? ? ? ? ? ? ?... >> ? ? ? ? ? ? ? ?SELECT ... >> ? ? ? ? ? ? ? ? ?concat('*:bytes=', quota_bytes, ':messages=10000') AS quota_rule, >> ? ? ? ? ? ? ? ? ?... >> >> Now, at init, >> >> ? ? ? ?doveadm quota get -A >> ? ? ? ? ? ? ? ?Username ? ? ? ? ? ? ? ?Quota name ? ? ?Type ? ? ? ? ? ?Value ? Limit ? % >> ? ? ? ? ? ? ? ?myuser at domain1.com ?...

...= host=127.0.0.1 dbname=mailserver user=mailuser password=************************* default_pass_scheme = PLAIN-MD5 iterate_query = SELECT email AS user FROM virtual_users password_query = SELECT email AS user, password, \ uid AS userdb_uid, gid AS userdb_gid, \ concat('*:bytes=', quota_bytes) AS userdb_quota_rule \ FROM virtual_users WHERE email = '%u' user_query = SELECT uid, gid, \ CONCAT('/data/vmail/storage/',CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBST RING_INDEX(email,'@',1))) AS home, \ CONCAT('*:bytes=', quota_bytes...

Hi, I'd like the vpopmail user database to return the quota settings for users, instead of having to rely on the validity of the maildirsize files. It doesn't look like this is currently possible. Would simply adding a auth_stream_reply_add call for "quota" with a suitable value in vpopmail_lookup be sufficient to make this work? (the quota can be read from the pw_shell

Hello, I'm running dovecot 2.2 and wanting to get quotas going. I've got the plugins loaded appropriately and am wanting to configure a dictionary backend to talk to my mysql database. I've got a single database called mail which has all the mail-related items in it. One table is for virtual users which postfix uses. It looks like this: CREATE TABLE `virtual_users` ( `id` int(11)

...ct = host=127.0.0.1 dbname=****** user=****** password=******** default_pass_scheme = PLAIN-MD5 password_query = SELECT email as user, password FROM view_users WHERE email='%u'; user_query = select 5000 as uid, 5000 as gid, '/home/vmail/%d/%n' as home, \ concat('*:bytes=', quota_bytes) as quota_rule \ from email_quota where email = '%u'

...iver: mysql, pgsql, sqlite driver = mysql connect = host=127.0.0.1 dbname=mailserver user=mailsuer password=***** default_pass_scheme = PLAIN-MD5 password_query = SELECT email,password FROM virtual_users WHERE email='%u'; #user_query = SELECT home, uid, gid, concat('*:storage=', quota_bytes, 'B') AS quota_rule FROM virtual_users WHERE userid = '%u' #user_query = SELECT maildir, 5000 AS uid, 5000 AS gid, CONCAT('*:storage=', quota_bytes, 'B') AS quota_rule FROM virtual_users WHERE userid = '%u' #user_query = SELECT maildir AS home , 5000 AS uid...

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

...ildb user=dbuser password=dbpass # 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 = email username_field = address value_field = quota_bytes } map { pattern = priv/quota/messages table = email username_field = address value_field = quota_messages } # CREATE TABLE expires ( # username varchar(100) not null, # mailbox varchar(255) not null, # expire_stamp integer not null, # primary key (username, mailbox) # ); map {...

...ser=dbuser password=dbpass # 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_usage username_field = address value_field = quota_bytes } map { pattern = priv/quota/messages table = quota_usage username_field = address value_field = quota_messages } # CREATE TABLE expires ( # username varchar(100) not null, # mailbox varchar(255) not null, # expire_stamp integer not null, # primary key (username, mailbox) # ); m...