hiich hab eien server mit sql aufgesetzt nur kann ich mich leider nicht einloggen .-(
hier mal ein debug :
R240225:/etc# proftpd -nd5
- mod_tls/2.0.7: using OpenSSL 0.9.7e 25 Oct 2004
- parsing '/etc/proftpd.conf' configuration
- <Directory />: adding section for resolved path '/'
R240225 -
R240225 - Config for SERVERNAME:
R240225 - /
R240225 - AllowOverwrite
R240225 - Umask
R240225 - AllowForeignAddress
R240225 - MaxClientsPerHost
R240225 - MaxClients
R240225 - AllowStoreRestart
R240225 - AllowRetrieveRestart
R240225 - RequireValidShell
R240225 - TransferLog
R240225 - SQLAuthTypes
R240225 - SQLAuthenticate
R240225 - SQLConnectInfo
R240225 - SQLDefaultGID
R240225 - SQLDefaultUID
R240225 - SQLMinUserGID
R240225 - SQLMinUserUID
R240225 - SQLLog_PASS
R240225 - SQLNamedQuery_counter
R240225 - SQLLog_RETR
R240225 - SQLLog_STOR
R240225 - SQLNamedQuery_transfer1
R240225 - SQLLog_ERR_RETR
R240225 - SQLLog_ERR_STOR
R240225 - SQLNamedQuery_transfer2
R240225 - ServerIdent
R240225 - DeferWelcome
R240225 - DefaultServer
R240225 - Umask
R240225 - AllowForeignAddress
R240225 - MaxClientsPerHost
R240225 - MaxClients
R240225 - MaxLoginAttempts
R240225 - AllowStoreRestart
R240225 - AllowRetrieveRestart
R240225 - DefaultRoot
R240225 - RequireValidShell
R240225 - TransferLog
R240225 - ExtendedLog
R240225 - ExtendedLog
R240225 - ExtendedLog
R240225 - SQLAuthTypes
R240225 - SQLAuthenticate
R240225 - SQLConnectInfo
R240225 - SQLDefaultGID
R240225 - SQLDefaultUID
R240225 - SQLMinUserGID
R240225 - SQLMinUserUID
R240225 - SQLUserTable
R240225 - SQLUsernameField
R240225 - SQLPasswordField
R240225 - SQLUidField
R240225 - SQLGidField
R240225 - SQLHomedirField
R240225 - SQLShellField
R240225 - SQLLogFile
R240225 - SQLLog_PASS
R240225 - SQLNamedQuery_counter
R240225 - SQLLog_RETR
R240225 - SQLLog_STOR
R240225 - SQLNamedQuery_transfer1
R240225 - SQLLog_ERR_RETR
R240225 - SQLLog_ERR_STOR
R240225 - SQLNamedQuery_transfer2
R240225 - ProFTPD 1.2.10 (stable) (built do mrt 22 18:28:32 CET 2001) standalone mode STARTUP
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - FTP session requested from unknown class
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - connected - local : 213.202.240.225:21
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - connected - remote : 81.245.67.86:45413
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - FTP session opened.
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_rewrite
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_tls
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_core
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_core
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_delay
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_auth
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching CMD command 'USER test' to mod_ratio
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching CMD command 'USER test' to mod_auth
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - no supplemental groups found for user 'test'
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching POST_CMD command 'USER test' to mod_sql
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching POST_CMD command 'USER test' to mod_delay
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - mod_delay/0.4: delaying for 3754 usecs
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching LOG_CMD command 'USER test' to mod_sql
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching LOG_CMD command 'USER test' to mod_log
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_tls
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_radius
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching CMD command 'PASS (hidden)' to mod_auth
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - no supplemental groups found for user 'test'
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - FTP session closed.
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - FTP session requested from unknown class
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - connected - local : 213.202.240.225:21
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - connected - remote : 81.245.67.86:45419
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - FTP session opened.
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_rewrite
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_tls
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_core
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_core
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_delay
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_auth
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching CMD command 'USER test' to mod_ratio
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching CMD command 'USER test' to mod_auth
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - no supplemental groups found for user 'test'
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching POST_CMD command 'USER test' to mod_sql
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching POST_CMD command 'USER test' to mod_delay
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - mod_delay/0.4: delaying for 2060 usecs
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching LOG_CMD command 'USER test' to mod_sql
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching LOG_CMD command 'USER test' to mod_log
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_tls
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_radius
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching CMD command 'PASS (hidden)' to mod_auth
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - no supplemental groups found for user 'test'
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - FTP session closed.
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - FTP session requested from unknown class
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - connected - local : 213.202.240.225:21
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - connected - remote : 81.245.67.86:45422
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - FTP session opened.
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_rewrite
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_tls
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_core
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_core
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_delay
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'USER test' to mod_auth
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching CMD command 'USER test' to mod_ratio
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching CMD command 'USER test' to mod_auth
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - no supplemental groups found for user 'test'
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching POST_CMD command 'USER test' to mod_sql
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching POST_CMD command 'USER test' to mod_delay
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching LOG_CMD command 'USER test' to mod_sql
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching LOG_CMD command 'USER test' to mod_log
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_tls
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_radius
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - dispatching CMD command 'PASS (hidden)' to mod_auth
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - no supplemental groups found for user 'test'
R240225 (86-67.245.81.adsl.skynet.be[81.245.67.86]) - FTP session closed.
[list=][/list]
[/color]
meine config :
ServerName "SERVERNAME"
ServerType standalone
ServerAdmin admin@proftpd.de
ServerIdent on "213.202.240.225"
DeferWelcome on
DefaultServer on
Port 21
Umask 022
# Normally, we want files to be overwriteable.
<Directory />
AllowOverwrite on
</Directory>
#
# FXP Unterstuetzung
#
AllowForeignAddress on
# Maximal Werte setzen
MaxClientsPerHost 2 "Nicht mehr als %m Verbindungen"
#
# Restart erlauben
#
AllowStoreRestart on
AllowRetrieveRestart on
#
# Jail all users into their virtual home dir
#
DefaultRoot ~
RequireValidShell off
#
# Logging options
#
TransferLog /var/log/proftpd.xferlog
# Some logging formats
#
LogFormat default "%h %l %u %t \"%r\" %s %b"
# 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 ftp@localhost root 8152325261
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserGID 100
SQLMinUserUID 500
SQLUserInfo users username password uid gid homedir shell
SQLLogFile /var/log/proftpd_sql.log
#
# 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
#SQLLog RETR,STOR transfer1
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
MaxClients 8 "Leider sind schon %m Clients verbunden"
MaxLoginAttempts 3
MaxInstances 30
hab schon gegoogelt aber ich find leider nichts
weis einer vielleicht rat ?
ps das spuckt mein client aus :
Connected to 213.202.240.225:21 waiting for reply...
220 213.202.240.225
USER test
331 Password required for test.
PASS (hidden)
Disconnected...Waiting for retry.
