PROFTP MySQL Certification

ProFTP the configuration file on the server

#修改
Authorder MOD_SQL.C

#注释取消
LoadModule MOD_SQL.C
LoadModule MOD_SQL_MYSQL.C

#增加
<ifmodule mod_sql.c>
sqlconnectinfo [Email protected]:3306 admin Admin 30
Sqlauthtypes Backend PlainText
Sqlauthenticate Users
Sqlnamedquery get-user-by-name Select "userid, passwd, uid, GID, homedir, Shell from Users WHERE userid = '%u ' and disable =0 "
Sqluserinfo Custom:/get-user-by-name
Sqlgroupinfo groups groupname GID members
Sqldefaulthomedir/home
</IfModule>

PROFTP MySQL Certification