| Server IP : 45.40.142.9 / Your IP : 216.73.216.250 Web Server : Apache System : Linux s45-40-142-9.secureserver.net 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : bayspec ( 506) PHP Version : 5.6.40 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/doc/dovecot-2.3.10.1/wiki/ |
Upload File : |
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 2019-06-19 12:42)