- dovecot - dovecot.org

[Dovecot] dovecot lda aliases doesn't work
by Selcuk MIYNAT 28 Apr '11

28 Apr '11

Hi, I am trying to use dovecot as lda. I have put this line in my .qmail-default file: #|/var/qmail/bin/preline -f /usr/local/libexec/dovecot/dovecot-lda -d $EXT@$USER It is working correct with real addresses but couldn't find forwarding addresses. This is my /usr/local/etc/dovecot-sql.conf: driver = mysql connect = host=localhost user=vpopmailuser password=vpopmailpassword dbname=vpopmail default_pass_scheme = PLAIN password_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user, pw_clear_passwd AS password FROM vpopmail WHERE pw_name = '%n' AND pw_domain = '%d' user_query = SELECT pw_dir as home, 89 AS uid, 89 AS gid FROM vpopmail WHERE pw_name = '%n' AND pw_domain = '%d' It is querying vpopmail table all the time but forwarding addresses are in the valias table, so it couldn't find forwarding addresses. How can I solve this? -- Selcuk MIYNAT Endersys Ltd. Sistem Destek Muhendisi / System Support Engineer Phone : +90 216-4709423 | Fax : +90 216-4709508 Web : http://www.endersys.com.tr Blog : http://blog.endersys.com Twitter : http://www.twitter.com/endersys LPI : The #1 Linux Certification for IT Professionals LPI (Linux Professional Institute) Turkey http://www.lpi-turkey.com Endersys is the first Advanced Business Partner of Red Hat in Turkey ! http://www.europe.redhat.com/partners/endersys/

2 1

[Dovecot] What is the recommended way to move a message from one mailbox to another using CLI
by Uffe Jakobsen 27 Apr '11

27 Apr '11

What is the recommended way to move a message from one mailbox to another using CLI - serverside commands ? Since IMAP does not support transactional moves between mailboxes - The only thing that comes to my mind is this operation: 1) extract message from mailbox A using "doveadm fetch" 2) inject message into mailbox B using "dovecot-lda" 3) expunge message from mailbox A using "doveadm expunge" it this the right solution ? One problem with above approach is that injecting through "dovecot-lda" will trigger the sieve script - which I'm not interested in since the message have already been injected and processed once before - at delivery... Any advice is much welcome -- View this message in context: http://old.nabble.com/What-is-the-recommended-way-to-move-a-message-from-on… Sent from the Dovecot mailing list archive at Nabble.com.

3 3

[Dovecot] What is the recommended way to delete a message from a mailbox ?
by Uffe Jakobsen 27 Apr '11

27 Apr '11

Hi, I'm implementing a shell-script (pseudo) solution to the missing IMAP Outbox feature in Dovecot (Courier IMAP feature http://www.inter7.com/courierimap/INSTALL.html#imapsend) In order to remove the message from the Outbox once it is sent I have a question: What is the recommended way to delete a message from a mailbox (from an "external" server side program - such as a shell script) ? Can I just remove the file from the mailbox - I cannot seem to find any doveadm commands that does this task. I guess that Dovecot over time will discover that the atime and mtime of its indexes and maps does not reflect reality - or is there another (better) way to delete a message. Thanks Uffe -- View this message in context: http://old.nabble.com/What-is-the-recommended-way-to-delete-a-message-from-… Sent from the Dovecot mailing list archive at Nabble.com.

2 2

Re: [Dovecot] dovecot & OCFS2 Cluster
by Joseph Tam 27 Apr '11

27 Apr '11

Robert Schetterer <robert(a)schetterer.org> writes: >> Anyway, why use lmtp over lda ? > > i.e avoid backscatter by overquota A clarification on this: backscatter (or rather, ambiguous NDR notices that claim many users are over quota rather than just one) is a result of a local mailer that support multiple recipient delivery in one invocation, but can only return one result code to the MTA. Since Dovecot's deliver-lda does not support multiple recipient delivery, this is not a problem. LMTP can support multiple deliveries of the same message per invocation, but replies with individual SMTP codes to avoid the above problem. It can take advantage of this to efficiently implement single instance storage if it is enabled. > performance should better too Apart from multiple deliveries or SIS, I'm not sure this is true, or significant if it were. Joseph Tam <jtam.home(a)gmail.com>

