Am 03.09.2013 04:22, schrieb Regan Yelcich:
Can anyone point me in the direction of a detailed how-to for setting up a
postfix and dovecot (proxy) node with dbmail?
In particular I'm looking for a how-to which shows dovecot authenticating
against the dbmail database directly.
The only example I've found is this one which requires a duplication of the
user database.
http://content.fens.org/index.php?q=admin-howto/mail/dovecot2dbmail-proxy
no idea why someone would duplicate existing data
___
[root@testserver:~]$ cat /etc/dovecot/sql.conf
driver = mysql
connect = host=/var/lib/mysql/mysqld.sock dbname=dbmail user=dbmail
password=***
password_query = SELECT passwd as password, '127.0.0.1' as host, userid as
destuser, passwd AS pass, 'Y' AS
nologin, 'Y' AS nodelay, 'Y' AS proxy FROM dbmail_users WHERE userid='%u'
default_pass_scheme = plain
___
[root@testserver:~]$ cat /etc/dovecot/dovecot.conf
# provided services
protocols = imap pop3
# configure ssl
ssl= yes
ssl_cert = /etc/postfix/certs/localhost.pem
ssl_key= /etc/postfix/certs/localhost.pem
ssl_cipher_list=
EECDH+AES:EDH+AES:-SHA1:EECDH+RC4:EDH+RC4:RC4-SHA:EECDH+AES256:EDH+AES256:AES256-SHA:HIGH:!aNULL:!eNULL:!EXP:!MD5:!LOW:!SSLv2
# configure imap-proxy
service imap-login {
inet_listener imap {
address= public-ip
port = 143
}
inet_listener imaps {
address= public-ip
port = 993
}
vsz_limit= 256M
service_count= 0
process_min_avail= 1
process_limit= 1
client_limit = 200
}
# configure pop3-proxy
service pop3-login {
inet_listener pop3 {
address= public-ip
port = 110
}
inet_listener pop3s {
address= public-ip
port = 995
}
vsz_limit= 256M
service_count= 0
process_min_avail= 1
process_limit= 1
client_limit = 200
}
# default settings
imap_capability= IMAP4 IMAP4rev1 ACL RIGHTS=texk NAMESPACE
CHILDREN SORT QUOTA
THREAD=ORDEREDSUBJECT UNSELECT IDLE
login_greeting =
login_log_format_elements = %u %r %m %c
login_log_format = %$: %s
mail_max_userip_connections= 100
auth_mechanisms= CRAM-MD5 DIGEST-MD5 APOP LOGIN PLAIN
disable_plaintext_auth = no
shutdown_clients = no
version_ignore = yes
# Logging
syslog_facility= mail
# authentication process
auth_worker_max_count = 50
auth_cache_size= 1024
auth_cache_ttl = 600
auth_cache_negative_ttl= 600
auth_username_chars=
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890.-_@%
auth_username_translation =
%@AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz
# debug options
auth_debug = no
auth_debug_passwords = no
auth_verbose = no
mail_debug = no
verbose_ssl= no
# configure proxy-database
passdb {
driver= sql
args = /etc/dovecot/sql.conf
}
# we are not using local users
userdb {
driver= static
args = static uid=1 gid=1 home=/dev/null
}
# configure backend for postfix sasl-auth
service auth {
unix_listener /var/spool/postfix/private/auth {
mode = 0660
user = postfix
group= postfix
}
}
signature.asc
Description: OpenPGP digital signature