Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I need ProFTPd to connect to few databases/tables and authorize users by data from them.

I have ftp login data in db/tables:

db1 / ftp

db2 / ftp

db2 / users

db2 / ftp_vip

db3 / data

Can you give me right proftp.conf and/or sql.conf for that? I tried multiple solutions with SQLNamedQuery and SQLNamedConnectInfo but it won't work or work only for db1 / ftp and igonres other settings.

I wonna to do it only by ProFTPd modules without any external soft.

PS. Proftpd version: 1.3.3a or 1.3.4rc2 (no matter for me)

//EDIT: db3 is on another machine, so view will not make it.

share|improve this question
add comment

1 Answer

One solution would be to aggregate all the mysql data together using views.

http://dev.mysql.com/doc/refman/5.6/en/create-view.html

http://dev.mysql.com/doc/refman/5.6/en/views.html

share|improve this answer
    
db3 is on another machine, so view will not make it. –  Misiek May 23 '11 at 13:42
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.