PureFTPD Sub-User Access

Linux users can grant sub-user's FTP access by setting up a custom configuration.

This is an example!

Configure to use sub-users

Edit your ftp's ini to read the following

MYSQLServer     localhost
MYSQLPort       3306
MYSQLSocket     /tmp/mysql.sock
MYSQLUser       yourmysqluser
MYSQLPassword   yourmysqlpass
MYSQLDatabase   your_database
MYSQLCrypt      cleartext
MYSQLGetPW      SELECT 'password' as Password FROM usersubaccounts  WHERE name="\L"
MYSQLGetUID     SELECT U.username FROM users U, usersubaccounts S WHERE U.id=S.cid AND S.name="\L"
MYSQLGetGID     SELECT U.username FROM users U, usersubaccounts S WHERE U.id=S.cid AND S.name="\L"
MYSQLGetDir     SELECT concat("/home/",U.username) FROM users U, usersubaccounts S WHERE U.id=S.cid AND S.name="\L"

Adjust the mysql user password and database to match what your GameCP install uses