- dovecot - dovecot.org

[Dovecot] dovecot overquota and delete message
by sa 07 Mar '08

07 Mar '08

Hi all, i use dovecot-1.1_rc1 with postfix and maildrop as deliver. The problem is where user gets overquota, at this point he is unable to delete message in pop3 as imap. dovecot.conf has: plugin { quota = maildir } protocol imap { mail_plugins = quota imap_quota } protocol pop3 { mail_plugins = quota } I change it to plugin { quota = maildir:ignore=Trash } and plugin { quota = maildir:storage=100240:ignore=Trash } but the problem persist. I have to del manually maildirsize file to get the user back to delete. Any suggestion ? tnx s

2 7

[Dovecot] Not using "." as separator?
by Grant Edwards 07 Mar '08

07 Mar '08

When using maildir storage, is there any way to use something besides "." as the folder separator? I like to use folder names that match people's e-mail addresses (that's a default behavior in mutt), and "." is a pretty popular character in e-mail addresses. Ideally, I'd like to use "/". Is "." allowed in mailbox names when using mbox storage? -- Grant Edwards grante Yow! As President I have at to go vacuum my coin visi.com collection!

4 9

[Dovecot] Logging Options
by Steffen Ille 07 Mar '08

07 Mar '08

Dear Listmembers, I tried to figure out how to get statistics not only about the amount of mails which where sent from / to my mailusers, but also about the size in byte (e.g. to compare with other traffic stats) for each of my users. postfix shows me the size of sent mails per user, but afaik I cannot get the size of rcvd mails per user with it. I use the dovecot LDA with postfix and in this lda - logfiles I also cannot see a byte-like size of delivered mails. Is there any possibility get such statistics working? My used versions are (all Debian Etch): dovecot: 1.0.10 postfix: 2.4.6 Regards, Steffen Ille

3 2

[Dovecot] Wrong message information reported shortly after delivery
by Ron Avriel 07 Mar '08

07 Mar '08

Hi, If an IMAP fetch is issued some "short" time after a message was delivered with dovecot deliver then dovecot reports wrong (zero) values for that new message. Afterward, it reports the information OK. This causes problems to our IMAP client. The problem is easily reproduced with a large message on a slow machine. I'm using dovecot 1.0.10 Here's a sample trace: 1 uid fetch 1:* fast * 1 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:20:50 +0200" RFC822.SIZE 3378380 UID 1) * 2 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:21:40 +0200" RFC822.SIZE 3378380 UID 2) * 3 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:23:38 +0200" RFC822.SIZE 3378380 UID 3) * 4 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:40:06 +0200" RFC822.SIZE 3378380 UID 4) 1 OK Fetch completed. ######## Here dovecot reports a new message (5) arrived ######## 1 uid fetch 1:* fast * 1 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:20:50 +0200" RFC822.SIZE 3378380 UID 1) * 2 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:21:40 +0200" RFC822.SIZE 3378380 UID 2) * 3 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:23:38 +0200" RFC822.SIZE 3378380 UID 3) * 4 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:40:06 +0200" RFC822.SIZE 3378380 UID 4) * 5 EXISTS * 5 RECENT 1 OK Fetch completed. ######## This is where dovecot reports wrong information about message 5 ######## 1 uid fetch 1:* fast * 1 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:20:50 +0200" RFC822.SIZE 3378380 UID 1) * 2 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:21:40 +0200" RFC822.SIZE 3378380 UID 2) * 3 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:23:38 +0200" RFC822.SIZE 3378380 UID 3) * 4 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:40:06 +0200" RFC822.SIZE 3378380 UID 4) * 5 FETCH (FLAGS (\Recent) INTERNALDATE "01-Jan-1970 00:00:00 +0000" RFC822.SIZE 0 UID 5) 1 OK Fetch completed. ######## The same wrong information is repeated ######## 1 uid fetch 1:* fast * 1 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:20:50 +0200" RFC822.SIZE 3378380 UID 1) * 2 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:21:40 +0200" RFC822.SIZE 3378380 UID 2) * 3 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:23:38 +0200" RFC822.SIZE 3378380 UID 3) * 4 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:40:06 +0200" RFC822.SIZE 3378380 UID 4) * 5 FETCH (FLAGS (\Recent) INTERNALDATE "01-Jan-1970 00:00:00 +0000" RFC822.SIZE 0 UID 5) 1 OK Fetch completed. ######## The same wrong information is repeated several times ######## 1 uid fetch 1:* fast * 1 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:20:50 +0200" RFC822.SIZE 3378380 UID 1) * 2 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:21:40 +0200" RFC822.SIZE 3378380 UID 2) * 3 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:23:38 +0200" RFC822.SIZE 3378380 UID 3) * 4 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:40:06 +0200" RFC822.SIZE 3378380 UID 4) * 5 FETCH (FLAGS (\Recent) INTERNALDATE "01-Jan-1970 00:00:00 +0000" RFC822.SIZE 0 UID 5) 1 OK Fetch completed. ######## Trace truncated here ######## ######## Finally, correct information is reported ######## 1 uid fetch 1:* fast * 1 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:20:50 +0200" RFC822.SIZE 3378380 UID 1) * 2 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:21:40 +0200" RFC822.SIZE 3378380 UID 2) * 3 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:23:38 +0200" RFC822.SIZE 3378380 UID 3) * 4 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:40:06 +0200" RFC822.SIZE 3378380 UID 4) * 5 FETCH (FLAGS (\Recent) INTERNALDATE "06-Mar-2008 17:41:07 +0200" RFC822.SIZE 3378380 UID 5) dovecot -n: # 1.0.10: /etc/dovecot.conf log_timestamp: “%Y-%m-%d %H:%M:%S ” protocols: imap listen: *:143 ssl_disable: yes login_dir: /var/run/dovecot/login login_executable: /usr/libexec/dovecot/imap-login login_process_per_connection: no first_valid_uid: 150 last_valid_uid: 150 dotlock_use_excl: yes fsync_disable: yes maildir_copy_with_hardlinks: yes maildir_copy_preserve_filename: yes mail_plugins: quota imap_quota auth default: mechanisms: plain login user: nobody master_user_separator: * passdb: driver: sql args: /etc/dovecot-sql.conf passdb: driver: passwd-file args: /etc/dovecot.masterusers master: yes userdb: driver: prefetch userdb: driver: sql args: /etc/dovecot-sql.conf socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix master: path: /var/run/dovecot/auth-master mode: 432 user: vmail group: mail plugin: quota: maildir:storage=1024 Thanks, Ron ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs

