MySQL implements VSFTP virtual user access

Using MySQL for vsftp virtual user access

1. To see if the MySQL installation package is installed , do not install it using Yum

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/89/33/wKiom1gLVDHhcl84AAA5CzhxiPU365.jpg-wh_500x0-wm_3 -wmp_4-s_3992582731.jpg "title=" 1.jpg "alt=" Wkiom1glvdhhcl84aaa5czhxipu365.jpg-wh_50 "/>

2. Check if the VSFTPD package is installed if it is not installed with Yum

650) this.width=650; "src=" http://s1.51cto.com/wyfs02/M02/89/33/wKiom1gLVj-igzo2AAAf2T6qcwc945.jpg "title=" 2.jpg " alt= "Wkiom1glvj-igzo2aaaf2t6qcwc945.jpg"/>

3, check whether the MySQL and ftp service is powered on from boot if not, use Chkconfig to set up

650) this.width=650; "src=" http://s5.51cto.com/wyfs02/M02/89/30/wKioL1gLVEuhXtbxAABOFmiLMqY208.jpg "title=" 3.jpg " alt= "Wkiol1glveuhxtbxaabofmilmqy208.jpg"/>

4. Login Database

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/89/33/wKiom1gLVGTRDApAAABNLkshEaE867.jpg "title=" 4.jpg " alt= "Wkiom1glvgtrdapaaabnlksheae867.jpg"/>

5. Create database name vsftp Note that the semicolon is used later

650) this.width=650; "src=" http://s5.51cto.com/wyfs02/M01/89/33/wKiom1gLVJfDTdOWAAAZgnZmfLQ894.jpg "title=" 5.jpg " alt= "Wkiom1glvjfdtdowaaazgnzmflq894.jpg"/>

6. Use database vsftp and create ftpuser table

650) this.width=650; "src=" http://s2.51cto.com/wyfs02/M00/89/33/wKiom1gLVH7BasgjAAANPba8GGI282.jpg "title=" 6.jpg " alt= "Wkiom1glvh7basgjaaanpba8ggi282.jpg"/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/89/31/wKioL1gLVI3DwPbBAAAiQq4FWoc818.jpg "title=" 6.1. JPG "alt=" wkiol1glvi3dwpbbaaaiqq4fwoc818.jpg "/>

7.see if the created Ftpuser is successful and has been created successfully

650) this.width=650; "src=" http://s1.51cto.com/wyfs02/M02/89/33/wKiom1gLVKby8VThAABGZrV6OA0390.jpg "title=" 7.jpg " alt= "Wkiom1glvkby8vthaabgzrv6oa0390.jpg"/>

8, insert data name Yuri and kebo password for 123456 abcdef

650) this.width=650; "src=" http://s1.51cto.com/wyfs02/M02/89/31/wKioL1gLVLTQ2kfKAAAmRtlhO1o464.jpg "title=" 8.jpg " alt= "Wkiol1glvltq2kfkaaamrtlho1o464.jpg"/>

9. to see if the insert is successful, it is now inserted successfully

650) this.width=650; "src=" http://s4.51cto.com/wyfs02/M00/89/33/wKiom1gLVMGx8nQ6AAAvF60sSlE205.jpg "title=" 9.jpg " alt= "Wkiom1glvmgx8nq6aaavf60ssle205.jpg"/>

create a user in MySQL dedicated to reading virtual user information in the database ftpuser

650) this.width=650; "src=" http://s4.51cto.com/wyfs02/M01/89/31/wKioL1gLVPLR6N6mAAAxUaXzWxg711.jpg "title=" 10.jpg "alt=" Wkiol1glvplr6n6maaaxuaxzwxg711.jpg "/>

One, use just create ftpuser Login Database

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/89/31/wKioL1gLVPygEC4cAABGSld6QFY007.jpg-wh_500x0-wm_3 -wmp_4-s_1868857641.jpg "title=" 11.jpg "alt=" Wkiol1glvpygec4caabgsld6qfy007.jpg-wh_50 "/>

