search for: userdb_quota

Is there a way to return a per user dirsize quota from a passdb sql lookup? If so, what is the syntax? maybe "select quota as userdb_quota"? ..and in mysql table, quota column would be: "quota=dirsize:storage=10240" ? I'm using mbox, with /etc/passwd userdb, and mysql passdb. Thanks, Ken -- Ken Anderson Pacific.Net

...;t find in the wiki or forum. Some ways I configured dovecot-sql.conf: 1) password_query = SELECT email AS user, CONCAT('maildir:storage=',quota) AS quota, password FROM users WHERE email = '%u' 2) password_query = SELECT email AS user, CONCAT('maildir:storage=',quota) AS userdb_quota, password FROM users WHERE email = '%u' With userdb sql things worked perfect, but as I can use static userdb I just need quota information per user from passwd sql. Thanks, Bruno.

...ota=quota=dirsize:storage,status user_attrs = homeDirectory=home,uidNumber=uid,gidNumber=gid,boxQuota=quote_rule=maildir:storage=%$K,status user_filter = (&(objectClass=posixAccount)(uid=%u)) pass_attrs = uid=user,,,homeDirectory=userdb_home,uidNumber=userdb_uid,gidNumber=userdb_gid,boxQuota=userdb_quota=maildir:storage=%$K,userPassword=password,status=userdb_status pass_filter = (&(objectClass=posixAccount)(uid=%u)) ================= plan is: 1. if there is a quota in ldap (boxQuota) - we use it 2. if not - quota_rule = maildir:storage=500000K but in real world i have : in my box maildirsi...

...ery = SELECT mail as user, cryptp as password, > CONCAT('/home/vmail/',homedir,'/',maildir,'/') as userdb_home, uid as userdb_uid, gid as > userdb_gid, CONCAT('dirsize:/home/vmail/',homedir,'/',maildir,'/',':storage=',quota/1024) as > userdb_quota, nice as userdb_nice, hosts as allow_nets FROM users WHERE mail = '%u' and access = > 'Y' and %Ls = 'Y'; > > > When I insert allow_nets (and it should be used without userdb_ prefix) into password_query I could > not send any more letters. In logs next: > &...

...tter configuration setting. Here is a sample passdb entry which causes the quota assertion to fail: test at example.com:<snip>:3007:1000::/usr/boxes/username/example.com::userdb_mail=mbox:~/test^/.imap:INBOX=~/test userdb_uid=3007 userdb_gid=1000 userdb_home=/usr/boxes/username/example.com userdb_quota=dirsize:storage=100 The imap folder is "~/test^/.imap" and the INBOX is "~/test". As you can see, these are in different locations, but the INBOX string happens to be a substring of the imap folder directory. An example of the failed assertion error: Aug 31 16:44:13 www2 dove...

...ebug: sql(maurizio at caloro.ch,151.248.162.33): query: SELECT username AS user, password_enc AS password, CONCAT(homedir, maildir) AS userdb_home, uid AS userdb_uid, gid AS userdb_gid, CONCAT('maildir:', homedir, maildir) AS userdb_mail, CONCAT('maildir:storage=', (quota*1024)) as userdb_quota FROM mail_users WHERE (username = 'maurizio at caloro.ch' OR email = 'maurizio at caloro.ch') AND ((imap = 1 AND 'pop3' = 'imap') OR (pop3 = 1 AND 'pop3' = 'pop3') OR 'pop3' = 'smtp' OR 'pop3' = 'sieve') Feb 8 12:0...

Hello, I'm running dovecot 2.29 on a freebsd 10.3 system. I'm trying to cut down queries to my database and tried to do a userdb static and prefetch. I modified the password query to pull in userdb_quota and got an error that that was not valid. Is this behavior normal? Apr 13 17:22:15 hostname dovecot: master: Dovecot v2.2.29 (13ebc01) starting up for imap, sieve Apr 13 17:22:24 hostname dovecot: imap-login: Login: user=<username at example.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1,...

Hi, I am using dovecot 1.0.10 and using passwd-file as userdb. I have enabled quota plugin in /etc/dovecot.conf. Extra fields are added into userdb. user1:X:500:500:User1:/home/user1:/bin/bash:userdb_quota=maildir:storage=1024 Location of the inbox is /var/spool/mail/user1 I dont think this is working. The user already have 5MB in INBOX and if I send a new mail, it is being delivered. Do I need to change any settings? Thanks, Ranjith

I'm using dovecot 1.0 rc28 - great software! I have a virtual hosting setup, with passdb and userdb both using a passwd file. I cannot get per-user quotas put in the relevant field of the userdb to work. They appear to be completely ignored; only the setting from /etc/dovecot.conf is applied. Can anyone confirm that this is working for them? If it is, can you post the relevant bits of

...onf password_query = SELECT mail as user, cryptp as password, CONCAT('/home/vmail/',homedir,'/',maildir,'/') as userdb_home, uid as userdb_uid, gid as userdb_gid, CONCAT('dirsize:/home/vmail/',homedir,'/',maildir,'/',':storage=',quota/1024) as userdb_quota, nice as userdb_nice, hosts as allow_nets FROM users WHERE mail = '%u' and access = 'Y' and %Ls = 'Y'; When I insert allow_nets (and it should be used without userdb_ prefix) into password_query I could not send any more letters. In logs next: Dec 19 11:25:30 post dovecot...