2 1

[Dovecot] Quota exceeded - ignore setting
by Fabian Lazarski 06 Mar '08

06 Mar '08

Hello, I have a problem if I use the 'ignore' setting in my dovecot.conf A delete operation in the client means that the mail is copied to Trash mailbox. If the user is already over quota the delete operation will fail. Therefore I use the ignore setting, which doesn`t count the quota at all for the given mailbox. But it doesn`t work. I got still a quoted exceeded failure in my client. Here is the plugin part of my dovecot.conf (The trash folder was renamed in Papierkorb on the mailserver): plugin { quota = maildir:storage=0:ignore=Papierkorb acl = vfile:/etc/dovecot/acls } and the appropriate View definition: SELECT u.userid, 999 AS uid, 8 AS gid, rel_homedir(v.volume::text, u.userid::text) AS home, ('maildir:storage='::text || u.quota::text) || ':ignore=Papierkorb'::text AS quota FROM mailuser u, user_volume v WHERE u.userid::text = v.userid::text;iate view definition: here is a section of imap-info.log: dovecot: 2008-03-06 18:30:55 Info: auth(default): master in: REQUEST 184 3289 173 dovecot: 2008-03-06 18:30:55 Info: auth(default): sql(dg-SW3,172.27.60.237): SELECT * FROM dovecotuser WHERE userid = 'dg-SW3'; dovecot: 2008-03-06 18:30:55 Info: auth(default): master out: USER 184 dg-SW3 userid=dg-SW3 uid=999 gid=8 home=mail02/dg/SW3 quota=maildir:storage=2097152:ignore=Papierkorb master_user=master dovecot: 2008-03-06 18:30:55 Info: imap-login: Login: user=<dg-SW3>, method=PLAIN, rip=172.27.x.y, lip=172.27.x.x dovecot: 2008-03-06 18:30:55 Info: auth(default): client in: AUTH 174 PLAIN service=IMAP lip=172.27.x.x rip=172.27.x.y resp=<hidden> dovecot: 2008-03-06 18:30:55 Info: auth(default): passwd-file(master,172.27.x.y,master): lookup: user=master file=/etc/dovecot/dovecot-master.pwd dovecot: 2008-03-06 18:30:55 Info: auth(default): passdb(master,172.27.x.y,master): Master user logging in as dg-SW3 dovecot: 2008-03-06 18:30:55 Info: auth(default): client out: OK 174 user=dg-SW3 Used dovecot Version is 1.0.2 Can someone help? Is there another possiblity to except the quota for my papierkorb folder? Bye Fabian ----------------------------------------------------------------- Sicherheit - Verfügbarkeit - Kontinuität ----------------------------------------------------------------- IT-Service-Management von ScanPlus GmbH Lise-Meitner-Strasse 5 Tel. +49 731 92013 152 D-89081 Ulm, Germany Fax. +49 731 92013 290 Web: http://www.scan-plus.de/ Mail: lazarski(a)scan-plus.de Amtsgericht Ulm HRB 3220 Geschäftsführung: Jürgen Hörmann, Andreas Werther -----------------------------------------------------------------

1 0

[Dovecot] two problems with dovecot and antispam-plugin and qmail/vpopmail
by Mario Cardia 06 Mar '08

06 Mar '08

Hi! I'm trying do use antispam plug-in to split spams in different folders. My problem is with backends... I tried dspam backend and now I'm tring mail training backend. With dspam backend the problem is: When I receive a mail then dspam creates a data directory to store his data as it should do it. But when a try to move the message to Spam folder I get an error (could not execute dspam). If I remove de data directory, it works... I can move the message and by doing this de data directory is re-created. So I decided to try mail training backend. My configuration is: antispam_mail_tmpdir = /tmp antispam_mail_spam = spam@%d antispam_mail_notspam = nospam@%d antispam_mail_sendmail = /opt/qmail/bin/sendmail # antispam_mail_sendmail_args = -f;%u But an error occurs. (Failed to send mail) I tried to use qmail-inject instead but the same error occurs. Then i tried to use de args commented (-f;%u) but didn't work yet. I also tried to use a complete e-mail address to spam and notspam parameters... but nothing seems to works. So I created a shell script to use instead a sendmail program to be able to debug de error. The script has these contents: #!/bin/sh /opt/qmail/bin/sendmail 2> /tmp/error.txt The result of this test is: qmail-inject: fatal: unable to parse this line: Return-Path: <mario(a)cardia.com.br>Delivered-To: isharedev.travelnet.com.br-mario(a)isharedev.travelnet.com.br Note that there is not a "\n" between return-path and delivered-to Can someone help me? (Sorry by my english, I'm brazilian) Tks Mário Cardia

1 0

[Dovecot] Can't connect to auth server at /var/run/dovecot//auth-master
by maxxfire 06 Mar '08

06 Mar '08

