proftp users in a mysql database
I have a mandrake server and I installed proftp and mysql on it.
I configured proftp and I can connect to it. I have configured mysql and I make the tables I need
What do I have to add in the proftpd.conf file to tell proftp to look up if the username + password exists in the mysql database?
I read somewhere to add these lines:
SQLConnectInfo 'databasename'@localhost 'username' 'password'
SQLUserInfo usertable userid passwd uid gid homedir shell
SQLGroupInfo grouptable groupname gid members
But when I add these lines to the proftpd.conf file I get the error:
that the line (43) where SQLAuthTypes is located is not correct :S
But when I delete that line he comes with the error that all the other lines that I addes with SQL are incorrect :(
What do I wrong? Or can someone explain me how to configure it good?