- dovecot - dovecot.org

Re: [Dovecot] dovecot lda and quota plugin with mysql
by J4 17 Jan '11

17 Jan '11

On 01/17/2011 11:53 AM, J4 wrote: > On 01/16/2011 08:42 PM, Timo Sirainen wrote: >> On Thu, 2011-01-13 at 17:22 +0100, J4 wrote: >> >>> I have postfix delivering to dovecot lda (via spamassinassin). I >>> have configured the quota plugin, but it does not seem to respect the >>> details in the quota table in mysql. The query I have used looks >>> correct to me, and the user can connect to the database. >> .. >>> # Relevant portions of dovecot -n: >> This output doesn't show a quota_rule. If you don't have any, everyone >> has unlimited quota. >> >>> mysql> select * from quota; >>> +-----------------------------+-----------+----------+ >>> | username | bytes | messages | >>> +-----------------------------+-----------+----------+ >>> | root(a)test.info | 19524 | 18 | >>> | bob(a)test.info | 9420 | 6 | >>> | test(a)klunky.co.uk | 4662 | 4 | >>> | bob1(a)test.info | 19284 | 13 | >>> | bob2(a)test.info | 173906172 | 5702 | >>> | postmaster(a)test.info | 10587 | 9 | >>> | bob3(a)test.info | 3695 | 2 | >>> +-----------------------------+-----------+----------+ >>> 7 rows in set (0.00 sec) >> Looks like it's counting the quota, so I guess you're just missing the >> limits. > Hi Timo, > Many thanks for getting back to me. This has led me to look more into > the mailbox and quota tables. > > I think the limits are inserted into the mailbox table, > mysql> select * from mailbox; > +----------------------------+------------------------------------+----------------------------+-----------------------------+----------+------------+------------------+---------------------+---------------------+--------+ > | username | password | name > | maildir | quota | > local_part | domain | created | modified > | active | > +----------------------------+------------------------------------+----------------------------+-----------------------------+----------+------------+------------------+---------------------+---------------------+--------+ > | test(a)test.info | $1$1xxxxxxxxx | Fred TEST > | test.info/test/ | 10240000 | test | test.info | > 2011-01-07 17:47:25 | 2011-01-07 17:47:25 | 1 | > > +----------------------------+------------------------------------+----------------------------+-----------------------------+----------+------------+------------------+---------------------+---------------------+--------+ > > ... while the actual usage is inserted into the quota table (as shown in > the original Email). I think that Dovecot should read the limits from > mailbox.quota and retrieve the usage from the quota.bytes and > quota.messages. > > Somehow, I have to tell Dovecot to use these values in mailbox.quota. I > think that I have to add a reference to the file in the dovecot.conf, > and add an entry into the appropriate sql.conf file. > > Regards, J. > I updated the /etc/dovecot/dovecot-sql.conf file to include this modifed query, that I hoped would check the quota, but this failed. I think dovecot simply ignored this. I wonder if the alias quota_rule makes any sence to Dovecot as I only see : quota = dict:user::proxy::quotadict defined in the dovecot.conf and not quota_rule. # cat /etc/dovecot/dovecot-sql.conf password_query = SELECT username as user, password FROM mailbox WHERE email='%u'; user_query = SELECT 5000 AS uid, 5000 AS gid,'/home/vmail/%d/%n' as home, concat('*:storage= ', quota) AS quota_rule FROM mailbox WHERE user = '%n';

1 0

[Dovecot] BUG:v2.0.9 + expire plugin segfault
by Nikita Koshikov 17 Jan '11

17 Jan '11

