安装 ProFTPD 和 MySQL module

Published on 2016 - 06 - 25

Centos 安装 ProFTPD 和 MySQL module :

yum install proftpd proftpd-mysql
chkconfig proftpd on

Ubuntu 安装 ProFTPD 和 MySQL module :

sudo apt-get install proftpd-basic proftpd-mod-mysql
sudo update-rc.d proftpd defaults

配置文件如下:

proftpd.conf

#
# /etc/proftpd/proftpd.conf -- This is a basic ProFTPD configuration file.
# To really apply changes, reload proftpd after modifications, if
# it runs in daemon mode. It is not required in inetd/xinetd mode.
#

# Includes DSO modules
Include /etc/proftpd/modules.conf

# Set off to disable IPv6 support which is annoying on IPv4 only boxes.
UseIPv6                         off
# If set on you can experience a longer connection delay in many cases.
IdentLookups                    off

ServerName                      10.1.100.189
ServerType                      standalone
DeferWelcome                    off

MultilineRFC2228                on
DefaultServer                   on
ShowSymlinks                    on

TimeoutNoTransfer               600
TimeoutStalled                  600
TimeoutIdle                     1200

DisplayLogin                    welcome.msg
DisplayChdir                    .message true
ListOptions                     "-l"

DenyFilter                      \*.*/

# Use this to jail all users in their homes
DefaultRoot                     ~

# Users require a valid shell listed in /etc/shells to login.
# Use this directive to release that constrain.
# RequireValidShell             off

# Port 21 is the standard FTP port.
Port                            21

# In some cases you have to specify passive ports range to by-pass
# firewall limitations. Ephemeral ports can be used for that, but
# feel free to use a more narrow range.
PassivePorts                  49152 65534

# If your host was NATted, this option is useful in order to
# allow passive tranfers to work. You have to use your public
# address and opening the passive ports used on your firewall as well.
# MasqueradeAddress             1.2.3.4

# This is useful for masquerading address with dynamic IPs:
# refresh any configured MasqueradeAddress directives every 8 hours
<IfModule mod_dynmasq.c>
# DynMasqRefresh 28800
</IfModule>

# To prevent DoS attacks, set the maximum number of child processes
# to 30.  If you need to allow more than 30 concurrent connections
# at once, simply increase this value.  Note that this ONLY works
# in standalone mode, in inetd mode you should use an inetd server
# that allows you to limit maximum number of processes per service
# (such as xinetd)
MaxInstances                    30

# Set the user and group that the server normally runs at.
User                            proftpd
Group                           nogroup

# Umask 022 is a good standard umask to prevent new files and dirs
# (second parm) from being group and world writable.
Umask                           022  022
# Normally, we want files to be overwriteable.
AllowOverwrite                  on

# Uncomment this if you are using NIS or LDAP via NSS to retrieve passwords:
# PersistentPasswd              off

# This is required to use both PAM-based authentication and local passwords
# AuthOrder                     mod_auth_pam.c* mod_auth_unix.c

# Be warned: use of this directive impacts CPU average load!
# Uncomment this if you like to see progress and transfer rate with ftpwho
# in downloads. That is not needed for uploads rates.
#
# UseSendFile                   off

TransferLog /var/log/proftpd/xferlog
SystemLog   /var/log/proftpd/proftpd.log

# Logging onto /var/log/lastlog is enabled but set to off by default
#UseLastlog on

# In order to keep log file dates consistent after chroot, use timezone info
# from /etc/localtime.  If this is not set, and proftpd is configured to
# chroot (e.g. DefaultRoot or <Anonymous>), it will use the non-daylight
# savings timezone regardless of whether DST is in effect.
#SetEnv TZ :/etc/localtime

<IfModule mod_quotatab.c>
QuotaEngine off
</IfModule>

<IfModule mod_ratio.c>
Ratios off
</IfModule>


# Delay engine reduces impact of the so-called Timing Attack described in
# http://www.securityfocus.com/bid/11430/discuss
# It is on by default.
<IfModule mod_delay.c>
DelayEngine on
</IfModule>

<IfModule mod_ctrls.c>
ControlsEngine        off
ControlsMaxClients    100
ControlsLog           /var/log/proftpd/controls.log
ControlsInterval      5
ControlsSocket        /var/run/proftpd/proftpd.sock
</IfModule>

<IfModule mod_ctrls_admin.c>
AdminControlsEngine off
</IfModule>

#
# Alternative authentication frameworks

#
#Include /etc/proftpd/ldap.conf
#Include /etc/proftpd/sql.conf

#
# This is used for FTPS connections
#
#Include /etc/proftpd/tls.conf
#
# Useful to keep VirtualHost/VirtualRoot directives separated
#
#Include /etc/proftpd/virtuals.conf

# A basic anonymous configuration, no upload directories.

