requiring a full fqdn for authentication

[Reio Remma]

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 at 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 at mrstuudio.ee
www.mrstuudio.ee



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://dovecot.org/pipermail/dovecot/attachments/20180306/c9316ceb/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: cohglgggghnmglgh.png
Type: image/png
Size: 8540 bytes
Desc: not available
URL: <https://dovecot.org/pipermail/dovecot/attachments/20180306/c9316ceb/attachment.png>