Comments on Virtual Hosting With vsftpd And MySQL On Debian Squeeze
Vsftpd is one of the most secure and fastest FTP servers for Linux. Usually vsftpd is configured to work with system users. This document describes how to install a vsftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine.
6 Comment(s)
Comments
Why you need the id column? If username is unique you can also define this as primary key.
The id column is not needed for anything. Such column should be only used if you can't define a primanry over the other fields.
You'll figure it out when you expand to an RDB of 100+ tables and want to make changes to data you've declared to be primary keys in the base tables... Then you'll wish you'd referenced the "ID" column as the foreign key instead.
Why use vsftpd at all? Why not just use the sftp functionality that is built into OpenSSH?
nice information i like this
Nice How TO!
Works with wheezy also, but vsftpd need to be updated to at least 2.3.5-3.
Cause there is a bug with chroot!
Nice information I like your article. How to install vsftpd, Mysql and phpMyadmin etc..