On 25.4.2012, at 18.52, Kris Weston wrote: > On 25/04/12 11:48, Timo Sirainen wrote: >> On 25.4.2012, at 9.17, Kris wrote: >> >>> but then this happens when i attempt to send mail and this means the user >>> gets rejected because dovecot cant find the user id in the db without the >>> correct string (i.e. user@domain): >>> localhost dovecot: auth: Debug: sql(admin,xx.xx.xx.xx): query: SELECT id as >>> user, crypt as password FROM users WHERE id= 'admin' >> What exactly is doing this lookup? SMTP AUTH? Maybe the client's SMTP >> authentication is configured without the @domain part in username? >> > saslauthd via a query in dovecot-sql.conf.ext?
There is no saslauthd in Dovecot. > after these suggestions im pretty sure nobody here has a clue about this, and > this is not a known problem, i cant find anyone on the internet with it and > the query is quite clearly coming up wrong and the unchangeable variable is > quite clearly changing. To me it looks like the client isn't sending the domain. > the client can not be sending out different usernames every second surely. i > put the username in myself in thunderbird, double, triple checked, made other > accounts etc, the username changes by the second, ive watched the sql queries > go in and they change for no obvious reason. Show the full logs for a failing session, not just this one line. Even better would be full logs with auth_debug_passwords=yes, but in that case you'd better be using an unimportant password (some of the base64 encoded strings contain the password).