Hi, I'm using dovecot1.1 with postfix2.2.5; I configure dovecot.conf following the dovecot-wiki. But i doesn't work. The maillog said 'Can't connect to auth server at /var/run/dovecot//auth-master: No such file or directory' when I send a mail. my Postfix Master.cf configure: dovecot unix - n n - - pipe flags=DRhu user=vmail argv=/usr/local/libexec/dovecot/deliver -f ${sender} -d ${recipient} I just confused that why it needed to be authed again when postfix pipe the mail to dovecot. Best regards! Thanks and forgive my poor english writing.

2 1

[Dovecot] assert() using plugins zlib and antispam together
by Steffen Kaiser 06 Mar '08

06 Mar '08

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, I'm running Dovecot v1.0.10 and downloaded the "HEAD snapshot" today. If both plugins are enabled, I get: : file zlib-plugin.c: line 64 (zlib_maildir_get_stream): assertion failed: (fname != NULL) : Raw backtrace: imap [0x80ad741] -> imap [0x80ad65c] -> /usr/local/dovecot-1.0.10patch4mgtsv92/lib/dovecot/imap/lib20_zlib_plugin.so [0xb7e517ac] -> /usr/local/dovecot-1.0.10patch4mgtsv92/lib/dovecot/imap/lib90_antispam_plugin.so(backend_handle_mail+0x98) [0xb7e4e783] -> /usr/local/dovecot-1.0.10patch4mgtsv92/lib/dovecot/imap/lib90_antispam_plugin.so [0xb7e4d8bf] -> imap(mail_storage_copy+0xdd) [0x809ea1d] -> imap(maildir_copy+0x52) [0x806b802] -> /usr/local/dovecot-1.0.10patch4mgtsv92/lib/dovecot/imap/lib10_quota_plugin.so [0xb7e5a8b6] -> /usr/local/dovecot-1.0.10patch4mgtsv92/lib/dovecot/imap/lib20_mail_log_plugin.so [0xb7f97050] -> /usr/local/dovecot-1.0.10patch4mgtsv92/lib/dovecot/imap/lib90_antispam_plugin.so [0xb7e4d5f5] -> imap(cmd_copy+0x1aa) [0x8056c7a] -> imap [0x805ac38] -> imap [0x805acc7] -> imap(_client_input+0x6c) [0x805b3bc] -> imap(io_loop_handler_run+0x162) [0x80b3562] -> imap(io_loop_run+0x28) [0x80b29a8] -> imap(main+0x5a0) [0x8063590] -> /lib/tls/i686/cmov/libc.so.6(__libc_start_main+0xc : 8) [0xb7e73ea8] -> Error: child 18612 (imap) killed with signal 6 Bye, - -- Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHzoT8VJMDrex4hCIRAjtnAJ9OqdFWUVC2fr1ahVkpMSie7vQeRQCeKVjA VG9n+AzEM/hIHd66Bg2Xat4= =GEEc -----END PGP SIGNATURE-----

3 4

[Dovecot] Effects of migration
by Andy Dills 06 Mar '08

06 Mar '08

So, to follow up to my previous thread, we just successfully migrated our NFS-based mail cluster from qmail pop, courier imap, and bincimap to dovecot 1.1rc1. Overall the transition was very smooth, the only unexpected adjustment was having to implement ntpd on each box, rather than doing an hourly ntpdate against our local ntpd server, to prevent dovecot from crashing itself from too much drift. The impact has been severe! Even with NFS-stored indexes, our netapp is seeing 1/6th of the NFS ops per second, and its CPU utilization is now at 1/3rd previous levels. The only user comment thus far was thanking us for bringing IMAP folders out from under INBOX. Dovecot is truly excellent. In my book, Timo joins Wietse Venema and Marc Martinec to form the backbone of the premiere open source mail solution. For now, praise will have to suffice. I do, however, maintain a little IOU list that I intend to fulfill at some point in the future, and Timo is now high on the list. Thanks again! Andy --- Andy Dills Xecunet, Inc. www.xecu.net 301-682-9972 ---

3 4

[Dovecot] Checkpassword question
by Bob Wonder 06 Mar '08

06 Mar '08

Hi all, I would like to write my own checkpassword script for dovecot. I have very little experience with C programming. My questions are: 1. Can I use php for this purpose? 2. How dovecot call checkpassword program (passes <username> NUL <password> to checkpassword)? Thank you in advance for answers. Bob

2 1

[Dovecot] Quota override problem
by Oliver 05 Mar '08

05 Mar '08

