Software: Apache/2.2.22 (Debian). PHP/5.6.36 

uname -a: Linux h05.hvosting.ua 4.9.110-amd64 #3 SMP Sun Nov 4 16:27:09 UTC 2018 x86_64 

uid=1389(h33678) gid=1099(h33678) groups=1099(h33678),502(mgrsecure) 

Safe-mode: OFF (not secure)

/usr/share/doc/dovecot-core/wiki/   drwxr-xr-x
Free 1.48 GB of 7.22 GB (20.44%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     PasswordDatabase.ExtraFields.User.txt (1.03 KB)      -rw-r--r--

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.ext' would be:

---%<-------------------------------------------------------------------------
password_query = \
  SELECT concat(user, '@', domain) AS user, password \
  FROM users \
  WHERE user = '%n' and domain = '%d'
---%<-------------------------------------------------------------------------

You can also update "username" and "domain" fields separately:

---%<-------------------------------------------------------------------------
password_query = \
  SELECT user AS username, domain, password \
  FROM users \
  WHERE user = '%n' and domain = '%d'
---%<-------------------------------------------------------------------------

(This file was created from the wiki on 2013-11-24 04:42)