Install the PHP-files

Download andUnpack the php-files:

#tar xvzf ppmy-0.3.tar.gz

Then you should copy this folder to a directory where it can be found by your web server.
#cd ppmy-0.3
#mkdir /var/www/proftp-admin
#cp *.php /var/www/proftpd-admin

Change /var/www/ to the path where you have put your website. You may also change "proftpd-admin" to something else if you want.

 

Now it is time to create at least one group using the webb based admin
utility. Point your webb browser to

http://localhost/proftpd-admin/index.php

or whatever host you just installed the php files on.

 

Configure ProFTPd on the local machine.Of course you need some things in your proftpd.conf. The most important line in the

configuration is probably "SQLConnectInfo".

SQLConnectInfo        proftpd@localhost proftpd proftpd

"proftpd@localhost" tells proftpd that it should connect to the MySQL-server on the host "localhost" with username and password "proftpd". "proftpd" is the username you created for the database. Change "localhost" to the appropriate hostname.

The second and third argument is the password and database. See proftpd reference documentation for more information. Since you have the database password in clear text it might be a good idea to limit readaccess for the configuration file on a multiuser system.

I have the following MySQL-related stuff in my proftpd.conf:

<Limit LOGIN>
  Order deny,allow
  AllowGroup ftpserver1
  AllowGroup ftpall
</Limit>

SQLConnectInfo        proftpd@localhost proftpd proftpd
SQLAuthenticate       users groups
SQLAuthTypes          Crypt Backend
SQLDefaultHomedir     ~
SQLUserInfo           users userid passwd uid gid homedir shell
SQLGroupInfo          groups groupid gid members

SQLHomedirOnDemand    on
SQLLogFile        /var/log/proftpd.sql_log

# Count number of logins for each user
SQLLog                PASS logincount
SQLNamedQuery         logincount UPDATE "login_count=login_count+1 WHERE userid='%u'" users
# Save last login
SQLLog                PASS lastlogin
SQLNamedQuery         lastlogin UPDATE "last_login=now() WHERE userid='%u'" users
# Count number of bytes/files downloaded and uploaded
SQLLog RETR           dlbytescount
SQLNamedQuery         dlbytescount UPDATE "dl_bytes=dl_bytes+%b WHERE userid='%u'" users
SQLLog RETR           dlcount
SQLNamedQuery         dlcount UPDATE "dl_count=dl_count+1 WHERE userid='%u'" users
SQLLog STOR           ulbytescount
SQLNamedQuery         ulbytescount UPDATE "ul_bytes=ul_bytes+%b WHERE userid='%u'" users  
SQLLog STOR           ulcount
SQLNamedQuery         ulcount UPDATE "ul_count=ul_count+1 WHERE userid='%u'" users

# Do not let disabled or expired users to login
SQLUserWhereClause    "disabled!=1 and (NOW()<=expires or expires=-1)"

# Do not require a valid shell, this might be a good thing to turn on for SQL-users
# This might simplify the configuration a little bit
RequireValidShell     off

Configure proftpd on an additional system using the same user database.

On the second system you might want to replace a few rows:

<Limit LOGIN>
  Order deny,allow
  AllowGroup ftpserver2
  AllowGroup ftpall
</Limit>

SQLConnectInfo        proftpd@server1 proftpd proftpd


I you are setting up a web server with user accounts you might want a home directory for each user. When you create a user you can specify a home directory prefix for the user. If the user you create are named "ubuntu" and the home directory prefix is "/home/ftp/users" the resulting home directory will be "/home/ftp/users/ubuntu".

To automatically let proftpd create this directory you could use the following directive in the proftpd configuration file:

SQLHomedirOnDemand    on

It is important to remember that for that to work "/home/ftp/user" must be writable by the user that owns the proftpd process. If you do not want to use custom home directories for your user, simply use "SQLHomedirOnDemand off" in your proftpd.conf.