...patched in working but having trouble figuring this out. any help would be appreciated. prior to the quota-rewrite patch (which i installed with the hopes of using quota_warn feature) i was able to put the following line into my passwd-file userdb and it was working: alan:*:1000:1000::/home/alan::userdb_quota=maildir:storeage=2048000:ignore=Sent (which is what I wanted) but now with the new quota definition style, I'm not sure what I need to define the extra fields as. here is dovecot -n: # 1.0.14: /usr/local/etc/dovecot.conf log_path: /var/log/dovecot.log protocols: imap imaps managesieve ssl_ce...

...il || '@' || domain = '%u' password_query = SELECT mail || '@' || domain as user, password as password, '/mail/' || domain || '/' || mail || '/maildir' as userdb_home, uid as userdb_uid, gid as userdb_gid, 'maildir:storage=' || (quota/1024) as userdb_quota, nice as userdb_nice, hosts as allow_nets FROM users WHERE mail = '%n' and domain = '%d' and access = 'Y' and %Ls = 'Y';

Some ages ago there existed a compressed mbox patch, but now all I can find are posting about it. Does such a beast exist and would it remotely apply to today's dovecot? If not, is there any hope that something like that emerges? Thanks! -- Axel.Thimm at ATrpms.net -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type:

...loro.ch,151.248.162.33): query: SELECT username AS > user, password_enc AS password, CONCAT(homedir, maildir) AS > userdb_home, uid AS userdb_uid, gid AS userdb_gid, CONCAT('maildir:', > homedir, maildir) AS userdb_mail, CONCAT('maildir:storage=', > (quota*1024)) as userdb_quota FROM mail_users WHERE (username = > 'maurizio at caloro.ch' OR email = > 'maurizio at caloro.ch') AND ((imap = 1 AND 'pop3' = 'imap') OR (pop3 = 1 > AND 'pop3' = 'pop3') OR 'pop3' = 'smtp' OR 'pop3' = 'sieve'...

...ery = SELECT uid, gid, home, maildir as mail, concat('maildir:storage=',quota) AS quota FROM users WHERE login = '%u' password_query = SELECT password, uid AS userdb_uid, gid AS userdb_gid, home AS userdb_home, maildir as userdb_mail, concat('maildir:storage=', quota) AS userdb_quota FROM users WHERE login = '%u' My postfix config: # postconf -n alias_database = hash:/etc/postfix/aliases alias_maps = hash:/etc/postfix/aliases bounce_template_file = /etc/postfix/bounce.cf command_directory = /usr/local/sbin config_directory = /etc/postfix content_filter = smtp-amavis...

...zio at caloro.ch,151.248.162.33): query: SELECT username AS user, > password_enc AS password, CONCAT(homedir, maildir) AS userdb_home, uid AS > userdb_uid, gid AS userdb_gid, CONCAT('maildir:', homedir, maildir) AS > userdb_mail, CONCAT('maildir:storage=', (quota*1024)) as userdb_quota FROM > mail_users WHERE (username = 'maurizio at caloro.ch' OR email = > 'maurizio at caloro.ch') AND ((imap = 1 AND 'pop3' = 'imap') OR (pop3 = 1 AND > 'pop3' = 'pop3') OR 'pop3' = 'smtp' OR 'pop3' = 'sieve')...

Hello, I'm running dovecot 2.29 on a freebsd 10.3 system. I'm trying to cut down queries to my database and tried to do a userdb static and prefetch. I modified the password query to pull in userdb_quota and got an error that that was not valid. Is this behavior normal? Apr 13 17:22:15 hostname dovecot: master: Dovecot v2.2.29 (13ebc01) starting up for imap, sieve Apr 13 17:22:24 hostname dovecot: imap-login: Login: user=<username at example.com>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1,...

...user quota is configured like this (from LDAP): ---------------- user_attrs = homeDirectory=home,uidNumber=uid,gidNumber=gid,mailQuotaSize=quota=maildir:ignore=Kosz:storage pass_attrs = uid=user,userPassword=password,homeDirectory=userdb_home,uidNumber=userdb_uid,gidNumber=userdb_gid,mailQuotaSize =userdb_quota=maildir:ignore=Kosz:storage ---------------- "mailQuotaSize" attribute contains quota limit in kilobytes. /etc/dovecot.conf: ---------------------------- # 1.0.3: /etc/dovecot.conf log_path: /dev/stderr protocols: imap imaps pop3s managesieve login_dir: /var/run/dovecot/login login_execu...

Hi all, I'm new to the list, so ... hello everybody :-) Let's go to the point... I'm implementing quota over imap support in my mail server, so since a number of days I'm tring to upgrade to the new 1.x version (debian sarge) ... After having a number of troubles using the debian backport packege I am now using the -rc28 package that I have built by myself... I installed

...le.org Feb 18 17:44:27 ha-test1 dovecot: auth-worker(default): sql(user1 at example.org,127.0.0.1): query: SELECT username as user, password, maildir as userdb_home, concat('maildir:', maildir) as userdb_mail, 150 as userdb_uid, 12 as userdb_gid, concat('maildir:storage=', quota) AS userdb_quota FROM mailbox WHERE username = 'user1 at example.org' AND active = '1' Feb 18 17:44:27 ha-test1 dovecot: auth-worker(default): sql(user1 at example.org,127.0.0.1): Password mismatch ***** Here 'masterpass' is compared to the **USER** password hash (?) ******************* Fe...