Unable to get virtual users set up with database auth
Steffen Kaiser
skdovecot at smail.inf.fh-brs.de
Thu Oct 16 15:45:26 UTC 2014
-----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-----
More information about the dovecot
mailing list