I am new to dovecot and would like to setup dovecot with mysql auth. I
successfuly installed postfix admin and used the default
table structure there, Mail delivery works fine as It gets delivered to
mailboxes. My problem is the login, dovecot runs with no errors
but I get the error:
Mar 14 14:39:43 itecsouth dovecot: auth-worker(default): mysql: Connected to
localhost (postfix)
Mar 14 14:40:34 itecsouth dovecot: pop3-login: Disconnected: rip=41.xxx.xxx.190,
lip=41.243.140.153
Mar 14 14:41:14 itecsouth dovecot: pop3-login: Login failed: Plaintext
authentication disabled: rip=41.xxx.xxx.190, lip=41.xxx.xxx.153
Mar 14 14:41:14 itecsouth dovecot: pop3-login: Disconnected: rip=41.xxx.xxx.190,
lip=41.xxx.xxx.153
I have tried to change the pass scheme in dovecot-mysql.conf to CRYPT as but
says unknown auth_scheme
a copy of my dovecot.conf
protocols = pop3
listen = *
login_process_size = 64
default_mail_env = maildir:/usr/local/virtual/%d/%u/
mail_extra_groups = postfix
verbose_proctitle = yes
first_valid_uid = 125
first_valid_gid = 125
mbox_read_locks = fcntl
mbox_write_locks = fcntl
protocol pop3 {
pop3_uidl_format = %08Xu%08Xv
pop3_client_workarounds = outlook-no-nuls oe-ns-eoh
}
auth_username_chars =
abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890.-_@
auth_debug = yes
auth_verbose = yes
auth default {
passdb sql {
args = /usr/local/etc/dovecot-mysql.conf
}
userdb sql {
args = /usr/local/etc/dovecot-mysql.conf
}
}
-- and the dovecot-mysql.conf
# Database driver: mysql, pgsql
driver = mysql
default_pass_scheme = PLAIN
connect = host=localhost dbname=postfix user=dovecot password=dovecot
password_query = SELECT password FROM mailbox WHERE username = '%u' AND
active = '1'
user_query = SELECT maildir, 125 AS uid, 125 AS gid FROM mailbox WHERE username
= '%u' AND active = '1'