No support help needed, just a success report having Dovecot integrate
with Vexim (exim with web based frontend and sql db):
http://silverwraith.com/vexim/
Just wanted to forward some configs to the list if anyone finds them
useful. I just switched from vexim's normal "virtual_delivery" to
"dovecot_virtual_delivery" so I could use sieve, which works nicely
with
Horde. This is mostly as described on the wiki:
http://wiki.dovecot.org/LDA
I'm using maildirsize in my case. There were a few things that had to be
done to get it to work with quotas, I thought I would just spell it all
out for anyone reading this list in the future:
I can add stuff if anyone would like to the wiki, some of these items
are elsewhere in the wiki, I wanted to ask before I put a full page up
for integration with Vexim in particular. Should I do this, or just
throw bits and peices where they seem relevant?
This was on FreeBSD, hence the /usr/local/etc/ stuff.
Exim's 'configure' file:
===============================virtual_domains:
#file_transport = virtual_delivery
file_transport = dovecot_virtual_delivery
virtual_domains_catchall:
#file_transport = virtual_delivery
file_transport = dovecot_virtual_delivery
dovecot_virtual_delivery:
driver = pipe
command = /usr/local/libexec/dovecot/deliver -d \
$local_part@$domain
message_prefix message_suffix delivery_date_add
envelope_to_add
return_path_add
log_output
user = mailnull
dovecot-sql.conf:
===============================driver = mysql
connect = host=HOSTNAME dbname=vexim user=vexim password=PASSWORD
default_pass_scheme = CRYPT
password_query = SELECT crypt as password FROM users,domains \
WHERE users.username = '%u' AND users.enabled = '1' \
AND users.type='local' and domains.enabled='1' \
AND domains.domain_id = users.domain_id
user_query = SELECT pop AS home, 26 AS uid, 26 AS gid, \
CONCAT('maildir:storage=', quota*1024) AS quota \
FROM users WHERE username = '%u' AND enabled = '1'
Mostly complete dovecot.conf (much of this is obvious, but it's easier
than piecing things together from various mailing lists posts/docs):
===============================
mail_location = maildir:%h/Maildir
first_valid_gid = 26
last_valid_gid = 26
protocol lda {
mail_plugins = quota
}
auth default {
mechanisms = plain
passdb sql {
args = /usr/local/etc/dovecot-sql.conf
}
userdb sql {
args = /usr/local/etc/dovecot-sql.conf
}
user = root
socket listen {
master {
path = /var/run/dovecot/auth-master
mode = 0660
user = mailnull
group = mail
}
}
}
plugin {
quota = maildir
}
===============================
--Chris
