Dovecot: Authorization Query Problem
I'm setting up a mailserver, per the (excellent) Linode Library Postfix/Dovecot/MySQL piece.
The server seems to be receiving mail for
BUT I cannot log in to the server to get mail with Thunderbird.
I see in the logs that the query for the authorization is failing because there is no entry where email='admin'. Unsurprising, as the insertion for this user creates email to '
At a high level it seems the fix is to amend Dovecot's authorization query to search for '
Any help would be appreciated.
3 Replies
It could be be a configuration problem at Thunderbird. The Dovecot search query for password uses %u, which should be the user@domainname sent to the server. Perhaps Thunderbird isn't sending the domain name as part of the user name? But setting user name to
When I change the password_query to << WHERE email = '%u@%d', the log shows a search for 'admin@' – as if there is no value for %d. Which should be the domain value. (And no that query shouldn't work, %u ought to be name and domain name.)
If I had to guess, I'd say Dovecot somehow is missing or dropping the domain name. Maybe in the handoff from Postfix? How can I test that theory, and / or fix that if it is the problem?