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

Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Management) 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.

3 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: Nico Munoz
Reply  

CREATE TABLE ftpd (
User varchar(16) NOT NULL default '',
status enum('0','1') NOT NULL default '0',
Password varchar(64) NOT NULL default '',
Uid varchar(11) NOT NULL default '-1',
Gid varchar(11) NOT NULL default '-1',
Dir varchar(128) NOT NULL default '',
ULBandwidth smallint(5) NOT NULL default '0',
DLBandwidth smallint(5) NOT NULL default '0',
comment tinytext NOT NULL,
ipaccess varchar(15) NOT NULL default '*',
QuotaSize smallint(5) NOT NULL default '0',
QuotaFiles int(11) NOT NULL default 0,
PRIMARY KEY (User),
UNIQUE KEY User (User)
) Engine=MyISAM;

By: Fabrik
Reply  

Hi

I have similar problem failed when restarting it return:

Job for pure-ftpd-mysql.service failed because the control process exited with error code. See "systemctl status pure-ftpd-mysql.service" and "journalctl -xe" for details.

By: Anon
Reply  

I have set this up but pure-ftp still uses pureftpd.passwd and ignores mysql.  What do I need to set this straight?