How to Virtual Hosting With PureFTPd And MySQL

**Lawford** · 09-02-2010

Hi all,

I am using Mandriva 2009.1. I want to know them how to install a PureFTPd server that uses virtual users from a MySQL database instead of real system users. I think it is much more per formant and allows having thousands of ftp users on a single machine. In addition I also want to show the use of quota and upload bandwidth limits with this setup.

**Praetor** · 09-02-2010

Mandriva's PureFTPd package supports various backends, such as MySQL, PostgreSQL, LDAP, etc. You need to install it from this command :

Code:

urpmi pure-ftpd pure-ftpd-anon-upload pure-ftpd-anonymous

Then you need to make an ftp group i.e,ftpgroup and user i.e.,ftpuser that all your virtual users will be plan to. Then replace the group and userid 2001 with a number that is liberated on your system:

Code:

groupadd -g 2001 ftpgroup
useradd -u 2001 -s /bin/false -d /bin/null -c "pureftpd user" -g ftpgroup ftpuser

Check that and reply.

**Katty** · 09-02-2010

You need to also make a database called pureftpd and a MySQL user named pureftpd which the PureFTPd daemon will use afterward on to attach to the pureftpd database:

Code:

mysql -u root –p
CREATE DATABASE pureftpd;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON pureftpd.* TO 'pureftpd'@'localhost' IDENTIFIED BY 'ftpdpass';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON pureftpd.* TO 'pureftpd'@'localhost.localdomain' IDENTIFIED BY 'ftpdpass';
FLUSH PRIVILEGES;

You need to swap the string ftpdpass with whatsoever password you want to use for the MySQL user pureftpd. Best of luck.

**kelfro** · 09-02-2010

After the Configurition PureFTPd, You can also put the command

Code:

Edit /etc/pure-ftpd/pure-ftpd.conf

and confirm that the ChrootEveryone, MySQLConfigFile, and CreateHomeDir lines are enabled and appear like this:

Code:

vi /etc/pure-ftpd/pure-ftpd.conf
[...]
ChrootEveryone              yes
[...]
MySQLConfigFile               /etc/pure-ftpd/pureftpd-mysql.conf
[...]
CreateHomeDir               yes
[...]

Basically the ChrootEveryone setting will build PureFTPd chroot each virtual user in his home directory so you will not be talented to browse directories and files outside his home directory. Good luck.

**Zecho** · 09-02-2010

You also need to Populate The Database And Test the database you can use the MySQL, Use the command:

Code:

mysql -u root -p
USE pureftpd;

Now you make the user exampleuser with the status , the password secret, the UID and GID 2001 the home directory /home/www.example.com, an upload and download bandwidth of 100 KB/sec and a quota of 50 MB. Check that and reply.

**Reegan** · 09-02-2010

Whenever you want to create a new user in mysql, you have to create an entry in the table ftpd so you will explain the columns of the table. You should put the ftps table like this – User The name of the virtual PureFTPd user ,Password - The password of the virtual user. check you use MySQL's MD5 function to save the password encrypted as an MD5 string. Best of luck.