- dovecot - dovecot.org

[Dovecot] Quota in mysql dict not properly recalculated on 1.2?
by Joan 02 Jul '10

02 Jul '10

Good morning, I am trying to add quota storage on mysql following the guide in the wiki http://wiki.dovecot.org/Quota/Dict, and I am having some problems. My setup works fine for the newly created accounts, and correctly increases/decreases quota when necessary. The wrong part seems to be the recalculation. It seems to me that the system doesn't count the real occupation when it has to recreate the quota entry for a username. This is the case: .- User test(a)testing.com has a quota 200000 bytes, I delete the entry of the database for user, and then when I do the: echo 'x GETQUOTAROOT Inbox' | USER=test(a)testing.com /usr/sbin/dovecot --exec-mail imap .- These are ALL the queries I see, I am missing the userdb queries to get the real quota. INSERT INTO quota_dovecot (bytes,username) VALUES ('0','test(a)testing.com') ON DUPLICATE KEY UPDATE bytes='0' INSERT INTO quota_dovecot (messages,username) VALUES ('0','test(a)testing.com') ON DUPLICATE KEY UPDATE messages='0' COMMIT SELECT bytes FROM quota_dovecot WHERE username = 'test(a)testing.com' SELECT messages FROM quota_dovecot WHERE username = 'test(a)testing.com' .- And the result also seems to indicate that it's not reading the quota from userdb * PREAUTH [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS MULTIAPPEND UNSELECT IDLE CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS QUOTA] Logged in as test(a)testing.com * QUOTAROOT "Inbox" "user" * QUOTA "user" (STORAGE 0 1048576) x OK Getquotaroot completed. It seems to me that dovecot --exec-mail doesn't do the mysql lookups to get the usersdb. Note: attached are my dovecot -n output and the relevant .conf files

2 4

[Dovecot] Per-user quotas aren't working
by Guillaume CHARREYRON 02 Jul '10

02 Jul '10

Hello I tried to get per-user quotas working. The global quota is working well, but I can't get the one work on my test user: dovecot -n # 1.1.20: /etc/dovecot.conf # OS: Linux 2.6.18-164.el5 i686 Red Hat Enterprise Linux Server release 5.4 (Tikanga) log_path: /var/log/dovecot.log info_log_path: /var/log/dovecot.info.log protocols: pop3 login_dir: /var/run/dovecot/login login_executable: /usr/libexec/dovecot/pop3-login login_greeting: test-POP3 READY mail_location: maildir:~/Maildir mail_executable: /usr/libexec/dovecot/pop3 mail_plugins: quota mail_plugin_dir: /usr/lib/dovecot/pop3 pop3_client_workarounds: outlook-no-nuls oe-ns-eoh lda: postmaster_address: grog(a)test.mymail.srv mail_plugins: quota auth default: verbose: yes debug: yes debug_passwords: yes passdb: driver: passwd-file args: /etc/password.pop3 userdb: driver: passwd-file args: /etc/password.pop3 plugin: quota: maildir:User quota quota_rule: *:storage=10M quota_rule2: Trash:storage=1M with users line in my password.pop3 like this: test-oper:{plain}test-oper:501:501::/home/test-oper::userdb_quota_rule=*:bytes=2 0M allow_nets=192.168.4.0/24 I know that this file is well understood since the allow_nets works well. But I don't know why, the specific user quota rule isn't taken. I also use the Dovecot deliver process. Here is the info log: dovecot: Jul 02 12:55:32 Info: auth(default): passwd-file(test-oper,192.168.4.239): lookup: user=test-oper file=/etc/password.pop3 dovecot: Jul 02 12:55:32 Info: auth(default): auth(test-oper,192.168.4.239): allow_nets: Matching for network 192.168.4.0/24 dovecot: Jul 02 12:55:32 Info: auth(default): client out: OK 1 user=test-oper dovecot: Jul 02 12:55:32 Info: auth(default): master in: REQUEST 1 4521 1 dovecot: Jul 02 12:55:32 Info: auth(default): passwd-file(test-oper,192.168.4.239): lookup: user=test-oper file=/etc/password.pop3 dovecot: Jul 02 12:55:32 Info: auth(default): master out: USER 1 test-oper uid=501 gid=501 home=/home/test-oper quota_rule=*:bytes=20M dovecot: Jul 02 12:55:32 Info: pop3-login: Login: user=<test-oper>, method=PLAIN, rip=192.168.4.239, lip=192.168.4.239, secured deliver(test-oper): Jul 02 12:55:47 Info: msgid=<11c5.0003.0000(a)test.mymail.srv>: save failed to INBOX: Quota exceeded (mailbox for user is full) deliver(test-oper): Jul 02 12:55:47 Info: msgid=<11c5.0003.0000(a)test.mymail.srv>: rejected: Quota exceeded (mailbox for user is full) deliver(grog): Jul 02 12:55:47 Info: msgid=<dovecot-1278068147-645784-0(a)test.mymail.srv>: saved mail to INBOX dovecot: Jul 02 12:56:13 Info: POP3(test-oper): Disconnected: Logged out top=0/0, retr=0/0, del=0/15, size=13816325 The corresponding maildirsize still show the global quota, and not the "test-oper" one: more /home/test-oper/Maildir/maildirsize 10485760S 13643547 15 I also tried to delete it, restart dovecot service, the result is the same. Do you have any idea? Guillaume

