Home / server / Questions / 272527
In Process
Misiek
Asked: 2011-05-23 13:28:14 +0800 CST

ProFTPd Multiple MySQL databases

  • 772

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.

linux ftp mysql debian proftpd

1 Answers

  1. 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

    • 1