Unable to get virtual users set up with database auth

[Cliff Hayes]

I tried both ways with same result.
I tried just returning the username as well.

On 10/16/2014 10:45 AM, Steffen Kaiser wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Thu, 16 Oct 2014, Cliff Hayes wrote:
>
>> But %u always contains just chayes instead of chayes at domain.tld even
>> though I tried different select statements to put the entire username
>> in the username field.
>> mail_location = mbox:/var/spool/mail/%u:INBOX=/var/spool/mail/%u
>>
>> password_query = SELECT uNameDomain as username, uDomain as domain,
>> uPass as
>                                           ^^^^^^ From
> http://wiki2.dovecot.org/PasswordDatabase username should read just
> user. Whereas:  "username: Like user, but doesn't drop existing domain
> name (e.g. "username=foo" for "user at domain" gives "foo at domain"). "
>
>> password FROM users WHERE uName = '%n' AND uDomain = '%d'
>
> - -- Steffen Kaiser
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.11 (GNU/Linux)
>
> iQEVAwUBVD/oFnz1H7kL/d9rAQIawQgAuDCC8VpNDffq8n3tNvHD81YuAVdHO3Xf
> Tv1xUftwta3g5c51AxWercHrV+Td79Od4sqfNAElEJOkZGpCHje+R8u74xdidpq3
> RhDJaFzxFprJfnPa5SX2meoI98E0HMZRY/18kutK6JytMYzRZ10EV3wN0GuIjh+/
> a7bvxFaxQEWZYDlagDEvv2IULHVW5HROU5yacFDDxElnFPIvcUHLrbMCVnh9qUyg
> H7dtuySEooZVqPymoYUWTISaQ4mjv4mRI7jTxYYjSIxhWBkxoxUyqZGWds01/eGZ
> gzKLcx+PqjAmnpNV/ee/i8fA82UNmlPl4K6E2GWLnKfLiD8kzYIqTQ==
> =hVsF
> -----END PGP SIGNATURE-----
>