search for: quota_byt

Displaying 20 results from an estimated 23 matches for "quota_byt".

Did you mean: quota_bytes
2017 Jan 19
5
Segfault on LIST Command
...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...
2017 Jan 23
2
Segfault on LIST Command
...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 >>>>>...
2013 Nov 12
1
how to make quota per user ??
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='...
2017 Jan 19
0
Segfault on LIST Command
...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...
2017 Jan 23
2
Segfault on LIST Command
...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...
2011 Oct 19
1
'doveadm quota get' dictionary SQL query ignores specified '@domain' part of username. bad config or bug?
...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 | +----+------------------------+------------+--------...
2017 Jan 23
0
Segfault on LIST Command
...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...
2010 Jul 19
1
Unknown column username in where clause
...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 ========...
2011 Oct 24
0
[bug] Changing dovecot 'quota' Value incorrectly overwrites Limit with same value
...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 ?...
2017 Jan 23
0
Segfault on LIST Command
...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 &...
2017 Jan 23
0
Segfault on LIST Command
...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 >>>>>>>...
2011 Oct 28
0
Are you successfully using using SQL queries to manage Dovecot2 Quota Values & Limits?
...? ? ? ? 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 ?...
2013 Dec 08
1
Expire plugin - empty expires table
...= 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...
2007 Jun 12
1
vpopmail quota
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
2014 Feb 19
1
Dovecot, mysql, and quota
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)
2008 Nov 15
1
For Configuration Help: per-user quota for virtual users.
...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'
2010 Jul 22
1
problem mysql and dovecot 1.2
...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...
2012 Oct 11
3
per-user quotas
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
2013 May 12
2
Quota not working with dict proxy
...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 {...
2013 May 19
3
Error: dict client sent broken reply
...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...