Server : Apache/2.4.62 (Unix) OpenSSL/1.0.2k-fips System : Linux server1.richineiserver.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : fdshops ( 1003) PHP Version : 8.2.21 Disable Function : NONE Directory :  /usr/share/doc/dovecot-2.2.36/wiki/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

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 2018-05-23 04:42)