Форум tobolsk.net

Код: Выделить всё

Include /etc/proftpd/modules.conf
#Подключим конфиг для mysql авторизации
Include /etc/proftpd/sql.conf
UseIPv6                         off
IdentLookups                    off

ServerName                      "Debian"
ServerType                      standalone
DeferWelcome                    off
#настроим корректное отображение времени в логах proftpd
TimesGMT off
SetEnv TZ /etc/localtime

MultilineRFC2228                on
DefaultServer                   on
ShowSymlinks                    on

TimeoutNoTransfer               600
TimeoutStalled                  600
TimeoutIdle                     1200

DisplayLogin                    welcome.msg
DisplayChdir                    .message true
ListOptions                     "-l"
AuthOrder                       mod_sql.c* mod_auth_unix.c

DenyFilter                      \*.*/
Port                            21
MaxInstances                    30

User                            proftpd
Group                           nogroup
RequireValidShell               off

Umask                           022  022
AllowOverwrite                  on

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

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

Код: Выделить всё

<IfModule mod_sql.c>
SQLBackend    		mysql
SQLEngine				on
SQLAuthenticate		on
SQLAuthTypes Backend
SQLLogFile                      /var/log/proftpd/proftpd.mysql

SQLConnectInfo                  proftp_admin@localhost Логин Пароль
SQLUserInfo                     usertable userid passwd uid gid homedir shell
SQLGroupInfo                    grouptable groupname gid members
SQLUserWhereClause              "disabled=0 and (NOW()<=expiration or expiration=-1 or expiration=0)"

SQLLog PASS counter
SQLNamedQuery counter UPDATE "lastlogin=now(), count=count+1 WHERE userid='%u'" usertable

SQLLog EXIT time_logout
SQLNamedQuery time_logout UPDATE "lastlogout=now() WHERE userid='%u'" usertable

SQLNamedQuery login_time SELECT "lastlogin from usertable where userid='%u'"
SQLShowInfo PASS "230" "Last login was: %{login_time}"

SQLLog RETR,STOR transfer1
SQLNamedQuery  transfer1 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'c', NULL" xfer_stat
SQLLOG ERR_RETR,ERR_STOR transfer2
SQLNamedQuery  transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i', NULL" xfer_stat

</IfModule>