CentOS 5.x编译安装配置ProFTPd与添加MySQL虚拟用户.docVIP

CentOS 5.x编译安装配置ProFTPd与添加MySQL虚拟用户 2012-08-01 16:25:39| 分类： CentOS 网络 | 标签： |字号大中小 订阅 在安装ProFTPd与配置MySQL虚拟用户之前，请确保你的系统已经正常运行MySQL服务器。 编译安装ProFTPd wget ftp://ftp-stud.fht-esslingen.de/pub/Mirrors//distrib/source/proftpd-1.3.1.tar.gz tar xzvf proftpd-1.3.1.tar.gz cd proftpd-1.3.1 ./configure --with-modules=mod_sql:mod_sql_mysql:mod_quotatab:mod_quotatab_sql \ --with-includes=/usr/include/mysql \ --with-libraries=/usr/lib/mysql make make install 请根据你的MySQL安装路径修改–with-includes和–with-libraries的参数。 添加ftp用户和用户组 groupadd -g 5500 ftpgroup adduser -u 5500 -s /bin/false -d /bin/null -c proftpd user -g ftpgroup ftpuser MySQL配置 登录MySQL并创建数据库。 mysql -u root -p create database ftpdb; grant select, insert, update on ftpdb.* to proftpd@localhost identified by password; use ftpdb; # # Table structure for table `ftpgroup` # CREATE TABLE ftpgroup ( groupname varchar(16) NOT NULL default , gid smallint(6) NOT NULL default 5500, members varchar(16) NOT NULL default , KEY groupname (groupname) ) TYPE=MyISAM COMMENT=ProFTP group table; # # Dumping data for table `ftpgroup` # INSERT INTO `ftpgroup` VALUES (ftpgroup, 5500, ftpuser); INSERT INTO `ftpgroup` VALUES (ftpgroup, 5500, ftpguest); CREATE TABLE `ftpquotatallies` ( `name` varchar(30) NOT NULL default , `quota_type` enum(user,group,class,all) NOT NULL default user, `bytes_in_used` float NOT NULL default 0, `bytes_out_used` float NOT NULL default 0, `bytes_xfer_used` float NOT NULL default 0, `files_in_used` int(10) unsigned NOT NULL default 0, `files_out_used` int(10) unsigned NOT NULL default 0, `files_xfer_used` int(10) unsigned NOT NULL default 0 ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `ftpuser` # CREATE TABLE ftpuser ( id int(10) unsigned NOT NULL auto_increment, userid varchar(32) NOT NULL default , passwd varchar(32) NOT NULL default , uid smallint(6) NOT NULL default 5500, gid smallint(6) NOT NULL default 5500, homedir varchar(255) NOT NULL default , shell