Comments on Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Management) On Ubuntu 12.10

This document describes how to install a PureFTPd 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. In addition to that I will show the use of quota and upload/download bandwidth limits with this setup. Passwords will be stored encrypted as MD5 strings in the database. This tutorial is based on Ubuntu 12.10.

2 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: Arjan
Reply  

Thanks for this tutorial.

One remark, that caused my logins to fail ('authentication failed for user ....'):

As the status field in the ftpd mysql table is of type enum, the mysql queries in /etc/pure-ftpd/db/mysql.conf need to have the following format:

SELECT <field> FROM ftpd WHERE User="\L" AND status=1 ...

instead of this:

SELECT <field> FROM ftpd WHERE User="\L" AND status="1"...

 (the double quotes need to be removed)

By: TSH
Reply  

Thanks for tutorial, easy and understandable. Still this is very basic setup and may I ask You to clarify what is default otions concerned connections to ftpd service: per ip, connections per user and maximum allowed connections. How they can be altered?