- dovecot - dovecot.org

[Dovecot] Case-insensitive "detail" mailboxes?
by /dev/rob0 27 Jul '13

27 Jul '13

We're using sieve with LMTP. We want to have lda_mailbox_autocreate and lmtp_save_to_detail_mailbox. Is there a way to make the "detail" case-insensitive? If so I have not found it yet. I suppose we could lowercase the input string for the SQL userdb query, but that's not what is wanted. The idea being that if a user makes a mailbox called "Test" is that user+test(a)example.com and user+TEST(a)example.com should both go to that "Test" mailbox. If it was lowercased, a mailbox called "Test" would be ignored and "test" used. With autocreate, this could be a problem if mail is delivered to autocreated case-sensitive mailboxes that the user won't see. Hmmm, maybe a global sieve script? -- http://rob0.nodns4.us/ -- system administration and consulting Offlist GMX mail is seen only if "/dev/rob0" is in the Subject:

4 5

[Dovecot] dbus support in dovecot?
by Gene Heskett 27 Jul '13

27 Jul '13

Greetings; I am trying to transition from ubu10.04.4 LTS to ubu12.04.2 LTS, but in the changeover I want to setup dovecot as a local only imap server so that I can read & respond to email from any of the other 4 or so machines on my local net. To that end, and given that I have a well working setup right now, using fetchmail driving mailfilter as a pre-check, procmail as the MTA delivering to /var/spool/mail/me, with clamav and spamd in the mix to intercept and send to /dev/null the worst of the spam, or to a quarantine file if clamav triggers. The current transfer mechanism is driven by a script that uses inotifywait to detect newly delivered mail in that directory, and which then sends kmail a dbus message to go get the mail. Since I want to insert dovecot into this chain, does dovecot have a dbus port, and if so, what is the format of the command it expects? Thanks all. Cheers, Gene -- "There are four boxes to be used in defense of liberty: soap, ballot, jury, and ammo. Please use in that order." -Ed Howdershelt (Author) A pen in the hand of this president is far more dangerous than 200 million guns in the hands of law-abiding citizens.

4 10

[Dovecot] Namespace, Sieve and upgrading to dovecot 2.0 -- no folder "INBOX/"
by Ben 27 Jul '13

27 Jul '13

