Displaying 7 results from an estimated 7 matches for "quota_messag".
Did you mean:
quota_message
2012 Oct 19
4
still having difficulties with per-user quotas
Hello,
I am trying to get per-user quotas working. My thanks to all who have
helped so far.
To recap I am running Dovecot 2.1 and Mysql where I've got my virtual
users. All virtual users are under the system user vmail with a UID
and GID of 5000. Looking over the wiki docs I've added a quota table
and got the dict service working, I am not having problems with
permissions or the login
2010 Jul 22
1
problem mysql and dovecot 1.2
...ce 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 the quota manag...
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
2017 Apr 29
0
configuration sanity check
...=/tmp/mysql.sock dbname=dbname user=user password=password
default_pass_scheme = SHA512
password_query = SELECT user as user, password, \
CASE quota \
WHEN 0 \
THEN '*:bytes=256M:messages=0' \
ELSE \
CONCAT('*:bytes=', CAST(quota AS CHAR), 'M:messages=',
CAST(quota_messages AS CHAR)) \
END AS `userdb_quota_rule` \
FROM virtual_users WHERE user='%u';
user_query = SELECT user as user, \
CASE quota \
WHEN 0 \
THEN '*:bytes=1024M:messages=0' \
ELSE \
CONCAT('*:bytes=', CAST(quota AS CHAR), 'M:messages=',
CAST(quota_messa...
2013 May 12
2
Quota not working with dict proxy
...ot 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 {
pattern = shared/expire/$user/$mailbox
table = email
value_field = expire_stamp
fields {
address = $us...
2013 May 19
3
Error: dict client sent broken reply
...ult 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)
# );
map {
pattern = shared/expire/$user/$mailbox
table = expires
value_field = expire_stamp
fields {
address = $...
2015 Sep 06
0
doveadm quota recalc problem for domain
...n.conf |grep -v "#"
connect = host=XXXXX dbname=mail user=test password=test
map {
pattern = priv/quota/storage
table = domains
username_field = domain
value_field = quota
}
map {
pattern = priv/quota/messages
table = domains
username_field = domain
value_field = quota_messages
}
map {
pattern = shared/expire/$user/$mailbox
table = expires
value_field = expire_stamp
fields {
username = $user
mailbox = $mailbox
}
}
###################
root at postfix:/etc/dovecot# cat dovecot-dict-sql-user.conf |grep -v "#"
connect = host=XXXXXXXX...