Home Back to Tutorial Online Help

Write file transfer log to the database through ODBC

Xlight FTP Server can write file transfer logs to the database through ODBC.

In this example, we use MySQL database to demonstrate the procedure of writing file transfer logs to the database. Note: after the 30-day evaluation period, this function is only supported by the Professional edition of Xlight FTP Server.

To write a file transfer log to the database through ODBC, you need to configure the ODBC data source first.

1. Download MySQL ODBC data source driver from http://www.mysql.com/downloads/api-myodbc.html and install MySQL Data Source Driver in the machine running Xlight FTP Server.

2. Go to "Control Panel->Administrative tools->Data Sources (ODBC)"; select the "System DSN" tab.

3. Click the "Add..." button, select "MySQL ODBC 3.51 Driver" and click the "Finish" button.

4. In this example, we use "File Transfer Log" as the name of the data source. File transfer logs can use different databases and ODBC data sources from the Xlight FTP Server user database. It is suggested to use different databases for users and file transfer logs for better performance.

5. You need to enable logging to the database in "Global Options->Log->File Transfer Log - Logging to Database".

6. You have to set up data source name and database user and password as shown in the figure below. You can click the "Create" button to let Xlight FTP Server create the table needed in the database. You can also click the "Test" button to check if you have the correct table in the database.

After the above setup, you should be able to log file transfer to the database now.

transfer_log_table structure