3 2

[Dovecot] logs show two connections to database even though using static driver
by Gary Chodos 27 Apr '11

27 Apr '11

hi, im using: --- passdb { driver = sql args = /etc/dovecot/dovecot-sql.conf.ext } userdb { driver = static args = uid=vmail gid=vmail home=/home/vmail/%d/ mail=mdbox:/home/vmail/%d/%n } -- this works fine on a test machine but i still see *2* instead of 1 connections to the pgsql db before a successful login is logged.. how can i avoid these extra connections?: Apr 17 11:34:49 merlin dovecot: auth: pgsql(localhost): Connected to database users Apr 17 11:34:50 merlin dovecot: auth: pgsql(localhost): Connected to database users Apr 17 11:34:50 merlin dovecot: imap-login: Login: user=<gary(a)example.org>, ...

2 2

[Dovecot] Why is my quota warning script not getting executed?
by Darek M 27 Apr '11

27 Apr '11

Storing my users and quota in MySQL,running Dovecot 1.2.16, and followed the page at http://wiki1.dovecot.org/Quota/Dict I'm burning my eyes trying to find any syntax issues but can't. I'm including output of dovecot -n and the quota2 table schema below. dovecot.conf: ========== dict { quotadict = mysql:/usr/local/etc/postfix/dovecot-dict-sql.conf } plugin { quota = dict:emailaccount::proxy::quotadict quota_warning95 = storage=95%% /usr/local/bin/dovecot-quota-warning.sh 95 quota_warning90 = storage=90%% /usr/local/bin/dovecot-quota-warning.sh 90 quota_warning80 = storage=80%% /usr/local/bin/dovecot-quota-warning.sh 80 } /usr/local/etc/postfix/dovecot-dict-sql.conf: =============================== # v1.2+ only: connect = host=/tmp/mysql.sock dbname=postfix user=postfix password=**** map { pattern = priv/quota/storage table = quota2 username_field = username value_field = bytes } map { pattern = priv/quota/messages table = quota2 username_field = username value_field = messages } A log of 90% being passed: # vuserinfo darek(a)domain.com Email: darek(a)domain.com Name: Darek Maildir: domain.com/darek/ Created: 2011-04-11 18:08:05 Modified: 2011-04-25 17:30:26 Quota: 25,000K (24.41M) Used: 21,380.29K (20.88M) Usage: 85.52% Apr 26 11:57:53 deliver(darek(a)domain.com): Info: Loading modules from directory: /usr/local/lib/dovecot/lda Apr 26 11:57:53 deliver(darek(a)domain.com): Info: Module loaded: /usr/local/lib/dovecot/lda/lib10_quota_plugin.so Apr 26 11:57:53 deliver(darek(a)domain.com): Info: Module loaded: /usr/local/lib/dovecot/lda/lib90_sieve_plugin.so Apr 26 11:57:53 deliver(darek(a)domain.com): Info: auth input: home=/home/vmail/domain.com/darek/ Apr 26 11:57:53 deliver(darek(a)domain.com): Info: auth input: mail=maildir:/home/vmail/domain.com/darek/ Apr 26 11:57:53 deliver(darek(a)domain.com): Info: auth input: uid=5000 Apr 26 11:57:53 deliver(darek(a)domain.com): Info: auth input: gid=5000 Apr 26 11:57:53 deliver(darek(a)domain.com): Info: auth input: quota_rule=*:bytes=25600000 Apr 26 11:57:53 deliver(darek(a)domain.com): Info: Quota root: name=emailaccount backend=dict args=:proxy::quotadict Apr 26 11:57:53 deliver(darek(a)domain.com): Info: Quota rule: root=emailaccount mailbox=* bytes=25600000 messages=0 Apr 26 11:57:53 deliver(darek(a)domain.com): Info: dict quota: user=darek(a)domain.com, uri=proxy::quotadict, noenforcing=0 Apr 26 11:57:53 deliver(darek(a)domain.com): Info: maildir: data=/home/vmail/domain.com/darek/ Apr 26 11:57:53 deliver(darek(a)domain.com): Info: maildir++: root=/home/vmail/domain.com/darek, index=, control=, inbox=/home/vmail/domain.com/darek Apr 26 11:57:53 deliver(darek(a)domain.com): Info: dict quota: user=darek(a)domain.com, uri=proxy::quotadict, noenforcing=0 Apr 26 11:57:53 deliver(darek(a)domain.com): Info: sieve: user's script path /home/vmail/domain.com/darek/sieve/darek(a)domain.com.sieve doesn't exist (using global script path in stead) Apr 26 11:57:53 deliver(darek(a)domain.com): Info: sieve: user has no valid personal script Apr 26 11:57:53 deliver(darek(a)domain.com): Info: sieve: no scripts to execute: reverting to default delivery. Apr 26 11:57:53 deliver(darek(a)domain.com): Info: Namespace : Using permissions from /home/vmail/domain.com/darek: mode=0700 gid=-1 Apr 26 11:57:53 dict: Info: mysql: Connected to /tmp/mysql.sock (postfix) Apr 26 11:57:53 deliver(darek(a)domain.com): Info: msgid=<4DB6EB69.5010501(a)server.net>: saved mail to INBOX # vuserinfo darek(a)domain.com Email: darek(a)domain.com Name: Darek Maildir: domain.com/darek/ Created: 2011-04-11 18:08:05 Modified: 2011-04-25 17:30:26 Quota: 25,000K (24.41M) Used: 23,000.09K (22.46M) Usage: 92.00% Output of 'dovecot -n': ================ # 1.2.16: /usr/local/etc/dovecot.conf # OS: FreeBSD 8.2-RELEASE i386 ufs log_path: /var/log/dovecot/dovecot-err.log info_log_path: /var/log/dovecot/dovecot-info.log protocols: imap imaps pop3 pop3s managesieve listen: , [::] ssl_cert_file: /etc/ssl/dovecot/certs/dovecot.pem ssl_key_file: /etc/ssl/dovecot/private/dovecot.pem disable_plaintext_auth: no nfs_check: no version_ignore: yes 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_executable(managesieve): /usr/local/libexec/dovecot/managesieve-login login_process_per_connection: no login_processes_count: 10 first_valid_uid: 5000 last_valid_uid: 5000 first_valid_gid: 5000 last_valid_gid: 5000 mail_uid: 5000 mail_gid: 5000 mail_location: maildir:/home/vmail/%d/%n mail_debug: yes mail_nfs_storage: yes lock_method: dotlock maildir_very_dirty_syncs: yes 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_executable(managesieve): /usr/local/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/local/lib/dovecot/imap mail_plugin_dir(imap): /usr/local/lib/dovecot/imap mail_plugin_dir(pop3): /usr/local/lib/dovecot/pop3 mail_plugin_dir(managesieve): /usr/local/lib/dovecot/managesieve lda: postmaster_address: supportteam(a)domain.net hostname: inbox4.domain.net mail_plugins: quota sieve sendmail_path: /usr/sbin/sendmail auth default: mechanisms: plain login apop user: nobody username_translation: %@ passdb: driver: sql args: /usr/local/etc/postfix/dovecot.sql userdb: driver: sql args: /usr/local/etc/postfix/dovecot.sql socket: type: listen client: path: /var/spool/postfix/private/auth mode: 432 user: postfix group: vmail master: path: /var/run/dovecot/auth-master mode: 384 user: vmail group: vmail plugin: quota: dict:emailaccount::proxy::quotadict quota_warning95: storage=95%% /usr/local/bin/dovecot-quota-warning.sh 95 quota_warning90: storage=90%% /usr/local/bin/dovecot-quota-warning.sh 90 quota_warning80: storage=80%% /usr/local/bin/dovecot-quota-warning.sh 80 sieve: /home/vmail/%d/%n/sieve/%n(a)%d.sieve sieve_dir: /home/vmail/%d/%n/sieve/ dict: quotadict: mysql:/usr/local/etc/postfix/dovecot-dict-sql.conf Database schema: ============== # mysql -u root postfix mysql> describe quota2; +----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+-------+ | username | varchar(100) | NO | PRI | NULL | | | bytes | bigint(20) | NO | | 0 | | | messages | int(11) | NO | | 0 | | +----------+--------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) mysql> select * from quota2 where username='darek(a)domain.com'; +------------------+----------+----------+ | username | bytes | messages | +------------------+----------+----------+ | darek(a)domain.com | 23552090 | 7 | +------------------+----------+----------+ -- Darek