Hi all, i am using debian etch with backports for dovecot (1.0.10) with Postfix (Version: 2.3.8-2+b1) At the moment the quota for all maildir mailboxes is 265MB, some should be 512MB an others 10 MB for example. See my Mysql: mysql> show fields from users from mail; +----------+-------------+------+-----+----------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+----------+-------+ | email | varchar(80) | NO | PRI | | | | password | varchar(20) | NO | | | | | quota | int(15) | NO | | 10485760 | | | active | tinyint(1) | NO | | 1 | | +----------+-------------+------+-----+----------+-------+ http://wiki.dovecot.org/Quota -> I looked here but i dont see my failure, merde. My configuration is: dovecot.conf: base_dir = /var/run/dovecot/ protocols = imaps log_timestamp = �^�^�%Y-%m-%d %H:%M:%S �^�^ syslog_facility = mail ssl_cert_file = /etc/ssl/dovecot/server.pem ssl_key_file = /etc/ssl/dovecot/server.key #ssl_ca_file = /etc/ssl/mycompany/ca/mycompany.pem #ssl_verify_client_cert = yes ssl_parameters_regenerate = 168 verbose_ssl = no mail_location = maildir:/home/vmail/%d/%n mail_extra_groups = mail mail_debug = no first_valid_uid = 5000 last_valid_uid = 5000 maildir_copy_with_hardlinks = yes protocol imap { login_executable = /usr/lib/dovecot/imap-login mail_executable = /usr/lib/dovecot/imap imap_max_line_length = 65536 mail_plugins = quota imap_quota ssl_listen = *:993 } protocol lda { postmaster_address = postmaster(a)osthome.de sendmail_path = /usr/lib/sendmail auth_socket_path = /var/run/dovecot/auth-master mail_plugins = cmusieve quota #sieve = /home/vmail/%d/%n/.dovecot.sieve } auth_verbose = no auth_debug = no auth_debug_passwords = no auth default { mechanisms = plain passdb sql { args = /etc/dovecot/dovecot-sql.conf } userdb static { args = uid=5000 gid=5000 sieve=/home/vmail/%d/%n/.dovecot.sieve } userdb sql { args = /etc/dovecot/dovecot-sql.conf } user = nobody socket listen { master { path = /var/run/dovecot/auth-master mode = 0660 user = vmail group = vmail } client { path = /var/spool/postfix/private/auth mode = 0660 user = postfix group = postfix } } # # If you want client certificates, use these lines # ssl_require_client_cert = yes # ssl_username_from_cert = yes } namespace private { separator = . prefix = INBOX. inbox = yes } plugin { #quota = maildir # 10 MB + 1000 messages quota limit quota = maildir:storage=265000:messages=50000:ignore=Trash } ______________________ My dovecot-sql.conf is: driver = mysql connect = host=localhost dbname=mail user=admin password=secret default_pass_scheme = CRYPT password_query = SELECT password FROM users WHERE email = '%u' AND active ='1' user_query = SELECT email, 5000 AS uid, 5000 AS gid, CONCAT('maildir:storage=', quota) AS quota, mail_plugins FROM users WHERE email = '%u' AND active = '1' ______

3 4

[Dovecot] Problem with Thunderbird hang, multiple retry to .Sent/.Draft
by tlum 05 Mar '08

05 Mar '08

I have begun havening a problem when sending or when Thunderbird tries to write copy to .Draft. Usually only happens when the message is longer. While in the Thunderbird editor will say "Copying message to Draft folder". It will try indefinitely. The copy is successful but it looks like it is believed to have failed so its retried. Same then happens when sending. Send happens but then hangs on copy to .Sent. Copy works, but apparently is not seen and just keeps getting retried. If you let it go hundreds of copies of message end up in .Sent and .Draft. Have logs from Thunderbird and rawlog but they are huge and don't want to post them to the list until after determining there is no quick answer for this behavior. dovecot --version = 1.0.rc15 dovecot -n # /etc/dovecot.conf base_dir: /var/run/dovecot/ log_timestamp: ¦%Y-%m-%d %H:%M:%S ¦ protocols: imap imaps listen: 127.0.0.1:143 ssl_listen: *:993 ssl_ca_file: /etc/pki/mydomain/mailserver/certs/class3.crt ssl_cert_file: /etc/pki/mydomain/mailserver/certs/ms1srvp01.mydomain.net.crt ssl_key_file: /etc/pki/mydomain/mailserver/private/ms1srvp01.mydomain.net.key disable_plaintext_auth: yes verbose_ssl: yes login_dir: /var/run/dovecot//login login_executable: /usr/libexec/dovecot/imap-login verbose_proctitle: yes first_valid_uid: 5000 last_valid_uid: 5000 mail_extra_groups: vmail mail_location: maildir:/home/vmail/%d/%u:INDEX=/var/indexes/%d/%n mail_debug: yes maildir_copy_with_hardlinks: yes mbox_read_locks: dotlock mbox_write_locks: dotlock mail_executable: /usr/libexec/dovecot/rawlog /usr/libexec/dovecot/imap imap_client_workarounds: outlook-idle, tb-extra-mailbox-sep auth default: user: nobody passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: prefetch userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: postfix master: path: /var/run/dovecot/auth-master mode: 432 user: vmail group: vmail mail_location: gets an override from userdb SQL lookup. /home/vmail is nfs mounted, /var/indexes is is local ext3. No error messages are logged any place. I think Thunderbird asks for the copy and then verifies it. It seems dovecot never confirms they copy happened. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

3 2

[Dovecot] antispam plugin / mailtrain backend: t_pop() leak & killed with signal 6
by Steffen Kaiser 05 Mar '08

05 Mar '08

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, antispam plugin version downloaded HEAD snapshot today. Leaked a t_pop() call in I/O handler 0x805b350 Raw backtrace: imap [0x80ad741] -> imap [0x80ad65c] -> imap(io_loop_handler _run+0x1ce) [0x80b35ce] -> imap(io_loop_run+0x28) [0x80b29a8] -> imap(main+0x5a0) [0x8063590] -> /lib/tls/i686/cmov/libc.so.6(__lib c_start_main+0xc8) [0xb7e37ea8] -> imap [0x8055e31] child 18478 (imap) killed with signal 6 Cause is, if sendmail fails with an exit code != 0, the function returns with -1 immediately skipping the t_pop() before the end of the function. See attached diff. Bye, - -- Steffen Kaiser -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHzpkeVJMDrex4hCIRAhhzAJ9uwU9pYEOZoSZiYJiERcKJJOzI/ACfXG10 BmSVMKMh2FUFve9Qu8atY9k= =wE4j -----END PGP SIGNATURE-----

2 1

[Dovecot] v1.0.12 released
by Timo Sirainen 05 Mar '08

05 Mar '08

http://dovecot.org/releases/1.0/dovecot-1.0.12.tar.gz http://dovecot.org/releases/1.0/dovecot-1.0.12.tar.gz.sig - Using mail_privileged_group with dotlock_use_excl=no worked, but it logged "access denied" errors.

2 1

[Dovecot] User Unknown Sendmail Error
by Paul Roberts 05 Mar '08

05 Mar '08

