Re: [Dovecot] per user quota in mysql
Hi, Thank you for responding but i have read in the dovecot documentation and in postfixadmin documentation that: - The setup gets userdb and passdb info from MySQL as well as quotas ( postfixadmin documentation ) - Quota backend specifies the method how Dovecot keeps track of the current quota usage. They don't (usually) specify users' quota limits, that's done by returning extra fields from userdb ( http://wiki2.dovecot.org/Quota ) My question is that if i can keep per user quota limits in a mysql database and user ldap database for authentication. I can't see anywhere in the docs if i can return user and password data from ldap and per user quota from mysql, if i am mistaken, please give me the link. Thank you! On Sun, Jun 9, 2013 at 7:22 AM, Benny Pedersen m...@junc.eu wrote: John Doe skrev den 2013-06-07 15:32: I have set up dovecot to use ldap authentication and it works great. I wonder if it is possible to use mysql for user quota and still keep my ldap authentication. yes no problem, for more help check postfixadmin on sf.net, even if you dont use it, there is good examples on configure it with dovecot quotas -- senders that put my email into body content will deliver it to my own trashcan, so if you like to get reply, dont do it
Re: [Dovecot] per user quota in mysql
John Doe skrev den 2013-06-07 15:32: I have set up dovecot to use ldap authentication and it works great. I wonder if it is possible to use mysql for user quota and still keep my ldap authentication. yes no problem, for more help check postfixadmin on sf.net, even if you dont use it, there is good examples on configure it with dovecot quotas -- senders that put my email into body content will deliver it to my own trashcan, so if you like to get reply, dont do it
Re: [Dovecot] per user quota
Hello Andreas, Andreas Meyer wrote: I activated quota plugin { quota = maildir:User quota quota_rule = *:storage=1GB # 10% of 1GB = 100MB quota_rule2 = Trash:storage=+10%% } But when I want to do per user quota in the passwd-file ...vhosts/anup.de/anmeyer::userdb_mail=maildir:~/userdb_quota_rule=*:bytes=10G It looks like you are at least missing a space between userdb_mail=maildir:~/ and userdb_quota_rule. I get this in the logfile and can't login: Jun 08 22:25:52 imap(anme...@anup.de): Error: user anme...@anup.de: Initialization failed: Initializing mail storage from mail_location setting failed: Unknown setting: bytes Jun 08 22:25:52 imap(anme...@anup.de): Error: Invalid user settings. Refer to server log for more information. Same with 'storage' in the passwd-file. What's wrong? You forgot to attach your doveconf -n output. Regards, Daniel
Re: [Dovecot] per user quota
Daniel Parthey daniel.part...@informatik.tu-chemnitz.de wrote: Hello Andreas, Andreas Meyer wrote: I activated quota plugin { quota = maildir:User quota quota_rule = *:storage=1GB # 10% of 1GB = 100MB quota_rule2 = Trash:storage=+10%% } But when I want to do per user quota in the passwd-file ...vhosts/anup.de/anmeyer::userdb_mail=maildir:~/userdb_quota_rule=*:bytes=10G It looks like you are at least missing a space between userdb_mail=maildir:~/ and userdb_quota_rule. Wow, great! The space was missing and now it works. You forgot to attach your doveconf -n output. ok, next time. Regards, Daniel Andreas
Re: [Dovecot] Per user quota on MySQL
On 12/20/2010 06:09 PM M. Rodrigo Monteiro wrote: Question: can I have quota per domain? It's possible - sure. See: http://wiki2.dovecot.org/Quota/Dict Regards, Pascal -- The trapper recommends today: cafefeed.1035...@localdomain.org
Re: [Dovecot] Per user quota on MySQL
Am 20.12.2010 22:05, schrieb Charles Marcus: On 2010-12-20 12:09 PM, M. Rodrigo Monteiro wrote: Now, I'm using lmtp. The reply works great. Quota per user looks good. Question: can I have quota per domain? I don't use it, but latest version of postfixadmin supports domain and user quotas... but domain quota in the postfixadmin http gui should only prevent delegated postmaster from using more quota space for their mailboxes in summery of a maildomain then the superuser has allowed to use for their maildomain, i cant see what sense this should have this with integrate in dovecot lmtp quota mech ( as i understand this feature, for sure, as its in mysql you can use it for other work from tec sight) normally if you use postfixadmin a delegated postmaster cant setup more space for its mailboxes as the superadmin has allowed to so overquota domain is simply a problem that should not exist with postfixadmin in real whatever, i cant think about cases where overquota domain might be usefull, you shouldnt want to have bounces by domain over quota as the reciept mailbox might have enough space free, and think about overquota warnings at fill level , sending them to the domain postmaster makes things more complicated as they need to be , while a overquota warning to the orginating mailbox owner is enough ( and you are able to cc/bc this warning to postmasters too , if you like ) -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria
Re: [Dovecot] Per user quota on MySQL
Hi! anyway you should use lmtp http://wiki2.dovecot.org/LMTP this may avoid i.e backscatter quota bounces Excelent! Now, I'm using lmtp. The reply works great. Quota per user looks good. Question: can I have quota per domain? Regards, Rodrigo. -- M. Rodrigo Monteiro Free as in Freedom, not free as in free beer As we are liberated from our own fear, our presence automatically liberates others Linux User # 403730 Pense antes de imprimir. Think before printing. AVISO LEGAL Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação confidencial e/ou legalmente privilegiada. Se você não for destinatário desta mensagem, desde já fica notificado de abster-se a divulgar, copiar, distribuir, examinar ou, de qualquer forma, utilizar a informação contida nesta mensagem, por ser ilegal. Caso você tenha recebido esta mensagem por engano, pedimos que nos retorne este E-Mail, promovendo, desde logo, a eliminação do seu conteúdo em sua base de dados, registros ou sistema de controle. Fica desprovida de eficácia e validade a mensagem que contiver vínculos obrigacionais, expedida por quem não detenha poderes de representação. LEGAL ADVICE This message is exclusively destined for the people to whom it is directed, and it can bear private and/or legally exceptional information. If you are not addressee of this message, since now you are advised to not release, copy, distribute, check or, otherwise, use the information contained in this message, because it is illegal. If you received this message by mistake, we ask you to return this email, making possible, as soon as possible, the elimination of its contents of your database, registrations or controls system. The message that bears any mandatory links, issued by someone who has no representation powers, shall be null or void.
Re: [Dovecot] Per user quota on MySQL
Am 20.12.2010 18:09, schrieb M. Rodrigo Monteiro: Hi! anyway you should use lmtp http://wiki2.dovecot.org/LMTP this may avoid i.e backscatter quota bounces Excelent! Now, I'm using lmtp. The reply works great. Quota per user looks good. Question: can I have quota per domain? dont think so, quota is by mailbox trough design but you might play around with mysql quota to goal this perhaps Timo knows if this might work Regards, Rodrigo. -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria
Re: [Dovecot] Per user quota on MySQL
On 2010-12-20 12:09 PM, M. Rodrigo Monteiro wrote: Now, I'm using lmtp. The reply works great. Quota per user looks good. Question: can I have quota per domain? I don't use it, but latest version of postfixadmin supports domain and user quotas... -- Best regards, Charles
Re: [Dovecot] Per user quota on MySQL
Hello, In my installation (postfixadmin, dovecot-1.2.x), postfixadmin sets and stores user quota in bytes in `quota` field of `mailbox` table. Dovecot retrieves stored quotas via `user_query` and `password_query` mechanism. --- wbr, Denis. On Sat, Dec 18, 2010 at 2:59 AM, M. Rodrigo Monteiro fale...@rodrigomonteiro.net wrote: On Fri, Dec 17, 2010 at 15:41, Henrique Fernandes sf.ri...@gmail.com wrote: It is missing an global mail plugins conf! []'sf.rique Ok, now I have the quota in dovecotadm. doveadm quota get -u te...@domain.com Quota name TypeValue Limit % storage=1024000 STORAGE 5584 - 0 storage=1024000 MESSAGE 7 - 0 But I don't know how to configure to get work quota per user with Postfixadmin. Anyone? Regards, Rodrigo. -- M. Rodrigo Monteiro
Re: [Dovecot] Per user quota on MySQL
On Fri, Dec 17, 2010 at 14:50, Henrique Fernandes sf.ri...@gmail.com wrote: Try to use doveadm quota get to see if it is working! There is no quota in doveadm. # /usr/local/dovecot/bin/doveadm usage: doveadm [-Dv] [-f formatter] command [args] altmove [-u user|-A] [-S socket_path] search query auth [-a auth socket path] [-x auth info] user [password] config [doveconf parameters] director add|flush|map|remove|status dump [-t type] path expunge [-u user|-A] [-S socket_path] search query fetch[-u user|-A] [-S socket_path] fields search query force-resync [-u user|-A] [-S socket_path] mailbox help cmd import [-u user|-A] [-S socket_path] source mail location dest parent mailbox search query kick [-a anvil socket path] [-f] user mask[|]ip/bits log find|reopen|test mailbox create|delete|list|mutf7|rename|status|subscribe|unsubscribe penalty [-a anvil socket path] [ip/bits] purge[-u user|-A] [-S socket_path] pw [-l] [-p plaintext] [-r rounds] [-s scheme] [-u user] [-V] reload search [-u user|-A] [-S socket_path] search query sis deduplicate|find stop user [-a userdb socket path] [-x auth info] user mask [...] who [-a anvil socket path] [-1] [user mask] [ip/bits] -- M. Rodrigo Monteiro Free as in Freedom, not free as in free beer As we are liberated from our own fear, our presence automatically liberates others Linux User # 403730 Pense antes de imprimir. Think before printing. AVISO LEGAL Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação confidencial e/ou legalmente privilegiada. Se você não for destinatário desta mensagem, desde já fica notificado de abster-se a divulgar, copiar, distribuir, examinar ou, de qualquer forma, utilizar a informação contida nesta mensagem, por ser ilegal. Caso você tenha recebido esta mensagem por engano, pedimos que nos retorne este E-Mail, promovendo, desde logo, a eliminação do seu conteúdo em sua base de dados, registros ou sistema de controle. Fica desprovida de eficácia e validade a mensagem que contiver vínculos obrigacionais, expedida por quem não detenha poderes de representação. LEGAL ADVICE This message is exclusively destined for the people to whom it is directed, and it can bear private and/or legally exceptional information. If you are not addressee of this message, since now you are advised to not release, copy, distribute, check or, otherwise, use the information contained in this message, because it is illegal. If you received this message by mistake, we ask you to return this email, making possible, as soon as possible, the elimination of its contents of your database, registrations or controls system. The message that bears any mandatory links, issued by someone who has no representation powers, shall be null or void.
Re: [Dovecot] Per user quota on MySQL
It is missing an global mail plugins conf! []'sf.rique On Fri, Dec 17, 2010 at 4:07 PM, Pascal Volk user+dove...@localhost.localdomain.orguser%2bdove...@localhost.localdomain.org wrote: On 12/17/2010 07:06 PM M. Rodrigo Monteiro wrote: There is no quota in doveadm. See the note at: http://wiki2.dovecot.org/Tools/Doveadm/Quota Regards, Pascal -- The trapper recommends today: f007ba11.1035...@localdomain.org
Re: [Dovecot] Per user quota on MySQL
On Fri, Dec 17, 2010 at 15:41, Henrique Fernandes sf.ri...@gmail.com wrote: It is missing an global mail plugins conf! []'sf.rique Ok, now I have the quota in dovecotadm. doveadm quota get -u te...@domain.com Quota name TypeValue Limit % storage=1024000 STORAGE 5584 - 0 storage=1024000 MESSAGE 7 - 0 But I don't know how to configure to get work quota per user with Postfixadmin. Anyone? Regards, Rodrigo. -- M. Rodrigo Monteiro Free as in Freedom, not free as in free beer As we are liberated from our own fear, our presence automatically liberates others Linux User # 403730 Pense antes de imprimir. Think before printing. AVISO LEGAL Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação confidencial e/ou legalmente privilegiada. Se você não for destinatário desta mensagem, desde já fica notificado de abster-se a divulgar, copiar, distribuir, examinar ou, de qualquer forma, utilizar a informação contida nesta mensagem, por ser ilegal. Caso você tenha recebido esta mensagem por engano, pedimos que nos retorne este E-Mail, promovendo, desde logo, a eliminação do seu conteúdo em sua base de dados, registros ou sistema de controle. Fica desprovida de eficácia e validade a mensagem que contiver vínculos obrigacionais, expedida por quem não detenha poderes de representação. LEGAL ADVICE This message is exclusively destined for the people to whom it is directed, and it can bear private and/or legally exceptional information. If you are not addressee of this message, since now you are advised to not release, copy, distribute, check or, otherwise, use the information contained in this message, because it is illegal. If you received this message by mistake, we ask you to return this email, making possible, as soon as possible, the elimination of its contents of your database, registrations or controls system. The message that bears any mandatory links, issued by someone who has no representation powers, shall be null or void.
Re: [Dovecot] per user quota
On Sun, 2007-12-23 at 23:36 +0100, Massimo Maioli wrote: I've added a quota field to the mysql that read dovecot, but i don't know ho to read this in dovecot-mysql.conf. See http://wiki.dovecot.org/Quota signature.asc Description: This is a digitally signed message part
Re: [Dovecot] Per-user quota (with local users)
On Wed, 2007-10-17 at 19:57 -0400, Maykel Moya wrote: userdb passwd { } .. My quota configuration is -- plugin { quota = maildir:storage=10240:ignore=Trash } -- I have some users with particular quotas. With LDAP lookups, there is no problem, in those cases I simply put their particular quota values in their entries and pass it to dovecot via user_attrs. I wonder how to do the same for local users, I mean, to have the ability of specifying particular quotas for some local users. passwd can't contain any extra fields, so this isn't possible with it. You could instead use for example a checkpassword script that takes the quota from some configuration file (http://wiki.dovecot.org/PasswordDatabase/CheckPassword). Or you could create a script that generates a passwd-file using /etc/passwd and a separate quota config file and run it when something changes. Another doubt is how to express to Dovecot that a user have no quota at all, could I use 0? Yes. signature.asc Description: This is a digitally signed message part