# <Anonymous ~ftp>
#   User                                ftp
#   Group                               nogroup
#   # We want clients to be able to login with "anonymous" as well as "ftp"
#   UserAlias                   anonymous ftp
#   # Cosmetic changes, all files belongs to ftp user
#   DirFakeUser on ftp
#   DirFakeGroup on ftp
#
#   RequireValidShell           off
#
#   # Limit the maximum number of anonymous logins
#   MaxClients                  10
#
#   # We want 'welcome.msg' displayed at login, and '.message' displayed
#   # in each newly chdired directory.
#   DisplayLogin                        welcome.msg
#   DisplayChdir                .message
#
#   # Limit WRITE everywhere in the anonymous chroot
#   <Directory *>
#     <Limit WRITE>
#       DenyAll
#     </Limit>
#   </Directory>
#
#   # Uncomment this if you're brave.
#   # <Directory incoming>
#   #   # Umask 022 is a good standard umask to prevent new files and dirs
#   #   # (second parm) from being group and world writable.
#   #   Umask                           022  022
#   #            <Limit READ WRITE>
#   #            DenyAll
#   #            </Limit>
#   #            <Limit STOR>
#   #            AllowAll
#   #            </Limit>
#   # </Directory>
#
# </Anonymous>

#Include other custom configuration files
#Include /etc/proftpd/conf.d/
Include /etc/proftpd/sql.conf
RequireValidShell off

# auto create home
CreateHome on 711

modules.conf

#
## This file is used to manage DSO modules and features.
##
#
## This is the directory where DSO modules reside
#
#ModulePath /usr/lib/proftpd
#
## Allow only user root to load and unload modules, but allow everyone
## to see which modules have been loaded
#
#ModuleControlsACLs insmod,rmmod allow user root
#ModuleControlsACLs lsmod allow user *
#
#LoadModule mod_ctrls_admin.c
#LoadModule mod_tls.c
#
## Install one of proftpd-mod-mysql, proftpd-mod-pgsql or any other
## SQL backend engine to use this module and the required backend.
## This module must be mandatory loaded before anyone of
## the existent SQL backeds.
LoadModule mod_sql.c
#
## Install proftpd-mod-ldap to use this
##LoadModule mod_ldap.c
#
##
## 'SQLBackend mysql' or 'SQLBackend postgres' (or any other valid backend) directives
## are required to have SQL authorization working. You can also comment out the
## unused module here, in alternative.
##
#
## Install proftpd-mod-mysql and decomment the previous
## mod_sql.c module to use this.
LoadModule mod_sql_mysql.c
#
## Install proftpd-mod-pgsql and decomment the previous
## mod_sql.c module to use this.
##LoadModule mod_sql_postgres.c
#
## Install proftpd-mod-sqlite and decomment the previous
## mod_sql.c module to use this
##LoadModule mod_sql_sqlite.c
#
## Install proftpd-mod-odbc and decomment the previous
## mod_sql.c module to use this
##LoadModule mod_sql_odbc.c
#
## Install one of the previous SQL backends and decomment
## the previous mod_sql.c module to use this
##LoadModule mod_sql_passwd.c
#
#LoadModule mod_radius.c
#LoadModule mod_quotatab.c
#LoadModule mod_quotatab_file.c
#
## Install proftpd-mod-ldap to use this
##LoadModule mod_quotatab_ldap.c
#
## Install one of the previous SQL backends and decomment
## the previous mod_sql.c module to use this
##LoadModule mod_quotatab_sql.c
#LoadModule mod_quotatab_radius.c
#LoadModule mod_wrap.c
#LoadModule mod_rewrite.c
#LoadModule mod_load.c
#
#LoadModule mod_rewrite.c
#LoadModule mod_load.c
#LoadModule mod_ban.c
#LoadModule mod_wrap2.c
#LoadModule mod_wrap2_file.c
## Install one of the previous SQL backends and decomment
## the previous mod_sql.c module to use this
##LoadModule mod_wrap2_sql.c
#LoadModule mod_dynmasq.c
#LoadModule mod_exec.c
#LoadModule mod_shaper.c
#LoadModule mod_ratio.c
#LoadModule mod_site_misc.c
#
#LoadModule mod_sftp.c
#LoadModule mod_sftp_pam.c
## Install one of the previous SQL backends and decomment
## the previous mod_sql.c module to use this
##LoadModule mod_sftp_sql.c
#
#LoadModule mod_facl.c
#LoadModule mod_unique_id.c
#LoadModule mod_copy.c
#LoadModule mod_deflate.c
#LoadModule mod_ifversion.c
#LoadModule mod_tls_memcache.c
#
## Install proftpd-mod-geoip to use the GeoIP feature
##LoadModule mod_geoip.c
#
## keep this module the last one
##LoadModule mod_ifsession.c

sql.conf

注意设置SQLConnectInfo,格式是 数据库名@数据库IP 账户 密码

SQLBackend        mysql

#Passwords in MySQL are encrypted using CRYPT
SQLAuthTypes            OpenSSL Crypt
SQLAuthenticate         users groups

# used to connect to the database
# databasename@host database_user user_password
SQLConnectInfo  yetishare@10.1.100.169 root abc123,

# Here we tell ProFTPd the names of the database columns in the "usertable"
# we want it to interact with. Match the names with those in the db
SQLUserInfo     plugin_ftp_proftpd_user user_id passwd uid gid home_dir shell

# Here we tell ProFTPd the names of the database columns in the "grouptable"
# we want it to interact with. Again the names match with those in the db
SQLGroupInfo    plugin_ftp_proftpd_group group_name gid members

# set min UID and GID - otherwise these are 999 each
SQLMinID        500

# Update count every time user logs in
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE user_id='%u'" plugin_ftp_proftpd_user

# Update modified everytime user uploads or deletes a file
SQLLog  STOR,DELE modified
SQLNamedQuery modified UPDATE "modified=now() WHERE user_id='%u'" plugin_ftp_proftpd_user

SqlLogFile /var/log/proftpd/sql.log