Find the answer to your Linux question:
Results 1 to 2 of 2
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    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:
    SQLAuthTypes Backend
    SQLAuthenticate users
    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?

  2. #2
    Hi...
    The proftpd version included in the mandrake RPM does not have the mysql backend. So you have to uninstall it and compile a new one from sources.
    Here is a link for 9.2 but should be similar with 10.x :
    http://www.khoosys.net/single.htm?ipg=848

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •