CentOS6.2 vsftpd+mysql虚拟用户验证配置方法

系统环境CentOS6.2 64位 vsftpd mysql都是系统自动装好的，估计是yum方式装的

前提：vsftpd用mysql验证需要pam_mysql.so模块，下源码安装

wget

安装成功后可能在这个位置

/lib/security/pam_mysql.la

/lib/security/pam_mysql.so

我是64位系统，看到的所有pam模块都在

/lib64/security/

所以做成了硬链接

ln /lib/security/pam_mysql.* /lib64/security/

vsftpd:

配置文件路径/etc/vsftpd/vsftpd.conf

我的配置如下：

# Allow anonymous FTP? (Beware - allowed by default if you comment this out).
# 是否允许匿名登录
anonymous_enable=NO
#
# Uncomment this to allow local users to log in.
# 是否允许本地用户登录,虚拟用户开启
local_enable=YES
# 是否所有用户都当成匿名登录，虚拟用户开启
guest_enable=YES
# 上传文件的用户属性
guest_username=apache
#不知道这是什么意思
#hide_ids=YES
#
# Uncomment this to enable any form of FTP write command.
# 写权限,放在用户配置里了
#write_enable=YES
#
# Default umask for local users is 077. You may wish to change this to 022,
# if your users expect that (022 is used by most other ftpd's)
local_umask=022
#
# Uncomment this to allow the anonymous FTP user to upload files. This only
# has an effect if the above global write enable is activated. Also, you will
# obviously need to create a directory writable by the FTP user.
#anon_upload_enable=YES
#
# Uncomment this if you want the anonymous FTP user to be able to create
# new directories.
#anon_mkdir_write_enable=YES
#
# Activate directory messages - messages given to remote users when they
# go into a certain directory.
#可以给目录定义欢迎信息/.message
dirmessage_enable=YES
#
# Activate logging of uploads/downloads.
xferlog_enable=YES
#
# Make sure PORT transfer connections originate from port 20 (ftp-data).
connect_from_port_20=YES
#
# If you want, you can arrange for uploaded anonymous files to be owned by
# a different user. Note! Using "root" for uploaded files is not

# recommended!
#chown_uploads=YES
#chown_username=whoever
#
# You may override where the log file goes if you like. The default is shown
# below.
xferlog_file=/var/log/vsftpd.log
#
# If you want, you can have your log file in standard ftpd xferlog format.
# Note that the default log file location is /var/log/xferlog in this case.
xferlog_std_format=YES
#
# You may change the default value for timing out an idle session.
idle_session_timeout=300
#
# You may change the default value for timing out a data connection.
data_connection_timeout=120
#
# It is recommended that you define on your system a unique user which the
# ftp server can use as a totally isolated and unprivileged user.
#nopriv_user=ftpsecure
#
# Enable this and the server will recognise asynchronous ABOR requests. Not
# recommended for security (the code is non-trivial). Not enabling it,
# however, may confuse older FTP clients.
#async_abor_enable=YES
#
# By default the server will pretend to allow ASCII mode but in fact ignore
# the request. Turn on the below options to have the server actually do ASCII
# mangling on files when in ASCII mode.
# Beware that on some FTP servers, ASCII support allows a denial of service
# attack (DoS) via the command "SIZE /big/file" in ASCII mode. vsftpd
# predicted this attack and has always been safe, reporting the size of the
# raw file.
# ASCII mangling is a horrible feature of the protocol.
#ascii_upload_enable=YES
#ascii_download_enable=YES
#
# You may fully customise the login banner string:
ftpd_banner=********** Welcome to tbq FTP service. **********

#
# You may specify a file of disallowed anonymous e-mail addresses. Apparently
# useful for combatting certain DoS attacks.
#deny_email_enable=YES
# (default follows)
#banned_email_file=/etc/vsftpd/banned_emails
#
# You may specify an explicit list of local users to chroot() to their home
# directory. If chroot_local_user is YES, then this list becomes a list of
# users to NOT chroot().
# 限制用户在本地目录
chroot_local_user=YES
#chroot_list_enable=YES
# (default follows)
#chroot_list_file=/etc/vsftpd/chroot_list
#
# You may activate the "-R" option to the builtin ls. This is disabled by
# default to avoid remote users being able to cause excessive I/O on large
# sites. However, some broken FTP clients such as "ncftp" and "mirror" assume
# the presence of the "-R" option, so there is a strong case for enabling it.
#ls_recurse_enable=YES
#
# When "listen" directive is enabled, vsftpd runs in standalone mode and
# listens on IPv4 sockets. This directive cannot be used in conjunction
# with the listen_ipv6 directive.
listen=YES
#
# This directive enables listening on IPv6 sockets. To listen on IPv4 and IPv6
# sockets, you must run two copies of vsftpd with two configuration files.
# Make sure, that one of the listen options is commented !!
#listen_ipv6=YES

#pam验证文件名/etc/pam.d/vsftpd
pam_service_name=vsftpd
userlist_enable=YES
tcp_wrappers=YES


#本地最大速度500k
#local_max_rate=500000
#匿名用户速度30k
#anon_max_rate=30000
#客户端最大连接数
max_clients=5
#每个ip最大连接数(这个如果设置成1上传下载都会失败，不知道为啥)
max_per_ip=5

#用户配置
user_config_dir=/etc/vsftpd/user_conf

接下来看一下虚拟用户的配置文件:路径在上面定义了

/etc/vsftpd/user_conf/虚拟用户同名文件

比如/etc/vsftpd/user_conf/tbq

#user root path
local_root=/tmp
#必须设置否则不可以进行任何写入修改操作
write_enable=YES


#允许下载，不设置的时候文件权属a+r才能被下载
anon_world_readable_only=NO
#允许创建目录
anon_mkdir_write_enable=YES
#允许删除,重命名
anon_other_write_enable=YES
#上传
anon_upload_enable=YES

#虚拟用户与本地用户相同的权限（修改文件属性必备）
virtual_use_local_privs=YES
#允许修改文件属性
chmod_enable=YES

接下来mysql部分：

create database vsftpd;

-- Table "accounts" DDL

CREATE TABLE `accounts` (
  `username` varchar(30) NOT NULL,
  `password` varchar(50) NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

插入测试用户：

insert into accounts(username,password) values('tbq',password('123456'));
insert into accounts(username,password) values('tbq1',md5('123456'));
insert into accounts(username,password) values('tbq2','123456');

备注：这里插入三种不同的密码原因是pam验证模块的几种方式

配置vsftpd成pam_mysql验证：

/etc/pam.d/vsftpd

auth        required pam_mysql.so   user=root   passwd=123456    host=localhost  db=vsftpd   table=accounts  usercolumn=username passwdcolumn=password   crypt=2
account        required pam_mysql.so   user=root   passwd=123456    host=localhost  db=vsftpd   table=accounts  usercolumn=username passwdcolumn=password   crypt=2
#crypt的加密方式0明文，1unix加密，2表示password()函数加密，3表示md5加密

其中我用0、2都成功了3不成功1不明白

user=mysql用户名

passwd=myqsl密码

host=mysql连接主机

db=数据库

table=表

usercolumn=用户名字段

passwdcolumn=密码字段

crypt=验证方式

更具体的vsftpd.conf配置，请自己baidu把

感谢

pam验证来源参考：

基本配置来源参考：

其他参考：