2 1

Re: [Dovecot] dovecot.org broken
by Nick Edwards 26 Apr '11

26 Apr '11

Multiple mirrors (seems like you have plenty of offers) preferrably is multi geographical regions, using DNS round robin with TTL 0 on www and ftp , I wouldnt bother with the wiki mirroring though. However you could run 3600 seconds on it, should you need to bring it back elsewhere in a hurry. On Sun, Apr 24, 2011 at 1:19 AM, Timo Sirainen <tss(a)iki.fi> wrote: > On Thu, 2011-04-21 at 21:47 +0300, Timo Sirainen wrote: > > Serving it temporarily from a machine in my home. I'll move it to better > hosting in a few days. And I guess I should make it more fail safe some day > soon.. > > > > Lets see if mailman happens to work now. > > Thanks everyone for offering hosting. I've one easy solution worked out > already anyway, and looks like the old dovecot.org is also up nowadays, > but 30h downtime clearly isn't ideal.. > > I'm anyway going to figure out a more long term solution with some kind > of a quick failover in case something breaks. > > >

1 0

Re: [Dovecot] Having trouble getting Dovecot to read a ~/Maildir configuration
by Stan Hoeppner 26 Apr '11

26 Apr '11

Murray Collingwood put forth on 4/20/2011 8:29 PM: > Hi Stan > > I only have the one account on this server, everything else is relayed > elsewhere. If this is an SMTP relay server, I'm surprised you bothered to install an IMAP server at all. It would have been easier to simply alias postmaster@ to another account on another machine where you do store mailboxes. I.e. simply 'forward' all postmaster mail to you main account and use Sieve to sort all postmaster mail into a folder. This is exactly what I do. It's what a lot of people do, especially those handling many domains, and thus having lots of postmaster addresses. > A question about where the mail is actually supposed to be delivered to... > initially I configured Exim4 to delivery the email to ~/Maildir and I > noticed as you saw in the list directories like ~/Maildir/new and > ~/Maildir/cur, however once I configured Evolution to login to Dovecot I > noticed the directories ~/Maildir/INBOX/new and ~Maildir/INBOX/cur were > created. Should therefore Exim4 be configured to ~/Maildir/INBOX instead of > just ~/Maildir ? Configuration of maildir can be a little confusing the first time around. Given your situation/server, I'm really surprised you didn't use mbox instead. It fits this scenario much better than maildir. > Voila! I just tested this change with Exim4, restarted everything and > Evolution now shows me messages. The LAYOUT=fs was correct, and so it was > more a matter of getting Exim4 to deliver to ~/Maildir/INBOX .... a little > confusing but this was my first time with Exim4 (I've been a sendmail user > for a number of years). Setting up Dovecot LDA with EXIM: http://wiki1.dovecot.org/LDA/Exim You're probably using procmail or maildrop currently. I don't use either of these, so I'm unfamiliar with their setup WRT maildir. Should be pretty straightforward though. > RoundCube still isn't working but I'm not going to worry about that - > Evolution will be cool. Need more details to help with RC. As long as you can establish an IMAP connection to Dovecot, RC is pretty smart about figuring out where everything is even if you don't explicitly tell it. > Thanks for your help - simply confirming one setting helps. Heh, I didn't do much, but you're welcome. Are you planning on migrating all the mailboxes from the old server to this new one? -- Stan

2 2

[Dovecot] Having trouble getting Dovecot to read a ~/Maildir configuration
by Murray Collingwood 26 Apr '11

26 Apr '11

Hi folks Setting up a new server, hence a few software packages have been upgraded / changed. On my old server (only 2 years old) I was using Dovecot and RoundCube (web mail app) and had a good experience so was keen to use these again. The only major change is I have switched from sendmail to exim4 (which was installed by default on this Debian server). Exim4 appears to be doing the right thing, however read on and see if you can spot the error. I've tried two email clients, RoundCube (via apache) as a local connection and Evolution as a remote connection. Both appear to login to the Dovecot IMAP connection okay (log entries included further down), although they don't see any email. The INBOX is completely empty. Although when I check out /home/postmaster/Maildir/new it has many messages waiting to be read. It's like Exim4 is delivering the email into the ~/Maildir folder but Dovecot is not seeing it.... I've tried these three combinations in dovecot.conf but they give the same result: #mail_location = maildir:~/Maildir (ie this one I commented the line out to see if Dovecot would work it out automatically) mail_location = maildir:~/Maildir (I think this one should work) mail_location = maildir:~/Maildir:LAYOUT=fs (Now I'm just desperate and will try anything) The dovecot log gives no indication of any errors: This is the version I am running - it was the default version for Debian installed via apt-get: 2011-04-21 08:55:22 dovecot: Info: Dovecot v1.2.15 starting up (core dumps disabled) This connection is using Evolution email client on Linux: 2011-04-21 08:40:05 imap-login: Info: Login: user=<postmaster>, method=PLAIN, rip=122.148.149.28, lip=202.125.41.111 This connection is using roundcube via apache on the same server: 2011-04-21 08:40:41 imap-login: Info: Login: user=<postmaster>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured 2011-04-21 08:40:41 IMAP(postmaster): Info: Disconnected: Logged out bytes=39/443 And finally a look at the ~/Maildir content for my "postmaster" user: root@ds5683:/etc/dovecot# ls -al /home/postmaster/Maildir total 148 drwx------ 6 postmaster postmaster 4096 Apr 21 08:55 . drwxr-xr-x 3 postmaster postmaster 4096 Apr 19 08:12 .. drwx------ 2 postmaster postmaster 12288 Apr 21 08:40 cur -rw------- 1 postmaster postmaster 89088 Apr 21 08:40 dovecot.index.cache -rw------- 1 postmaster postmaster 2376 Apr 21 08:40 dovecot.index.log -rw------- 1 postmaster postmaster 5208 Apr 21 08:40 dovecot-uidlist -rw------- 1 postmaster postmaster 8 Apr 21 08:55 dovecot-uidvalidity -rw------- 1 postmaster postmaster 0 Apr 21 08:34 dovecot-uidvalidity.4daf5f73 drwx------ 5 postmaster postmaster 4096 Apr 21 08:56 INBOX drwx------ 2 postmaster postmaster 12288 Apr 21 09:39 new drwx------ 2 postmaster postmaster 4096 Apr 21 09:39 tmp So, can somebody help me get Dovecot to recognise the messages in this mailbox please? You can suggest anything you like.... upgrades, conf changes, low level formating of HDD... at this stage I'm ready to try anything! Cheers Murray -- Murray Collingwood Focus Computing p +61 415 24 26 24 http://www.focus-computing.com.au

4 3

Re: [Dovecot] Using replaceable variables in sieve
by Stephan Bosch 26 Apr '11

26 Apr '11

On 4/24/2011 10:29 PM, Jerry wrote: > I am not even sure if this is possible. I cannot find an example of it > anywhere. > > I am in the process of setting up a "plus" addressing system. The > addresses would be addresses to accounts like > <sales+USERNAME(a)domain.com>. there are presently 50 such names in sales. > > This is the one line entry I presently have in the sieve script: > > if envelope :detail "To" "joe" {fileinto "joe"; stop;} > > Now, what I would like to do is find a way to do this: > > if envelope :detail "To" "joe" {fileinto :detail; stop} > > That does not work though. I really do not want to list every available > user individually since it will eventually become a nightmare to > maintain. Is there any way in a sieve script to assign the value of > ":detail" to another variable and use that variable in the "fileinto" > portion of the script? I would also need to maintain the same case > folding so as not to create multiple folders with the same name; ie, > Joe, joe, jOe The variables extension is what you need. Here's an example: require ["variables", "envelope", "fileinto", "subaddress"]; if envelope :is :user "to" "sales" { if envelope :matches :detail "to" "*" { /* Save name in ${name} in all lowercase except for the first letter. * Joe, joe, jOe thus all become 'Joe'. */ set :lower :upperfirst "name" "${1}"; } if string :is "${name}" "" { /* Default case if no detail is specified */ fileinto "sales"; } else { /* For sales+joe@ this will become users/Joe */ fileinto "users/${name}"; } } Regards, Stephan.

2 1