2 3

[Dovecot] do Dovecot userdb and passwd filles need to be postmap'd
by Hans Neukomm 02 Jul '10

02 Jul '10

Hi all I am unsure if dovecot files like userdb and passwd also need to be postmap'd i.e. postmap userdb or userdb passwd when I use the typical data format for creating userdp postmap outputs the error > postmap userdb postmap: warning: userdb, line 1: expected format: key whitespace value a clarification is welcome greetings hans

2 2

[Dovecot] address extension going into folder
by Phil Howard 01 Jul '10

01 Jul '10

Is it possible with a simple config change to make address extensions, e.g. alice+sales(a)example.com, go into a folder, e.g. .INBOX.sales, and do so ONLY if that folder already exists (and just go into INBOX if it does not exist)?

2 4

[Dovecot] Upgrade Too 1.2.11 Broke Everything
by Marcel Grandemange 01 Jul '10

01 Jul '10

Good Day. I have had dovecot working successfully for years now, however after a system update , dovecot refused to start up complaing that im not using absolute paths. It took a bit of hacking to get it working again as can be seen by the sql query, however now imap doesn't work anymore because of that change. Im lost!! dovecot --version 1.2.11 dovecot -n # 1.2.11: /usr/local/etc/dovecot.conf # OS: FreeBSD 8.1-PRERELEASE amd64 protocols: imap pop3 listen(default): * listen(imap): * listen(pop3): *:110 ssl: no disable_plaintext_auth: no login_dir: /var/run/dovecot/login login_executable(default): /usr/local/libexec/dovecot/imap-login login_executable(imap): /usr/local/libexec/dovecot/imap-login login_executable(pop3): /usr/local/libexec/dovecot/pop3-login login_greeting: thavinci Ready verbose_proctitle: yes first_valid_uid: 125 first_valid_gid: 125 mail_access_groups: postfix mail_privileged_group: postfix mail_location: mbox:~:INBOX=/var/mail/%u mail_executable(default): /usr/local/libexec/dovecot/imap mail_executable(imap): /usr/local/libexec/dovecot/imap mail_executable(pop3): /usr/local/libexec/dovecot/pop3 mail_plugin_dir(default): /usr/local/lib/dovecot/imap mail_plugin_dir(imap): /usr/local/lib/dovecot/imap mail_plugin_dir(pop3): /usr/local/lib/dovecot/pop3 imap_client_workarounds(default): delay-newmail outlook-idle netscape-eoh tb-extra-mailbox-sep imap_client_workarounds(imap): delay-newmail outlook-idle netscape-eoh tb-extra-mailbox-sep imap_client_workarounds(pop3): pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh lda: postmaster_address: postmaster(a)example.com sendmail_path: /usr/sbin/sendmail auth default: passdb: driver: sql args: /usr/local/etc/dovecot-mysql.conf passdb: driver: sql args: /usr/local/etc/dovecot-mysql.conf userdb: driver: sql args: /usr/local/etc/dovecot-mysql.conf userdb: driver: sql args: /usr/local/etc/dovecot-mysql.conf In regards to this file the following was changed to make it work... mail_location = mbox:~:INBOX=/var/mail/%u Used to be: mail_location = mbox:~/mail/:INBOX=/var/mail/%u grep -v '^ *$#.*$\?$' dovecot-mysql.conf driver = mysql default_pass_scheme = CRYPT connect = host=xx.xx.xx.xx dbname=nameofdb user=dbuser password=dbpassword password_query = SELECT password FROM mailbox WHERE username = '%u' AND active = '1' user_query = SELECT maildir, concat('/var/mail/',maildir) AS home, 125 AS uid, 125 AS gid FROM mailbox WHERE username = '%u' AND active = '1' This query used to be: user_query = SELECT maildir, maildir AS home, 125 AS uid, 125 AS gid FROM mailbox WHERE username = '%u' AND active = '1' A snapshot of the maillog during failure Jun 29 11:50:15 thavinci postfix/qmgr[1469]: BA3DD9B4C9: removed Jun 29 11:50:49 thavinci dovecot: imap-login: Login: user=<me(a)thavinci.za.net>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Jun 29 11:50:49 thavinci dovecot: IMAP(me(a)thavinci.za.net): Connection closed bytes=53/372 Jun 29 11:52:05 thavinci dovecot: imap-login: Login: user=<me(a)thavinci.za.net>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Jun 29 11:52:05 thavinci dovecot: IMAP(me(a)thavinci.za.net): Connection closed bytes=53/372 Jun 29 11:52:05 thavinci dovecot: imap-login: Login: user=<me(a)thavinci.za.net>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured Jun 29 11:52:05 thavinci dovecot: IMAP(me(a)thavinci.za.net): stat(/var/mail/me(a)thavinci.za.net/.imap/INBOX) failed: Not a directory Jun 29 11:52:05 thavinci last message repeated 2 times Jun 29 11:52:05 thavinci dovecot: IMAP(me(a)thavinci.za.net): open() failed with subscription file /var/mail/me(a)thavinci.za.net/.subscriptions: Not a directory Jun 29 11:52:05 thavinci dovecot: IMAP(me(a)thavinci.za.net): Connection closed bytes=306/4046 As can be seen somehow it's trying to write to the mbox file and I have no idea why! And this is the db structure! SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `mailbox_copy` -- ---------------------------- DROP TABLE IF EXISTS `mailbox_copy`; CREATE TABLE `mailbox_copy` ( `username` varchar(255) NOT NULL DEFAULT '', `password` varchar(255) NOT NULL DEFAULT '', `name` varchar(255) NOT NULL DEFAULT '', `maildir` varchar(255) NOT NULL DEFAULT '', `quota` int(10) NOT NULL DEFAULT '0', `domain` varchar(255) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`username`), KEY `username` (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Mailboxes'; -- ---------------------------- -- Records of mailbox_copy -- ----------------------------

