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

SQLLogFile /var/log/proftpd/proftpd.mysql
ExtendedLog /var/log/proftpd/access.log WRITE,READ default
ExtendedLog /var/log/proftpd/auth.log AUTH auth

SQLMinID 100

</IfModule>