|
Titel: Login über SQL nicht möglich Beitrag von: lucky am 07. September 2005, 17:15:11 Ein loggin per FTP ist nicht möglich. proftp basiert auf sql
Logs kommen nun : DEBUG: Zitat strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - ROOT PRIVS at mod_auth.c:132 strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - opening scoreboard '/usr/local/proftpd//var/proftpd/proftpd.scoreboard' strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - RELINQUISH PRIVS at mod_auth.c:134 strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - ident lookup disabled strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - connected - local : 81.169.129.21:21 strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - connected - remote : XX.XXX.XX.XX:62399 strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - FTP session opened. strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching PRE_CMD command 'USER root' to mod_core strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching PRE_CMD command 'USER root' to mod_core strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching PRE_CMD command 'USER root' to mod_auth strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endpwent" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endpwent" to module mod_auth_file strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endpwent" to module mod_auth_unix strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endgrent" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endgrent" to module mod_auth_file strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endgrent" to module mod_auth_unix strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching CMD command 'USER root' to mod_auth strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "getgroups" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "getgroups" to module mod_auth_file strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "getgroups" to module mod_auth_unix strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching POST_CMD command 'USER root' to mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching LOG_CMD command 'USER root' to mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching LOG_CMD command 'USER root' to mod_log strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endpwent" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endpwent" to module mod_auth_file strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endpwent" to module mod_auth_unix strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endgrent" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endgrent" to module mod_auth_file strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endgrent" to module mod_auth_unix strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching CMD command 'PASS (hidden)' to mod_auth strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "getgroups" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "getgroups" to module mod_auth_file strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "getgroups" to module mod_auth_unix strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "getpwnam" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "gid_name" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "gid_name" to module mod_auth_file strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "gid_name" to module mod_auth_unix strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "auth" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "check" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "check" to module mod_auth_file strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "check" to module mod_auth_unix strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "auth" to module mod_auth_file strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "auth" to module mod_auth_unix strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - ROOT PRIVS at mod_auth_unix.c:421 strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - RELINQUISH PRIVS at mod_auth_unix.c:482 strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "check" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "check" to module mod_auth_file strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "check" to module mod_auth_unix strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - USER root (Login failed): Incorrect password. strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endpwent" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endpwent" to module mod_auth_file strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endpwent" to module mod_auth_unix strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endgrent" to module mod_sql strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endgrent" to module mod_auth_file strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - dispatching auth request "endgrent" to module mod_auth_unix strato.serverkompetenz.net (XX.XXX.XX.XX[XX.XXX.XX.XX]) - FTP session closed. strato.serverkompetenz.net - FS: using system lstat() strato.serverkompetenz.net - scrubbing scoreboard strato.serverkompetenz.net - ROOT PRIVS at mod_core.c:130 strato.serverkompetenz.net - RELINQUISH PRIVS at mod_core.c:132 strato.serverkompetenz.net - ROOT PRIVS at mod_core.c:160 strato.serverkompetenz.net - RELINQUISH PRIVS at mod_core.c:189 strato.serverkompetenz.net - FS: using system lstat() SQL.LOG Zitat Sep 07 17:06:03 mod_sql/4.11[10014]: db: 'proftpd' Sep 07 17:06:03 mod_sql/4.11[10014]: port: '3306' Sep 07 17:06:03 mod_sql/4.11[10014]: ttl: '0' Sep 07 17:06:03 mod_sql/4.11[10014]: exiting mysql cmd_defineconnection Sep 07 17:06:03 mod_sql/4.11[10014]: entering mysql cmd_open Sep 07 17:06:03 mod_sql/4.11[10014]: connection 'default' opened Sep 07 17:06:03 mod_sql/4.11[10014]: connection 'default' count is now 1 Sep 07 17:06:03 mod_sql/4.11[10014]: exiting mysql cmd_open Sep 07 17:06:03 mod_sql/4.11[10014]: backend successfully connected. Sep 07 17:06:03 mod_sql/4.11[10014]: mod_sql status : on Sep 07 17:06:03 mod_sql/4.11[10014]: negative_cache : off Sep 07 17:06:03 mod_sql/4.11[10014]: authenticate : users Sep 07 17:06:03 mod_sql/4.11[10014]: usertable : ftp Sep 07 17:06:03 mod_sql/4.11[10014]: userid field : username Sep 07 17:06:03 mod_sql/4.11[10014]: password field : password Sep 07 17:06:03 mod_sql/4.11[10014]: uid field : uid Sep 07 17:06:03 mod_sql/4.11[10014]: gid field : gid Sep 07 17:06:03 mod_sql/4.11[10014]: homedir field : homedir Sep 07 17:06:03 mod_sql/4.11[10014]: homedir(default) : '/etc/' Sep 07 17:06:03 mod_sql/4.11[10014]: shell field : shell Sep 07 17:06:03 mod_sql/4.11[10014]: homedirondemand : true Sep 07 17:06:03 mod_sql/4.11[10014]: SQLMinUserUID : 500 Sep 07 17:06:03 mod_sql/4.11[10014]: SQLMinUserGID : 100 Sep 07 17:06:03 mod_sql/4.11[10014]: <<< sql_getconf Sep 07 17:06:03 mod_sql/4.11[10014]: >>> cmd_getpwnam Sep 07 17:06:03 mod_sql/4.11[10014]: entering mysql cmd_escapestring Sep 07 17:06:03 mod_sql/4.11[10014]: exiting mysql cmd_escapestring Sep 07 17:06:03 mod_sql/4.11[10014]: cache miss for user 'root' Sep 07 17:06:03 mod_sql/4.11[10014]: : entering mysql cmd_select Sep 07 17:06:03 mod_sql/4.11[10014]: entering mysql cmd_open Sep 07 17:06:03 mod_sql/4.11[10014]: connection 'default' count is now 2 Sep 07 17:06:03 mod_sql/4.11[10014]: exiting mysql cmd_open Sep 07 17:06:03 mod_sql/4.11[10014]: query "SELECT username, password, uid, gid, homedir, shell FROM ftp WHERE (username='root') LIMIT 1" Sep 07 17:06:03 mod_sql/4.11[10014]: entering mysql cmd_close Sep 07 17:06:03 mod_sql/4.11[10014]: connection 'default' count is now 1 Sep 07 17:06:03 mod_sql/4.11[10014]: exiting mysql cmd_close Sep 07 17:06:03 mod_sql/4.11[10014]: exiting mysql cmd_select Sep 07 17:06:03 mod_sql/4.11[10014]: NULL shell column value, setting to "" Sep 07 17:06:03 mod_sql/4.11[10014]: cache miss for user 'root' Sep 07 17:06:03 mod_sql/4.11[10014]: user 'root' cached Sep 07 17:06:03 mod_sql/4.11[10014]: + pwd.pw_name : root Sep 07 17:06:03 mod_sql/4.11[10014]: + pwd.pw_uid : 65534 Sep 07 17:06:03 mod_sql/4.11[10014]: + pwd.pw_gid : 65555 Sep 07 17:06:03 mod_sql/4.11[10014]: + pwd.pw_dir : /etc/ Sep 07 17:06:03 mod_sql/4.11[10014]: + pwd.pw_shell : Sep 07 17:06:03 mod_sql/4.11[10014]: <<< cmd_getpwnam Sep 07 17:06:03 mod_sql/4.11[10014]: >>> cmd_auth Sep 07 17:06:03 mod_sql/4.11[10014]: entering mysql cmd_escapestring Sep 07 17:06:03 mod_sql/4.11[10014]: exiting mysql cmd_escapestring Sep 07 17:06:03 mod_sql/4.11[10014]: cache hit for user 'root' Sep 07 17:06:03 mod_sql/4.11[10014]: >>> cmd_check Sep 07 17:06:03 mod_sql/4.11[10014]: checking auth_type Empty Sep 07 17:06:03 mod_sql/4.11[10014]: <<< cmd_check Sep 07 17:06:03 mod_sql/4.11[10014]: <<< cmd_auth Sep 07 17:06:03 mod_sql/4.11[10014]: >>> cmd_check Sep 07 17:06:03 mod_sql/4.11[10014]: checking auth_type Empty Sep 07 17:06:03 mod_sql/4.11[10014]: <<< cmd_check Sep 07 17:06:04 mod_sql/4.11[10014]: entering mysql cmd_close Sep 07 17:06:04 mod_sql/4.11[10014]: connection 'default' closed Sep 07 17:06:04 mod_sql/4.11[10014]: connection 'default' count is now 0 Sep 07 17:06:04 mod_sql/4.11[10014]: exiting mysql cmd_close Titel: Login über SQL nicht möglich Beitrag von: lucky am 09. September 2005, 00:46:01 ***Push***
Keiner kann mir dabei helfen?! Titel: Login über SQL nicht möglich Beitrag von: stonki am 09. September 2005, 06:33:48 Zitat von: "lucky" ***Push*** Keiner kann mir dabei helfen?! passiert das auch bei Usernamen die NICHT im System existieren ? Ausserdem verwende PlainTEXT passwoerter zum testen Titel: Login über SQL nicht möglich Beitrag von: lucky am 10. September 2005, 22:55:16 Ich benutzte PlainText
Auch Benutzer die nicht im System sind passiert dieses |