Unable to get virtual users set up with database auth

[Gedalya]

Since you have to use system users, why don't you just use that? Why use 
SQL?


On 10/16/2014 12:06 PM, Cliff Hayes wrote:
> 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-----
>>