dovecot - Mar 2008 - (no subject)

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^IAGJjbGFyawBxYXoMar  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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL:
<http://dovecot.org/pipermail/dovecot/attachments/20080310/bfb86926/attachment-0002.bin>