.:.FTP problemo.:.

[cjbilly]

OK interesting situation follows....

1. I have a system that creates a dedicated folder on the server (running apache / redhat / php / mysql) for each new client that registers (aka. personal folder)

2. This 'personal folder' is where they upload large files via http interface (php) - there can be quite a few aswell.

3. I wish to grant them FTP access to their personal folder only - so, obviously, they wouldn't be able to see other clients folders.

4. This ftp access would be using their username and password already given to them (and stored in mysql db).

5. Preferably, the clients could access (via ftp) the folders via a subdomain of the html interface (e.g. http://clients.mywork.com/ for ftp and http://www.mywork.com/ for the html)

Therefore, my question is - is it possible to extract the username and password from the mysql db and generate an ftp client automatically with restricted access to their folder only?

Any help greatly appreciated.

Thanks,

cjb.

[jstarkey]

proftpd http://www.proftpd.org/ will allow you to authenticate using SQL. It's also great about chrooting users.

Unfortunately, here's the man page for SQL authentication: http://proftpd.linux.co.uk/localsite/Userguide/linked/x643.html
Maybe google knows more?

I've been using it for 2 years, but haven't tried SQL auth with it. So that's about all the info I have.

Hope this helps in some way.