Rotten mud: Server-u ftp and Mysql Database Integration

This article is sponsored by the men's family and first launched in the dark world.

Yesterday, I introduced the permissions after Server-u ftp is integrated with Windows users. Today I will introduce it again. Integration of Server-u ftp with Mysql database.

Note: This experiment is ongoing on Windows Server 2008 R2. You need to use the mysql database, mysql database client, and Server-u ftp software.

The integration of Server-u ftp and Mysql is divided into the following steps:

1. Mysql database installation and configuration

2. ODBC installation and configuration

3. Server-u ftp Configuration

1. Mysql database installation and configuration

For Mysql databases, we use a green and free installation version. If necessary, you can open the relevant link at the end of the article for download. Of course, you can also use the installed mysql database, which you can choose freely. For the convenience of the experiment, we don't need to install the version.

Start the mysql database and use the Mysql client to connect to the Mysql database. After successfully connecting to the database, create an empty database ilanni, as shown in:

650) this. width = 650; "width =" 726 "height =" 370 "title =" clip_image001 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image001 "src =" http://www.bkjia.com/uploads/allimg/140120/223341C93-0.png "border =" 0 "/>

650) this. width = 650; "width =" 685 "height =" 345 "title =" clip_image002 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image002 "src =" http://www.bkjia.com/uploads/allimg/140120/2233413500-1.png "border =" 0 "/>

Ii. ODBC installation and configuration

First, I would like to popularize ODBC knowledge. Baidu encyclopedia explained that ODBC is short for Open Database Connectivity and ODBC. It is an integral part of the open service structure of Microsoft. It establishes a set of specifications and provides a set of standard API application programming interfaces for database access ). These APIs use SQL to complete most of their tasks. ODBC also provides support for the SQL language. You can directly send SQL statements to ODBC.

Why is ODBC installed? This is because Server-u ftp supports user and user group settings based on ODBC databases, so we need to install ODBC.

Download and install the corresponding version based on your OS and mysql database version. The installation process is not described in detail here. You only need to install it step by step as prompted.

650) this. width = 650; "width =" 640 "height =" 423 "title =" clip_image003 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image003 "src =" http://www.bkjia.com/uploads/allimg/140120/22334153G-2.png "border =" 0 "/>

After installing ODBC, click "start"-"Administrative Tools"-"Data Source ODBC", as shown in:

650) this. width = 650; "width =" 655 "height =" 417 "title =" clip_image004 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image004 "src =" http://www.bkjia.com/uploads/allimg/140120/2233415460-3.png "border =" 0 "/>

On the displayed page, you can see "system DSN"-"add", for example:

650) this. width = 650; "width =" 496 "height =" 417 "title =" clip_image005 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image005 "src =" http://www.bkjia.com/uploads/allimg/140120/22334145D-4.png "border =" 0 "/>

Select "Mysql ODBC 5.2 Driver", for example:

650) this. width = 650; "width =" 502 "height =" 380 "title =" clip_image006 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image006 "src =" http://www.bkjia.com/uploads/allimg/140120/223341C63-5.png "border =" 0 "/>

In the pop-up window, enter the relevant information, as shown in:

650) this. width = 650; "width =" 601 "height =" 440 "title =" clip_image007 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image007 "src =" http://www.bkjia.com/uploads/allimg/140120/2233415141-6.png "border =" 0 "/>

After "Data Source Name" is entered, you must remember it because it is still used later. Here we enter ilanni. The "TCP/IP Server" field is the Server where the Msql database is located. Now the Server-u ftp and Msql database are on the same Server, so we fill in 127.0.0.1. "User" indicates the database User. Here, we enter the root User. Of course, you can also enter other users in the Mysql database. "Database" selects the corresponding data.

After entering the preceding information, click Finish. The final interface is shown as follows:

650) this. width = 650; "width =" 495 "height =" 295 "title =" clip_image008 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image008 "src =" http://www.bkjia.com/uploads/allimg/140120/2233415139-7.png "border =" 0 "/>

After the ODBC configuration is complete, you can view the relevant information through the odbc. ini file, for example:

650) this. width = 650; "width =" 633 "height =" 399 "title =" clip_image009 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image009 "src =" http://www.bkjia.com/uploads/allimg/140120/2233415T1-8.png "border =" 0 "/>

