I'm running Debian Sarge, and the software I'm dealing with is proftpd-mysql from an official Debian server. MySQL is already compiled with ProFTP in this.

/etc/proftpd.conf has had no changes to it's original state except the name of the server. I then added in various MySQL lines, and when I restart proftpd, it says Fatal: Unknown configuration direct "MySQLInfo" (or something very close). No other information except what line that is on.

I've tried both "SQL" and "MySQL" used, so I tried both variations. I then just quoted it out so it would jump to the next SQL line and try to read it, repeating the process (incase I didn't fill out the line correctly). I did this with half of the group until I got sick of it.

I even uninstalled the package, redownloaded it and reinstalled it. I havent tried compiling from source becase, well, it's a package for Stable Debian from an offical Debian server, and it's entire purpose for existing is to provide proftpd (which it does) compiled with MySQL. I have my doubts the package itself is faulty.

What am I doing wrong? Maybe there is a new way to word a MySQL command, or maybe I missed something in some obscure file that I'm suppose to change.

And yes, MySQL's database does exist, it's running well on its own (if it matters), and again, the config file is unaltered except for the added MySQL lines. Which are...

MySQLInfo localhost root ***** test
SQLUserTable ftp
SQLUsernameField username
SQLUidField uid
SQLGidField gid
SQLPasswordField password
SQLHomedirField homedir
SQLLoginCountField count
SQLAuthoritative on
SQLPlaintextPasswords on