Hello list, New version of dovecot segfaulting with expire plugin(sqlite db). Steps to reproduce: 1)DB file has permitions: -rw-r--r-- 1 mail mail 87040 Янв 17 10:04 /var/mail/expire.db 2)Dict dovecot config section: service dict { # If dict proxy is used, mail processes should have access to its socket. # For example: mode=0660, group=vmail and global mail_access_groups=vmail unix_listener dict { mode = 0600 user = mail } #user = mail } 3)Trying to add new record to database I get: Jan 17 10:03:12 dict: Error: sqlite: exec(INSERT INTO expires (expire_stamp,username,mailbox) VALUES ('1294852805','user(a)domain.com','Trash')) fail ed: attempt to write a readonly database (8) Jan 17 10:03:12 IMAP(user(a)domain.com 192.168.2.252): Error: read(/var/run/dovecot/dict) failed: Remote disconnected Jan 17 10:03:12 master: Error: service(dict): child 13957 killed with signal 11 (core not dumped) This crash has gone after service dict got enough permission to access db file(user mail in my case). Don't know how to get backtrace with dict service, but can reproduce crash any time.

1 0

[Dovecot] vpopmail disabled services fix
by Calvin 17 Jan '11

17 Jan '11

I noticed that disabling services using vpopmail was not being recognized by dovecot. Using "vmoduser -swip user(a)domain.com" should disable all services, but both pop and imap logins were still allowed. After a bit of digging in the code and confirming with a few debug lines, it appears that lines 38 and 52 of src/auth/passdb-vpopmail.c are the issue (dovecot 2.0.8). These two lines do a strcmp on request->service. It appears that request->service is in lower case, but the comparison values are in upper case. Either updating the values to lowercase or using strcasecmp should fix the issue. Calvin _________________________________________________ Scanned on 27 Dec 2010 23:05:02 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender at 425-336-0480 and delete the e-mail message from your computer. Thank you.

3 2

[Dovecot] Share: How to share IMAP folder with Dovecot and Roundcube webmail
by Zhang Huangbin 17 Jan '11

17 Jan '11

Hi, all. I achieved mailbox sharing with Dovecot & Roundcube webmail in iRedMail[1] today, just want to share you my experience, hope it helps. Although it's for iRedMail, but it doesn't depend on it. http://www.iredmail.org/wiki/index.php?title=IRedMail/FAQ/Share.IMAP.Folder It describes: - How to enable mailbox sharing in Dovecot - How to enable mailbox sharing in Roundcube webmail. - How to test mailbox sharing with telnet Requirements: - Dovecot >= 1.2 - Roundcube webmail >= 0.5 -stable release [1] iRedMail - Free, Open Source Email Server Solution: http://www.iredmail.org/

1 0

[Dovecot] Web Based User Management
by Matt 17 Jan '11

17 Jan '11

Does anyone know of a web GUI type application that would allow the creation and deletion of email accounts on an email server?

9 12

[Dovecot] Dovecot LDA problem: dovecot: deliver(dave): Fatal: postmaster_address setting not given
by Dave100 16 Jan '11

16 Jan '11

I have been trying to get the virtual domain and mailboxes working on an newly built Ubuntu 10.04 server and am stuck on this error. System is using a postgres database and PostfixAdmin. Thanks in advance for any help. Dave ==> /var/log/mail.err <== Jan 16 13:21:26 radius dovecot: deliver(dave(a)mydomain.com): Fatal: postmaster_address setting not given ==> /var/log/mail.log <== Jan 16 13:21:26 radius dovecot: auth(default): master in: USER#0111#011dave(a)mydomain.com#011service=deliver Jan 16 13:21:26 radius dovecot: auth(default): passwd(dave(a)mydomain.com): lookup Jan 16 13:21:26 radius dovecot: auth(default): passwd(dave(a)mydomain.com): unknown user Jan 16 13:21:26 radius dovecot: auth(default): sql(dave(a)mydomain.com): SELECT '/var/mail/mydomain.com/dave' as home, 'maildir:/var/mail/mydomain.com/dave' as mail, 150 AS uid, 8 AS gid FROM mailbox WHERE username = 'dave(a)mydomain.com' AND active = true Jan 16 13:21:26 radius dovecot: auth(default): master out: USER#0111#011dave@mydomain.com#011home=/var/mail/mydomain.com/dave#011mail=maildir:/var/mail/mydomain.com/dave#011uid=150#011gid=8 Jan 16 13:21:26 radius dovecot: deliver(dave(a)mydomain.com): Fatal: postmaster_address setting not given Jan 16 13:21:26 radius postfix/pipe[3213]: 54E024554: to=<dave(a)mydomain.com>, relay=dovecot, delay=21381, delays=21381/0.42/0/0.07, dsn=4.3.0, status=deferred (temporary failure) # 1.2.9: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-27-generic i686 Ubuntu 10.04.1 LTS log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap pop3 imaps pop3s managesieve listen: *,[::] ssl_cert_file: /etc/ssl/certs/ssl-mail.pem ssl_key_file: /etc/ssl/private/ssl-mail.key ssl_cipher_list: ALL:!LOW:!SSLv2:ALL:!aNULL:!ADH:!eNULL:!EXP:RC4+RSA:+HIGH:+MEDIUM login_dir: /var/run/dovecot/login login_executable(default): /usr/lib/dovecot/imap-login login_executable(imap): /usr/lib/dovecot/imap-login login_executable(pop3): /usr/lib/dovecot/pop3-login login_executable(managesieve): /usr/lib/dovecot/managesieve-login first_valid_uid: 150 first_valid_gid: 8 mail_privileged_group: mail mail_uid: vmail mail_gid: mail mail_location: maildir:~/Maildir mail_debug: yes mbox_write_locks: fcntl dotlock mail_executable(default): /usr/lib/dovecot/imap mail_executable(imap): /usr/lib/dovecot/imap mail_executable(pop3): /usr/lib/dovecot/pop3 mail_executable(managesieve): /usr/lib/dovecot/managesieve mail_plugin_dir(default): /usr/lib/dovecot/modules/imap mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3 mail_plugin_dir(managesieve): /usr/lib/dovecot/modules/managesieve imap_client_workarounds(default): outlook-idle delay-newmail imap_client_workarounds(imap): outlook-idle delay-newmail imap_client_workarounds(pop3): imap_client_workarounds(managesieve): pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh pop3_client_workarounds(managesieve): lda: postmaster_address: postmaster(a)mydomain.com hosthame: deliver_log_format: msgid=%m: %$ sendmail_path: /usr/lib/sendmail rejection_subject: Rejected: %s rejection_reason: Your message to <%t> was automatically rejected:%n%r auth_socket_path: /var/run/dovecot/auth-master mail_plugins: sieve quota_full_tempfail: yes deliver_log_format: msgid=%m: %$ rejection_reason: Your message to <%t> was automatically rejected:%n%r auth default: mechanisms: plain login verbose: yes debug: yes debug_passwords: yes passdb: driver: pam passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: passwd userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf socket: type: listen client: path: /var/spool/postfix/private/auth-client mode: 432 master: path: /var/run/dovecot/auth-master mode: 384 user: vmail group: mail socket: type: listen client: path: /var/spool/postfix/private/dovecot-auth mode: 432 user: postfix group: postfix plugin: quota: maildir:storage=10240:messages=1000 trash: /etc/dovecot/dovecot-trash.conf sieve: ~/.dovecot.sieve sieve_dir: ~/sieve

1 0

[Dovecot] Dovecot LDA problem: dovecot: deliver(dave): Fatal: postmaster_address setting not given
by David Mattox 16 Jan '11

16 Jan '11

I have been trying to get the virtual domain and mailboxes working on an newly built Ubuntu 10.04 server and am stuck on this error. System is using a postgres database and PostfixAdmin. Thanks in advance for any help. Dave ==> /var/log/mail.err <== Jan 16 13:21:26 radius dovecot: deliver(dave(a)mydomain.com): Fatal: postmaster_address setting not given ==> /var/log/mail.log <== Jan 16 13:21:26 radius dovecot: auth(default): master in: USER#0111#011dave(a)mydomain.com#011service=deliver Jan 16 13:21:26 radius dovecot: auth(default): passwd(dave(a)mydomain.com): lookup Jan 16 13:21:26 radius dovecot: auth(default): passwd(dave(a)mydomain.com): unknown user Jan 16 13:21:26 radius dovecot: auth(default): sql(dave(a)mydomain.com): SELECT '/var/mail/mydomain.com/dave' as home, 'maildir:/var/mail/mydomain.com/dave' as mail, 150 AS uid, 8 AS gid FROM mailbox WHERE username = 'dave(a)mydomain.com' AND active = true Jan 16 13:21:26 radius dovecot: auth(default): master out: USER#0111#011dave@mydomain.com#011home=/var/mail/mydomain.com/dave#011mail=maildir:/var/mail/mydomain.com/dave#011uid=150#011gid=8 Jan 16 13:21:26 radius dovecot: deliver(dave(a)mydomain.com): Fatal: postmaster_address setting not given Jan 16 13:21:26 radius postfix/pipe[3213]: 54E024554: to=<dave(a)mydomain.com>, relay=dovecot, delay=21381, delays=21381/0.42/0/0.07, dsn=4.3.0, status=deferred (temporary failure) # 1.2.9: /etc/dovecot/dovecot.conf # OS: Linux 2.6.32-27-generic i686 Ubuntu 10.04.1 LTS log_timestamp: %Y-%m-%d %H:%M:%S protocols: imap pop3 imaps pop3s managesieve listen: *,[::] ssl_cert_file: /etc/ssl/certs/ssl-mail.pem ssl_key_file: /etc/ssl/private/ssl-mail.key ssl_cipher_list: ALL:!LOW:!SSLv2:ALL:!aNULL:!ADH:!eNULL:!EXP:RC4+RSA:+HIGH:+MEDIUM login_dir: /var/run/dovecot/login login_executable(default): /usr/lib/dovecot/imap-login login_executable(imap): /usr/lib/dovecot/imap-login login_executable(pop3): /usr/lib/dovecot/pop3-login login_executable(managesieve): /usr/lib/dovecot/managesieve-login first_valid_uid: 150 first_valid_gid: 8 mail_privileged_group: mail mail_uid: vmail mail_gid: mail mail_location: maildir:~/Maildir mail_debug: yes mbox_write_locks: fcntl dotlock mail_executable(default): /usr/lib/dovecot/imap mail_executable(imap): /usr/lib/dovecot/imap mail_executable(pop3): /usr/lib/dovecot/pop3 mail_executable(managesieve): /usr/lib/dovecot/managesieve mail_plugin_dir(default): /usr/lib/dovecot/modules/imap mail_plugin_dir(imap): /usr/lib/dovecot/modules/imap mail_plugin_dir(pop3): /usr/lib/dovecot/modules/pop3 mail_plugin_dir(managesieve): /usr/lib/dovecot/modules/managesieve imap_client_workarounds(default): outlook-idle delay-newmail imap_client_workarounds(imap): outlook-idle delay-newmail imap_client_workarounds(pop3): imap_client_workarounds(managesieve): pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh pop3_client_workarounds(managesieve): lda: postmaster_address: postmaster(a)mydomain.com hosthame: deliver_log_format: msgid=%m: %$ sendmail_path: /usr/lib/sendmail rejection_subject: Rejected: %s rejection_reason: Your message to <%t> was automatically rejected:%n%r auth_socket_path: /var/run/dovecot/auth-master mail_plugins: sieve quota_full_tempfail: yes deliver_log_format: msgid=%m: %$ rejection_reason: Your message to <%t> was automatically rejected:%n%r auth default: mechanisms: plain login verbose: yes debug: yes debug_passwords: yes passdb: driver: pam passdb: driver: sql args: /etc/dovecot/dovecot-sql.conf userdb: driver: passwd userdb: driver: sql args: /etc/dovecot/dovecot-sql.conf socket: type: listen client: path: /var/spool/postfix/private/auth-client mode: 432 master: path: /var/run/dovecot/auth-master mode: 384 user: vmail group: mail socket: type: listen client: path: /var/spool/postfix/private/dovecot-auth mode: 432 user: postfix group: postfix plugin: quota: maildir:storage=10240:messages=1000 trash: /etc/dovecot/dovecot-trash.conf sieve: ~/.dovecot.sieve sieve_dir: ~/sieve

1 0

[Dovecot] Fatal crash during a user search
by Rick Romero 16 Jan '11

16 Jan '11

Well, it looks like it occurred during the search to me... Jan 10 17:05:37 sysvolone dovecot: [ID 583609 mail.crit] imap(user(a)host.com): Panic: file istream-header-filter.c: line 520 (i_stream_create_header_filter): assertion failed: (ret < 0) Jan 10 17:05:37 sysvolone dovecot: [ID 583609 mail.error] imap(user(a)host.com): Error: Raw backtrace: /usr/local/lib/dovecot/libdovecot.so.0.0.0'default_fatal_finish+0x3c [0xfee7b050] -> /usr/local/lib/dovecot/libdovecot.so.0.0.0'i_internal_fatal_handler+0x2b [0xfee7bbe7] -> /usr/local/lib/dovecot/libdovecot.so.0.0.0'0x3b239 [0xfee7b239] -> /usr/local/lib/dovecot/libdovecot.so.0.0.0'i_stream_create_header_filter+0x12f [0xfee6598b] -> /usr/local/lib/dovecot/libdovecot-storage.so.0.0.0'index_mail_get_header_stream+0x17c [0xfef050cc] -> /usr/local/lib/dovecot/libdovecot-storage.so.0.0.0'mail_get_header_stream+0x13 [0xfeee8b8b] -> /usr/local/lib/dovecot/libdovecot-storage.so.0.0.0'index_storage_search_next_nonblock+0x5bf [0xfef07807] -> /usr/local/lib/dovecot/libdovecot-storage.so.0.0.0'mailbox_search_next_nonblock+0x2a [0xfeeef4c6] -> /usr/local/libexec/dovecot/imap'cmd_search_more+0x78 [0x806516c] -> /usr/local/libexec/dovecot/imap'imap_search_start+0x18e [0x8065612] -> /usr/local/libexec/dovecot/imap'c Jan 10 17:05:37 sysvolone dovecot: [ID 583609 mail.error] master: Error: service(imap): child 7746 killed with signal 6 (core not dumped - set service imap { drop_priv_before_exec=yes }) I'm not sure if that gives you what you need - it looks like the entire dump didn't get saved. This is on OpenSolaris 5.11 snv_134 Rick

2 2

[Dovecot] mail to admin when quota exceeded
by Karolis Žvaigždinas 16 Jan '11

16 Jan '11

We're using Dovecot v1.2.15 LDA/IMAP/POP3+MySQL with quota plugin, quota_rule per-user size, quota_exceed_message and quota_warning on storage=90%%.with script. Everything is working as expected. But I've been asked to configure it the way, that when a user gets message, which would make his maildir over quota limit, notification go not only to sender, but also to postmaster(a)domain.com. Browsed wiki, mailinglist archive - couldn't find anything on that. Is there a way to implement such feature? And what about possibility to send a message to user, notifying him about rejected email "from: xxx(a)yyy.com" with "subj: blah blah" due to full mailbox? Such messages are small and would not take too much space. Thus the user would know what he misses, urging him to clean his mailbox. Thank you in advance. -- Karolis

3 3

[Dovecot] master: Error: service(imap): child 40100 killed with signal 11
by interfaSys sàrl 16 Jan '11

16 Jan '11

Hello, I've just updated to 2.0.9 and I've got lots of these in the logs now. Jan 13 18:57:13 master: Error: service(imap): child 40100 killed with signal 11 (core not dumped - set service imap { drop_priv_before_exec=yes }) Is there a configuration change or something else I should have done while updating? I tried to get some information by loading the binary into gdb and got this: (gdb) bt full #0 0x00000008007c71fc in kevent () from /lib/libc.so.7 No symbol table info available. #1 0x00000008005a8281 in io_loop_handler_run () from /usr/lib/dovecot/libdovecot.so.0 No symbol table info available. #2 0x0000000000000707 in ?? () No symbol table info available. #3 0x00000000000f4138 in ?? () No symbol table info available. #4 0x0000000000000707 in ?? () No symbol table info available. #5 0x000000003b96c2c0 in ?? () No symbol table info available. #6 0x0000000000000002 in ?? () No symbol table info available. #7 0x0000000800a1f040 in ?? () No symbol table info available. #8 0x0000000000000000 in ?? () No symbol table info available. #9 0x00007fffffffeccd in ?? () No symbol table info available. #10 0x00007fffffffe7c0 in ?? () No symbol table info available. #11 0x00000008005a83d8 in io_loop_run () from /usr/lib/dovecot/libdovecot.so.0 No symbol table info available. #12 0x0000000800a1a100 in ?? () No symbol table info available. #13 0x00000008005a8823 in master_service_run () from /usr/lib/dovecot/libdovecot.so.0 No symbol table info available. #14 0x0000000800a0f840 in ?? () No symbol table info available. #15 0x00000000004219d0 in main () No symbol table info available. This is on FreeBSD 8.1 with the gold linker (which still can't be used to compile pop3-login) and gcc 4.5.2. Cheers, Olivier

3 10