alle user logins (ausser anonymous) geben mir ein OFFLINE zurück. ich hab null plan wie sich der verhalten (kann). kann mir einer nen tip geben? hier noch mal die conf:
Code:
# 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 "RZH FTP Server"
ServerType standalone
ServerIdent on "Server bereit"
DeferWelcome on
DefaultServer on
# Port 21 is the standard FTP port.
Port 21
# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask 022
# 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 under which the server will run.
User nobody
Group nogroup
# To cause every FTP user to be "jailed" (chrooted) into their home
# directory, uncomment this line.
DefaultRoot ~
# Messages
AccessGrantMsg "Willkommen auf dem FTP Server vom RZH"
AccessDenyMsg "Zugriff verweigert"
# MySQL Kram Start
################################################
############### mysql Modul: 4.x ###############
################################################
SQLAuthTypes Plaintext
SQLAuthenticate users* groups*
SQLConnectInfo ftp@localhost:17777 root passwort
SQLNamedQuery transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T',now(), 'i', NULL" xfer_stat
SQLUserInfo ftp username password uid gid homedir shell
SQLGroupInfo groups groupname gid members
SQLUserWhereClause "login_enabled = 'y'"
SQLLog PASS counter
SQLNamedQuery counter UPDATE "last_login_ftp=now(), login_count_ftp=login_count_ftp+1 WHERE username='%u'" stat_users
#####stat_xfer_stor in mysql#####
SQLLog STOR,APPE transfer1
SQLNamedQuery transfer1 INSERT "NULL, '%u', '%F', '%b', '%h', '%a', '%m', '%T', 'y', now()" stat_xfer_stor
SQLLOG ERR_STOR,ERR_APPE transfer2
SQLNamedQuery transfer2 INSERT "NULL, '%u', '%F', '%b', '%h', '%a', '%m', '%T', 'n', now()" stat_xfer_stor
#####stat_xfer_retr in mysql#####
SQLLog RETR transfer3
SQLNamedQuery transfer3 INSERT "NULL, '%u', '%F', '%b', '%h', '%a', '%m', '%T', 'y', now()" stat_xfer_retr
SQLLOG ERR_RETR transfer4
SQLNamedQuery transfer4 INSERT "NULL, '%u', '%F', '%b', '%h', '%a', '%m', '%T', 'n', now()" stat_xfer_retr
#####up-/downloads#####
SQLLog RETR dlbytescount
SQLNamedQuery dlbytescount UPDATE "dl_bytes=dl_bytes+%b WHERE username='%u'" stat_users
SQLLog RETR dlcount
SQLNamedQuery dlcount UPDATE "dl_count=dl_count+1 WHERE username='%u'" stat_users
SQLLog STOR ulbytescount
SQLNamedQuery ulbytescount UPDATE "ul_bytes=ul_bytes+%b WHERE username='%u'" stat_users
SQLLog STOR ulcount
SQLNamedQuery ulcount UPDATE "ul_count=ul_count+1 WHERE username='%u'" stat_users
################################################
# MySQL Kram Ende
# Normally, we want files to be overwriteable.
<Directory />
AllowOverwrite on
</Directory>
# A basic anonymous configuration, no upload directories. If you do not
# want anonymous users, simply delete this entire <Anonymous> section.
<Anonymous ~ftp>
User ftp
Group ftp
# We want clients to be able to login with "anonymous" as well as "ftp"
UserAlias anonymous ftp
# 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
DisplayFirstChdir .message
# Limit WRITE everywhere in the anonymous chroot
<Limit WRITE>
DenyAll
</Limit>
</Anonymous>
# '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 "RZH FTP Server"
ServerType standalone
ServerIdent on "Server bereit"
DeferWelcome on
DefaultServer on
# Port 21 is the standard FTP port.
Port 21
# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask 022
# 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 under which the server will run.
User nobody
Group nogroup
# To cause every FTP user to be "jailed" (chrooted) into their home
# directory, uncomment this line.
DefaultRoot ~
# Messages
AccessGrantMsg "Willkommen auf dem FTP Server vom RZH"
AccessDenyMsg "Zugriff verweigert"
# MySQL Kram Start
################################################
############### mysql Modul: 4.x ###############
################################################
SQLAuthTypes Plaintext
SQLAuthenticate users* groups*
SQLConnectInfo ftp@localhost:17777 root passwort
SQLNamedQuery transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T',now(), 'i', NULL" xfer_stat
SQLUserInfo ftp username password uid gid homedir shell
SQLGroupInfo groups groupname gid members
SQLUserWhereClause "login_enabled = 'y'"
SQLLog PASS counter
SQLNamedQuery counter UPDATE "last_login_ftp=now(), login_count_ftp=login_count_ftp+1 WHERE username='%u'" stat_users
#####stat_xfer_stor in mysql#####
SQLLog STOR,APPE transfer1
SQLNamedQuery transfer1 INSERT "NULL, '%u', '%F', '%b', '%h', '%a', '%m', '%T', 'y', now()" stat_xfer_stor
SQLLOG ERR_STOR,ERR_APPE transfer2
SQLNamedQuery transfer2 INSERT "NULL, '%u', '%F', '%b', '%h', '%a', '%m', '%T', 'n', now()" stat_xfer_stor
#####stat_xfer_retr in mysql#####
SQLLog RETR transfer3
SQLNamedQuery transfer3 INSERT "NULL, '%u', '%F', '%b', '%h', '%a', '%m', '%T', 'y', now()" stat_xfer_retr
SQLLOG ERR_RETR transfer4
SQLNamedQuery transfer4 INSERT "NULL, '%u', '%F', '%b', '%h', '%a', '%m', '%T', 'n', now()" stat_xfer_retr
#####up-/downloads#####
SQLLog RETR dlbytescount
SQLNamedQuery dlbytescount UPDATE "dl_bytes=dl_bytes+%b WHERE username='%u'" stat_users
SQLLog RETR dlcount
SQLNamedQuery dlcount UPDATE "dl_count=dl_count+1 WHERE username='%u'" stat_users
SQLLog STOR ulbytescount
SQLNamedQuery ulbytescount UPDATE "ul_bytes=ul_bytes+%b WHERE username='%u'" stat_users
SQLLog STOR ulcount
SQLNamedQuery ulcount UPDATE "ul_count=ul_count+1 WHERE username='%u'" stat_users
################################################
# MySQL Kram Ende
# Normally, we want files to be overwriteable.
<Directory />
AllowOverwrite on
</Directory>
# A basic anonymous configuration, no upload directories. If you do not
# want anonymous users, simply delete this entire <Anonymous> section.
<Anonymous ~ftp>
User ftp
Group ftp
# We want clients to be able to login with "anonymous" as well as "ftp"
UserAlias anonymous ftp
# 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
DisplayFirstChdir .message
# Limit WRITE everywhere in the anonymous chroot
<Limit WRITE>
DenyAll
</Limit>
</Anonymous>

