- dovecot - dovecot.org

[Dovecot] Fwd: Re: [SOLVED] Configuring Quota on Dovecot 1.0.13-1~bpo40+1
by Lucas Carlessi 29 May '08

29 May '08

Thank you Tomasz! The quota per user worked fine now... The problem was that in dovecot.conf I had these lines: userdb static { args = uid=5000 gid=5000 home=/home/vmail/%d/%n allow_all_users=yes } And I just changed to: userdb sql { args = /etc/dovecot/dovecot-sql.conf } Now it's working... bye! On Wed, 28 May 2008 21:08:51 +0200, Tomasz Suchodolski <suchodolski.tomasz(a)gmail.com> wrote: >> Hi all! >> I have just updated my dovecot 1.0.rc15 to 1.0.13-1~bpo40+1 > >> I have a mysql table with this structure: > >> +----------+--------------+------+-----+---------+-------+ >> | Field | Type | Null | Key | Default | Extra | >> +----------+--------------+------+-----+---------+-------+ >> | email | varchar(91) | YES | | NULL | | >> | password | varchar(32) | NO | | | | >> | quota | bigint(20) | NO | | | | >> | home | varchar(255) | NO | | | | >> +----------+--------------+------+-----+---------+-------+ > >> email returns email(a)domain.com > >> password returns the pass in mysql-crypt format > >> quota returns the quota in bytes(like 100000000) > >> home returns the path to the user home(like >> /home/vmail/domain.com/email/) > >> the mail user and group id are 5000. > >> Now the question: How can I configure the quotas by user using >> mysql... in dovecot 1.0.rc15 didn't work... >> Thanks for your >> help! > > http://wiki.dovecot.org/Quota/1.0 > Set global quota and see examples for sql queries. Also try with > kilobytes. > > Ps. 1.0.rc15 - quota per user(with mysql) works - I have tested it. > > Regards

1 0

[Dovecot] "storage error during logout"
by Vegard Svanberg 29 May '08

29 May '08

What is this error message actually trying to tell me? May 28 13:47:24 yyy dovecot: POP3(aaa@bbb): Disconnected: Storage error during logout. top=0/0, retr=2/73195, del=0/435, size=13509375 This user is accessing his mailbox using both POP3 and IMAP, I don't know if that's relevant. The POP3 check is quite aggressive; once every minute or so. Dovecot 1.0.13-1~bpo40+1 -- Vegard Svanberg <vegard(a)svanberg.no> [*Takapa@IRC (EFnet)]

2 1

[Dovecot] Trim trailing whitespace from username
by David Jonas 29 May '08

29 May '08

Recently we changed Postfix to use Dovecot for our SASL authentication and we ran into trouble with some of our clients having extraneous spaces at the end of their usernames. The quick fix was to add a space to username_chars. The slightly longer fix was a pretty simple patch to Dovecot. I put the trimming in auth_request_fix_username. I didn't think it warranted a full strfuncs function. If there is a better way to do this I'm all ears. I don't really like patching with my own code, even if I did essentially steal if from the kernel's strstrip(). diff -u dovecot-1.1.rc5/src/auth/auth-request.c dovecot-1.1.rc5-patched/src/auth/auth-request.c --- dovecot-1.1.rc5/src/auth/auth-request.c 2008-05-04 15:01:52.000000000 -0700 +++ dovecot-1.1.rc5-patched/src/auth/auth-request.c 2008-05-16 00:44:15.000000000 -0700 @@ -22,6 +22,7 @@ #include <stdlib.h> #include <sys/stat.h> +#include <ctype.h> struct auth_request * auth_request_new(struct auth *auth, const struct mech_module *mech, @@ -750,6 +751,7 @@ { unsigned char *p; char *user; + size_t size; if (strchr(username, '@') == NULL && request->auth->default_realm != NULL) { @@ -759,6 +761,16 @@ user = p_strdup(request->pool, username); } + /* Trim trailing whitespace from the username */ + size = strlen((unsigned char*)user); + if(size) { + p = user + size - 1; + while (p != user && isspace(*p)) + p--; + *(p + 1) = '\0'; + p = NULL; + } + for (p = (unsigned char *)user; *p != '\0'; p++) { if (request->auth->username_translation[*p & 0xff] != 0) *p = request->auth->username_translation[*p & 0xff];

3 6

[Dovecot] Sieve/Vacation
by Ulrich Schreiner 29 May '08

29 May '08

hi, i'm using 1.1.rc5 but the same error occured with 1.0.13. the dovecot package was installed on centos 5 with rpm's from atrpms. exim 4.69. everything works fine except the vacation's from sieve. don't get me wrong, sieve works for everything, including mailforwards, or sorting in subfolders. but when i have a vacation, the script is compiled, but it produces the following output: sieve_execute_bytecode(/var/virtuser/test@<adomain>.sievec) failed (the "<adomain>" is replaced with the real domain of the user). i use virtual users in different domains. the sieve-scripts are generated by horde/ingo and stored via ftp in the "/var/virtuser" directory with the pattern "%u.sieve". the "sievec" files are up-to-date, because: a) i can delete the "sievec" files and they are regenerated b) i can "sieved" them and get an disassembled output with the vacation rule inside but when executing the script (when a mail arrives) the upper error is logged and no vacation is processed. the same error occured with 1.0.13 thank you </usc>