View the contents of the database and table you just created

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/89/33/wKiom1gLVRGCGBXJAABSesgWziQ581.jpg-wh_500x0-wm_3 -wmp_4-s_2255037561.jpg "title=" 12.jpg "alt=" Wkiom1glvrgcgbxjaabsesgwziq581.jpg-wh_50 "/>

Create a locally mapped user and create a permission to modify its home directory

650) this.width=650; "src=" http://s5.51cto.com/wyfs02/M01/89/31/wKioL1gLVTCz5WtLAAAuB6a5QHI180.jpg "title=" 13.jpg "alt=" Wkiol1glvtcz5wtlaaaub6a5qhi180.jpg "/>

install the mysql-certified PAM module as follows

Http://sourceforge.net/projects/pam-mysql/files/pam-mysql/0.7RC1/pam_mysql-0.7RC1.tar.gz/download

Unzip to /usr/src below and compile and install

650) this.width=650; "src=" http://s2.51cto.com/wyfs02/M02/89/31/wKioL1gLVT-Q5GjuAAAxIjWjnRA346.jpg "title=" 14.jpg "alt=" Wkiol1glvt-q5gjuaaaxijwjnra346.jpg "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/89/33/wKiom1gLVVXAB3oQAAB1wqOuIYA833.jpg "title=" 14.1. JPG "alt=" wkiom1glvvxab3oqaab1wqouiya833.jpg "/>

Install the Pam-devle package

650) this.width=650; "src=" http://s1.51cto.com/wyfs02/M00/89/33/wKiom1gLVWWjrOAfAABM7ZUhHf0059.jpg "title=" 15.jpg "alt=" Wkiom1glvwwjroafaabm7zuhhf0059.jpg "/>

after installation , you will see the following two files under/usr/lib/security, link these two files to the/lib/security directory

650) this.width=650; "src=" http://s2.51cto.com/wyfs02/M00/89/31/wKioL1gLVYvzM0j2AABEq4_ZDHg942.jpg "title=" 15.1. JPG "alt=" wkiol1glvyvzm0j2aabeq4_zdhg942.jpg "/>

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/89/33/wKiom1gLVZXTBOMDAAB7r574-iI055.jpg-wh_500x0-wm_3 -wmp_4-s_4075271337.jpg "title=" 15.2.jpg "alt=" Wkiom1glvzxtbomdaab7r574-ii055.jpg-wh_50 "/>

16, compile  pam  Mysql  certification, when entering the note mysq database user ftpuser password database name and table name etc do not enter an error

650) this.width=650; "src=" http://s4.51cto.com/wyfs02/M00/89/31/wKioL1gLVaThMCtOAAAUrrpyDGQ779.jpg "title=" 16.jpg "alt=" Wkiol1glvathmctoaaaurrpydgq779.jpg "/>

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/89/33/wKiom1gLVbKC_jseAACKQ7x_SaU851.jpg "title=" 16.1. JPG "alt=" wkiom1glvbkc_jseaackq7x_sau851.jpg "/>

User: username added for login database

PASSWD: Password for the user name used

Host: The address of the database, such as the possible access to localhost, parsing error, resulting in a login failure

recommended use of 127.0.0.1

DB: for database name

Table: Name

Restart MySQL and vsftp services, and turn off selinux and iptables firewalls, etc., in /var/ftp/guest Create a directory under storage

650) this.width=650; "src=" http://s4.51cto.com/wyfs02/M02/89/31/wKioL1gLVcTR7ArcAAB_ecMSFIQ880.jpg "title=" 17.jpg "alt=" Wkiol1glvctr7arcaab_ecmsfiq880.jpg "/>

test success, prompt login success and can view the existing files inside

650) this.width=650; "src=" http://s4.51cto.com/wyfs02/M01/89/31/wKioL1gLVdCQW-aaAACbAkaGeSg074.jpg "title=" 18.jpg "alt=" Wkiol1glvdcqw-aaaacbakagesg074.jpg "/>

This article is from the "record a bit of learning life" blog, please make sure to keep this source http://ureysky.blog.51cto.com/2893832/1864618

MySQL implements VSFTP virtual user access