Install ISPConfig 3 ProFTPd for Debian

TipsMake.com - For Linux users, ISPConfig 3 is the leading solution in the field of hosting management on open source. It allows managing multiple servers through 1 cpanel control system. If you are using a VPS server with OpenVZ, unfortunately you cannot run the Pureftpd that comes with ISPConfig by default. The following article will show you how to use ProFTPd to replace Pureftpd easily.

Prepare to install

ProFTPd is a powerful and simple FTP server for installation and configuration, used by many servers. However, this tutorial does not include quota because it is not supported in VPS (if you do not want to edit ftp_user_edit.php in ISPConfig 3).

In this illustration we use Debian 5.0 Lenny but it can also be applied to version 6.0. Some other distributions may need some modification.

Note: this process works fine on a clean server and installs ISPConfig 3. If using the current server will need to enter and editting / saving every user created, which may cause some problems.

Setting

First, run the following command independently:

Create Group & User

Configure the database

Run the following command:

Then run the following query:

Configure ProFTPd

We will first modify the /usr/local/ispconfig/interface/lib/config.inc.php file:

Find the variable db_password and password note for later.

Edit the file /etc/proftpd/proftpd.conf :

Find to line:

Remove the caption for it to become:

Edit the file /etc/proftpd/sql.conf :

Delete all content in it and replace it with:

 # # Proftpd sample configuration for SQL-based authentication. # # (This không phải được sử dụng nếu bạn muốn xác thực PAM-based) # DefaultRoot ~ SQLBackend mysql # The passwords printed MySQL are encrypted using CRYPT SQLAuthTypes Plaintext Crypt SQLAuthenticate users # used to connect to the database # databasename users group database_user user_password SQLConnectInfo dbispconfig @ localhost ispconfig _insertpasswordhere_ # Here we tell ProFTPd the names of the database columns in the "usertable" # we want it to interact with. Đã có các tên với các người dùng trong cơ sở dữ liệu dbUser trong sqp_user username password uid gid dir shell # Here we tell ProFTPd the names of the database columns in the "grouptable" # we want it to interact with. Again các tên với các cùng trong cơ sở dữ liệu SQLGroupInfo ftp_group groupname gid members # set min UID and GID - otherwise these are 999 each SQLMinID 500 # create a directory user on demand if it doesn't exist CreateHome off # Update count every time logs in SQLLog PASS updatecount SQLNamedQuery updatecount UPDATE "count = count + 1, accessed = now () WHERE userid = '% u'" ftpuser # Update modified everytime user uploads or deletes a file SQLLog STOR, DELE modified SQLNamedQuery modified UPDATE, DELE modified SQLNamedQuery modified UPDATE "modified = now () WHERE userid = '% u' "ftpuser RootLogin off RequireValidShell off 

Make sure you have changed _insertpasswordhere_ with a password from ISPConfig.

If the MySQL database is on another server, change localhost to represent your MySQL server.

Edit the file /etc/proftpd/modules.conf :

Find to line:

and uncomment it to:

Change the line:

City:

Finally run:

Change ISPConfig 3

Now we need to change some files in ispconfig. Although this is not the best idea because when upgrading to the new version, these changes will disappear. However, in this case, ProFTPD will work better.

Edit the file /usr/local/ispconfig/interface/web/sites/ftp_user_edit.php :

Find the line:

and replace with:

It is done! Note that if you are logged into the ISPConfig web console, you must log out before changing the registrations on your computer.