I am totally stumped here. I have setup a dovecot user and I can telnet to port 110 and login no problem with that user. When I try to send mail I get an error from sendmail: Mar 4 13:39:56 flashyhome sendmail[5014]: m24JdtGp005014: <paul(a)fleeky.com>... User unknown Now apparenly I need to setup the sendmail.mc file...which I have: MAILER(smtp)dnl MAILER(procmail)dnl MAILER(dovecot) And: more /usr/share/sendmail-cf/mailer/dovecot.m4 ######################*****############## ### DOVECOT Mailer specification ### ##################*****################## Mdovecot, P=/usr/local/libexec/dovecot/deliver, F=DFMPhnu9, S=EnvFromSMTP/HdrFromSMTP, R=EnvToSMTP/HdrFromSMTP, T=DNS/RFC822/X-Unix, A=deliver -d $u If anyone can give me any advice on what I need to do it would be much appreciated. Thanks so much in advance! -Paul

4 4

[Dovecot] different mail_locations
by Antonio Casado Rodríguez 05 Mar '08

05 Mar '08

Hi all I've mounted a cluster ACTIVE-PASIVE, with the mailbox in a SAN. The user's home are: /Correo/mail/foo/home I use: Postfix, dovecot and dovecot_lda. The folder /san/mail is only show in the active node (switch the virtual ip, filesystem and daemons). How i configure dovecot mail_location?? Now i have: mail_location: maildir:/Correo/mail/%n The problem is that the admin mails in pasive node are in enqueued and not arrive. I need a user with mail_location in /var/spool/mail/foo (in aliases, root: foo)and the rest users in /Correo/mail/ I have seen override mail_executable, but it not work with dovecot_lda and postfix (local mailer). I have thinked about: mail_location: maildir:%h/.. Have you any idea? # dovecot -n # 1.0.10: /etc/dovecot.conf log_path: /var/log/dovecot/dovecot.log info_log_path: /var/log/dovecot/dovecot.info protocols: imap imaps pop3 managesieve ssl_cert_file: /etc/pki/dovecot/certs/imap.ual.es.crt ssl_key_file: /etc/pki/dovecot/private/imap.ual.es.key login_dir: /var/run/dovecot/login login_executable(default): /usr/libexec/dovecot/imap-login login_executable(imap): /usr/libexec/dovecot/imap-login login_executable(pop3): /usr/libexec/dovecot/pop3-login login_executable(managesieve): /usr/libexec/dovecot/managesieve-login mail_location: maildir:/Correo/mail/%n mail_executable(default): /usr/local/sbin/post-login-imap-dovecot mail_executable(imap): /usr/local/sbin/post-login-imap-dovecot mail_executable(pop3): /usr/local/sbin/post-login-pop3-dovecot mail_executable(managesieve): /usr/libexec/dovecot/managesieve mail_plugins(default): quota imap_quota mail_plugins(imap): quota imap_quota mail_plugins(pop3): quota mail_plugins(managesieve): mail_plugin_dir(default): /usr/lib64/dovecot/imap mail_plugin_dir(imap): /usr/lib64/dovecot/imap mail_plugin_dir(pop3): /usr/lib64/dovecot/pop3 mail_plugin_dir(managesieve): /usr/lib64/dovecot/managesieve namespace: type: private separator: / location: maildir:/Correo/mail/%n inbox: yes auth default: passdb: driver: pam userdb: driver: passwd plugin: quota: maildir:storage=1048576

3 5

[Dovecot] dspam+sendmail+virtual users
by Anil 05 Mar '08

05 Mar '08

I want to setup something like this... Sendmail MTA -> DSPAM -> LDA/Dovecot Can someone give me some sendmail.mc configuration examples on how I can set this up? I was having trouble getting sendmail to deliver to dspam and then to dovecot's deliver. Thanks PS: I am not using the IMAP DSPAM integratation libs (yet)... I am using 1.1. When will 1.1 of this come out?

1 0

[Dovecot] multiple namespaces, Mac OS X
by David Koski 05 Mar '08

05 Mar '08

After installing a new server with postfix/dovecot I found that the Mac OS X mail client does not see email in subfolders. It seemed to be related to the namespace. From dovecot.conf: namespace private { separator = . prefix = INBOX. inbox = yes hidden = no } After googling I found that I might need to add a default namespace with an empty prefix so I added this: namespace private { separator = . prefix = inbox = yes hidden = no } Then I was able to access mail in subfolders using the Mac mail client. However, using Kmail I can see both namespaces, where all the folders are listed under the inbox at the same level, and where all folders are listed one level below the inbox. I don't really want to keep my "INBOX." prefix so existing accounts remain unchanged. How do I solve this? The current dovecot.conf is below. Regards, David Koski david(a)kosmosisland.com log_timestamp: %Y-%m-%d %H:%M:%S login_dir: /var/run/dovecot/login login_executable: /usr/lib/dovecot/imap-login first_valid_uid: 104 last_valid_uid: 104 mail_extra_groups: mail mail_location: /var/vmail maildir_copy_with_hardlinks: yes mail_plugins: quota imap_quota imap_client_workarounds: outlook-idle delay-newmail namespace: type: private separator: . prefix: INBOX. inbox: yes auth default: mechanisms: PLAIN LOGIN CRAM-MD5 APOP NTLM user: nobody passdb: driver: pam passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: prefetch socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: mail master: path: /var/run/dovecot/auth-master mode: 432 user: vmail group: mail

1 1

[Dovecot] Mercurial repository
by Timo Sirainen 05 Mar '08

05 Mar '08

I removed "dovecot" repository for now. It was almost the same as dovecot-1.1, with the exception that I had forgotten to commit a few things there and also messed up some other commits ("oh, hg export can export multiple changesets at a time, cool. oh, hg import imported it all in one changeset, not cool."). So for now v1.2 code doesn't exist. I'll clone it again from dovecot-1.1 once I have something real to commit. Although I guess that's probably going to be pretty soon.

