Hi
Im trying something new with my test dovecot.
I set my mail_location to to a new location
mail_location = maildir:/var/maildir/%u/Maildir
But with this new setup i too am authenticating against Mysql. This worked fine till i decided to move the mail.
So now i have moved the mail, deleted the account from /etc/passwd,, but now in my mail client, i cant view my test mail.
Here is my DB set up :
+-----------------------------+--------+ | home | user | +-----------------------------+--------+ | /var/maildir/bclark/Maildir | bclark | +-----------------------------+--------+
dovecot-sql set up password_query = SELECT username as user, password, home , uid as userdb_uid, gid as userdb_gid FROM user WHERE username = '%u' and domain = '%d'
I have removed
Mar 8 15:42:56 eccostorage dovecot: auth(default): client out: CONT^I1^I Mar 8 15:42:56 eccostorage dovecot: auth(default): client in: CONT^I1^IAGJjbGFyawBxYXo= Mar 8 15:42:56 eccostorage dovecot: auth-worker(default): sql(bclark, 192.168.111.31): query: SELECT username as user, password, home , uid as userdb_uid, gid as userdb_gid FROM user WHERE username = 'bclark' and domain = 'eccotours.biz' Mar 8 15:42:56 eccostorage dovecot: auth(default): client out: OK^I1^Iuser=bclark^Ihome=/var/maildir/bclark/Maildir Mar 8 15:42:56 eccostorage dovecot: auth(default): master in: REQUEST^I15^I24965^I1 Mar 8 15:42:56 eccostorage dovecot: auth(default): passwd(bclark, 192.168.111.31): lookup Mar 8 15:42:56 eccostorage dovecot: auth(default): passwd(bclark, 192.168.111.31): unknown user Mar 8 15:42:56 eccostorage dovecot: auth(default): userdb(bclark, 192.168.111.31): user not found from userdb Mar 8 15:42:56 eccostorage dovecot: auth(default): master out: NOTFOUND^I15 Mar 8 15:42:56 eccostorage dovecot: imap-login: Internal login failure: user=<bclark>, method=PLAIN, rip=192.168.111.31, lip=192.168.111.11
On Sat, 2008-03-08 at 15:48 +0200, Brent Clark wrote:
password_query = SELECT username as user, password, home , uid as Mar 8 15:42:56 eccostorage dovecot: auth-worker(default): sql(bclark, 192.168.111.31): query: SELECT username as user, password, home , uid as userdb_uid, gid as userdb_gid FROM user WHERE username = 'bclark' and domain = 'eccotours.biz'
You changed passdb to sql.
Mar 8 15:42:56 eccostorage dovecot: auth(default): passwd(bclark, 192.168.111.31): lookup Mar 8 15:42:56 eccostorage dovecot: auth(default): passwd(bclark, 192.168.111.31): unknown user
But your userdb is still passwd. Change that to sql as well.
participants (2)
-
Brent Clark
-
Timo Sirainen