vsftpd+mysql 虚拟用户认证配置实例

yum -y install ncurses-devel openssl-devel pam-devel

cd /home/tools
tar xvzf mysql-5.1.56.tar.gz
./configure --prefix=/usr/local/mysql  --with-plugins=innobase,myisam --with-low-memory --with-big-tables --with-comment  --with-charset=utf8 --with-extra-charsets=all
make
make install
groupadd -g 1000 mysql
useradd -g 1000 -u 1000 -s /sbin/nologin -d /dev/null mysql
cp support-files/mysql.server  /etc/rc.d/init.d/mysqld
cp support-files/my-medium.cnf     /etc/my.cnf                     
cd /usr/local/mysql
chown -R mysql:mysql .
bin/mysql_install_db --user=mysql
chown -R root .
chown -R mysql.mysql var
bin/mysqld_safe --user=mysql &
PATH=$PATH:/usr/local/mysql/bin
echo "/usr/local/mysql/lib/mysql"  >> /etc/ld.so.conf
ldconfig -v

tar xvzf vsftpd-2.3.4.tar.gz
cd vsftpd-2.3.4
vi builddefs.h
####看看里面pam认证是否打开####
make
#mkdir -p /usr/share/empty/
#mkdir /var/ftp
#useradd -d /var/ftp/ ftp
#chown -R root.root /var/ftp/
#chmod og-w /var/ftp/
#####如果不要匿名用户，不知道这几句要加吗,时间紧,没测#####
make install
cp vsftpd.conf /etc/

tar xvzf pam_mysql-0.7RC1.tar.gz
cd pam_mysql-0.7RC1
./configure  --with-mysql=/usr/local/mysql --with-ssl
很奇怪,曾经在ubuntu的机器上做过一次,不加--with-ssl的话验证没过
make
make install

useradd -d /home/vsftpd -s /sbin/nologin vsftpd
chown -R vsftpd:vsftpd /home/vsftpd/
mkdir -p /etc/vsftpd/vsftpd_user_conf
touch user1
touch user2
vi /etc/vsftpd/vsftpd_user_conf/user1
local_root=/home/vsftpd/user1
vi /etc/vsftpd/vsftpd_user_conf/user2
local_root=/home/vsftpd/user2

mkdir  -p /home/vsftpd/user1
mkdir  -p /home/vsftpd/user2

/usr/local/mysql/bin/mysql
 mysql>create database vsftpd;
 mysql>create table vsftpd.user(name char(16)binary,passwd char(16)binary);
 mysql>insert into vsftpd.user (name,passwd) values ('user1','123456');
 mysql>insert into vsftpd.user (name,passwd) values ('user2','123456');
 mysql>grant all privileges on vsftpd.* to vsftpd@'localhost' identified by '123456';
 mysql>flush privileges;
 mysql>exit
 
 cp RedHat/vsftpd.pam  /etc/pam.d/ftp
 vi /etc/pam.d/ftp
 auth required /lib/security/pam_mysql.so user=vsftpd passwd=123456 host=localhost db=vsftpd table=user usercolumn=name passwdcolumn=passwd crypt=0
 account required /lib/security/pam_mysql.so user=vsftpd passwd=123456 host=localhost db=vsftpd table=user usercolumn=name passwdcolumn=passwd crypt=0

guest_enable=YES
 guest_username=vsftpd
 user_config_dir=/etc/vsftpd/vsftpd_user_conf/
 pam_service_name=/etc/pam.d/ftp
 anon_other_write_enable=YES
 anon_upload_enable=YES
 write_enable=YES

anonymous_enable=NO
local_enable=YES
write_enable=YES
local_umask=022
anon_upload_enable=YES
anon_mkdir_write_enable=YES
dirmessage_enable=YES
xferlog_enable=YES
connect_from_port_20=YES
#chown_uploads=YES
#chown_username=whoever
#xferlog_file=/var/log/vsftpd.log
#xferlog_std_format=YES
#idle_session_timeout=600
#data_connection_timeout=120
#nopriv_user=ftpsecure
#async_abor_enable=YES
#ascii_upload_enable=YES
#ascii_download_enable=YES
#ftpd_banner=Welcome to blah FTP service.
#deny_email_enable=YES
#banned_email_file=/etc/vsftpd.banned_emails
#chroot_local_user=YES
#chroot_list_enable=YES
#chroot_list_file=/etc/vsftpd.chroot_list
#ls_recurse_enable=YES
listen=YES
#listen_ipv6=YES
guest_enable=YES
guest_username=vsftpd
user_config_dir=/etc/vsftpd/vsftpd_user_conf
pam_service_name=/etc/pam.d/ftp
anon_other_write_enable=YES
anon_upload_enable=YES
write_enable=YES