proftp 改mysql認證

標籤：

proftp伺服器上改設定檔

#修改
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認證