1 0

[Dovecot] Security issue #5: mail_extra_groups setting is often used insecurely
by Timo Sirainen 05 Mar '08

05 Mar '08

mail_extra_groups=mail setting is often used insecurely to give Dovecot access to create dotlocks to /var/mail directory. If you don't use mboxes in /var/mail, make sure this setting is cleared. If you do use /var/mail mboxes and Dovecot gives permission errors without it, do one of the following (in the preferred order): a) Upgrade to v1.0.11 and use the new mail_privileged_group setting instead of mail_extra_groups. b) Make /var/mail sticky and world-writable (chmod 01777 /var/mail) and clear mail_extra_groups setting. c) Make /var/mail sticky (chmod +t /var/mail) and keep mail_extra_groups setting. This fixes the main problem but some may be left. The mail_privileged_group setting is also available as a patch: http://dovecot.org/patches/1.0/dovecot-1.0.10.mail_priv_groups.diff mail_extra_groups setting has existed since Dovecot v0.99.10.6. It's never been enabled by default in the distributed dovecot-example.conf, but some distributions enable it by default (at least Debian). A longer explanation: The main problem is that if users have filesystem access to the mail server, they can create symlinks. Dovecot doesn't try to prevent following symlinks (and I don't think it should) and normally it isn't a problem. But when mail_extra_groups=mail is set: 1a) Maildir: Any files readable by mail group can be read by the user by symlinking the file to their ~/Maildir/cur/. 1b) Any mbox files readable by mail group can be read by the user by symlinking the mbox file to their ~/mail/ directory. These are pretty obvious problems and I didn't think they were all that important. Why would anyone have secret files that are mail group-readable? But apparently those do exist in some systems (maybe accidentally). 2a) mbox: Any files/directories under mail group-writable directories can be created/deleted/renamed by symlinking the directory under ~/mail/. For example ln -s /var/mail ~/mail/var, DELETE var/root will happily delete root's mailbox. This I hadn't thought about before. 2b) Maildir: Pretty much the same thing can be done with maildir but with a little less control. mail_privileged_group setting works by keeping the group in process's saved GID while it's not in use and temporarily switching it to effective GID while dotlocks are created. Currently this is done only when: 1. It's only done for INBOX mbox which doesn't exist under the same location as other mailboxes (so typically under /var/mail). 2. It's used only after initial dotlock creation try failed with EACCES error.

7 15

[Dovecot] constant mailbox rebuilding with dovecot 1.0.10
by Philip J. Hollenback 04 Mar '08

04 Mar '08

I've recently upgraded to 1.0.10 in hopes that this problem would go away but no luck. I've got some users at my company with large inboxes on maildir (say 22,000 messages). Their mailboxes are hosted on nfs and dovecot is configured to do dotlocking. Still I see messages like this continually in the logs (sometimes every hour or so): server dovecot: IMAP(user): dotlock /home/user/Maildir/dovecot.index.log.lock was immediately recreated under us server dovecot: IMAP(user): file_dotlock_create() failed with file /home/user/Maildir/dovecot.index.log: No such file or directory server dovecot: IMAP(user): Our dotlock file /home/user/Maildir/dovecot-uidlist.lock was overridden (kept it 0 secs) server dovecot: IMAP(user): Duplicate file in uidlist file /home/user/Maildir/dovecot-uidlist: 1162416499.010493.mbox:2,Sa server dovecot: IMAP(user): Maildir /home/user/Maildir sync: UID inserted in the middle of mailbox (48573 > 1, file = 1162416499.010493.mbox:2,Sa) or this: server dovecot: IMAP(user): dotlock /home/user/Maildir/dovecot.index.log.lock was immediately recreated under us server dovecot: IMAP(user): file_dotlock_create() failed with file /home/user/Maildir/dovecot.index.log: No such file or directory server dovecot: IMAP(user): Duplicate file in uidlist file /home/user/Maildir/dovecot-uidlist: 1167674195.83666_2.tandoori.schrodinger.com:2,Sklwv server dovecot: IMAP(user): Maildir /home/user/Maildir sync: UID inserted in the middle of mailbox (34969 > 1, file = 1167674195.83666_2.server.com:2,Sklwv) server dovecot: IMAP(user): Corrupted transaction log file /home/user/Maildir/dovecot.index.log.2: invalid indexid (1204046496 != 1204055346) it seems that every time this sort of thing happens the mail client (thunderbird) sits and rebuilds it's mailbox info for as long as 20-30 minutes, during which time it is unusable. I suspect this happens with other users as well but since they have smaller inboxes they don't notice the long delays. Also this is not linked to version 1.0.10, I've been seeing on and off with the previous version (1.0rc17). Here's the 'dovecot -n' output. I should add that the default is for users to use mbox but some users (like the above one) use maildir via a separate dovecot.passwd file. Server is FreeBSD 4.7. # 1.0.10: /usr/local/etc/dovecot.conf base_dir: /var/run/dovecot/ protocols: imaps ssl_cert_file: /usr/local/openssl/certs/server.crt ssl_key_file: /usr/local/openssl/private/server.key login_dir: /var/run/dovecot//login login_executable: /usr/local/libexec/dovecot/imap-login login_greeting_capability: yes verbose_proctitle: yes first_valid_uid: 700 last_valid_uid: 9999 first_valid_gid: 100 last_valid_gid: 200 mail_extra_groups: mail default_mail_env: mbox:%h/mail:INBOX=/var/mail/%u mail_location: mbox:%h/mail:INBOX=/var/mail/%u mmap_disable: yes lock_method: dotlock mbox_read_locks: dotlock mbox_write_locks: dotlock imap_client_workarounds: delay-newmail outlook-idle netscape-eoh tb-extra-mailbox-sep auth default: passdb: driver: pam passdb: driver: passwd-file args: /usr/local/etc/dovecot.passwd passdb: driver: passwd userdb: driver: passwd-file args: /usr/local/etc/dovecot.passwd userdb: driver: passwd -- Phil Hollenback hollenba(a)schrodinger.com Schrodinger, Inc.

