You need to match against both %n (username) and %d (domain) in your SQL query.

Good luck!
Reio

On 06.03.18 16:42, David Mehler wrote:
Hi,

Thanks. Can you elaborate?

Thanks.
Dave.


On 3/6/18, Steffen Kaiser <skdovecot@inf.h-brs.de> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 2 Mar 2018, David Mehler wrote:

dovecot to require a complete email address as a login. Currently I
can log in by either a username or fqdn. I've got the below what is
the issue?

        
If I need to provide my sql password query let me know.
your SQL query in passdb allows both usernames.


- --
Steffen Kaiser
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQEVAwUBWp6JisQnQQNheMxiAQKuuggAjNcedq1DVGWbe/3vpKHUHdgBJVzmmEsI
seSm/NFfR6/Fw8c4fCz0BAiIBUkmo7LEowFFo6M9Yf+ZJHP1IDt6N7gWTgral2Vh
pMrNn+mv9okzL2UvJzUlkCA4ntBJVG3BrG9ZUJfk/1f8IKS090nNpu4F79Ag0TG2
MiobX5XtIRvpwSTCteVzQaIanpNhmW/BSvA2smPcdt58AmVI6HUslxcsv9A1XZLP
q47pYucUTyPdsNcK4OrzitRH2+0HNTw70kClP/dfUWEvL4ssw3drCXhO7LjN+Crq
IpdfHp0k7bkfIv/e5Lfg4ZZs4uV5obEyqaa+UP0IUTLrEau1syZd9Q==
=lhft
-----END PGP SIGNATURE-----



--
Tervitades
Reio Remma


MR
        Stuudio 25 aastat

MR Stuudio OÜ
Tondi 17b, 11316, Tallinn
Tel +372 650 4808
Mob +372 56 22 00 33
reio@mrstuudio.ee
www.mrstuudio.ee