ProFTPD with MySQL Auth

brooky · 04-03-2004, 08:46 AM

Hi there,

I've installed ProFTPD on Suse 9 Pro with MySQL Authentication but when I go to execute the ./proftpd command I get this error:

- Fatal: unknown configuration directive 'SQLAuthTypes' on line 11 of '/usr/local/etc/proftpd.conf'.

This line is:

SQLAuthTypes Plaintext

I've tried it also as:

SQLAuthTypes Plaintext Crypt

I'm 99.9% sure the installation was successful and the database is setup right.

Thanks for any help.

Here is my proftpd.conf file:

Code:

ServerName			"Brooky FTP Server"
ServerType			standalone
DefaultServer			on
ScoreboardFile                  "/usr/local/var/proftpd/proftpd.scoreboard"
Port				21
Umask				022
MaxInstances			10
User				nobody
Group				nogroup
DefaultRoot ~
SQLAuthTypes         Plaintext Crypt
SQLAuthenticate      users usersetfast
SQLConnectInfo       proftpd@localhost proftpd mypassword
SQLDefaultUID        80
SQLDefaultGID        80
SQLMinUserUID        3000
SQLMinUserGID        21
SQLUserInfo          users username password uid gid homedir shell
SQLLog PASS login
SQLNamedQuery login UPDATE "last_login = NOW() WHERE username = '%u'" users
RequireValidShell               off
UseReverseDNS off
<Directory />
  AllowOverwrite		on
</Directory>