4 4

[Dovecot] Dovecot LDA/LDAP
by Frank den Hartog 01 Jul '10

01 Jul '10

I'm a total newbie with Dovecot LDA and LDAP. To be honoust, I don't know what I'm doing. My system runs CentOS 5.5, Postfix 2.3.3 and Dovecot 1.2.11. I try to set up Dovecot LDA. But whatever I'm trying, I fail. 2010-06-30T18:28:12.585128+02:00 h1690641 postfix/pipe[26443]: 84F012A00A55: to=<test(a)domain.com>, relay=dovecot, delay=0.07, delays=0.03/0.01/0/0.02, dsn=5.1.1, status=bounced (user unknown) My current situation: I'm using at the current server OpenLDAP, Postfix and Dovecot with the Postfix LDA. It works fine, but I want to use sieve. I've setup a second server. I'm using my current OpenLDAP directory. The configurations: /etc/dovecot.conf # 1.2.11: /etc/dovecot.conf # OS: Linux 2.6.18-028stab064.7 i686 CentOS release 5.5 (Final) reiserfs 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 mail_location: maildir:/home/vmail/%i/Maildir/ mail_executable(default): /usr/libexec/dovecot/imap mail_executable(imap): /usr/libexec/dovecot/imap mail_executable(pop3): /usr/libexec/dovecot/pop3 mail_plugin_dir(default): /usr/lib/dovecot/imap mail_plugin_dir(imap): /usr/lib/dovecot/imap mail_plugin_dir(pop3): /usr/lib/dovecot/pop3 imap_client_workarounds(default): delay-newmail outlook-idle netscape-eoh imap_client_workarounds(imap): delay-newmail outlook-idle netscape-eoh imap_client_workarounds(pop3): pop3_client_workarounds(default): pop3_client_workarounds(imap): pop3_client_workarounds(pop3): outlook-no-nuls oe-ns-eoh namespace: type: private separator: / location: maildir:/home/vmail/%i/Maildir/ inbox: yes hidden: yes list: yes subscriptions: yes lda: postmaster_address: postmaster(a)cocamsterdam.net sendmail_path: /usr/lib/sendmail auth_socket_path: /var/run/dovecot/auth-master auth default: passdb: driver: ldap args: /etc/dovecot-ldap.conf userdb: driver: ldap args: /etc/dovecot-ldap.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 /etc/dovecot-ldap.conf hosts = host.server.com dn = cn=Manager,dc=domain,dc=com dnpass = blabla ldap_version = 3 base = dc=domain,dc=com user_attrs = homeDirectory=home,uidNumber=uid,gidNumber=gid user_filter = (&(objectClass=posixAccount)(uid=%u)) pass_attrs = uid=user,userPassword=password,\ homeDirectory=userdb_home,uidNumber=userdb_uid,gidNumber=userdb_gid pass_filter = (&(objectClass=posixAccount)(uid=%u)) /etc/postfix/main.cf (Virtual settings) virtual_alias_domains = $virtual_alias_maps virtual_alias_expansion_limit = 1000 virtual_alias_maps = $virtual_maps virtual_alias_recursion_limit = 1000 virtual_destination_concurrency_limit = $default_destination_concurrency_limit virtual_destination_recipient_limit = $default_destination_recipient_limit virtual_gid_maps = static:12 virtual_mailbox_base = /home/vmail/ virtual_mailbox_domains = /etc/postfix/domains.cf virtual_mailbox_limit = 51200000 virtual_mailbox_lock = fcntl virtual_mailbox_maps = ldap:/etc/postfix/ldap-users.cf virtual_minimum_uid = 100 virtual_transport = dovecot virtual_uid_maps = static:500 /etc/postfix/master.cf (Dovecot settings) dovecot unix - n n - - pipe flags=DRhu user=vmail:vmail argv=/usr/libexec/dovecot/deliver -f ${sender} -d ${recipient} /etc/postfix/domains.cf domain.com /etc/postfix/ldap-users.cf server_host = host.domain.com search_base = dc=domain,dc=com version = 3 query_filter = (&(objectclass=person)(mail=%s)) result_attribute = uid result_format = %s/Maildir/ I've used http://www.linuxmail.info as an example. That works fine, but I want more.

