Timo Sirainen schrieb:
On Sat, 2008-07-12 at 16:38 +0200, Robert Schetterer wrote:
Timo Sirainen schrieb:
On Sat, 2008-07-12 at 16:12 +0200, Robert Schetterer wrote:
I think existing quotas in sql could be used
if dovecot would ignore that no
maildir storage is used and simply
interpretes existing maildirsize files, which maybe created out of
existing sql quota entries
( but thats speculate )
You can of course create a script for yourself that does that, but I
don't think Dovecot should bother trying to do it.
Hi Timo, it maybe possible with
Post-login scripting
like
QUOTA=`/usr/bin/mysql -N -B -D${DBDBSE} -h ${DBHOST} -u${DBUSER}
-p${DBPASS} -e "SELECT ${DBQOTA} FROM ${DBTABL} where username='$USER'"
2>/dev/null`
but i am lost how to answer this in imap to the client
You're using userdb sql, right? Why don't you just have it return the
quota using user_query? See the examples in
http://wiki.dovecot.org/Quota/1.1
seems not to work with dbox
quota maildir: No maildir storages, ignoring quota
You'll have to use dict quota. That's independent of how the limits as
configured.
sorry i read dict stuff
and i dont understand it
i have no idea to make this work out of the wiki
it says
----
For example:
plugin {
# v1.0: 10MB and 1000 messages quota limit
quota = dict:storage=10240:messages=1000
mysql:/etc/dovecot-dict-quota.conf
# v1.1:
quota = dict:::mysql:/etc/dovecot-dict-quota.conf
quota_rule = *:storage=10M:messages=1000
}
However, the above example won't really work. This is because it would
require linking all the binaries with MySQL library
i understand this
-----
, which I didn't really want to do. Currently you'll have to do this via
the dictionary proxy (see below). Actually the performance is better
that way anyway, and I don't really see a reason not to use it.
Example dovecot-dict-quota.conf:
connect = host=localhost dbname=mails user=sqluser password=sqlpass
table = quota
select_field = current
where_field = path
username_field = username
---
ok i allready have my quota tables
from postfix admin
and i am unclear about the query i need
as well how to set this in plugin quota section
in dovecot.conf
i have this quota userdb sql working with maildir
user_query = SELECT concat('/usr/local/virtual/', maildir) AS home, \
concat('*:storage=', ROUND( mailbox.quota / 1024 ) ) AS quota_rule, \
#when saving to Trash mailbox the user gets additional 50MB
"Trash:storage=50240" AS quota_rule2, \
#when saving to Sent mailbox the user gets additional 50MB
"Sent:storage=50240" AS quota_rule3, \
#when saving to Drafts mailbox the user gets additional 50MB
"Drafts:storage=50240" AS quota_rule4, \
#when saving to Templates mailbox the user gets additional 50MB
"Templates:storage=50240" AS quota_rule5, \
#when saving to Junk mailbox the user gets additional 50MB
"Junk:storage=50240" AS quota_rule6, \
#ignore quota on shared
"shared:ignore" AS quota_rule7, \
concat('dbox:/usr/local/virtual/', maildir) AS mail, \
1001 AS uid, 1001 AS gid FROM mailbox WHERE username = '%u' AND active
= '1'
sorry about asking like newbie here , but i simply dont understand this
dict stuff setup
--
Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