2 3

[Dovecot] v1.0.11 released
by Timo Sirainen 04 Mar '08

04 Mar '08

http://dovecot.org/releases/1.0/dovecot-1.0.11.tar.gz http://dovecot.org/releases/1.0/dovecot-1.0.11.tar.gz.sig * mail_extra_groups setting was commonly used insecurely. This setting is now deprecated. Most users should switch to using mail_privileged_group setting, but if you really need the old functionality use mail_access_groups instead. - mbox: Dropped some of the physical size fetch optimizations added in v1.0.8. This makes some commands slower, but should fix the rest of the problems. - IMAP: SEARCH BEFORE/ON/SINCE didn't handle timezones correctly. - ldap: auth_bind was doing lookups using subtree scope instead of the scope specified in config file. - zlib plugin crashfixes by Richard Platel - master passdbs: pass=yes setting was broken with blocking passdbs (e.g. MySQL)

3 2

[Dovecot] Missing IMAP folders
by Willem Jan Withagen 04 Mar '08

04 Mar '08

Hi, I'm fresh starting to use dovecot. Before this I used bincimap, mainly because it was very simple to config. I've tried to find the FAQ's and tried searching the archives, but little came up. My current config: server FreeBSD i386, postfix 2.4 dovecot 1.0.10 client: windows 2000 thunderbird 2.0.0.12 after some inital config this starts up, and I even have the advantage that I can save in the Sent folder on the server. However I have over 3500 folders and most of them are more than 3 levels deep. And I only get to see the first top level of directories. Searching and/or subscribing does not bring anything. Does somebody have pointers on how to fix this, other than manually trying to recreate al subscriptions. --WjW

2 3

[Dovecot] deliver dovecot 1.0.9 patched with quota-rewrite-1.0.9.diff
by Osvaldo Alvarez Pozo 04 Mar '08

04 Mar '08

