|
Titel: sqlprobs Beitrag von: dest am 18. November 2005, 23:42:21 hiich hab eien server mit sql aufgesetzt nur kann ich mich leider nicht einloggen .-(
hier mal ein debug : Zitat 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. Code: meine config : Zitat 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 : Zitat 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. |