Ich habe proftpd neu installiert und wollte mysql nutzen... dazu habe ich die config von proftpd.de genommen..
# This is a basic ProFTPD configuration file (rename it to
# 'proftpd.conf' for actual use. It establishes a single server
# and a single anonymous login. It assumes that you have a user/group
# "nobody" and "ftp" for normal operation and anon.
ServerName
"ftp.xxx.de"
ServerType
standalone
DeferWelcome
on
ServerAdmin
ftp@xxx.de
ServerIdent on
"ftp.xxx.de FTP server ready."
ShowSymlinks
on
MultilineRFC2228
on
DefaultServer
on
ShowSymlinks
on
AllowOverwrite
on
# Login Msgs
AccessGrantMsg
"Login completed"
AccessDenyMsg
"Access denied"
#Folderroot
Defaultroot
~
# FXP Erlauben
AllowForeignAddress
on
# Resumen erlauben
AllowOverwrite
on
AllowRetrieveRestart
on
AllowStoreRestart
on
# Login Erlauben der Shell User (off = on)
RequireValidShell
off
TimeoutNoTransfer
300
TimeoutStalled
300
TimeoutIdle
600
DisplayLogin welcome.msg
DisplayFirstChdir .message
ListOptions
""
DenyFilter
\*.*/
# Uncomment this if you are using NIS or LDAP to retrieve passwords:
#PersistentPasswd
off
# Port 21 is the standard FTP port.
Port
21
# 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
nobody
Group
nogroup
# Normally, we want files to be overwriteable.
<Directory /*>
# Umask 022 is a good standard umask to prevent new files and dirs
# (second parm) from being group and world writable.
#Umask
022 022
AllowOverwrite
on
</Directory>
# 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
#
# RequireValidShell
off
#
# # Limit the maximum number of anonymous logins
# MaxClients
50
#
# # We want 'welcome.msg' displayed at login, and '.message' displayed
# # in each newly chdired directory.
# DisplayLogin
welcome.msg
# DisplayFirstChdir
.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>
#
# Logging options
#
TransferLog /var/log/proftpd.xferlog
# Some logging formats
#
LogFormat default "%h %l %u %t \"%r\" %s %b"
LogFormat auth "%v [%P] %h %t \"%r\" %s"
LogFormat write "%h %l %u %t \"%r\" %s %b"
# Log file/dir access
ExtendedLog /var/log/proftpd.access_log WRITE,READ write
# Record all logins
ExtendedLog /var/log/proftpd.auth_log AUTH auth
# Paranoia logging level....
ExtendedLog /var/log/proftpd.paranoid_log ALL default
#------------------------mysql Modul: 4.x
#
# Zugangskontrolle
#
SQLAuthTypes Plaintext
SQLAuthenticate users*
SQLConnectInfo proftpd@localhost root ROOTPW
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserGID 100
SQLMinUserUID 500
SQLUserInfo users username password uid gid homedir shell
#
# aktive SQL Kommandos, ab hier passiert etwas :-)
#
SQLLog PASS counter
SQLNamedQuery counter UPDATE "letzter_zugriff=now(), count=count+1 WHERE username='%u'" users
# xfer Log in mysql
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
Dazu habe ich eine mysql db namens 'proftpd' erstellt. mehr noch nicht.