Hi I downloaded dovecot 1.09 sources I patched it with quota-rewrite patch for v1.0. And now I have a problem with quota , I have quota dans mysql. When I send mail to a mailbox & I exeded the quota limit, I mean I have the impresion deliver does not obey the quota limit. then when I want to erase de mail via imap dovecot tells me there is no space for this operation. my logs: /var/log/dovecot-deliver.log deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: Loading modules from directory: /usr/lib/dovecot/modules/lda deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: Module loaded: /usr/lib/dovecot/modules/lda/lib10_quota_plugin.so deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: auth input: info(a)webmark.fr deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: auth input: home=/export/vmail/webmark.fr/info/Maildir deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: auth input: mail=maildir:/export/vmail/webmark.fr/info/Maildir deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: auth input: uid=5000 deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: auth input: gid=8 deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: auth input: quota_rule=*:bytes=10240000 deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: maildir: data=/export/vmail/webmark.fr/info/Maildir deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: maildir: root=/export/vmail/webmark.fr/info/Maildir, index=/export/vmail/webmark.fr/info/Maildir, control=, inb$ deliver(info(a)webmark.fr): Mar 03 12:46:17 Info: msgid=<5393f790988e70e84018e2510363bdfe@localhost>: saved mail to INBOX /var/log/mail.log: dovecot: imap-login: Login: user=<info(a)webmark.fr>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured dovecot: IMAP(info(a)webmark.fr): Loading modules from directory: /usr/dovecot/lib/dovecot/imap dovecot: IMAP(info(a)webmark.fr): Module loaded: /usr/dovecot/lib/dovecot/imap/lib10_quota_plugin.so dovecot: IMAP(info(a)webmark.fr): Module loaded: /usr/dovecot/lib/dovecot/imap/lib11_imap_quota_plugin.so dovecot: IMAP(info(a)webmark.fr): Effective uid=5000, gid=8, home=/export/vmail/webmark.fr/info/Maildir dovecot: IMAP(info(a)webmark.fr): Quota root: name= backend=maildir args= dovecot: IMAP(info(a)webmark.fr): Quota rule: root= mailbox= bytes=10240000 messages=0 dovecot: IMAP(info(a)webmark.fr): Quota rule: root= mailbox=Trash bytes=3072000 messages=0 dovecot: IMAP(info(a)webmark.fr): maildir: data=/export/vmail/webmark.fr/info/Maildir dovecot: IMAP(info(a)webmark.fr): maildir: root=/export/vmail/webmark.fr/info/Maildir, index=/export/vmail/webmark.fr/info/Maildir, control=, inbox= My file dovecot.conf is the following. ssl_cert_file = /etc/ssl/certs/ssl-cert-snakeoil.pem ssl_key_file = /etc/ssl/private/ssl-cert-snakeoil.key mail_location = maildir:/export/vmail/%d/%u/Maildir mail_extra_groups = mail first_valid_uid = 5000 last_valid_uid = 5000 maildir_copy_with_hardlinks = yes disable_plaintext_auth = no mail_debug = yes protocols = imap pop3 protocol imap { mail_plugins = quota imap_quota imap_client_workarounds = outlook-idle delay-newmail } protocol pop3 { mail_plugins = quota pop3_client_workarounds = outlook-no-nuls oe-ns-eoh pop3_uidl_format = %08Xu%08Xv } protocol lda { postmaster_address = support(a)oc3.fr mail_plugins = quota log_path = /var/log/dovecot-deliver.log info_log_path = /var/log/dovecot-deliver.log } auth default { mechanisms = plain login passdb sql { args = /etc/dovecot/sql.conf } # userdb prefetch { # } userdb sql { args = /etc/dovecot/sql.conf } user = nobody socket listen { master { path = /var/run/dovecot/auth-master mode = 0660 user = vmail group = mail } client { path = /var/spool/postfix/private/auth mode = 0660 user = postfix group = mail } } } dict { } plugin { quota = maildir quota_rule2 = Trash:storage=30%% } my file sql.conf driver = mysql default_pass_scheme = MD5 connect = host=localhost dbname=postfix user=postfix password=password user_query = SELECT concat('/export/vmail/', maildir, 'Maildir') as home, concat('maildir:/export/vmail/', maildir, 'Maildir') as mail, 5000 AS uid, 8 AS gid, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1' password_query = SELECT username as user, password, concat('/export/vmail/', maildir, 'Maildir') as userdb_home, concat('maildir:/export/vmail/', maildir, 'Maidir') as userdb_mail, 5000 as userdb_uid, 8 as userdb_gid, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1' Any Idea? Thanks

2 1

[Dovecot] dovecot 1.09 quota-rewrite patch for v1.0.
by Osvaldo Alvarez Pozo 04 Mar '08

04 Mar '08

I downloaded dovecot 1.09 sources I patched it with quota-rewrite patch for v1.0. And now I have a problem with quota , I have quota dans mysql. I send mail to a mailbox & i exeded the quota limit, then when I want to errase de mail via imap dovecot tells me there is no space for this operation. my logs: /var/log/dovecot-deliver.log deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: Loading modules from directory: /usr/lib/dovecot/modules/lda deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: Module loaded: /usr/lib/dovecot/modules/lda/lib10_quota_plugin.so deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: auth input: info(a)webmark.fr deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: auth input: home=/export/vmail/webmark.fr/info/Maildir deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: auth input: mail=maildir:/export/vmail/webmark.fr/info/Maildir deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: auth input: uid=5000 deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: auth input: gid=8 deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: auth input: quota_rule=*:bytes=10240000 deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: maildir: data=/export/vmail/webmark.fr/info/Maildir deliver(info(a)webmark.fr): Mar 03 12:46:15 Info: maildir: root=/export/vmail/webmark.fr/info/Maildir, index=/export/vmail/webmark.fr/info/Maildir, control=, inb$ deliver(info(a)webmark.fr): Mar 03 12:46:17 Info: msgid=<5393f790988e70e84018e2510363bdfe@localhost>: saved mail to INBOX /var/log/mail.log: dovecot: imap-login: Login: user=<info(a)webmark.fr>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured dovecot: IMAP(info(a)webmark.fr): Loading modules from directory: /usr/dovecot/lib/dovecot/imap dovecot: IMAP(info(a)webmark.fr): Module loaded: /usr/dovecot/lib/dovecot/imap/lib10_quota_plugin.so dovecot: IMAP(info(a)webmark.fr): Module loaded: /usr/dovecot/lib/dovecot/imap/lib11_imap_quota_plugin.so dovecot: IMAP(info(a)webmark.fr): Effective uid=5000, gid=8, home=/export/vmail/webmark.fr/info/Maildir dovecot: IMAP(info(a)webmark.fr): Quota root: name= backend=maildir args= dovecot: IMAP(info(a)webmark.fr): Quota rule: root= mailbox= bytes=10240000 messages=0 dovecot: IMAP(info(a)webmark.fr): Quota rule: root= mailbox=Trash bytes=3072000 messages=0 dovecot: IMAP(info(a)webmark.fr): maildir: data=/export/vmail/webmark.fr/info/Maildir dovecot: IMAP(info(a)webmark.fr): maildir: root=/export/vmail/webmark.fr/info/Maildir, index=/export/vmail/webmark.fr/info/Maildir, control=, inbox= My file dovecot.conf is the following. ssl_cert_file = /etc/ssl/certs/ssl-cert-snakeoil.pem ssl_key_file = /etc/ssl/private/ssl-cert-snakeoil.key mail_location = maildir:/export/vmail/%d/%u/Maildir mail_extra_groups = mail first_valid_uid = 5000 last_valid_uid = 5000 maildir_copy_with_hardlinks = yes disable_plaintext_auth = no mail_debug = yes protocols = imap pop3 protocol imap { mail_plugins = quota imap_quota imap_client_workarounds = outlook-idle delay-newmail } protocol pop3 { mail_plugins = quota pop3_client_workarounds = outlook-no-nuls oe-ns-eoh pop3_uidl_format = %08Xu%08Xv } protocol lda { postmaster_address = support(a)oc3.fr mail_plugins = quota log_path = /var/log/dovecot-deliver.log info_log_path = /var/log/dovecot-deliver.log } auth default { mechanisms = plain login passdb sql { args = /etc/dovecot/sql.conf } # userdb prefetch { # } userdb sql { args = /etc/dovecot/sql.conf } user = nobody socket listen { master { path = /var/run/dovecot/auth-master mode = 0660 user = vmail group = mail } client { path = /var/spool/postfix/private/auth mode = 0660 user = postfix group = mail } } } dict { } plugin { quota = maildir quota_rule2 = Trash:storage=30%% } my file sql.conf driver = mysql default_pass_scheme = MD5 connect = host=localhost dbname=postfix user=postfix password=password user_query = SELECT concat('/export/vmail/', maildir, 'Maildir') as home, concat('maildir:/export/vmail/', maildir, 'Maildir') as mail, 5000 AS uid, 8 AS gid, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1' password_query = SELECT username as user, password, concat('/export/vmail/', maildir, 'Maildir') as userdb_home, concat('maildir:/export/vmail/', maildir, 'Maidir') as userdb_mail, 5000 as userdb_uid, 8 as userdb_gid, concat('*:bytes=', quota) AS quota_rule FROM mailbox WHERE username = '%u' AND active = '1' Any Idea Thanks

2 2