Proftpd relevant settings

If You ever want to connect your proftpd server to the tf database, these settings will allow your proftpd users to authenticate from mysql TF database:

modules.conf

LoadModule mod_sql.c
LoadModule mod_sql_passwd.c
LoadModule mod_sql_mysql.c

proftpd.conf

<VirtualHost myftp>
...
<IfModule mod_sql_passwd.c>
SQLPasswordEngine on
SQLPasswordEncoding hex
SQLAuthenticate users
SQLAuthTypes md5
SQLBackend mysql
SQLConnectInfo tfng@localhost proftpduser proftpdpass
SQLDefaultGID 5500
SQLDefaultHomedir "/tfng/%u"
SQLDefaultUID 5500
SQLEngine on
SQLMinID 1000
SQLNegativeCache true
SQLUserInfo tf_users user_id password NULL NULL user_id NULL
SQLUserWhereClause "state = '1'"
</IfModule>
</VirtualHost>