1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
User extra field
================
This is mostly useful in case-insensitive username lookups to get the username
returned back using the same casing always. Otherwise depending on your
configuration it may cause problems, such as '/var/mail/user' and
'/var/mail/User' mailboxes created for the same user.
An example 'password_query' in 'dovecot-sql.conf' would be:
---%<-------------------------------------------------------------------------
# '\' line splitting works only in v1.1+
password_query = \
SELECT concat(user, '@', domain) AS user, password \
FROM users \
WHERE user = '%n' and domain = '%d'
---%<-------------------------------------------------------------------------
With v1.1+ you can update the user and domain parts separately using "username"
and "domain" fields.
(This file was created from the wiki on 2009-10-16 04:42)
|