MYSQL_SERVER {mysql_server_host}
|
MYSQL_USERNAME {mysql_server_ispconfig_user}
|
MYSQL_PASSWORD {mysql_server_ispconfig_password}
|
MYSQL_PORT {mysql_server_port}
|
MYSQL_DATABASE {mysql_server_database}
|
MYSQL_USER_TABLE mail_user
|
MYSQL_CRYPT_PWFIELD password
|
#MYSQL_CLEAR_PWFIELD password
|
MYSQL_UID_FIELD uid
|
MYSQL_GID_FIELD gid
|
MYSQL_LOGIN_FIELD login
|
MYSQL_HOME_FIELD homedir
|
MYSQL_MAILDIR_FIELD maildir
|
#MYSQL_NAME_FIELD
|
MYSQL_QUOTA_FIELD quota
|
#MYSQL_QUOTA_FIELD concat(quota,'S')
|
#MYSQL_WHERE_CLAUSE access='y'
|
#MYSQL_AUXOPTIONS_FIELD concat('disableimap=',disableimap,',disablepop3=',disablepop3)
|
MYSQL_AUXOPTIONS_FIELD concat('disableimap=', if(disableimap = 'y', 1, 0), ',', 'disablepop3=', if(disablepop3 = 'y', 1, 0))
|