PureftPD + Quota + MySQL + PHP

Installation Environment: httpd php mysql OS: Redhat 9.0 / Redhat AS 3 Compile installation Pure-ftpd # tar zvxf pure-ftpd-1.0.19.tar.gz # cd pure-ftpd-1.0.19 # ./configure / -prefix = / usr / local / pureftpd / --with-paraanoidmsg / --with-welcomemsg / --with-uploadscript / --with-welcomemsg / --with-mysql / --with-largefile / --with- Cookie / --With-Virtualchroot / --with-VirtualHosts / --with-VirtualRoot / --with-diraliaseS / --with-quotas / --with-ftpwho / --with-shanguage = Simplified-Chinese # make # make check # make install configuration pure-ftpd # cd configuration-file # chmod u x pure-config.pl # cp pure-config.pl / usr / local / pureftpd / sbin # mkdir / usr / Local / pureftpd / etc # cd .. # cp pureft / etc / # cp pureft / etc / # cp pureft / etc / # cp pureft / etc / # cp pureft / etc / # cp pureft / etc / # cp pureft / etc / # cp. .d / pureftpd # vi /etc/init.d/pureftpd ==================== PureftPD ================ ====== #! / bin / bash # # startup script for the pure-ftpd ftp server $ revision: 1.3 $ # # chkconfig: 2345 85 15 # Description: pure-ftpd is a N ftp server daemon based upon troll-ftpd # processname: pure-ftpd # pidfile: /var/run/pure-ftpd.pid # config: /usr/local/pureftpd/pure-ftpd.conf # source function library. . /etc/rc.d/init.d/functions retval = 0 # path to the pure-ftp binaries. prog = pure-config.pl FullPath = / usr / local / pureftpd / sbin / $ prog pureftpwho = / usr / Local / pureftpd / sbin / pure-ftpwho start () {echo -n $ "Starting $ PROG:" $ fullpath /usr/local/pureftpdpd/etc/pure-ftpd.conf retval = $? [$ RETVAL = 0] &&

Touch / var / limited}............................ slightly =================== = PureftPD ===================== # chmod 755 /etc/init.d/pureftpd # chown root: root /etc/init.d/pureftpd # chkconfig - -add pureftpd # chKCONFIG PUREFTPD ON Install PHP_Manager # tar -xvf ftp.tar.gz -c / var / www / html / # vi /var/www/html/ftp/config.php $ lang = $ zh_cn; $ dbhost = "127.0.0.1"; $ dblogin = "ftp"; $ dbpassword = "tmpasterwd"; $ dBDatabase = "ftpusers"; $ ftpaddress = "127.0.0.1:21"; php_manager security settings # vi / etc / httpd / conf / HTTPD.CONF ORDER DENY, ALLOW DENY from ALLOW from 192.168.0.10 Modify Database script # vi /var/www/html/ftp/script.mysql === ================== Script.mysql ============================ Insert Into mysql.user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, / Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, / Index_priv, Alter_priv) VALUES ( '127.0.0.1', 'ftp', PASSWORD ( 'tmppasswd') 'Y' , 'Y', 'Y', 'Y', 'N', 'N', 'N', / 'N', 'N', 'N', 'N', 'N', 'N', 'N'); Flush Privileges; Create Database FTPUsers; Use ftpusers; Create Table Admin (Username Varchar (35) NOT NULL Default ', Password Char (32) Binary Not Null Default'

Primary key (username) type = myisam; INSERT INTO Admin Values ​​('TmpassWd'); Create Table Users (user char (16) Not null default ', Password Char (32) Binary Not Null Default ', Uid Int (11) Not Null Default' 2000 ', GID INT (11) Not Null Default' 2000 ', Dir Char (128) Not Null Default' ', Quotafiles Int (10) Not Null Default' 1000 ', Quotasize Int (10) Not Null Default' 100 ', UlbandWidth Int (10) Not Null Default' 80 ', DLBANDWIDTH INT (10) Not Null Default' 80 ', Status Enum (' 0 ',' 1 ') NOT Null Default '1', iPaccess Varchar (15) Not Null Default '*', Comment Tinytext NOT NULL, Primary Key (User) TYPE = Myisam; ========== =========== Script.mysql =================== Create a database # mysql -u root -p ***** <