proftp 改mysql认证

proftp服务器上改配置文件

#修改
AuthOrder mod_sql.c

#注释取消
LoadModule mod_sql.c
LoadModule mod_sql_mysql.c

#增加
<IfModule mod_sql.c>
SQLConnectInfo proftpd@localhost: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>

原文：http://www.cnblogs.com/DDSys/p/4318093.html