2 1

[Dovecot] Can't establish Dovecot authorization in Exim.
by 秋元亮二 30 Jun '10

30 Jun '10

Hi, I have some problem in Dovecot authorization in Exim for outgoing SMTP. Version of Exim is 4.69 and the Exim was compiled with "AUTH_DOVECOT=yes" and "AUTH_PLAINTEXT=yes". Version of Dovecot is 1.2.12. I use SSL for IMAP. Is Exim neccesary to use SSL(TLS) for authorization of outgoing SMTP? Configuration files is as follows; - Exim ---------------------------------------------------------- dovecot_login: driver = dovecot public_name = LOGIN server_socket = /var/run/dovecot/auth-client server_set_id = $auth1 dovecot_plain: driver = dovecot public_name = PLAIN server_socket = /var/run/dovecot/auth-client server_set_id = $auth2 ---------------------------------------------------------- - Dovecot ---------------------------------------------------------- auth default { mechanisms = plain login passdb pam { args = cache_key=%u dovecot } userdb passwd { } socket listen { #master { #} client { path = /var/run/dovecot/auth-client mode = 0666 } } } ---------------------------------------------------------- Do I have to set other than that, like TLS for Exim? Thanks in advance. _________________________________________________________________ Hotmailがサクサク動く！フィッシング詐欺も怖くない http://o.jp.msn.com/ie8/

3 4

[Dovecot] "forgot my password" feature
by Mustafa Cagatayli 30 Jun '10

30 Jun '10

Hi, We have a mail server with the postfix/Squirrelmail/Dovecot(v.1.1.11) combination which we have user data on MySQL through virtual users. We have configured the SquirrelMail interface so that users can now change their own passwords. Is there any opensource solution to provide "self service password management" which would allow us to add the "I forgot my password. Lets reset it" feature which would do the authentication with the help of some random personal data or personal question/answer combination ? Regards. -- Mustafa Çağataylı BİM

2 1

[Dovecot] Work with auth socket
by Неворотин Вадим 30 Jun '10

30 Jun '10

---------- Forwarded message ---------- From: Неворотин Вадим <nevorotin(a)gmail.com> Date: 2010/6/29 Subject: Re: [Dovecot] Work with auth socket To: Steffen Kaiser <skdovecot(a)smail.inf.fh-brs.de> Hmm, I have some problems with realization of authentication throw dovecot socket. I've wrote such script: #!/usr/bin/perl $login = "test"; $passwd = "test"; #utf8::encode($login); # I don't know are we really need it #utf8::encode($passwd); my $service = "ejabberd"; my $timeout = 1; my $socket = '/var/spool/postfix/private/auth-client'; my $sock = new IO::Socket::UNIX(Type => SOCK_STREAM, Peer => $socket) or die "Can't open socket."; my $sel = new IO::Select($sock); while (1) { $sel->can_read($timeout) or last; defined recv($sock, my $buf, 256, 0) or warn 'Error while reading response'; print $buf; } send($sock,"VERSION\t1\t0\nCPID\t$$\n",0) or die "Can't write to $socket"; my $base64 = encode_base64("\0$login\0$passwd"); $sock->send("AUTH\t1\tPLAIN\tservice=$service\tsecured\tresp=$base64\n") or die "Can't write to $socket"; my $i = 10; while ($i--) { $sel->can_read($timeout) or last; # "Timed out while waiting for response"; defined recv($sock, my $buf, 256, 0) or warn 'Error while reading response'; print $buf; } And has such log: # ./test.pl MECH PLAIN plaintext MECH LOGIN plaintext VERSION 1 0 SPID 26023 CUID 1818 DONE So dovecot doesn't answer anything after AUTH command. May be http://wiki.dovecot.org/Authentication%20Protocol is not fully describe auth protocol? 2010/6/24 Неворотин Вадим <nevorotin(a)gmail.com> Thank you! > > > 2010/6/24 Steffen Kaiser <skdovecot(a)smail.inf.fh-brs.de> > > -----BEGIN PGP SIGNED MESSAGE----- >> Hash: SHA1 >> >> On Thu, 24 Jun 2010, Неворотин Вадим wrote: >> >> >> I need to use Dovecot auth socket from my perl script to validate user's >>> passwords (for jabber server). Is there any information about how to >>> communicate with dovecot auth socket? >>> >>> >> >> http://search.cpan.org/~sasha/Authen-SASL-Authd-0.04/lib/Authen/SASL/Authd.… >> >> "NAME >> >> Authen::SASL::Authd - Client authentication via Cyrus saslauthd or Dovecot >> authentication daemon." >> >> http://wiki.dovecot.org/Authentication+Protocol >> >> Regards, >> >> - -- Steffen Kaiser >> -----BEGIN PGP SIGNATURE----- >> Version: GnuPG v1.4.6 (GNU/Linux) >> >> iQEVAwUBTCNOy7+Vh58GPL/cAQJXEQf/SHlQTrUo/OiNFSLteEuF6kGGY/iYGYZ2 >> CUEKLJQtE92yyGJqt7CYun3Z64llrkzYUGoJDnyPtEFgP2a1uqaEUyusilobuYfB >> E/B7zdRbHOD2+4afdwHocGundcfWB2GxZi+j454rCDWt5haX+cSd5Be561WdpyE0 >> yUc3raXLRz6qeRC/A+vmpbA4sbmm+Fd1fCHtwcQhOVvk+X7fJRLb30HUq1wRjyMi >> LBTv5TxCib+O34MPYpA6xLyrNCkjwAuhdshiw6KihVBx29U9HcoNtUIjfSqL6/gG >> vhKt6RfgahpytJm97LuDwE7GNf6/3oDeHlTJfAS5EfYdSqcnxxyfLw== >> =1C+5 >> -----END PGP SIGNATURE----- >> > >

3 4

[Dovecot] Expunge email Plugin
by Alex Baule 29 Jun '10

29 Jun '10

Hello everyone..... I Need to know when a email is expunge, but i don't need change this action. I Need to call another action + the default action. There is a plugin to do this ?

5 11