Software: Apache. PHP/8.1.30 uname -a: Linux server1.tuhinhossain.com 5.15.0-151-generic #161-Ubuntu SMP Tue Jul 22 14:25:40 UTC uid=1002(picotech) gid=1003(picotech) groups=1003(picotech),0(root) Safe-mode: OFF (not secure) /usr/share/doc/dovecot-core/wiki/ drwxr-xr-x |
Viewing file: Select action/file-type: 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) |
:: Command execute :: | |
--[ c99shell v. 2.5 [PHP 8 Update] [24.05.2025] | Generation time: 0.0169 ]-- |