Vsftpd+Mysql的安装配置教程

# useradd vsftpdguest   
// 添加vsftpdguest用户，作为VSFTPD的guest
# wget http://www.jjww.com.cn/upload/software/vsftpd-2.0.1-5.i386.rpm
//下载vsftpd-2.0.1-5.i386.rpm软件包

# rpm –ivh vsftpd-2.0.1-5.i386.rpm         
// 安装vsftpd-2.0.1-5.i386.rpm

# rm /etc/vsftpd/vsftpd.conf       
// 删除vsftpd默认的vsftpd.conf

# vi /etc/vsftpd/vsftpd.conf     
// 新建并编辑vsftpd.conf文件，加入如下配置
anonymous_enable=NO
local_enable=YES
write_enable=YES
local_umask=022
anon_upload_enable=YES
anon_mkdir_write_enable=YES
anon_other_write_enable=YES
chroot_local_user=YES
guest_enable=YES
guest_username=vsftpdguest
listen=YES
listen_port=21
pasv_enable=YES
pasv_min_port=30000
pasv_max_port=30999
anon_world_readable_only=NO
virtual_use_local_privs=YES
# user_config_dir=/etc/vsftpd/vsftpd_user_conf
 
# service vsftpd start    // 重启vsftpd

# rpm -ivh mysql-3.23.58-1.i386.rpm
# rpm -ivh mysql-server-3.23.58-1.i386.rpm
# rpm -ivh mysql-devel-3.23.58-1.i386.rpm
// 以上是安装mysql-server的rpm包，mysql-devel包是必须安装的
# service mysqld start      // 启动mysql
# mysql           // mysql命令进入
mysql>create database vsftpdvu;   // 新建数据库“vsftpdvu”
mysql>use vsftpdvu;    // 打开数据库“vsftpdvu”
mysql>create table users(name char(20) binary,passwd char(20) binary); 
//创建“users”表

mysql>insert into users (name,passwd) values ('test1','12345'); 
//新建FTP用户:test1密码:12345

mysql>insert into users (name,passwd) values ('test2','54321'); 
//新建FTP用户:test2密码:54321

mysql>grant select on vsftpdvu.users to vsftpdguest@localhost identified by '789987';
//新建一个由本地连接的mysql用户“vsftpdguest”密码为“789987”

mysql>flush privileges;            // 刷新权限设置
mysql>select * from users;         // 查看users表的数据
+-------+--------+
| name  | passwd |
+-------+--------+
| test1 | 12345  |
| test2 | 54321  |
+-------+--------+
2 rows in set (0.00 sec)
mysql>quit

# wget http://www.jjww.com.cn/upload/software/pam_mysql-0.5.tar.gz
# tar zxvf pam_mysql-0.5.tar.gz
# cd pam_mysql
# make
# cp pam_mysql.so /lib/security
# vi /etc/pam.d/ftp
// 新建并编辑ftp文件，加入pam_mysql的认证信息
auth required /lib/security/pam_mysql.so user=vsftpdguest passwd=789987 host=localhost db=vsftpdvu table=users usercolumn=name passwdcolumn=passwd crypt=0
account required /lib/security/pam_mysql.so user=vsftpdguest passwd=789987 host=localhost db=vsftpdvu table=users usercolumn=name passwdcolumn=passwd crypt=0
// 这里要注意一下，上面其实是二行，不要搞错