Find the answer to your Linux question:
Results 1 to 2 of 2
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Aug 2004
    Posts
    6

    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
    Just Joined!
    Join Date
    Sep 2004
    Posts
    21
    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
  •