- dovecot - dovecot.org

[Dovecot] quota - dict - username = '(null)'
by Andreas Jørgensen 15 Mar '07

15 Mar '07

I am trying setting up at virtual domain with quota using postfix and dovecut. But I can't get the quota to work, every time I try sending a mail the following queries is run on the database. SELECT home, uid, gid FROM mail_view_tmp WHERE account = 'dummy' AND domain = 'example.com' SELECT current FROM mail_quota WHERE path = 'quota/storage' AND username = '(null)' BEGIN;INSERT INTO mail_quota (current, path, username) VALUES ('quota/ storage', 262, '(null)') ON DUPLICATE KEY UPDATE current = current + 262;COMMIT The mail is delivered, but the quota for the user is not updated. Instead I just have an other new row for the user (null). I am using the package dovecot-1.0.rc2p3-mysql on OpenBSD 4.0 for macppc My configuration: (posting the full content of alt the config files seemed unnecessary so I cut out the important bits) /etc/postfix/main.cf ... virtual_transport = dovecot /etc/postfix/master.cf : ... dovecot unix - n n - - pipe flags=DRhu user=vmail argv=/usr/local/libexec/dovecot/deliver -d $ {recipient} /etc/dovecot.conf .... protocol lda { mail_plugins = quota } .. auth default { user = root passdb sql { args = /etc/dovecot-mysql.conf } userdb static { args = uid=2000 gid=2000 home=/var/vmail/%d/%n/ } socket listen { master { path = /var/run/dovecot/auth-master mode = 0600 user = vmail group = vmail } } } dict { quota = mysql:/etc/dovecot-dict-quota.conf } plugin { quota = dict:storage=10240:messages=1000 proxy::quota } /etc/dovecot-mysql.conf: driver = mysql connect = host=localhost dbname=ingoBase user=dovecot password=dovecot default_pass_scheme = CRYPT password_query = SELECT password FROM mail_view_dovecot WHERE account = '%n' AND domain = '%d' user_query = SELECT home, uid, gid FROM mail_view_tmp WHERE account = '%n' AND domain = '%d' or account = '%u' /etc/dovecot-dict-quota.conf connect = host=localhost dbname=ingoBase user=dovecot password=dovecot table = mail_quota select_field = current where_field = path username_field = username Is there something wrong in my configuration or is this a bug in the version i am using ? Thanks in advance ! Andreas

2 1

[Dovecot] login authentication
by juan carlos 15 Mar '07

15 Mar '07

Hi everyone, i used postfix, dovecot and mysql. I have virtual users and domains. I have this configuration in dovecot-mysql.conf: db_host = localhost db_port = 3306 db_unix_socket = /var/run/mysqld/mysqld.sock db = postfix db_user = postfix db_passwd = bscidth46 db_client_flags = 0 default_pass_scheme = CRYPT password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT maildir, 105 AS uid, 106 AS gid FROM mailbox WHERE username = '%u' The table mailbox: +-------------------+--------------+------------------+-----------+------------+ | username | home | maildir | quota | domain | +-------------------+--------------+------------------+-----------+------------+ | test(a)domain.com | /home/vmail/ | domain.com/test/ | 10240000 | domain.com | | test2(a)domain.com | /home/vmail/ | domain.com/test2/ | 10240000 | domain.com | | test3(a)domain.com | /home/vmail/ | domain.com/test3/ | 10240000 | domain.com | +-------------------+--------------+-------------------+----------+------------+ I have this configuration in smtpd.conf: pwcheck_method: auxprop mech_list: LOGIN CRAM-MD5 DIGEST-MD5 GSSAPI auxprop_plugin: sql sql_verbose: yes sql_engine: mysql sql_hostnames: localhost sql_database: postfix sql_user: postfix sql_passwd: bscidth46 sql_select: select password from mailbox where username = '%u@%r' What can i do to log in with only user part of user(a)domain.com? Thanks in advance

3 2

Re: [Dovecot] imap-login (proxy) Connection queue full
by Bill Boebel 15 Mar '07

