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.
[Dovecot] quota issues
Hi I seem to be getting an error when quotas are enabled. Also I noticed that the quota_ rule settings don't actually get used, the only settings that are used are on the sql.conf file. Maybe I'm not understanding what the quota_rule does but should I be specifying the storage/messages values on there even though they are being read/used are on the sql.conf file only. dict { quotadict = mysql:/usr/local/etc/dovecot/dovecot-dict-quota-sql.conf } plugin { quota = dict:::proxy::quotadict quota_rule = *:storage=1M:messages=5 quota_exceeded_message = Quota exceed, please email support for further assistance. trash = /usr/local/etc/dovecot/trash.conf.ext driver = sql } Sql.conf user_query = SELECT concat('/var/vmail/%d/', maildir) as home, concat('maildir:/var/vmail/%d/', maildir) as mail, 101 AS uid, 502 AS gid, concat('*:messages=5:storage=', quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1' Below are the errors I'm seeing in the log. If I'm overquota I get the following error Dec 20 08:32:32 testip5 dovecot: dict: mysql: Connected to localhost (dovecotquota) Dec 20 08:32:32 testip5 dovecot: lda(us...@virttest2.meganet.net): Panic: stream doesn't support seeking backwards Dec 20 08:32:32 testip5 dovecot: lda(us...@virttest2.meganet.net): Error: Raw backtrace: /usr/local/lib/dovecot/libdovecot.so.0 [0x7850c0] - /usr/local/lib/dovecot/libdovecot.so.0(i_syslog_fatal_handler+0x34) [0x785164] - /usr/local/lib/dovecot/libdovecot.so.0 [0x784704] - /usr/local/lib/dovecot/libdovecot.so.0 [0x78e600] - /usr/local/lib/dovecot/libdovecot.so.0(i_stream_seek+0x68) [0x78bb68] - /usr/local/lib/dovecot/libdovecot.so.0 [0x78eda8] - /usr/local/lib/dovecot/libdovecot.so.0(i_stream_read+0x7a) [0x78bc3a] - /usr/local/lib/dovecot/libdovecot.so.0(i_stream_read_data+0x2b) [0x78beab] - /usr/local/lib/dovecot/libdovecot.so.0(message_parse_header_next+0x87) [0x76f4a7] - /usr/local/lib/dovecot/libdovecot.so.0 [0x770d5e] - /usr/local/lib/dovecot/libdovecot.so.0(message_parser_parse_next_block+0x43) [0x770543] - /usr/local/lib/dovecot/libdovecot.so.0(message_parser_parse_header+0x2f) [0x77075f] - /usr/local/lib/dovecot/libdovecot-storage.so.0(index_mail_parse_headers+0x10 1) [0x598b51] - /usr/local Dec 20 08:32:32 testip5 postfix/pipe[7995]: E0FA4958156: to=us...@virttest2.meganet.net, relay=dovecot, delay=3900, delays=3900/0/0/0.06, dsn=4.3.0, status=deferred (Command died with signal 6: /usr/local/libexec/dovecot/deliver) Or error message if I'm not over quota on certain messages. Dec 20 08:12:12 testip5 dovecot: auth: Debug: master out: USER 1 us...@virttest1.meganet.net home=/var/vmail/virttest1.meganet.net/us...@virttest1.meganet.net/ mail=maildir:/var/vmail/virttest1.meganet.net/us...@virttest1.meganet.net/ uid=101 gid=502quota_rule=*:messages=5:storage=0 Dec 20 08:12:12 testip5 dovecot: lda(us...@virttest1.meganet.net): Panic: stream doesn't support seeking backwards Dec 20 08:12:12 testip5 dovecot: lda(us...@virttest1.meganet.net): Error: Raw backtrace: /usr/local/lib/dovecot/libdovecot.so.0 [0x63d0c0] - /usr/local/lib/dovecot/libdovecot.so.0(i_syslog_fatal_handler+0x34) [0x63d164] - /usr/local/lib/dovecot/libdovecot.so.0 [0x63c704] - /usr/local/lib/dovecot/libdovecot.so.0 [0x646600] - /usr/local/lib/dovecot/libdovecot.so.0(i_stream_seek+0x68) [0x643b68] - /usr/local/lib/dovecot/libdovecot.so.0 [0x646da8] - /usr/local/lib/dovecot/libdovecot.so.0(i_stream_read+0x7a) [0x643c3a] - /usr/local/lib/dovecot/libdovecot.so.0(i_stream_read_data+0x2b) [0x643eab] - /usr/local/lib/dovecot/libdovecot.so.0(message_parse_header_next+0x87) [0x6274a7] - /usr/local/lib/dovecot/libdovecot.so.0 [0x628d5e] - /usr/local/lib/dovecot/libdovecot.so.0(message_parser_parse_next_block+0x43) [0x628543] - /usr/local/lib/dovecot/libdovecot.so.0(message_parser_parse_header+0x2f) [0x62875f] - /usr/local/lib/dovecot/libdovecot-storage.so.0(index_mail_parse_headers+0x10 1) [0xb17b51] - /usr/local Dec 20 08:12:12 testip5 postfix/pipe[7557]: 2982A958151: to=us...@virttest1.meganet.net, relay=dovecot, delay=0.03, delays=0.01/0/0/0.02, dsn=4.3.0, status=deferred (Command died with signal 6: /usr/local/libexec/dovecot/deliver) I look at http://www.mail-archive.com/dovecot@dovecot.org/msg35048.html and it looks like the issue I'm having, if so what file to I apply the path to? Dovecot -n # OS: Linux 2.6.18-194.el5PAE i686 CentOS release 5.5 (Final) ext3 auth_debug = yes auth_mechanisms = plain login auth_verbose = yes base_dir = /usr/local/var/run/dovecot/ dict { quotadict = mysql:/usr/local/etc/dovecot/dovecot-dict-quota-sql.conf } disable_plaintext_auth = no first_valid_uid = 101 last_valid_uid = 101 login_greeting = Mail Server Ready. mail_location = maildir:/var/vmail/%d/%u passdb { args = /usr/local/etc/dovecot/sql.conf.ext driver = sql } plugin { acl = vfile:/usr/local/etc/dovecot/acls driver = sql quota = dict:::proxy::quotadict quota_exceeded_message = Quota exceed, please email support for
Re: [Dovecot] quota issues
On 2010-12-20 1:35 PM, PA wrote: Dovecot -n # OS: Linux 2.6.18-194.el5PAE i686 CentOS release 5.5 (Final) ext3 Why'd you snip the version? -- Best regards, Charles Marcus I.T. Director Media Brokers International, Inc. 678.514.6200 x224 | 678.514.6299 fax
Re: [Dovecot] quota issues
dovecot --version 2.0.8 -Original Message- From: dovecot-bounces+razor=meganet@dovecot.org [mailto:dovecot-bounces+razor=meganet@dovecot.org] On Behalf Of Charles Marcus Sent: Monday, December 20, 2010 2:31 PM To: dovecot@dovecot.org Subject: Re: [Dovecot] quota issues On 2010-12-20 1:35 PM, PA wrote: Dovecot -n # OS: Linux 2.6.18-194.el5PAE i686 CentOS release 5.5 (Final) ext3 Why'd you snip the version? -- Best regards, Charles Marcus I.T. Director Media Brokers International, Inc. 678.514.6200 x224 | 678.514.6299 fax
Re: [Dovecot] quota issues
Just looked at the patch I referenced below seems to be included on version 2.0.8 that I'm using, not really sure why I'm getting those errors. -Original Message- From: dovecot-bounces+razor=meganet@dovecot.org [mailto:dovecot-bounces+razor=meganet@dovecot.org] On Behalf Of PA Sent: Monday, December 20, 2010 3:13 PM To: 'Dovecot Mailing List' Subject: Re: [Dovecot] quota issues dovecot --version 2.0.8 -Original Message- From: dovecot-bounces+razor=meganet@dovecot.org [mailto:dovecot-bounces+razor=meganet@dovecot.org] On Behalf Of Charles Marcus Sent: Monday, December 20, 2010 2:31 PM To: dovecot@dovecot.org Subject: Re: [Dovecot] quota issues On 2010-12-20 1:35 PM, PA wrote: Dovecot -n # OS: Linux 2.6.18-194.el5PAE i686 CentOS release 5.5 (Final) ext3 Why'd you snip the version? -- Best regards, Charles Marcus I.T. Director Media Brokers International, Inc. 678.514.6200 x224 | 678.514.6299 fax
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] quota issues - fixed
Looks like I fixed the issue, changed postfix master to use appropriate dovecot string. flags=DRhu user=vmail:vmail argv=/usr/local/libexec/dovecot/dovecot-lda -f ${sender} -d ${us...@${nexthop} on my sql virtual domains file I had the incorrect string, used wrogn variable. changed to query = SELECT domain FROM domain WHERE domain='%d' AND active = '1' thanks, Paul -Original Message- From: dovecot-bounces+razor=meganet@dovecot.org [mailto:dovecot-bounces+razor=meganet@dovecot.org] On Behalf Of PA Sent: Monday, December 20, 2010 3:30 PM To: 'Dovecot Mailing List' Subject: Re: [Dovecot] quota issues Just looked at the patch I referenced below seems to be included on version 2.0.8 that I'm using, not really sure why I'm getting those errors. -Original Message- From: dovecot-bounces+razor=meganet@dovecot.org [mailto:dovecot-bounces+razor=meganet@dovecot.org] On Behalf Of PA Sent: Monday, December 20, 2010 3:13 PM To: 'Dovecot Mailing List' Subject: Re: [Dovecot] quota issues dovecot --version 2.0.8 -Original Message- From: dovecot-bounces+razor=meganet@dovecot.org [mailto:dovecot-bounces+razor=meganet@dovecot.org] On Behalf Of Charles Marcus Sent: Monday, December 20, 2010 2:31 PM To: dovecot@dovecot.org Subject: Re: [Dovecot] quota issues On 2010-12-20 1:35 PM, PA wrote: Dovecot -n # OS: Linux 2.6.18-194.el5PAE i686 CentOS release 5.5 (Final) ext3 Why'd you snip the version? -- Best regards, Charles Marcus I.T. Director Media Brokers International, Inc. 678.514.6200 x224 | 678.514.6299 fax
[Dovecot] Maildir and Solaris UFS acls
I have a centrally located shared imap folder location. We have several maildir folders with different file system permissions. They are for several groups of people who are loosely related for support purposes. All mail gets delivered to queue1 just fine. The files are group writable by group1. Some of the mail gets moved via imap to queue2. Queue2's maildir tree is configured with Solaris UFS acls such that any new files are read/write by group1 or group2. If a new file is created within queue2 anywhere, it has the correct permissions. However, if a message is moved from queue1 to queue2, it retains the permissions that it had within queue1. This is what happens if I use 'mv' within the file system, btw. Is there any way to configure dovecot such that if a person moves or copies a message to another imap folder, it creates a new file instead of doing a link or mv or whatever? If not, no problem; I was just hoping for an elegant solution to my particular problem. :-) queue1 - read/write by group1 queue2 - read/write by group1 group2 through solaris ACLs BTW, if any file whatsoever in queue2 is not readable by group2, those in group2 cannot read _anything_ in queue2. thanks Tom Lieuallen
Re: [Dovecot] Maildir and Solaris UFS acls
On 12/20/2010 6:42 PM, Tom Lieuallen wrote: I have a centrally located shared imap folder location. We have several maildir folders with different file system permissions. ... Is there any way to configure dovecot such that if a person moves or copies a message to another imap folder, it creates a new file instead of doing a link or mv or whatever? http://wiki2.dovecot.org/MailLocation/Maildir?highlight=%28maildir_copy_with_hardlinks%29 The default for maildir_copy_with_hardlinks is yes, so you may want to turn it off manually. But, I'm not sure you really want to do this. Dovecot acls can protect the files from imap access, and exporting them via a raw filesystem seems counterproductive to your security goal. Also, performance will suffer.
[Dovecot] dovecot 2.08 start script
Hi Could anyone provide me with a start script for dovecot 2.08 that could be placed in /etc/init.d ? I did an installation from the sources and followed the documentation at dovecot.org. Thankx in advance. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email:mailto:carsten.laun-delel...@delellis.net carsten.laun-delel...@delellis.net
Re: [Dovecot] dovecot 2.08 start script
If you look in the sources you unpacked, under doc you'll find dovecot-initrd.sh I copied that into /etc/init.d/dovecot and it worked well in my CentOS/RedHat environment. On Dec 20, 2010, at 11:33 PM, Carsten Laun-De Lellis wrote: Hi Could anyone provide me with a start script for dovecot 2.08 that could be placed in /etc/init.d ? I did an installation from the sources and followed the documentation at dovecot.org. Thankx in advance. Mit freundlichem Gruß Carsten Laun-De Lellis Dipl.-Ing. Elektrotechnik Certified Information Systems Auditor (CISA) Hauptstrasse 13 D-67705 Trippstadt Phone: +49 (6306) 992140 Mobile: +49 (151) 27530865 email:mailto:carsten.laun-delel...@delellis.net carsten.laun-delel...@delellis.net