VSFTPD MySQL

  • Print
Details
Category: Linux && Unix Services
Written by Mahdi Bahmani Ciahmard
Hits: 87

VSFTPD

Config files

1-/etc/vsftpd.conf

2- /etc/pam.d/vsftpd

apt-get install vsftpd libpam-mysql mysql-server mysql-client phpmyadmin

apt-get install vsftpd libpam-mysql mysql-server mysql-client phpmyadmin
netstat -tap | grep mysql

mysqladmin -h san-server.golco.net -u root password yourrootsqlpassword

mysql -u root -p

CREATE DATABASE vsftpd;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON vsftpd.* TO 'vsftpd'@'localhost' IDENTIFIED BY 'ftpdpass';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON vsftpd.* TO 'vsftpd'@'localhost.localdomain' IDENTIFIED BY 'ftpdpass';
FLUSH PRIVILEGES;

USE vsftpd;

CREATE TABLE `accounts` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`username` VARCHAR( 30 ) NOT NULL ,
`pass` VARCHAR( 50 ) NOT NULL ,
UNIQUE (
`username`
)
) ENGINE = MYISAM ;

quit;

First we create a non-privileged user called vsftpd (with the homedir /home/vsftpd) belonging to the group nogroup. We will run vsftpd under this user, and the FTP directories of our virtual users will be in the /home/vsftpd directory (e.g. /home/vsftpd/user1, /home/vsftpd/user2, etc.).

useradd --home /home/vsftpd --gid nogroup -m --shell /bin/false vsftpd

cp /etc/vsftpd.conf /etc/vsftpd.conf_orig
cat /dev/null > /etc/vsftpd.conf
vi /etc/vsftpd.conf

SAN-Server:~# grep -v "^#" /etc/vsftpd/vsftpd.conf |grep -v "^$"
listen=YES
anonymous_enable=NO
local_enable=YES
write_enable=YES
local_umask=022
dirmessage_enable=YES
xferlog_enable=YES
connect_from_port_20=YES
nopriv_user=vsftpd
chroot_local_user=YES
secure_chroot_dir=/var/run/vsftpd
pam_service_name=vsftpd
guest_enable=YES
guest_username=vsftpd
local_root=/nas_storage/linuxiso
user_sub_token=$USER
virtual_use_local_privs=YES
user_config_dir=/etc/vsftpd_user_conf

mkdir /etc/vsftpd_user_conf
cp /etc/pam.d/vsftpd /etc/pam.d/vsftpd_orig
cat /dev/null > /etc/pam.d/vsftpd
vi /etc/pam.d/vsftpd
SAN-Server:~# grep -v "^#" /etc/pam.d/vsftpd |grep -v "^$"
auth required pam_mysql.so user=root passwd= host=localhost db=vsftpd table=accounts usercolumn=username passwdcolumn=pass crypt=2
account required pam_mysql.so user=root passwd= host=localhost db=vsftpd table=accounts usercolumn=username passwdcolumn=pass crypt=2
/etc/init.d/vsftpd restart

mysql -u root -p

USE vsftpd;

INSERT INTO accounts (username, pass) VALUES('testuser', PASSWORD('secret'));
quit;

mkdir /home/vsftpd/testuser
chown vsftpd:nogroup /home/vsftpd/testuser

منابع

http://www.howtoforge.com/vsftpd_mysql_debian_etch_p1