This is the configuration...
-------
$ sudo doveconf -n
# 2.2.15: /etc/dovecot/dovecot.conf
# Pigeonhole version 0.4.6 (3e924b1b6c5c+)
# OS: Linux 3.16.0-31-generic x86_64 Ubuntu 14.04.2 LTS
auth_debug = yes
auth_mechanisms = plain login
auth_verbose = yes
first_valid_uid = 1000
mail_debug = yes
mail_location = maildir:~/Maildir
namespace inbox {
inbox = yes
location =
mailbox Drafts {
special_use = \Drafts
}
mailbox Junk {
special_use = \Junk
}
mailbox Sent {
special_use = \Sent
}
mailbox "Sent Messages" {
special_use = \Sent
}
mailbox Trash {
special_use = \Trash
}
prefix =
}
passdb {
driver = pam
}
passdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
plugin {
sieve = file:~/sieve;active=~/.dovecot.sieve
}
postmaster_address = [email protected]
protocols = " imap"
service auth {
unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0666
user = postfix
}
}
ssl_cert = </etc/dovecot/dovecot.pem
ssl_cipher_list =
ECDH+AESGCM:DH+AESGCM:ECDH+AES256:DH+AES256:ECDH+AES128:DH+AES:ECDH+3DES:DH+3DES:RSA+AESGCM:RSA+AES:RSA+3DES:!aNULL:!MD5:!DSS
ssl_key = </etc/dovecot/private/dovecot.pem
ssl_protocols = !SSLv2 !SSLv3
userdb {
driver = passwd
}
userdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
On 2015年03月07日 00:12, Emmanuel Chanel wrote:
Version: 2.2.9 & 2.2.15 (
http://ppa.launchpad.net/malte.swart/dovecot-2.2/ubuntu )
OS: Ubuntu 14.04 Server LTS
I installed Ubuntu 14.04.2 LTS newly on my new server...
And I try to configure the mail server considering both my system
account and the virtual mailboxes, by seeing
https://www.exratione.com/2014/05/a-mailserver-on-ubuntu-1404-postfix-dovecot-mysql/
But when I configured by uncommenting #!include auth-sql.conf.ext , it
doesn't auth...
Possibly, it's a trouble with the configurations of postfix and of
dovecot. But I don't understand why...
When I enable either auth-system.conf.ext or auth-sql.conf.ext , it
works...
My doveconf -n http://pastebin.com/MU1LL63d
dovecot-sql.conf.ext http://pastebin.com/PJkTnPB3
tail /var/log/mail.log by debug mode / dovecot 2.2.15
http://pastebin.com/1TRQL49d
Mar 6 07:45:12 gateway dovecot: auth: Debug: client
in:
AUTH#0114#011PLAIN#011service=imap#011secured#011session=xS6uSpIQvQDAqAAC#011lip=192.168.0.1#011rip=192.168.0.2#011lport=143#011rport=38333
Mar 6 07:45:12 gateway dovecot: auth: Debug: client passdb out:
CONT#0114#011
Mar 6 07:45:12 gateway dovecot: auth: Debug: client in: CONT<hidden>
Mar 6 07:45:12 gateway dovecot: auth-worker(22933): Debug:
pam(emmanuel,192.168.0.2): lookup service=dovecot
Mar 6 07:45:12 gateway dovecot: auth: Error: auth worker: Aborted
PASSV request for emmanuel: Worker process died unexpectedly
Mar 6 07:45:12 gateway dovecot: auth-worker(22936): Debug:
sql(emmanuel,192.168.0.2): query: SELECT username as user, password,
'/home/vmail//emmanuel' as userdb_home,
'maildir:/home/vmail//emmanuel' as userdb_mail, 65000 as userdb_uid, 8
as userdb_gid FROM mailbox WHERE username = 'emmanuel' AND active = '1'
Mar 6 07:45:12 gateway dovecot: auth-worker(22933): Fatal: master:
service(auth-worker): child 22933 killed with signal 11 (core dumped)
Mar 6 07:45:12 gateway dovecot: auth-worker(22936):
sql(emmanuel,192.168.0.2): unknown user
Mar 6 07:45:12 gateway dovecot: auth-worker(23755): Debug: Loading
modules from directory: /usr/lib/dovecot/modules/auth
Mar 6 07:45:12 gateway dovecot: auth-worker(23755): Debug: Module
loaded: /usr/lib/dovecot/modules/auth/libdriver_mysql.so
Mar 6 07:45:14 gateway dovecot: auth: Debug: client passdb out:
FAIL#0114#011user=emmanuel#011temp
Mar 6 07:45:14 gateway dovecot: auth: Debug: client in:
AUTH#0115#011LOGIN#011service=imap#011secured#011session=xS6uSpIQvQDAqAAC#011lip=192.168.0.1#011rip=192.168.0.2#011lport=143#011rport=38333
Mar 6 07:45:14 gateway dovecot: auth: Debug: client passdb out:
CONT#0115#011VXNlcm5hbWU6
Mar 6 07:45:14 gateway dovecot: auth: Debug: client in: CONT<hidden>
Mar 6 07:45:14 gateway dovecot: auth: Debug: client passdb out:
CONT#0115#011UGFzc3dvcmQ6
Mar 6 07:45:14 gateway dovecot: auth: Debug: client in: CONT<hidden>
Mar 6 07:45:14 gateway dovecot: auth-worker(22936): Debug:
pam(emmanuel,192.168.0.2): lookup service=dovecot
Mar 6 07:45:14 gateway dovecot: auth: Error: auth worker: Aborted
PASSV request for emmanuel: Worker process died unexpectedly
Mar 6 07:45:14 gateway dovecot: auth-worker(23755): Debug:
sql(emmanuel,192.168.0.2): query: SELECT username as user, password,
'/home/vmail//emmanuel' as userdb_home,
'maildir:/home/vmail//emmanuel' as userdb_mail, 65000 as userdb_uid, 8
as userdb_gid FROM mailbox WHERE username = 'emmanuel' AND active = '1'
Mar 6 07:45:14 gateway dovecot: auth-worker(22936): Fatal: master:
service(auth-worker): child 22936 killed with signal 11 (core dumped)
Mar 6 07:45:14 gateway dovecot: auth-worker(23755):
sql(emmanuel,192.168.0.2): unknown user
Mar 6 07:45:14 gateway dovecot: auth-worker(23764): Debug: Loading
modules from directory: /usr/lib/dovecot/modules/auth
Mar 6 07:45:14 gateway dovecot: auth-worker(23764): Debug: Module
loaded: /usr/lib/dovecot/modules/auth/libdriver_mysql.so
Mar 6 07:45:16 gateway dovecot: auth: Debug: client passdb out:
FAIL#0115#011user=emmanuel#011temp
Mar 6 07:45:16 gateway dovecot: auth: Debug: client in:
AUTH#0116#011PLAIN#011service=imap#011secured#011session=xS6uSpIQvQDAqAAC#011lip=192.168.0.1#011rip=192.168.0.2#011lport=143#011rport=38333#011resp=<hidden>
Mar 6 07:45:16 gateway dovecot: auth-worker(23755): Debug:
pam(emmanuel,192.168.0.2): lookup service=dovecot
Mar 6 07:45:16 gateway dovecot: auth: Error: auth worker: Aborted
PASSV request for emmanuel: Worker process died unexpectedly
Mar 6 07:45:16 gateway dovecot: auth-worker(23764): Debug:
sql(emmanuel,192.168.0.2): query: SELECT username as user, password,
'/home/vmail//emmanuel' as userdb_home,
'maildir:/home/vmail//emmanuel' as userdb_mail, 65000 as userdb_uid, 8
as userdb_gid FROM mailbox WHERE username = 'emmanuel' AND active = '1'
Mar 6 07:45:16 gateway dovecot: auth-worker(23755): Fatal: master:
service(auth-worker): child 23755 killed with signal 11 (core dumped)
Mar 6 07:45:16 gateway dovecot: auth-worker(23764):
sql(emmanuel,192.168.0.2): unknown user
Mar 6 07:45:16 gateway dovecot: auth-worker(23767): Debug: Loading
modules from directory: /usr/lib/dovecot/modules/auth
Mar 6 07:45:16 gateway dovecot: auth-worker(23767): Debug: Module
loaded: /usr/lib/dovecot/modules/auth/libdriver_mysql.so
Mar 6 07:45:18 gateway dovecot: auth: Debug: client passdb out:
FAIL#0116#011user=emmanuel#011temp
--
Emmanuel Chanel( [email protected] )