On Wed, Apr 25, 2012 at 07:17:18AM +0100, Kris wrote:
[..]
the problem is a variable in dovecot (%u) which is normally used as a full username in sql query strings (i.e. user@domain) and is simply dropping the domain for some reason...
[..]
and to further confuse me, this 'unchangeable' variable sometimes decides to right itself without any obvious reason... localhost dovecot: auth: Debug: sql(admin@microhard.com,xx.xx.xx.xx): query: SELECT id as user, crypt as password FROM users WHERE id= 'admin@microhard.com'
im wondering if its something to do with my client dropping the domain, or whether dovecot has an error, or some other thing ive overlooked...
Indeed, it seems some of your users try to authenticate with a username without the '@domain' part.
You can either try to make your users comply or you can use auth_default_realm in your config:
# Default realm/domain to use if none was specified. This is
# used for both SASL realms and appending @domain to username
# in plaintext logins.
#
#auth_default_realm =Dennis
[..]