MYSQL_SERVER localhost MYSQL_USERNAME {{ mail_db_user}} MYSQL_PASSWORD {{ mail_db_password }} MYSQL_PORT 0 MYSQL_DATABASE {{ mail_db_name }} MYSQL_USER_TABLE {{ mail_db_users_table_name }} MYSQL_CRYPT_PWFIELD {{ mail_db_users_password_field }} #MYSQL_CLEAR_PWFIELD {{ mail_db_users_password_field }} MYSQL_UID_FIELD 5000 MYSQL_GID_FIELD 5000 MYSQL_LOGIN_FIELD {{ mail_db_users_username_field }} MYSQL_HOME_FIELD "/home/vmail" MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX({{ mail_db_users_username_field }},'@',-1),'/',SUBSTRING_INDEX({{ mail_db_users_username_field }},'@',1),'/') #MYSQL_NAME_FIELD MYSQL_QUOTA_FIELD {{ mail_db_users_quota_field }} MYSQL_OPT 0 ##NAME: MARKER:0 # # Do not remove this section from this configuration file. This section # must be present at the end of this file.