На VDS стоит Ubuntu 12.10+Postfix+Dovecot 2.1.7+Postfixadmin.Dovecot не может авторизоваться в mysql
Я человек неопытный, английского не знаю, манов по второму Dovecotу практически нет. Вобщем кое-как методом тыка настроил. Thunderbird настройки сервера получает, однако войти никак не может.
Вот мой dovecot -n
# 2.1.7: /etc/dovecot/dovecot.conf
# OS: Linux 3.5.0-25-generic i686 Ubuntu 12.10 ext3
auth_debug = yes
auth_debug_passwords = yes
auth_mechanisms = plain login
auth_socket_path = /var/run/dovecot/auth-master
auth_verbose = yes
base_dir = /var/run/dovecot/
debug_log_path = /var/log/degug_dovecotlog
disable_plaintext_auth = no
lda_mailbox_autocreate = yes
log_path = /var/log/dovecotlog
log_timestamp = "%Y-%m-%d %H:%M:%S "
mail_debug = yes
mail_location = maildir:/home/vmail/%d/%n
mail_privileged_group = vmail
namespace {
inbox = yes
location =
prefix = INBOX.
separator = .
type = private
}
passdb {
driver = pam
}
passdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
postmaster_address = postmaster@da.rs
protocols = imap pop3
service auth {
unix_listener /var/spool/postfix/private/auth {
group = postfix
mode = 0660
user = postfix
}
unix_listener auth-master {
mode = 0600
user = vmail
}
user = root
}
ssl_cert = </etc/ssl/certs/dovecot.pem
ssl_key = </etc/ssl/private/dovecot.pem
userdb {
driver = passwd
}
userdb {
args = /etc/dovecot/dovecot-sql.conf.ext
driver = sql
}
verbose_ssl = yes
protocol lda {
log_path = /home/vmail/dovecot-deliver.log
}
protocol pop3 {
pop3_uidl_format = XuXv
}
Вот dovecot-sql.conf.ext
driver = mysql
connect = host=127.0.0.1 dbname=mailserver user=mailuser password=пароль
default_pass_scheme = PLAIN-MD5
password_query = SELECT email as user, password FROM view_users WHERE email='%u';
Вот degug_dovecotlog
2013-03-19 00:00:42 auth-worker(3783): Debug: sql(postmaster,109.93.97.123): query: SELECT email as user, password FROM view_users WHERE email='postmaster';
2013-03-19 00:00:44 auth: Debug: client out: FAIL 7 user=postmaster
2013-03-19 00:00:44 auth: Debug: client in: AUTH 8 LOGIN service=imap secured session=KUow8zrYJgBtXWF7 lip=78.47.11.221 rip=109.93.97.123 lport=143 rport=57126
2013-03-19 00:00:44 auth: Debug: client out: CONT 8 VXNlcm5hbWU6
2013-03-19 00:00:44 auth: Debug: client in: CONT 8 cG9zdG1hc3Rlcg==
2013-03-19 00:00:44 auth: Debug: client out: CONT 8 UGFzc3dvcmQ6
2013-03-19 00:00:44 auth: Debug: client in: CONT 8 S2lMX1MtMTUubWFzdGVy
2013-03-19 00:00:44 auth-worker(3783): Debug: pam(postmaster,109.93.97.123): lookup service=dovecot
2013-03-19 00:00:44 auth-worker(3783): Debug: pam(postmaster,109.93.97.123): #1/1 style=1 msg=Password:
2013-03-19 00:00:47 auth-worker(3783): Debug: sql(postmaster,109.93.97.123): query: SELECT email as user, password FROM view_users WHERE email='postmaster';
2013-03-19 00:00:49 auth: Debug: client out: FAIL 8 user=postmaster
2013-03-19 00:00:49 auth: Debug: client in: AUTH 9 PLAIN service=imap secured session=KUow8zrYJgBtXWF7 lip=78.47.11.221 rip=109.93.97.123 lport=143 rport=57126 resp=AHBvc3RtYXN0ZXIAS2lMX1MtMTUubWFzdGVy
2013-03-19 00:00:49 auth-worker(3783): Debug: pam(postmaster,109.93.97.123): lookup service=dovecot
2013-03-19 00:00:49 auth-worker(3783): Debug: pam(postmaster,109.93.97.123): #1/1 style=1 msg=Password:
2013-03-19 00:00:51 auth-worker(3783): Debug: sql(postmaster,109.93.97.123): query: SELECT email as user, password FROM view_users WHERE email='postmaster';
2013-03-19 00:00:53 auth: Debug: client out: FAIL 9 user=postmaster
Вот dovecotlog
2013-03-19 00:00:06 imap-login: Warning: SSL: where=0x2001, ret=1: SSLv3 read client key exchange A [109.93.97.123]
2013-03-19 00:00:06 imap-login: Warning: SSL: where=0x2001, ret=1: SSLv3 read finished A [109.93.97.123]
2013-03-19 00:00:06 imap-login: Warning: SSL: where=0x2001, ret=1: SSLv3 write session ticket A [109.93.97.123]
2013-03-19 00:00:06 imap-login: Warning: SSL: where=0x2001, ret=1: SSLv3 write change cipher spec A [109.93.97.123]
2013-03-19 00:00:06 imap-login: Warning: SSL: where=0x2001, ret=1: SSLv3 write finished A [109.93.97.123]
2013-03-19 00:00:06 imap-login: Warning: SSL: where=0x2001, ret=1: SSLv3 flush data [109.93.97.123]
2013-03-19 00:00:06 imap-login: Warning: SSL: where=0x20, ret=1: SSL negotiation finished successfully [109.93.97.123]
2013-03-19 00:00:06 imap-login: Warning: SSL: where=0x2002, ret=1: SSL negotiation finished successfully [109.93.97.123]
2013-03-19 00:00:06 auth-worker(3783): Info: mysql(127.0.0.1): Connected to database mailserver
2013-03-19 00:00:08 auth-worker(3783): Info: pam(postmaster,109.93.97.123): pam_authenticate() failed: Authentication failure (password mismatch?) (given password: правильный пароль)
2013-03-19 00:00:08 auth-worker(3783): Info: sql(postmaster,109.93.97.123): unknown user
2013-03-19 00:00:16 auth-worker(3783): Info: pam(postmaster,109.93.97.123): pam_authenticate() failed: Authentication failure (password mismatch?) (given password: правильный пароль)
2013-03-19 00:00:16 auth-worker(3783): Info: sql(postmaster,109.93.97.123): unknown user
2013-03-19 00:00:24 auth-worker(3783): Info: pam(postmaster,109.93.97.123): pam_authenticate() failed: Authentication failure (password mismatch?) (given password: правильный пароль)
2013-03-19 00:00:24 auth-worker(3783): Info: sql(postmaster,109.93.97.123): unknown user
2013-03-19 00:00:30 auth-worker(3783): Info: pam(postmaster,109.93.97.123): pam_authenticate() failed: Authentication failure (password mismatch?) (given password: правильный пароль)
2013-03-19 00:00:30 auth-worker(3783): Info: sql(postmaster,109.93.97.123): unknown user
2013-03-19 00:00:34 auth-worker(3783): Info: pam(postmaster,109.93.97.123): pam_authenticate() failed: Authentication failure (password mismatch?) (given password: правильный пароль)
2013-03-19 00:00:34 auth-worker(3783): Info: sql(postmaster,109.93.97.123): unknown user
2013-03-19 00:00:37 auth-worker(3783): Info: pam(postmaster,109.93.97.123): pam_authenticate() failed: Authentication failure (password mismatch?) (given password: правильный пароль)
2013-03-19 00:00:37 auth-worker(3783): Info: sql(postmaster,109.93.97.123): unknown user
2013-03-19 00:00:42 auth-worker(3783): Info: pam(postmaster,109.93.97.123): pam_authenticate() failed: Authentication failure (password mismatch?) (given password: правильный пароль)
2013-03-19 00:00:42 auth-worker(3783): Info: sql(postmaster,109.93.97.123): unknown user
2013-03-19 00:00:47 auth-worker(3783): Info: pam(postmaster,109.93.97.123): pam_authenticate() failed: Authentication failure (password mismatch?) (given password: правильный пароль)
2013-03-19 00:00:47 auth-worker(3783): Info: sql(postmaster,109.93.97.123): unknown user
2013-03-19 00:00:51 auth-worker(3783): Info: pam(postmaster,109.93.97.123): pam_authenticate() failed: Authentication failure (password mismatch?) (given password: правильный пароль)
2013-03-19 00:00:51 auth-worker(3783): Info: sql(postmaster,109.93.97.123): unknown user
2013-03-19 00:02:33 imap-login: Warning: SSL alert: where=0x4004, ret=256: warning close notify [109.93.97.123]
2013-03-19 00:02:33 imap-login: Warning: SSL alert: where=0x4008, ret=256: warning close notify [109.93.97.123]
2013-03-19 00:02:33 imap-login: Info: Disconnected (auth failed, 9 attempts in 147 secs): user=<postmaster>, method=PLAIN, rip=109.93.97.123, lip=78.47.11.221, TLS, session=<KUow8zrYJgBtXWF7>
Прошу помощи уважаемого сообщества.