2 1

[Dovecot] Configuring Quota on Dovecot 1.0.13-1~bpo40+1
by Lucas Carlessi 28 May '08

28 May '08

2 1

[Dovecot] Configuring Quota on Dovecot 1.0.13-1~bpo40+1
by Lucas Carlessi 28 May '08

28 May '08

Hi all! I have just updated my dovecot 1.0.rc15 to 1.0.13-1~bpo40+1 from backports... I need some help in configure quotas by user using mysql

1 0

[Dovecot] Dovecot 1.0 rc15 + Quota by user using mysql
by Lucas Carlessi 28 May '08

28 May '08

Hi all, I installed the Dovecot on a Debian by apt-get, it's all working except quota by user.. I have a database with all quotas in bytes, and that lines in /etc/dovecot/dovecot-sql.conf : driver = mysql connect = host=127.0.0.1 dbname=mailserver user=USER password=PASS default_pass_scheme = CRYPT password_query = SELECT email as user, password FROM view_users WHERE email='%u'; #Quota: user_query = SELECT home AS maildir, 5000 AS uid, 5000 AS gid, CONCAT('dirsize:storage=', ROUND( view_users.quota / 1024) ) AS quota FROM view_users WHERE email='%u'; and in /etc/dovecot/dovecot.conf : protocol imap { mail_plugins = quota imap_quota } protocol pop3 { pop3_uidl_format = %08Xu%08Xv mail_plugins = quota } plugin { #quota = maildir:ignore=Trash } But when I open the webmail I have no limit quotas! If I put quota = maildir:storage=101480 in plugin the quota works fine at 100MB, but in all users... Is the query right? There is another way to configure quotas by user in Dovecot 1.0 using mysql? Sorry my bad English, and thank you all!

2 2

[Dovecot] Error when using include directive in Sieve
by Juan Asensio Sánchez 28 May '08

28 May '08

Hi I have two sieve scripts: # cat /var/vmail/sieve/global require ["include"]; include :global "spam"; include :personal "sieve"; # cat /var/vmail/sieve/spam require "fileinto"; if exists "X-Spam-Flag" { fileinto "Junk"; } # ls -l /var/vmail/sieve/ total 16 -rw-r--r-- 1 mailuser mailgroup 68 2008-05-28 00:40 global -rw------- 1 mailuser mailgroup 80 2008-05-28 00:40 globalc -rw-r--r-- 1 mailuser mailgroup 68 2008-05-27 21:15 spam -rw------- 1 mailuser mailgroup 80 2008-05-27 21:25 spamc # cat /etc/dovecot/dovecot.conf [...] sieve_global_dir = /var/vmail/sieve/ sieve_global_path = /var/vmail/sieve/global [...] When delivering a message I get: deliver(*****@*******): May 28 00:39:04 Error: sieve_execute_bytecode(/var/vmail/sieve/globalc) failed Personal sieve script is not sure to exist, only if the user has created it. If I put the contents of the spam script in the global script (replacing the content), everything works fine. Why does this happen? Is it because the personal script doesn't exists?Or is the syntax incorrect (i don't think this because the script is compiled)? Thanks in advance.

3 3

[Dovecot] Vanishing maildirsize files with 1.0.7 using 'deliver' via postfix
by Jason Forester 28 May '08

28 May '08

Aloha, I've searched the list and have found no similar reports, so I'm asking here. We have 3 RH5.1 boxes running the stock Postfix 2.3.3, but due to issues with the stock Dovecot 1.0rc15, Redhat supplied us with the version of Dovecot 1.0.7 that will be in Redhat 5.2. The mail store is automounted per-user from a Sun box via NFS. We were using it with no problems until last Friday, when we attempted to implement quotas. I had done quite a lot of testing on a single system, so I didn't anticipate any issues here. I created maildirsize files for each user in the NFS-mounted /var/spool/mail/$USER and everything seemed fine. I changed mailbox_command to /usr/libexec/dovecot/deliver in postfix main.cf. Mail was delivered, quota files updated, all good. However almost immediately a maildirsize folder vanished. Soon after another, then another, and now we're missing nearly 40 of them. Any ideas as to why they're vanishing? Something to do with NFS? I've tried to trigger it by massively sending to the same user on all three systems but have yet to reproduce it at will. Any clues would be appreciated. For reasons of support I cannot upgrade to a later dovecot at this time. Best Regards, - jason

3 8

[Dovecot] Dovecot quota for mailadministrator
by Markus Hofer 27 May '08

27 May '08

Hallo, i have a question for the quota with dovecot. I plan to go from our cyrus installation to dovecot. I have just install dovecot without problem with mysqldb and quota per user. Quota work well and the user receive always via Webmail or client the quota information. My question is: With cyrus the mailadministrator has the possibility to see the quota for all users with the command "quota". Output or example: 300000 9 28305 user.tinfo With that way the administrator could have always a look if some users have quota problems. My question is, if dovecot has some similar command for the administrator? Thanks in advance. Markus

2 3