[Proftpd-user] ProFTP and Apache jailed home How to

[Carlos L. <the...@ya...>]

Hi, 

I'm new to ProFtp and I was wondering if there is a tutorial on how to set up Proftp as a access point to Virtual users's web pages by using apache and also working with Mysql DB.

Let's say:

I have site1 and site2

- site1 have user1 and user2
  webroot is /dir/site1/www (for web content and can be accessed vi ftp)
             /dir/site1/emails (for maildir based emails, already implemented)
- site2 have user1 and user2 also
  webroot is /dir/site1/www (for web content and can be accessed vi ftp)
             /dir/site1/emails (for maildir based emails, already implemented)

mysql DB acounts:

 - user1/user2 for site1
 - user1/user2 for site2

one las question is:

Can the parameter on proftpd.conf be queried like:

1- SQLUserInfo  "select * from userinfo"   

on which will return:
ftpuser userid passwd uid gid homedir shell


2- SQLGroupInfo "select * from groupinfo"

on which will return:
ftpgroup groupname gid members



thanks in advanced