In order to deal with case-sensitive issues, I am thinking to use the
variable %L (adding it to my current configs --as suggested before by
other users in this list) in the configuration files in this way:
In Dovecot.conf:
mail_location = maildir:/vmail/%Ld/%Ln/Maildir:INDEX=/indexes/%Ld/%Ln
auth default:
username_format: %Lu
passdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
userdb:
driver: sql
args: /etc/dovecot/dovecot-sql.conf
userdb:
driver: static
args: uid=5000 gid=5000 home=/vmail/%Ld/%Ln allow_all_users=yes
In dovecot-sql.conf:
password_query = select concat(virtual_users.user, '@',
virtual_domains.name) AS user, virtual_users.password as password \
from virtual_users LEFT JOIN virtual_domains ON
virtual_users.domain_id=virtual_domains.id \
where virtual_users.user='%Ln' and virtual_domains.name='%Ld'
and virtual_users.status = 1 and virtual_domains.status = 1;
user_query = SELECT 5000 AS uid,5000 AS gid,'/vmail/%Ld/%Ln' as home, \
concat('*:storage= ', virtual_users.quota_kb) AS
quota_rule \
from virtual_users LEFT JOIN virtual_domains ON
virtual_users.domain_id=virtual_domains.id \
where virtual_users.user='%Ln' and virtual_domains.name='%Ld'
Is this the correct way of assuring lowercase use all over the place?
Can I use the variable %L in where sql statements?
Regards,
Mario Antonio