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 ...
- 10-01-2004 #1Just 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?
- 10-01-2004 #2Just 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


Reply With Quote
