Mysql with vsftpd authentication
Posted 07-11-2011 at 10:23 AM by venkatkoorapati
Unable to login in vsftpd user authenticate with mysql server.....
# /etc/vsftpd/vsftpd.conf
anonymous_enable=NO
local_enable=YES
write_enable=YES
local_umask=022
dirmessage_enable=YES
xferlog_enable=YES
connect_from_port_20=YES
xferlog_file=/var/log/xferlog
xferlog_std_format=YES
nopriv_user=vsftpd
virtual_use_local_privs=YES
guest_enable=YES
user_sub_token=$USER
local_root=/var/$USER
chroot_local_user=YES
guest_username=vsftpd
listen=YES
secure_chroot_dir=/var/run/vsftpd
pam_service_name=vsftpd
user_config_dir=/etc/vsftpd_user_conf
------------------------------------------------------------------------------------------------------------
# /etc/pam.d/vsftpd
auth required pam_mysql.so user=root passwd=password host=localhost db=userdb
table=accounts usercolumn=username passwdcolumn=password crypt=1
account required pam_mysql.so user=root passwd=password host=localhost db=userdb
table=accounts usercolumn=username passwdcolumn=password crypt=1
--------------------------------------------------------------------------------------------------------------
#useradd --home /home/vsftpd -m --shell /bin/false vsftpd
#/etc/init.d/vsftpd start
Starting vsftpd for vsftpd: [ OK ]
#mkdir /var/user3
# chown vsftpd:vsftpd /var/user3/
# ftp localhost
Connected to localhost.localdomain.
220 (vsFTPd 2.0.5)
530 Please login with USER and PASS.
530 Please login with USER and PASS.
KERBEROS_V4 rejected as an authentication type
Name (localhost:root): user3
331 Please specify the password.
Password:
530 Login incorrect.
Login failed.
# /etc/vsftpd/vsftpd.conf
anonymous_enable=NO
local_enable=YES
write_enable=YES
local_umask=022
dirmessage_enable=YES
xferlog_enable=YES
connect_from_port_20=YES
xferlog_file=/var/log/xferlog
xferlog_std_format=YES
nopriv_user=vsftpd
virtual_use_local_privs=YES
guest_enable=YES
user_sub_token=$USER
local_root=/var/$USER
chroot_local_user=YES
guest_username=vsftpd
listen=YES
secure_chroot_dir=/var/run/vsftpd
pam_service_name=vsftpd
user_config_dir=/etc/vsftpd_user_conf
------------------------------------------------------------------------------------------------------------
# /etc/pam.d/vsftpd
auth required pam_mysql.so user=root passwd=password host=localhost db=userdb
table=accounts usercolumn=username passwdcolumn=password crypt=1
account required pam_mysql.so user=root passwd=password host=localhost db=userdb
table=accounts usercolumn=username passwdcolumn=password crypt=1
--------------------------------------------------------------------------------------------------------------
#useradd --home /home/vsftpd -m --shell /bin/false vsftpd
#/etc/init.d/vsftpd start
Starting vsftpd for vsftpd: [ OK ]
#mkdir /var/user3
# chown vsftpd:vsftpd /var/user3/
# ftp localhost
Connected to localhost.localdomain.
220 (vsFTPd 2.0.5)
530 Please login with USER and PASS.
530 Please login with USER and PASS.
KERBEROS_V4 rejected as an authentication type
Name (localhost:root): user3
331 Please specify the password.
Password:
530 Login incorrect.
Login failed.
Total Comments 0