I just upgraded from debian squeeze->wheezy. This meant upgrading from dovecot 1.2 to 2.1.7 and upgrading to Pigdeonhole sieve. I have dovecot configured to use sieve and virtual users (I'll post config below) Now any message that come in get filtered by sieve, but any messages that don't hit any filters gives the error (in the sieve log): msgid=<XXXX(a)XXX.com>: failed to store into mailbox 'INBOX/': Invalid mailbox name As far as I can tell, Pidgeonhole has hard-coded to the behavior of 'keep' (that is unfiltered emails) to be: fileinto "INBOX/" However, in my setup "INBOX/" is not a valid folder. "INBOX" is. Is there a way to get pidgeonhole sieve to treat 'keep' as fileinto "INBOX"? Or do I need to reconfigure my dovecot namespaces? I tried playing with them, but everything works right now (sharing, etc) and when I changed my prefix on the inbox, etc, it did weird things (INBOX.INBOX.FOLDER) instead of (INBOX.Folder). Suggestions? Here is, I believe the relevant config info: dovecot.conf: namespace { inbox = yes location = prefix = separator = / type = private } namespace { list = children location = maildir:/Mail/Users/%%n/:INDEX=/Mail/Users/%u/shared/%%u prefix = shared/%%u/ separator = / subscriptions = no type = shared } Thanks, Ben

2 1

[Dovecot] Fw: POP3 issues
by Thomas I Higgins 26 Jul '13

26 Jul '13

Sorry - forgot to mention it is on Dovecot version 1.0.7 and RHEL 5.6 Tom >I have been trying off and on for the better part of a year to get a dovecot server migrated from one machine to another. It is currently working on CENTOS and we are trying to get it on Redhat. Currently I have everything migrated and >working in IMAP, but we have one client device that requires POP3 (doesn't support IMAP). To this end, we have set up everything to work in POP3 as far as I can tell. > >In the dovecot.conf file, we show: > >protocols = imap imaps pop3 pop3s >protocol pop3 { > pop3_uidl_format = %08Xu%08Xv >} > >The services running include: > >dovecot-auth >imap-login >imap-login >imap-login >pop3-login >pop3-login >pop3-login > >Everything else looks good including the logs which seem to show proper connectivity - messages are being received, accounts are connecting and disconnecting, etc. but the pop connections are not (apparently) passing messages >found in that box. They are still just sitting there, not being read, picked up, or otherwise delivered by dovecot. Any ideas on what else I can check or change to get this to pick up? > >Thanks, >Tom Higgins

2 3

[Dovecot] Duplicate Mails downloding issue
by Kavish Karkera 26 Jul '13

26 Jul '13

Hi All, We are repeatedly getting the below warning / errors on our pop server. Please help us out buy knowing what could be the issue. ------------------------------------------------------------------------------------------------------------------------------------------------------- Jul 23 15:34:51 popserver dovecot: pop3(14949_kavish): Warning: Locking transaction log file /indexes//mail/v3store/example.com/14949_kavish/.INBOX/dovecot.index.log took 133 seconds Jul 23 15:34:51 popserver dovecot: pop3(kavish(a)example.com): Error: Broken file /indexes//mail/v3store/example.com/14949_kavish/.INBOX/dovecot-uidlist line 180: UIDs not ordered (10156 >= 10156) Jul 23 15:35:01 popserver dovecot: pop3(kavish(a)example.com): Error: utime(/indexes//mail/v3store/example.com/kavish/.INBOX/dovecot-uidlist.lock) failed: No such file or directory Jul 23 15:35:11 popserver dovecot: pop3(kavish(a)example.com): Error: utime(/indexes//mail/v3store/example.com/kavish/.INBOX/dovecot-uidlist.lock) failed: No such file or directory Jul 23 15:35:21 popserver dovecot: pop3(kavish(a)example.com): Warning: Our dotlock file /indexes//mail/v3store/example.com/kavish/.INBOX/dovecot-uidlist.lock was deleted (kept it 30 secs) --------------------------------------------------------------------------------------------------------------------------------------------------------- Regards, Kavish Karkera

3 9

[Dovecot] dovecot-lda not logging if dovecot runs under daemontools
by Roberto Puzzanghera 26 Jul '13

26 Jul '13

Hello all, I have dovecot running under daemontools and I can't see dovecot-lda in action when I read the logs. I've set the logs to /dev/stderr because daemontools redirects /dev/stderr to /var/log/dovecot/current. The dovecot server works fine and I know that dovecot-lda is actually doing the delivery, because the sieve facility is working as well. I can get lda log working -but only on syslog- if I override the log_path in this way: protocol lda { mail_plugins = $mail_plugins sieve log_path = } I'm calling dovecot-lda in the usual qmail way. This is my .qmail-default: |/var/qmail/bin/preline -f /usr/libexec/dovecot/deliver -d $EXT@$USER As running dovecot under daemontools seems to be a common practice among qmail users, could any of you give me an hint on how dovecot should be configured to achieve the purpose? Thanks in advance. My doveconf follows Roberto Puzzanghera # dovecof -n # 2.2.4: /etc/dovecot/dovecot/dovecot.conf # OS: Linux 3.2.29-smp i686 Slackware 14.0 auth_default_realm = mydomain.net auth_mechanisms = plain login auth_socket_path = /var/run/dovecot/auth-userdb auth_verbose = yes default_login_user = vpopmail disable_plaintext_auth = no first_valid_gid = 89 first_valid_uid = 89 last_valid_gid = 89 last_valid_uid = 89 lda_mailbox_autocreate = yes lda_mailbox_autosubscribe = yes log_path = /dev/stderr mail_access_groups = 89 mail_debug = yes mail_gid = 89 mail_location = maildir:%h/Maildir mail_plugins = " quota mail_log notify" mail_privileged_group = 89 mail_uid = 89 managesieve_notify_capability = mailto managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave spamtest spamtestplus namespace inbox { inbox = yes location = mailbox Drafts { auto = subscribe special_use = \Drafts } mailbox Junk { auto = subscribe special_use = \Junk } mailbox Sent { auto = subscribe special_use = \Sent } mailbox Trash { auto = subscribe special_use = \Trash } prefix = } passdb { args = /etc/dovecot/dovecot/conf.d/dovecot-sql.conf.ext driver = sql } plugin { autocreate = Sent autocreate2 = Drafts autocreate3 = Junk autocreate4 = Trash autosubscribe = Sent autosubscribe2 = Drafts autosubscribe3 = Junk autosubscribe4 = Trash mail_log_events = delete undelete expunge copy mailbox_delete mailbox_rename mail_log_fields = uid box msgid size quota = maildir:User quota sieve = ~/sieve/dovecot.sieve sieve_before = /etc/dovecot/sieve/ sieve_dir = ~/sieve sieve_extensions = +spamtest +spamtestplus +relational +comparator-i;ascii-numeric } postmaster_address = postmaster@%d protocols = imap pop3 sieve sendmail_path = /var/qmail/bin/sendmail service auth-worker { user = $default_internal_user } service auth { unix_listener auth-userdb { group = vchkpw mode = 0600 user = vpopmail } user = $default_internal_user } service managesieve-login { inet_listener sieve { port = 4190 } service_count = 1 vsz_limit = 64 M } ssl_cert = </etc/dovecot/ssl/certs/dovecot.pem ssl_key = </etc/dovecot/ssl/private/dovecot.pem userdb { args = /etc/dovecot/dovecot/conf.d/dovecot-sql.conf.ext driver = sql } verbose_ssl = yes protocol lda { mail_plugins = " quota mail_log notify sieve" } protocol imap { mail_plugins = " quota mail_log notify imap_quota" } protocol pop3 { mail_plugins = " quota mail_log notify" }

2 1

[Dovecot] Managing IMAP IDLE/Push with Sieve – possible?
by FF 25 Jul '13

25 Jul '13

Hello, I've been using Dovecot with Sieve for a long time already, and I'm very happy with it. Push is working fine too. I was wondering, however, whether it would be possible to define a Sieve rule (perhaps using some plug-in), such that an IMAP push message gets sent out only for specific senders etc.? Have you come across anything like that? Thanks a lot, F.F.

3 4

[Dovecot] POP3 issues
by Thomas I Higgins 24 Jul '13

24 Jul '13

I have been trying off and on for the better part of a year to get a dovecot server migrated from one machine to another. It is currently working on CENTOS and we are trying to get it on Redhat. Currently I have everything migrated and working in IMAP, but we have one client device that requires POP3 (doesn't support IMAP). To this end, we have set up everything to work in POP3 as far as I can tell. In the dovecot.conf file, we show: protocols = imap imaps pop3 pop3s protocol pop3 { pop3_uidl_format = %08Xu%08Xv } The services running include: dovecot-auth imap-login imap-login imap-login pop3-login pop3-login pop3-login Everything else looks good including the logs which seem to show proper connectivity - messages are being received, accounts are connecting and disconnecting, etc. but the pop connections are not (apparently) passing messages found in that box. They are still just sitting there, not being read, picked up, or otherwise delivered by dovecot. Any ideas on what else I can check or change to get this to pick up? Thanks, Tom Higgins

1 0

Re: [Dovecot] Sieve info
by Reindl Harald 24 Jul '13

24 Jul '13

Am 24.07.2013 14:29, schrieb Noel Butler: > dnsbl - yes, his IP range is now listed in two lists. > > insisted to one dnsbl that they should list the dovecot mailing list > server IP's not his, why? because the list server directly sent his > abuse, not his mail server direct to, not only mine, but others :) you do not understand the problem i never said you should blacklist any mailing-list-server i only said that it is pretty dumb to block a /24 network on a DNSBL because one user from one of the IP's is disliked by you with this brain-dead logic you would need to block also all google-ranges if you dislike a single person with a gmail-address but for *that* you are too faint-hearted serious people can decide by theirself what the want or want not to read and do not need to misuse their position of controlling a RBL > Ahhh if only he was not dev nulled, I would likely have another abusive > email from him jumping up and down claiming yet again he is the innocent > victim, yes, we are all wrong.... the problem is that you can not read anything i write directly because your /dev/nulling, so in the worst case you see only stripped answers of some nitpickers and

1 0

[Dovecot] Sieve info
by Sam Flint 24 Jul '13

24 Jul '13

I'm using Dovecot v2, and I can't seem to find any info abut using sieve with the LDA, or the ManageSieve protocol, can you please point me un the right direction? Sam

5 7

[Dovecot] performance 2.1.17 zlib maildir
by Robert Schetterer 23 Jul '13

23 Jul '13

Hi Timo, i have reports from few users about lost performance with 2.17 maildir bigger mailboxes ( up to 2 GB ), i also use zlib plugin what about this patch.....,may not working as i should? http://hg.dovecot.org/dovecot-2.1/rev/9c23d1fb8969 Best Regards MfG Robert Schetterer -- [*] sys4 AG http://sys4.de, +49 (89) 30 90 46 64 Franziskanerstraße 15, 81669 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer Aufsichtsratsvorsitzender: Florian Kirstein

3 6

[Dovecot] Dovecot 2.2.4/sendmail with sql user and aliases
by Cedric 23 Jul '13

23 Jul '13

Hi, We are currently moving from linuxconf/dovecot to a dovecot setup with sql support, the problem we currently facing is having a message sent to a aliase delivered to the user email inbox with dovecot-lda, i have created cedrict(a)mail.vdl and a alias test(a)mail.vdl, when i send to cedrict(a)mail.vdl the message is included in the user inbox file, but when i send to test(a)mail.vdl it should do the same and not create a new created file named test, thank in advance for your help. # dovecot --version 2.2.4 dovecot.conf auth_debug = yes auth_debug_passwords = yes auth_verbose = yes default_internal_user = root default_login_user = mail disable_plaintext_auth = no first_valid_uid = 100 mail_access_groups = mail users sysadmin popusers mail_location = mbox:%h/mail:LAYOUT=maildir++:INDEX=MEMORY:CONTROL=%h/mail/control:INBOX=/var/spool/vmail/%d/%n mail_max_userip_connections = 40 mail_plugins = " quota sieve" managesieve_notify_capability = mailto managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave mbox_lazy_writes = no passdb { args = /vdl/etc/dovecot/dovecot-sql.conf driver = sql } plugin { sieve = %h/mail/sieve/%n sieve_global_dir = /vdl/etc/dovecot/ sieve_vacation_default_period = 1d sieve_vacation_max_period = 7d } postmaster_address = x(a)x.x protocols = imap pop3 service auth { unix_listener auth-userdb { mode = 0600 user = popusers } } service imap-login { inet_listener imap { port = 143 } process_min_avail = 4 vsz_limit = 256 M } service pop3-login { inet_listener pop3 { port = 110 } process_min_avail = 16 } ssl = no submission_host = localhost:25 userdb { args = /vdl/etc/dovecot/dovecot-sql.conf driver = sql } protocol imap { mail_plugins = quota imap_quota mail_log notify } protocol pop3 { mail_plugins = quota } protocol lda { mail_plugins = quota sieve } dovecot-sql.conf password_query = SELECT \ concat(s_courriel_utilisateur.utilisateur, '@', s_courriel_domaine.nom) AS user,s_courriel_utilisateur.password as password \ FROM s_courriel_utilisateur left join s_courriel_alias on s_courriel_utilisateur.id=s_courriel_alias.utilisateur and s_courriel_alias.archive !=1 ,s_courriel_domaine \ WHERE s_courriel_utilisateur.archive !=1 \ and s_courriel_domaine.archive !=1 \ and s_courriel_utilisateur.domaine=s_courriel_domaine.id \ and s_courriel_domaine.nom = '%d' \ and ( s_courriel_utilisateur.utilisateur = '%n' or s_courriel_alias.alias = '%n' ) user_query = SELECT \ concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur) as home, \ concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur,"/mail/index") as "index", \ concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur,"/mail/control") as control, \ concat("/var/spool/vmail/",s_courriel_domaine.nom,"/",s_courriel_utilisateur.utilisateur) as inbox, \ "maildir++" as layout, \ s_courriel_utilisateur.uid as uid,s_courriel_domaine.gid as gid \ FROM s_courriel_utilisateur left join s_courriel_alias on s_courriel_utilisateur.id=s_courriel_alias.utilisateur and s_courriel_alias.archive !=1 ,s_courriel_domaine \ WHERE s_courriel_utilisateur.archive !=1 \ and s_courriel_domaine.archive !=1 \ and s_courriel_utilisateur.domaine=s_courriel_domaine.id \ and s_courriel_domaine.nom = '%d' \ and ( s_courriel_utilisateur.utilisateur = '%n' or s_courriel_alias.alias = '%n' ) Transaction debug for cedrict(a)mail.vdl with message added to file /var/spool/vmail/mail.vdl/cedrict SELECT concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur) as home, concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur,"/mail/index") as "index", concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur,"/mail/control") as control, concat("/var/spool/vmail/",s_courriel_domaine.nom,"/",s_courriel_utilisateur.utilisateur) as inbox, "maildir++" as layout, s_courriel_utilisateur.uid as uid,s_courriel_domaine.gid as gid FROM s_courriel_utilisateur left join s_courriel_alias on s_courriel_utilisateur.id=s_courriel_alias.utilisateur and s_courriel_alias.archive !=1 ,s_courriel_domaine WHERE s_courriel_utilisateur.archive !=1 and s_courriel_domaine.archive !=1 and s_courriel_utilisateur.domaine=s_courriel_domaine.id and s_courriel_domaine.nom = 'mail.vdl' and ( s_courriel_utilisateur.utilisateur = 'cedrict' or s_courriel_alias.alias = 'cedrict'); +------------------------------+-----------------------------------------+-------------------------------------------+-----------------------------------+-----------+-------+------+ | home | index | control | inbox | layout | uid | gid | +------------------------------+-----------------------------------------+-------------------------------------------+-----------------------------------+-----------+-------+------+ | /vhome/mail.vdl/home/cedrict | /vhome/mail.vdl/home/cedrict/mail/index | /vhome/mail.vdl/home/cedrict/mail/control | /var/spool/vmail/mail.vdl/cedrict | maildir++ | 60001 | 231 | +------------------------------+-----------------------------------------+-------------------------------------------+-----------------------------------+-----------+-------+------+ Jul 17 14:00:56 devshed dovecot: auth: Debug: master in: USER 1 cedrict(a)mail.vdl service=lda Jul 17 14:00:56 devshed dovecot: auth-worker(7009): Debug: Loading modules from directory: /vdl/lib/dovecot/auth Jul 17 14:00:56 devshed dovecot: auth-worker(7009): Debug: sql(cedrict(a)mail.vdl): SELECT concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur) as home, concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur,"/mail/index") as "index", concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur,"/mail/control") as control, concat("/var/spool/vmail/",s_courriel_domaine.nom,"/",s_courriel_utilisateur.utilisateur) as inbox, "maildir++" as layout, s_courriel_utilisateur.uid as uid,s_courriel_domaine.gid as gid FROM s_courriel_utilisateur left join s_courriel_alias on s_courriel_utilisateur.id=s_courriel_alias.utilisateur and s_courriel_alias.archive !=1 ,s_courriel_domaine WHERE s_courriel_utilisateur.archive !=1 and s_courriel_domaine.archive !=1 and s_courriel_utilisateur.domaine=s_courriel_domaine.id and s_courriel_domaine.nom = 'mail.vdl' and ( s_courriel_utilisateur.utilisateur = 'cedrict' or s_courriel_alias.alias = 'cedrict' Jul 17 14:00:56 devshed dovecot: auth: Debug: userdb out: USER 1 cedrict(a)mail.vdl home=/vhome/mail.vdl/home/cedrict index=/vhome/mail.vdl/home/cedrict/mail/index control=/vhome/mail.vdl/home/cedrict/mail/control inbox=/var/spool/vmail/mail.vdl/cedrict layout=maildir++ uid=60001 gid=231 Jul 17 14:00:56 devshed dovecot: lda: Debug: auth input: cedrict(a)mail.vdl home=/vhome/mail.vdl/home/cedrict index=/vhome/mail.vdl/home/cedrict/mail/index control=/vhome/mail.vdl/home/cedrict/mail/control inbox=/var/spool/vmail/mail.vdl/cedrict layout=maildir++ uid=60001 gid=231 Jul 17 14:00:56 devshed dovecot: lda: Debug: Added userdb setting: plugin/control=/vhome/mail.vdl/home/cedrict/mail/control Jul 17 14:00:56 devshed dovecot: lda: Debug: Added userdb setting: plugin/inbox=/var/spool/vmail/mail.vdl/cedrict Jul 17 14:00:56 devshed dovecot: lda: Debug: Added userdb setting: plugin/index=/vhome/mail.vdl/home/cedrict/mail/index Jul 17 14:00:56 devshed dovecot: lda: Debug: Added userdb setting: plugin/layout=maildir++ Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): Debug: Effective uid=60001, gid=231, home=/vhome/mail.vdl/home/cedrict Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): Debug: quota: No quota setting - plugin disabled Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): Debug: maildir++: root=/vhome/mail.vdl/home/cedrict/mail, index=, indexpvt=, control=/vhome/mail.vdl/home/cedrict/mail/control, inbox=/var/spool/vmail/mail.vdl/cedrict, alt= Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): Debug: quota: No quota setting - plugin disabled Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): Debug: none: root=, index=, indexpvt=, control=, inbox=, alt= Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): Debug: Destination address: cedrict(a)mail.vdl (source: user@hostname) Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): Debug: sieve: Pigeonhole version 0.4.1 initializing Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): Debug: sieve: script file /vhome/mail.vdl/home/cedrict/mail/sieve/cedrict not found Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): Debug: sieve: user's script /vhome/mail.vdl/home/cedrict/mail/sieve/cedrict doesn't exist (trying default script location instead) Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): Debug: sieve: no default script configured for user Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): Debug: sieve: user has no valid location for a personal script Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): Debug: sieve: no scripts to execute: reverting to default delivery. Jul 17 14:00:56 devshed dovecot: lda(cedrict(a)mail.vdl): msgid=<201307171800.r6HI0unE007004(a)devshed.derytelecom.ca>: saved mail to INBOX Transaction debug for alias test(a)mail.vdl with message added to file /var/spool/vmail/mail.vdl/test mysql> SELECT concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur) as home, concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur,"/mail/index") as "index", concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur,"/mail/control") as control, concat("/var/spool/vmail/",s_courriel_domaine.nom,"/",s_courriel_utilisateur.utilisateur) as inbox, "maildir++" as layout, s_courriel_utilisateur.uid as uid,s_courriel_domaine.gid as gid FROM s_courriel_utilisateur left join s_courriel_alias on s_courriel_utilisateur.id=s_courriel_alias.utilisateur and s_courriel_alias.archive !=1 ,s_courriel_domaine WHERE s_courriel_utilisateur.archive !=1 and s_courriel_domaine.archive !=1 and s_courriel_utilisateur.domaine=s_courriel_domaine.id and s_courriel_domaine.nom = 'mail.vdl' and ( s_courriel_utilisateur.utilisateur = 'test' or s_courriel_alias.alias = 'test' ); +------------------------------+-----------------------------------------+-------------------------------------------+-----------------------------------+-----------+-------+------+ | home | index | control | inbox | layout | uid | gid | +------------------------------+-----------------------------------------+-------------------------------------------+-----------------------------------+-----------+-------+------+ | /vhome/mail.vdl/home/cedrict | /vhome/mail.vdl/home/cedrict/mail/index | /vhome/mail.vdl/home/cedrict/mail/control | /var/spool/vmail/mail.vdl/cedrict | maildir++ | 60001 | 231 | +------------------------------+-----------------------------------------+-------------------------------------------+-----------------------------------+-----------+-------+------+ 1 row in set (0,00 sec) Jul 17 14:03:10 devshed dovecot: auth-worker(7135): Debug: sql(test(a)mail.vdl): SELECT concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur) as home, concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur,"/mail/index") as "index", concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur,"/mail/control") as control, concat("/var/spool/vmail/",s_courriel_domaine.nom,"/",s_courriel_utilisateur.utilisateur) as inbox, "maildir++" as layout, s_courriel_utilisateur.uid as uid,s_courriel_domaine.gid as gid FROM s_courriel_utilisateur left join s_courriel_alias on s_courriel_utilisateur.id=s_courriel_alias.utilisateur and s_courriel_alias.archive !=1 ,s_courriel_domaine WHERE s_courriel_utilisateur.archive !=1 and s_courriel_domaine.archive !=1 and s_courriel_utilisateur.domaine=s_courriel_domaine.id and s_courriel_domaine.nom = 'mail.vdl' and ( s_courriel_utilisateur.utilisateur = 'test' or s_courriel_alias.alias = 'test' ) Jul 17 14:03:10 devshed dovecot: auth: Debug: userdb out: USER 1 test(a)mail.vdl home=/vhome/mail.vdl/home/cedrict index=/vhome/mail.vdl/home/cedrict/mail/index control=/vhome/mail.vdl/home/cedrict/mail/control inbox=/var/spool/vmail/mail.vdl/cedrict layout=maildir++ uid=60001 gid=231 Jul 17 14:03:10 devshed dovecot: lda: Debug: auth input: test(a)mail.vdl home=/vhome/mail.vdl/home/cedrict index=/vhome/mail.vdl/home/cedrict/mail/index control=/vhome/mail.vdl/home/cedrict/mail/control inbox=/var/spool/vmail/mail.vdl/cedrict layout=maildir++ uid=60001 gid=231 Jul 17 14:03:10 devshed dovecot: lda: Debug: Added userdb setting: plugin/control=/vhome/mail.vdl/home/cedrict/mail/control Jul 17 14:03:10 devshed dovecot: lda: Debug: Added userdb setting: plugin/inbox=/var/spool/vmail/mail.vdl/cedrict Jul 17 14:03:10 devshed dovecot: lda: Debug: Added userdb setting: plugin/index=/vhome/mail.vdl/home/cedrict/mail/index Jul 17 14:03:10 devshed dovecot: lda: Debug: Added userdb setting: plugin/layout=maildir++ Jul 17 14:03:10 devshed dovecot: lda(test(a)mail.vdl): Debug: Effective uid=60001, gid=231, home=/vhome/mail.vdl/home/cedrict Jul 17 14:03:10 devshed dovecot: lda(test(a)mail.vdl): Debug: quota: No quota setting - plugin disabled Jul 17 14:03:10 devshed dovecot: lda(test(a)mail.vdl): Debug: maildir++: root=/vhome/mail.vdl/home/cedrict/mail, index=, indexpvt=, control=/vhome/mail.vdl/home/cedrict/mail/control, inbox=/var/spool/vmail/mail.vdl/test, alt= Jul 17 14:03:10 devshed dovecot: lda(test(a)mail.vdl): Debug: quota: No quota setting - plugin disabled Jul 17 14:03:10 devshed dovecot: lda(test(a)mail.vdl): Debug: none: root=, index=, indexpvt=, control=, inbox=, alt= Jul 17 14:03:10 devshed dovecot: lda(test(a)mail.vdl): Debug: Destination address: test(a)mail.vdl (source: user@hostname) Jul 17 14:03:10 devshed dovecot: lda(test(a)mail.vdl): Debug: sieve: Pigeonhole version 0.4.1 initializing Jul 17 14:03:10 devshed dovecot: lda(test(a)mail.vdl): Debug: sieve: script file /vhome/mail.vdl/home/cedrict/mail/sieve/test not found Jul 17 14:03:10 devshed dovecot: lda(test(a)mail.vdl): Debug: sieve: user's script /vhome/mail.vdl/home/cedrict/mail/sieve/test doesn't exist (trying default script location instead) Jul 17 14:03:10 devshed dovecot: lda(test(a)mail.vdl): Debug: sieve: no default script configured for user Jul 17 14:03:10 devshed dovecot: lda(test(a)mail.vdl): Debug: sieve: user has no valid location for a personal script Jul 17 14:03:10 devshed dovecot: lda(test(a)mail.vdl): Debug: sieve: no scripts to execute: reverting to default delivery. I also tried adding the username in the sql query, same problem, there's the debug : [root@devshed ~]# Jul 17 14:11:59 devshed dovecot: lda: Debug: Loading modules from directory: /vdl/lib/dovecot Jul 17 14:11:59 devshed dovecot: lda: Debug: Module loaded: /vdl/lib/dovecot/lib10_quota_plugin.so Jul 17 14:11:59 devshed dovecot: lda: Debug: Module loaded: /vdl/lib/dovecot/lib90_sieve_plugin.so Jul 17 14:11:59 devshed dovecot: auth: Debug: master in: USER 1 test(a)mail.vdl service=lda Jul 17 14:11:59 devshed dovecot: auth-worker(7385): Debug: Loading modules from directory: /vdl/lib/dovecot/auth Jul 17 14:11:59 devshed dovecot: auth-worker(7385): Debug: sql(test(a)mail.vdl): SELECT s_courriel_utilisateur.utilisateur as username, concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur) as home, concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur,"/mail/index") as "index", concat("/vhome/",s_courriel_domaine.nom,"/home/",s_courriel_utilisateur.utilisateur,"/mail/control") as control, concat("/var/spool/vmail/",s_courriel_domaine.nom,"/",s_courriel_utilisateur.utilisateur) as inbox, "maildir++" as layout, s_courriel_utilisateur.uid as uid,s_courriel_domaine.gid as gid FROM s_courriel_utilisateur left join s_courriel_alias on s_courriel_utilisateur.id=s_courriel_alias.utilisateur and s_courriel_alias.archive !=1 ,s_courriel_domaine WHERE s_courriel_utilisateur.archive !=1 and s_courriel_domaine.archive !=1 and s_courriel_utilisateur.domaine=s_courriel_domaine.id and s_courriel_domaine.nom = 'mail.vdl' and ( s_courriel_utilisateur.utilisateur = 'tes Jul 17 14:11:59 devshed dovecot: auth-worker(7385): Debug: auth(test(a)mail.vdl): username changed test(a)mail.vdl -> cedrict(a)mail.vdl Jul 17 14:11:59 devshed dovecot: auth: Debug: userdb out: USER 1 test(a)mail.vdl home=/vhome/mail.vdl/home/cedrict index=/vhome/mail.vdl/home/cedrict/mail/index control=/vhome/mail.vdl/home/cedrict/mail/control inbox=/var/spool/vmail/mail.vdl/cedrict layout=maildir++ uid=60001 gid=231 Jul 17 14:11:59 devshed dovecot: lda: Debug: auth input: test(a)mail.vdl home=/vhome/mail.vdl/home/cedrict index=/vhome/mail.vdl/home/cedrict/mail/index control=/vhome/mail.vdl/home/cedrict/mail/control inbox=/var/spool/vmail/mail.vdl/cedrict layout=maildir++ uid=60001 gid=231 Jul 17 14:11:59 devshed dovecot: lda: Debug: Added userdb setting: plugin/control=/vhome/mail.vdl/home/cedrict/mail/control Jul 17 14:11:59 devshed dovecot: lda: Debug: Added userdb setting: plugin/inbox=/var/spool/vmail/mail.vdl/cedrict Jul 17 14:11:59 devshed dovecot: lda: Debug: Added userdb setting: plugin/index=/vhome/mail.vdl/home/cedrict/mail/index Jul 17 14:11:59 devshed dovecot: lda: Debug: Added userdb setting: plugin/layout=maildir++ Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): Debug: Effective uid=60001, gid=231, home=/vhome/mail.vdl/home/cedrict Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): Debug: quota: No quota setting - plugin disabled Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): Debug: maildir++: root=/vhome/mail.vdl/home/cedrict/mail, index=, indexpvt=, control=/vhome/mail.vdl/home/cedrict/mail/control, inbox=/var/spool/vmail/mail.vdl/test, alt= Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): Debug: quota: No quota setting - plugin disabled Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): Debug: none: root=, index=, indexpvt=, control=, inbox=, alt= Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): Debug: Destination address: test(a)mail.vdl (source: user@hostname) Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): Debug: sieve: Pigeonhole version 0.4.1 initializing Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): Debug: sieve: script file /vhome/mail.vdl/home/cedrict/mail/sieve/test not found Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): Debug: sieve: user's script /vhome/mail.vdl/home/cedrict/mail/sieve/test doesn't exist (trying default script location instead) Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): Debug: sieve: no default script configured for user Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): Debug: sieve: user has no valid location for a personal script Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): Debug: sieve: no scripts to execute: reverting to default delivery. Jul 17 14:11:59 devshed dovecot: lda(test(a)mail.vdl): msgid=<201307171811.r6HIBxWe007380(a)devshed.derytelecom.ca>: saved mail to INBOX Cedric

3 8

Re: [Dovecot] dovecot: imap-login: Aborted login
by Joseph Tam 23 Jul '13

23 Jul '13

Adnane <mls(a)adnane.me> writes: > but I cant send mails > > Jul 23 03:01:34 mailer postfix/anvil[9245]: statistics: max connection > rate 1/60s for (smtp:209.85.220.177) at Jul 23 02:58:13 > Jul 23 03:01:34 mailer postfix/anvil[9245]: statistics: max connection > count 1 for (smtp:209.85.220.177) at Jul 23 02:58:13 > Jul 23 03:01:34 mailer postfix/anvil[9245]: statistics: max cache size 1 > at Jul 23 02:58:13 Not a dovecot issue. In fact, neither was your previous problem, which was a mail reader configuration problem. Joseph Tam <jtam.home(a)gmail.com>

2 1

[Dovecot] dovecot: imap-login: Aborted login
by Adnane 23 Jul '13

23 Jul '13

Hello every one first I'am new to mail servers, I have followed this tutorial --> https://library.linode.com/email/postfix/postfix2.9.6-dovecot2.0.19-mysql?f… to set up an Ubuntu 12.04 Dovecot postfix mail box for a subdomain mailer.adnane.me, I think I followed every thing right but I get disconnected when I try to access adnane(a)mailer.adnane.me with thunderbird dig mx mailer.adnane.me +short 1 mailer.adnane.me. root@mailer:~# postmap -q mailer.adnane.me mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf 1 root@mailer:~# postmap -q adnane(a)mailer.adnane.me mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf 1 I think the issue is with authentication root@mailer:~# tail -f /var/log/syslogJul Jul 22 03:34:41 mailer dovecot:imap-login: Disconnected (no auth attempts): rip=41.251.155.145, lip=5.135.151.43, TLS Jul 22 03:35:02 mailer dovecot: imap-login: Disconnected (no auth attempts): rip=41.251.155.145, lip=5.135.151.43, TLS handshaking: Disconnected Jul 22 03:35:02 mailer dovecot: imap-login: Disconnected (no auth attempts): rip=41.251.155.145, lip=5.135.151.43, TLS handshaking: Disconnected Jul 22 03:35:03 mailer dovecot: imap-login: Disconnected (no auth attempts): rip=41.251.155.145, lip=5.135.151.43, TLS: Disconnected plz let me know which conf files I need to post here, tnx.

3 4

Re: [Dovecot] dovecot: imap-login: Aborted login
by Joseph Tam 23 Jul '13

23 Jul '13

From: Adnane <mls(a)adnane.me> writes: > Jul 22 22:32:53 mailer dovecot: pop3-login: Disconnected (tried to use > disabled plaintext auth): rip=196.217.182.199, lip=5.135.151.43 > Jul 22 22:36:04 mailer dovecot: pop3(adnane(a)mailer.adnane.me): > Disconnected: Logged out top=0/0, retr=0/0, del=0/0, size=0 Looks like a mail client issue: you're not enabling STARTTLS on port 110. Fiddle with the SSL configuration. Joseph Tam <jtam.home(a)gmail.com>

1 0

[Dovecot] zlib error when running doveadm
by Michael Long 22 Jul '13

22 Jul '13

I manually fixed it by copying src/plugins/zlib/lib20_zlib_plugin.la to /usr/local/lib/dovecot/doveadm I do not understand why 'make install' won't do that? A bug perhaps?

1 0

[Dovecot] zlib error when running doveadm
by Michael Long 22 Jul '13

22 Jul '13

> Looks like you have two versions installed and are mixing them up. I checked and only one binary is on the system. I took a look in the directory /usr/local/lib/dovecot/doveadm/ and it appears the upgrade rebuilt all libraries EXCEPT zlib. Any ideas? -rw-r--r-- 1 root root 125910 Jul 22 10:58 lib10_doveadm_acl_plugin.a -rwxr-xr-x 1 root root 1070 Jul 22 10:58 lib10_doveadm_acl_plugin.la -rwxr-xr-x 1 root root 88190 Jul 22 10:58 lib10_doveadm_acl_plugin.so -rw-r--r-- 1 root root 54812 Jul 22 10:58 lib10_doveadm_expire_plugin.a -rwxr-xr-x 1 root root 1091 Jul 22 10:58 lib10_doveadm_expire_plugin.la -rwxr-xr-x 1 root root 44763 Jul 22 10:58 lib10_doveadm_expire_plugin.so -rw-r--r-- 1 root root 89116 Jul 22 10:58 lib10_doveadm_quota_plugin.a -rwxr-xr-x 1 root root 1084 Jul 22 10:58 lib10_doveadm_quota_plugin.la -rwxr-xr-x 1 root root 61137 Jul 22 10:58 lib10_doveadm_quota_plugin.so -rw-r--r-- 1 root root 369576 Jul 22 10:47 lib10_doveadm_sieve_plugin.a -rwxr-xr-x 1 root root 1248 Jul 22 10:47 lib10_doveadm_sieve_plugin.la -rwxr-xr-x 1 root root 208863 Jul 22 10:47 lib10_doveadm_sieve_plugin.so -rw-r--r-- 1 root root 26166 Apr 9 14:30 lib10_doveadm_zlib_plugin.a -rwxr-xr-x 1 root root 1077 Apr 9 14:30 lib10_doveadm_zlib_plugin.la -rwxr-xr-x 1 root root 25243 Apr 9 14:30 lib10_doveadm_zlib_plugin.so -rw-r--r-- 1 root root 100120 Jul 22 10:58 lib20_doveadm_fts_plugin.a -rwxr-xr-x 1 root root 1070 Jul 22 10:58 lib20_doveadm_fts_plugin.la -rwxr-xr-x 1 root root 65515 Jul 22 10:58 lib20_doveadm_fts_plugin.so Configure does seem to see it though: checking zlib.h usability... yes checking zlib.h presence... yes checking for zlib.h... yes checking bzlib.h usability... yes checking bzlib.h presence... yes checking for bzlib.h... yes checking for BZ2_bzdopen in -lbz2... yes

1 0

[Dovecot] OT: SAN vs Flash only SAN-less VM architecture for data storage
by Charles Marcus 21 Jul '13

21 Jul '13

Hello all, I am investigating options for leveraging our companies two locations, to provide fault tolerance/redundancy for our VM infrastructure. I was looking at SAN storage options, but ran across an interesting article, and would like opinions. It sounds great, a real win-win as to cost *and* performance... We have redundant/identical hosts at each location that can fulfill the requirements discussed... http://www.storage-switzerland.com/Articles/Entries/2012/9/20_The_Benefits_… or http://tinyurl.com/khwuspo Stan, I'm especially interested in your take, considering your experience with high end SANs and VM storage environments... Thanks, -- Best regards, Charles

4 3

[Dovecot] Error: stat dove 2.1.16 failed: File name too long
by Robert Schetterer 21 Jul '13

21 Jul '13

Hi , from some migration i have some long subfolder list sdbox ( for sure nonsense ) any good idea how to fix ? Best Regards MfG Robert Schetterer -- [*] sys4 AG http://sys4.de, +49 (89) 30 90 46 64 Franziskanerstraße 15, 81669 München Sitz der Gesellschaft: München, Amtsgericht München: HRB 199263 Vorstand: Patrick Ben Koetter, Axel von der Ohe, Marc Schiffbauer Aufsichtsratsvorsitzender: Florian Kirstein

1 1

Re: [Dovecot] Sieve info
by Reindl Harald 21 Jul '13

21 Jul '13

Am 21.07.2013 00:45, schrieb Sam Flint: > > On Jul 20, 2013 5:39 PM, "Reindl Harald" <h.reindl(a)thelounge.net <mailto:h.reindl@thelounge.net>> wrote: >> >> Am 21.07.2013 00:34, schrieb Sam Flint: >> > I'm using Dovecot v2, and I can't seem to find any info abut using sieve >> > with the LDA, or the ManageSieve protocol, can you please point me un the >> > right direction? >> >> google "dovecot sieve" leads to >> http://wiki2.dovecot.org/Pigeonhole/Sieve/Configuration > > Thank you very muuch! The pointer on the v1 wiki pointed to a non-existent page http://wiki2.dovecot.org/ is for version >= 2.0 many configs are completly different in v2 http://wiki.dovecot.org/ This documentation is for Dovecot v1.x, see wiki2 for v2.0 documentation

1 0

[Dovecot] zlib plugin "undefined symbol: imap_module_register"
by Alexander Weber 19 Jul '13

19 Jul '13

Hi all, i've tried to enable the zlib plugin within die LDA, but i've got some strange errors dovecot: lda: Error: dlopen(/usr/lib/dovecot/modules/lib30_imap_zlib_plugin.so) failed: /usr/lib/dovecot/modules/lib30_imap_zlib_plugin.so: undefined symbol: imap_module_register dovecot: lda: Fatal: Couldn't load required plugins am i missing something within the config? doveconf -n # 2.0.19: /etc/dovecot/dovecot.conf # OS: Linux 3.2.0-49-generic x86_64 Ubuntu 12.04.2 LTS base_dir = /var/run/dovecot/ disable_plaintext_auth = no hostname = mail.local mail_location = maildir:~/Maildir managesieve_notify_capability = mailto managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave namespace { list = yes location = maildir:/home/shared:CONTROL=~/.Maildir/control/Shared:INDEX=~/.Maildir/index/Shared prefix = shared/ separator = / subscriptions = yes type = public } namespace { inbox = yes location = prefix = separator = / type = private } passdb { driver = pam } passdb { args = /etc/dovecot/dovecot-ldap.conf driver = ldap } plugin { sieve = ~/.dovecot.sieve sieve_dir = ~/sieve zlib_save = gz zlib_save_level = 6 } postmaster_address = postmaster@localhost protocols = imap sieve service auth { unix_listener /var/spool/postfix/private/dovecot-auth { group = postfix mode = 0660 user = postfix } } service imap-login { inet_listener imaps { port = 993 ssl = yes } } ssl_ca = </etc/ssl/some_magic_wildcard.pem ssl_cert = </etc/ssl/some_magic_wildcard.pem ssl_cipher_list = HIGH:MEDIUM:+TLSv1:!SSLv2:+SSLv3 ssl_key = </etc/ssl/some_magic_wildcard.pem userdb { driver = passwd } userdb { args = /etc/dovecot/dovecot-ldap.conf driver = ldap } protocol imaps { imap_client_workarounds = delay-newmail mail_max_userip_connections = 50 } protocol lda { deliver_log_format = msgid=%m: %$ mail_plugins = sieve, zlib, acl, imap_zlib postmaster_address = postmaster quota_full_tempfail = yes rejection_reason = Your message to <%t> was automatically rejected:%n%r } protocol imap { mail_plugins = zlib, acl, imap_zlib } Mit freundlichen Gruessen / best regards papaya Software GmbH i.A. Alexander Weber -- papaya Software GmbH | Im MediaPark 5 | 50670 Koeln | Germany Tel./Ph.: +49-221-5743-8070 | Fax: +49-221-5743-8099 mailto:weber@papaya-cms.com | http://www.papaya-cms.com/ -- Geschaeftsfuehrer: Andreas Jacobi, André Schnitzler, Daniel Schäfer Sitz& Registergericht: Koeln | HRB 60030 | USt.-Id.-Nr.: DE 255642963 --

2 1

[Dovecot] Archiving mail
by Koenraad Lelong 18 Jul '13

18 Jul '13

Hi, I'm going to migrate my company-mailserver to new hardware. I would like to take the opportunity to archive some older mail. But I would like to have it still accessible, would this be possible with dovecot ? I mean, I would like to put that older mail from different users (I got about 50 users) on some read-only media but mount that media in the users mail-dirs. That way I will have less to backup after I backup that old mail and store it safely away. I can't convince my users to really clean up their mailboxes, so I backup more than 100GB mail while the total backup is a bit more than 300GB. Writing this I realise I could give each user a folder oldmail and symlink that to a read-only oldmail folder. Would this work ? I will have to find out how my backup-software can ignore the oldmail-folder. Thanks for any suggestions, Koenraad Lelong

3 2

[Dovecot] Password encryption type for dovecot & postfix saslauthd with mysql
by Simon 18 Jul '13

18 Jul '13

Hi There, We are using dovecot v2.2.4 (compiled from source) and postfix (yum install) on Centos 6.4. We are storing our virtual user config in mysql. Server 1 has dovecot/postfix and accepts incoming mail from our mail filter servers - this is purely for IMAP/POP services. Server 2 has postfix for our clients to send email via TLS/saslauthd. Both use the same (separate) mysql server for config. One issue is that we have a requirement to merge user / passwords for sending clients from two sources: 1) the dovecot mailbox list 2). another list. The dovecot user list is email + password. The other list is username + password. To that end we have created a view table in mysql that merges the two.. tables + view look a little like this: table: mail_users (for dovecot) email,password test(a)test1.com,CRAM-MD5_PASSWORD test2(a)test1.com,CRAM-MD5_PASSWORD bla(a)bla.com,CRAM-MD5_PASSWORD table: mail_senders_other username,password username1,CRAM-MD5_PASSWORD something_else,CRAM-MD5_PASSWORD view: mail_senders (for postfix) username,password test(a)test1.com,CRAM-MD5_PASSWORD test2(a)test1.com,CRAM-MD5_PASSWORD bla(a)bla.com,CRAM-MD5_PASSWORD username1,CRAM-MD5_PASSWORD something_else,CRAM-MD5_PASSWORD I have dovecot working fine, but just need a little push in the correct direction (please) to figure out the correct settings and password encryption scheme to make the above work. Many thanks! Simon

1 0

[Dovecot] Dovecot 2.2.4 does not create home directory?
by Dmitry . 17 Jul '13

17 Jul '13

Hi, Does not create, or something I did wrong? Here http://wiki2.dovecot.org/VirtualUsers/Home it is written Home vs. mail directory Home directory shouldn't be the same as mail directory. It's possible to do that, but you might run into trouble with it sooner or later. Some problems with this are: and Ways to set up home directory The home directory is the same as the mail directory. If for example home=/var/vmail/domain/user/ mail=/var/vmail/domain/user/mail/, set: mail_home = /var/vmail/%d/%n mail_location = maildir:~/mail I think I've done it so. And yet, here http://wiki.dovecot.org/HowTo/SimpleVirtualInstall it is written Users can be added by editing this file. Dovecot automatically notices the new users immediately after they're added. It also creates their home directories when the user logs in. However, the directory is not created. My config: # dovecot -n # 2.2.4: /etc/dovecot/dovecot.conf # OS: Linux 3.9.6 x86_64 Slackware 14.0 auth_debug = yes auth_debug_passwords = yes auth_mechanisms = plain login digest-md5 cram-md5 rpa apop auth_verbose = yes auth_verbose_passwords = plain debug_log_path = /var/log/dovecot/dovecot.debug.log disable_plaintext_auth = no info_log_path = /var/log/dovecot/dovecot.info.log lda_mailbox_autocreate = yes listen = 192.168.1.1 log_path = /var/log/dovecot/dovecot.log mail_debug = yes mail_gid = dovecot mail_uid = dovecot managesieve_notify_capability = mailto managesieve_sieve_capability = fileinto reject envelope encoded-character vacation subaddress comparator-i;ascii-numeric relational regex imap4flags copy include variables body enotify environment mailbox date ihave namespace inbox { inbox = yes location = mailbox Drafts { auto = subscribe special_use = \Drafts } mailbox Sent { auto = subscribe special_use = \Sent } mailbox Spam { auto = subscribe special_use = \Junk } mailbox Trash { auto = subscribe special_use = \Trash } prefix = } passdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } plugin { antispam_allow_append_to_spam = NO antispam_backend = dspam antispam_debug_target = syslog antispam_dspam_args = --user;%Lu;--deliver=;--source=error;--signature=%%s antispam_dspam_binary = /usr/bin/dspam antispam_dspam_notspam = --class=innocent antispam_dspam_result_blacklist = Virus;Blocklisted;Blacklisted antispam_dspam_result_header = X-DSPAM-Result antispam_dspam_spam = --class=spam antispam_signature = X-DSPAM-Signature antispam_signature_missing = move antispam_skip_from_line = NO antispam_spam = Spam;spam;SPAM;Junk;junk;JUNK; antispam_trash = Trash;trash;Deleted;deleted;Deleted Items;Deleted Messages; antispam_verbose_debug = 1 sieve = ~/.dovecot.sieve sieve_default = /etc/dovecot/sieve/default.sieve sieve_dir = ~/sieve sieve_global_dir = /etc/dovecot/sieve/ } protocols = imap pop3 lmtp sieve service lmtp { inet_listener lmtp { address = 127.0.0.1 port = 24 } } service managesieve-login { inet_listener sieve { port = 4190 } } ssl_cert = </etc/dovecot/ssl/key.pem ssl_key = </etc/dovecot/ssl/key.pem userdb { args = /etc/dovecot/dovecot-sql.conf driver = sql } verbose_ssl = yes protocol lmtp { mail_plugins = " sieve" } protocol lda { mail_plugins = " sieve" } protocol imap { mail_max_userip_connections = 15 mail_plugins = " antispam" } protocol imaps { mail_max_userip_connections = 15 mail_plugins = " antispam" } # grep -v '^ *$#.*$\?$' dovecot-sql.conf driver = pgsql connect = host=localhost dbname=dbname user=user password=password default_pass_scheme = PLAIN password_query = SELECT password FROM users WHERE email = '%u' AND enabled = 1 user_query = SELECT \ concat('/var/spool/vmail/', home) AS home, \ concat('maildir:', maildir) AS mail \ FROM users WHERE email = '%u' AND enabled = 1 where in db home = "example.com/test/" maildir = "Maildir/" /etc/passwd dovecot:x:1202:202:Dovecot:/dev/null:/bin/bash dovenull:x:1203:203:Dovenull:/dev/null:/bin/false /etc/group dovecot:x:202: dovenull:x:203: cd /var/spool # ls -l drwxrwxr-x 4 dovecot dovecot 4096 Jul 17 12:41 vmail /var/log/dovecot/dovecot.debug.log Jul 17 12:49:41 auth: Debug: Loading modules from directory: /usr/lib64/dovecot/auth Jul 17 12:49:41 auth: Debug: Read auth token secret from /var/run/dovecot/auth-token-secret.dat Jul 17 12:49:41 auth: Debug: auth client connected (pid=10501) Jul 17 12:49:41 auth: Debug: client in: AUTH 1 CRAM-MD5 service=imap session=RONGFqLhrgDAqAPO lip=192.168.1.1 rip=192.168.1.2 lport=143 rport=50094 Jul 17 12:49:41 auth: Debug: client passdb out: CONT 1 PDk3MDcyMzA1OTYxMTU0MzguMTM3Mzk4NjE4MUBtYWlsPg== Jul 17 12:49:41 auth: Debug: client in: CONT 1 dGVzdEBoYXJkcmV2aWV3LnJ1IDFhOTE0NDBmZDk1OGE5ZWI0MWVkN2Q4ZDdhOGIzNzFi (previous base64 data may contain sensitive data) Jul 17 12:49:41 auth: Debug: sql(test(a)example.com,192.168.1.2,<RONGFqLhrgDAqAPO>): query: SELECT password FROM users WHERE email = 'test(a)example.com' AND enabled = 1 Jul 17 12:49:41 auth: Debug: password(test(a)example.com,192.168.1.2,<RONGFqLhrgDAqAPO>): Generating CRAM-MD5 from user 'test@example.com@', password 'test' Jul 17 12:49:41 auth: Debug: password(test(a)example.com,192.168.1.2,<RONGFqLhrgDAqAPO>): Credentials: 6062bc903ac97de43f0b5d33ebe8c1a63bb9ae1a88ec39cf6fd85a645de8c63a Jul 17 12:49:41 auth: Debug: client passdb out: OK 1 user= test(a)example.com Jul 17 12:49:41 auth: Debug: master in: REQUEST 2206334977 10501 1 49e1fcdcc5e1c2becb50c3b47d31cdeb session_pid=10506 Jul 17 12:49:41 auth: Debug: sql(test(a)example.com,192.168.1.2,<RONGFqLhrgDAqAPO>): SELECT concat('/var/spool/vmail/', home) AS home, concat('maildir:', maildir) AS mail FROM users WHERE email = 'test(a)example.com' AND enabled = 1 Jul 17 12:49:41 auth: Debug: master userdb out: USER 2206334977 test(a)example.com home=/var/spool/vmail/example.com/test/ mail=maildir:Maildir/ auth_token=670c839af976e3c0c74db1754e28ff40a2557095 Jul 17 12:49:41 imap: Debug: Loading modules from directory: /usr/lib64/dovecot Jul 17 12:49:41 imap: Debug: Module loaded: /usr/lib64/dovecot/lib90_antispam_plugin.so Jul 17 12:49:41 imap: Debug: Added userdb setting: mail=maildir:Maildir/ Jul 17 12:49:41 imap(test(a)example.com): Debug: Effective uid=1202, gid=202, home=/var/spool/vmail/example.com/test/ Jul 17 12:49:41 imap(test(a)example.com): Debug: Home dir not found: /var/spool/vmail/example.com/test/ Jul 17 12:49:41 imap(test(a)example.com): Debug: Namespace inbox: type=private, prefix=, sep=, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:Maildir/ Jul 17 12:49:41 imap(test(a)example.com): Debug: maildir++: root=Maildir, index=, indexpvt=, control=, inbox=Maildir, alt= Jul 17 12:49:41 imap(test(a)example.com): Debug: Namespace : Maildir doesn't exist yet, using default permissions Jul 17 12:49:41 imap(test(a)example.com): Debug: Namespace : Using permissions from Maildir: mode=0700 gid=default Thank you! Regards, Dmitry

4 6

[Dovecot] Variable similar to %u but providing the username changed by a database lookup?
by Axel Luttgens 17 Jul '13

17 Jul '13

Hello, Variable %u may be used in dovecot.conf whenever the "full username" is needed. But the expansion of %u returns the username before a possible change performed thru a password or user database lookup (e.g., in the case of a SQL database, thru as "AS user" clause). Is there a variable that would expand to the changed name when used in the configuration file? TIA, Axel

2 3