15 Mar '07

On Wed, March 14, 2007 1:57 pm, Timo Sirainen <tss(a)iki.fi> said: > On Thu, 2006-08-10 at 23:15 -0400, Bill Boebel wrote: >> On Thu, August 10, 2006 5:22 pm, Timo Sirainen <tss(a)iki.fi> said: >> >> >> Aug 10 16:23:34 director5 dovecot: imap-login: Disconnected: Connection queue >> >> full: >> >> >> >> I am seeing this logged several times per minute. From netstat, the server >> has >> >> 650 proxied IMAP connections and 450 proxied IMAPS connections, there are >> >> currently 10 imap-login processes running, and using the following config: >> > >> > I did some changes to CVS which hopefully should fix this? >> >> It is still disconnecting with "Connection queue full", although less frequently. >> Testing with about 315 IMAP connections right now and same config as earlier >> today, so it should never hit this condition, right? > > BTW. Does this still happen? No, however I haven't had to touch our Dovecot proxies in several months. They just work. We're still running a copy I pulled from CVS just before 1.0.rc8. We're running the new code only on our backend mail servers. I guess we should update our proxies soon. Bill

1 0

[Dovecot] Courier keywords - anyone even tried?
by Troy Engel 14 Mar '07

14 Mar '07

I do realize from the Wiki that the formats are incompatible, and am looking at the Courier spec (http://www.courier-mta.org/imap/?README.imapkeywords.html) and the Dovecot spec (http://wiki.dovecot.org/MailboxFormat/Maildir) trying to see if there's any sane way I could try and write a shellscript. The pain here is the Courier spec, I think I lost a few brain cells trying to understand this convoluted methodology ("When encountering ".N.file" after another ".N.file" was encountered earlier, remove the file with the lesser N, unless the larger of the two Ns is greater than or equals to T." e.g.) Has anyone even started down this path and has some prototype code written that they gave up on? Is this just so painful trying to migrate that I should just give up? Any ideas welcome... -te -- Troy Engel | Systems Engineer Fluid, Inc | http://www.fluid.com

2 1

[Dovecot] Benchmarking CVS HEAD vs. v1.0
by Timo Sirainen 14 Mar '07

14 Mar '07

Some new features in CVS HEAD are: - v1.0 saves most of the data to dovecot.index.cache only when the client is FETCHing the messages. With mboxes the message headers are saved while parsing the mbox, which is almost the same thing. With CVS HEAD the dovecot.index.cache file is updated already when the new messages are being saved (with deliver or IMAP APPEND). This avoids reading the message second time (although if client fetches the new message bodies immediately it doesn't probably help that much). - Mailbox list index. LIST command can be handled by reading the mailboxes from the index. The index also contains the mailbox's message counters, so STATUS command can be handled by only looking into the index file. - Multiple commands can be handled simultaneously. For example you can start a long running SEARCH command and then at the same time continue FETCHing new messages. Or if you're doing a long FETCH (eg. fetching all message bodies) you can do a smaller FETCH while the long one is still running, and get the result in the middle of the long running FETCH reply. There are also indexing support for SORT and THREAD, and full text search indexes for SEARCH BODY/TEXT, but I didn't benchmark these now. It looks like CVS HEAD is quite a lot faster than v1.0. I think that's mostly because of the APPEND optimization. Here are the results: 100MB ext3 filesystem inside a file in XFS. C: CVS HEAD, fsync_disable=yes, mmap_disable=yes S: CVS branch_1_0 (upcoming 1.0.rc28), fsync_disable=yes, mmap_disable=yes ./imaptest seed=1 secs=60 Logi List Stat Sele Fetc Fet2 Stor Dele Expu Appe Logo C: 11275 5647 5597 11275 11264 16179 5571 4126 11256 6074 22531 C: 11287 5740 5606 11287 11275 16193 5698 4154 11267 6064 22553 S: 9201 4660 4575 9197 9190 13107 4614 2843 9184 3601 18382 S: 9271 4701 4657 9267 9260 13189 4580 2799 9256 3540 18522 82% 82% 59% ./imaptest seed=1 secs=60 no_pipelining Logi List Stat Sele Fetc Fet2 Stor Dele Expu Appe Logo C: 5756 2856 2795 5756 5747 8087 2796 1942 5746 5081 11489 C: 5779 2865 2872 5777 5768 8273 2929 1965 5768 5138 11532 S: 5016 2564 2467 5016 5008 7090 2512 1756 5006 4116 10012 S: 5009 2529 2481 5008 4999 7142 2503 1734 4997 4165 9998 87% 89% 81% ---------- Trying to see how much mailbox list indexing code affects the results by disabling LIST and STATUS (which means that CVS HEAD is doing more I/O by updating the list indexes which are never used). Looks like the indexes do help some, since CVS HEAD is ~5% less faster now. ./imaptest seed=1 secs=60 list=0 status=0 Logi Sele Fetc Fet2 Stor Dele Expu Appe Logo C: 11435 11432 11422 16341 5639 4122 11415 5941 22848 S: 9984 9984 9976 14347 5013 2987 9967 3840 19947 87% 65% ./imaptest seed=1 secs=60 list=0 status=0 no_pipelining Logi Sele Fetc Fet2 Stor Dele Expu Appe Logo C: 5778 5778 5768 8105 2922 2021 5767 5107 11533 S: 5240 5239 5230 7384 2525 1823 5229 4343 10460 90% 85% --------------- Any difference with just one client instead of 10 simultaneously running? Looks like with pipelining CVS HEAD is now even faster, but without pipelining it's a bit slower. I'm not sure why. I tried with different max. command queue lengths with CVS HEAD. The C1, C4 and C8 mean queue lengths of 1, 4 and 8 commands. 1 practically disables it, so it runs like v1.0. Doesn't look like the queue length makes much of a different. ./imaptest seed=1 secs=60 list=0 status=0 clients=1 Logi Sele Fetc Fet2 Stor Dele Expu Appe Logo C4: 9968 9968 9967 14244 5020 2664 9967 2990 19934 S : 6510 6510 6508 9340 3216 1729 6508 1942 13017 65% 63% C1: 9956 9956 9954 14314 4959 2642 9954 2987 19907 C4: 9968 9968 9967 14244 5020 2664 9967 2990 19934 C8: 9978 9978 9976 14329 4848 2618 9976 2962 19953 ./imaptest seed=1 secs=60 list=0 status=0 clients=1 no_pipelining Logi Sele Fetc Fet2 Stor Dele Expu Appe Logo C: 1942 1942 1941 2711 962 508 1941 605 3882 S: 1868 1868 1867 2669 965 520 1866 618 3734 96% 102% --------------- mmap_disable=no seems to work more slowly after all even with etx3..: Logi List Stat Sele Fetc Fet2 Stor Dele Expu Appe Logo C: 8254 4150 4139 8254 8244 11813 4126 2791 8234 3658 16487 S: 7833 3940 3910 7829 7821 11243 3846 2345 7816 2966 15646 95% 81%

2 1

Re: [Dovecot] imap-login (proxy) Connection queue full
by Bill Boebel 14 Mar '07

14 Mar '07

On Thu, August 10, 2006 5:22 pm, Timo Sirainen <tss(a)iki.fi> said: >> Aug 10 16:23:34 director5 dovecot: imap-login: Disconnected: Connection queue >> full: >> >> I am seeing this logged several times per minute. From netstat, the server has >> 650 proxied IMAP connections and 450 proxied IMAPS connections, there are >> currently 10 imap-login processes running, and using the following config: > > I did some changes to CVS which hopefully should fix this? It is still disconnecting with "Connection queue full", although less frequently. Testing with about 315 IMAP connections right now and same config as earlier today, so it should never hit this condition, right? The weird thing is sometimes when I am testing via telnet, my session encounters this condition and disconnects within the first 5 seconds. It does this with and without these patches. Bill

2 1

[Dovecot] Sieve plugin - install help - filters ignored
by Brent Hostetler 14 Mar '07

14 Mar '07

Hello, My setup consists of the following: * Freebsd 6.2 system with software installed from ports tree: * Postfix 2.3.8,1 * postfixadmin 2.1.0_7 * mysql 5.0.33 * dovecot-1.0.r25 * dovecot-sieve 1.0.1 * clamav 0.90_3 * SpamAssassin 3.1.8_1 * amavisd-new 2.4.5_1,1 My mail setup is a virtual user setup with all users/domains sharing same UID:GID. Postfix and dovecot get their User information from mysql tables that are administered with postfixadmin. Mail is filtered through clamav and spamassassin using amavisd-new setup as a content filter. All users mail is delivered such as their maildir is /usr/local/vmail/%d/%u using dovecot's lda 'deliver' agent. The system is working fine as configured.. Mail goes where it is supposed to. Trying to get sieve support and unable to get this going. First step is simulating home directories. >From dovecot-mysql.conf ... changed user_query to user_query = SELECT maildir, 5000 AS uid, 5000 AS gid, @home := maildir AS home FROM mailbox WHERE username = '%u' Added the following to a users maildir: .dovecot.sieve require "fileinto"; fileinto "test"; --- Restart all daemons.. Mail still delivers to inbox. Nothing appears in /var/log/maillog or /usr/local/vmail/dovecot-deliver.log that shows anything but the message being delivered to the inbox. HELP! Brent.

4 5

[Dovecot] userdb-vpopmail.c bug in rc27
by Gabor HALASZ 14 Mar '07

14 Mar '07

Hi! I discovered a bug in $subject. Next line caused a compilation error: auth_request_log_debug(auth_request, "vpopmail", "lookup user=%s domain=%s", vpop_user, vpop_domain); I think, te correct version is: auth_request_log_debug(request, "vpopmail", "lookup user=%s domain=%s", vpop_user, vpop_domain); -- Gabor HALASZ <halasz.g(a)freemail.hu>

2 1

[Dovecot] Variable %h not recognized in userdb_mail (passwd-file)
by Michal Soltys 14 Mar '07

14 Mar '07

As in subject, if you for instance create a simple passwd-file with: test@domain.tld:{plain}pass:20000:10::/home/regular/.test::userdb_mail=maildir:%h/maildir Dovecot (rc23 & 27) will expand %h to empty string, and try to make a directory under / Mar 14 14:25:28 rasengan dovecot: IMAP(test(a)domain.tld): mkdir(/maildir/cur) failed: Permission denied Mar 14 14:25:28 rasengan dovecot: IMAP(test(a)domain.tld): mkdir(/maildir/.Trash/cur) failed: Permission denied ... If tilde is used instead of %h, the expansion works properly. While checking it, I tested other variables (putting aside craziness of using some of them), so summing it up - h,w,i,a,b don't work, all the other ones do. In case %h is not actually intended to work in passwd-files, some wiki examples would have to be adjusted.

2 4

[Dovecot] Issue with pop3 & phpList
by Chris Harner 14 Mar '07

14 Mar '07

Hello, all. Dovecot really sparked my interest when I noticed it focused on security. It seems to be a great product thus far. Anyway... I'm new to the mail world (pop3/smtp), and I have a project in which I use a mass mailer known as phpList. If you aren't familiar with it, it has the ability to view and process bounces. Bounces are basically emails that don't quite make it (for the most part). In order for this to work, I must create a pop3 account. I installed Dovecot and now the port is open, which means the service is running. Here is where it gets confusing... When I goto process the bounces, it times out because of the fact that there were too many login attempts. Does dovecot have a default username/password? How do I set up a username and password? Is there a special way to just have the pop3 portion of Dovecot load? I went through the config file and took out some of the #'s like the docs said. Thanks! Server: OpenSUSE 10.1 -- Chris Harner [] Server Engineer [] Arnold Transportation Services

2 1