Step 3: configure Server-U FTP

After configuring Mysql and ODBC, configure Server-u ftp. Open Server-u ftp and find "manage domain"-"Configure database access settings for accounts and groups in the domain", for example:

650) this. width = 650; "width =" 395 "height =" 463 "title =" clip_image010 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image010 "src =" http://www.bkjia.com/uploads/allimg/140120/2233413b6-9.png "border =" 0 "/>

Fill in the relevant information in the pop-up interface, such:

650) this. width = 650; "width =" 547 "height =" 427 "title =" clip_image011 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image011 "src =" http://www.bkjia.com/uploads/allimg/140120/22334144N-10.png "border =" 0 "/>

The "Data Source Name" must be the same as the ODBC configuration information, which is ilanni. The "database Login ID" and "Database Password" must be the same as the ODBC configuration information.

After entering these information, select the appropriate options. Click "save ". After the configuration is complete, it is best to restart the Server-U service. For example:

650) this. width = 650; "width =" 275 "height =" 339 "title =" clip_image012 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image012 "src =" http://www.bkjia.com/uploads/allimg/140120/2233413233-11.png "border =" 0 "/>

After the restart, you can use the mysql client to connect to the database, for example:

650) this. width = 650; "width =" 800 "height =" 556 "title =" clip_image013 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image013 "src =" http://www.bkjia.com/uploads/allimg/140120/2233412958-12.png "border =" 0 "/>

We can see that the Server-u ftp has successfully created related tables in the ilanni database.

Now let's add a new user, "user"-"create, modify, and delete the user account stored in the database", as shown in:

650) this. width = 650; "width =" 401 "height =" 387 "title =" clip_image014 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image014 "src =" http://www.bkjia.com/uploads/allimg/140120/2233412A7-13.png "border =" 0 "/>

Click "add", for example:

650) this. width = 650; "width =" 639 "height =" 514 "title =" clip_image015 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image015 "src =" http://www.bkjia.com/uploads/allimg/140120/2233415534-14.png "border =" 0 "/>

Here we can set user-related information, as shown in:

650) this. width = 650; "width =" 769 "height =" 595 "title =" clip_image016 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image016 "src =" http://www.bkjia.com/uploads/allimg/140120/22334120U-15.png "border =" 0 "/>

650) this. width = 650; "width =" 653 "height =" 485 "title =" clip_image017 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image017 "src =" http://www.bkjia.com/uploads/allimg/140120/22334111D-16.png "border =" 0 "/>

Server-u ftp is integrated with the Mysql database. All user permissions are controlled here, as shown in.

650) this. width = 650; "width =" 471 "height =" 243 "title =" clip_image018 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image018 "src =" http://www.bkjia.com/uploads/allimg/140120/2233412O1-17.png "border =" 0 "/>

After adding the user, the interface is shown as follows:

650) this. width = 650; "width =" 1172 "height =" 344 "title =" clip_image019 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image019 "src =" http://www.bkjia.com/uploads/allimg/140120/223341G53-18.png "border =" 0 "/>

Now we use this user to log on to FTP to see the actual results, such:

650) this. width = 650; "width =" 835 "height =" 607 "title =" clip_image020 "style =" margin: 0px; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image020 "src =" http://www.bkjia.com/uploads/allimg/140120/223341NO-19.png "border =" 0 "/>

We can clearly see that the ilanni user has successfully logged on to FTP. This means that the Server-u ftp is successfully integrated.

Now let's take a look at the Mysql database and execute the following SQL statement:

Select LoginID, HomeDir from suusers;

The suusers table is used to store FTP account information. The field LoginID is used to store the user's FTP account, and the field HomeDir is used to store the user's home directory. As shown in:

650) this. width = 650; "width =" 784 "height =" 619 "title =" clip_image021 "style =" border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; background-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; "alt =" clip_image021 "src =" http://www.bkjia.com/uploads/allimg/140120/2233413205-20.png "border =" 0 "/>

So far, the integration of Server-u ftp and mysql database has been completed. Of course, we can also integrate Server-u ftp with MSSQL and Oracle.

If time permits, we can also write related articles by time.

Mysql database free installation version: http://pan.baidu.com/s/1qWCqGu4

This article from the "muddy world" blog, please be sure to keep this source http://ilanni.blog.51cto.com/526870/1352890