|
Titel: SQL Auth. Problem Beitrag von: maik am 05. Oktober 2005, 15:05:45 Ich kann mich nicht per MySQL anmelden.
Kann jemand mal beine Logs checken, ich finde keinen Fehler: FTP log: Code: - parsing '/etc/proftpd.conf' configuration - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness debian - debian - Config for FTP-Server: debian - SyslogLevel debian - ServerIdent debian - DeferWelcome debian - DefaultServer debian - DisplayLogin debian - DisplayConnect debian - DisplayFirstChdir debian - SQLAuthTypes debian - SQLAuthenticate debian - SQLConnectInfo debian - SQLDefaultGID debian - SQLDefaultUID debian - SQLMinUserGID debian - SQLMinUserUID debian - SQLUserTable debian - SQLUsernameField debian - SQLPasswordField debian - SQLUidField debian - SQLGidField debian - SQLHomedirField debian - SQLShellField debian - SQLLog_PASS debian - SQLNamedQuery_counter debian - SQLLog_RETR debian - SQLLog_STOR debian - SQLNamedQuery_transfer1 debian - SQLLog_ERR_RETR debian - SQLLog_ERR_STOR debian - SQLNamedQuery_transfer2 debian - AllowForeignAddress debian - Umask debian - UserID debian - UserName debian - GroupID debian - GroupName debian - MaxClientsPerHost debian - MaxClients debian - AllowStoreRestart debian - AllowRetrieveRestart debian - TimeoutStalled debian - MaxLoginAttempts debian - RequireValidShell debian - ProFTPD 1.2.10 (stable) (built Di Okt 4 19:29:43 CEST 2005) standalone mode STARTUP debian (proftptestserver.local[192.168.1.211]) - FTP session requested from unknown class debian (proftptestserver.local[192.168.1.211]) - connected - local : 192.168.1.16:21 debian (proftptestserver.local[192.168.1.211]) - connected - remote : 192.168.1.211:4139 debian (proftptestserver.local[192.168.1.211]) - FTP session opened. debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_core debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_core debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_auth debian (proftptestserver.local[192.168.1.211]) - dispatching CMD command 'USER maik' to mod_auth debian (proftptestserver.local[192.168.1.211]) - no supplemental groups found for user 'maik' debian (proftptestserver.local[192.168.1.211]) - dispatching POST_CMD command 'USER maik' to mod_sql debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD command 'USER maik' to mod_sql debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD command 'USER maik' to mod_log debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth debian (proftptestserver.local[192.168.1.211]) - dispatching CMD command 'PASS (hidden)' to mod_auth debian (proftptestserver.local[192.168.1.211]) - no supplemental groups found for user 'maik' debian (proftptestserver.local[192.168.1.211]) - USER maik (Login failed): No such user found. debian (proftptestserver.local[192.168.1.211]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth debian (proftptestserver.local[192.168.1.211]) - FTP session closed. debian (proftptestserver.local[192.168.1.211]) - FTP session requested from unknown class debian (proftptestserver.local[192.168.1.211]) - connected - local : 192.168.1.16:21 debian (proftptestserver.local[192.168.1.211]) - connected - remote : 192.168.1.211:4153 debian (proftptestserver.local[192.168.1.211]) - FTP session opened. debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_core debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_core debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_auth debian (proftptestserver.local[192.168.1.211]) - dispatching CMD command 'USER maik' to mod_auth debian (proftptestserver.local[192.168.1.211]) - no supplemental groups found for user 'maik' debian (proftptestserver.local[192.168.1.211]) - dispatching POST_CMD command 'USER maik' to mod_sql debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD command 'USER maik' to mod_sql debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD command 'USER maik' to mod_log debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth debian (proftptestserver.local[192.168.1.211]) - dispatching CMD command 'PASS (hidden)' to mod_auth debian (proftptestserver.local[192.168.1.211]) - no supplemental groups found for user 'maik' debian (proftptestserver.local[192.168.1.211]) - USER maik (Login failed): No such user found. debian (proftptestserver.local[192.168.1.211]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth debian (proftptestserver.local[192.168.1.211]) - FTP session closed. FTP SQL log: Code: Oct 05 15:06:46 mod_sql/4.11[22370]: entering mysql cmd_escapestring Oct 05 15:06:46 mod_sql/4.11[22370]: exiting mysql cmd_escapestring Oct 05 15:06:46 mod_sql/4.11[22370]: cache miss for user 'maik' Oct 05 15:06:46 mod_sql/4.11[22370]: : entering mysql cmd_select Oct 05 15:06:46 mod_sql/4.11[22370]: entering mysql cmd_open Oct 05 15:06:46 mod_sql/4.11[22370]: connection 'default' count is now 2 Oct 05 15:06:46 mod_sql/4.11[22370]: exiting mysql cmd_open Oct 05 15:06:46 mod_sql/4.11[22370]: query "SELECT username, password, uid, gid, homedir, shell FROM ftp WHERE (username ='maik') LIMIT 1" Oct 05 15:06:46 mod_sql/4.11[22370]: entering mysql cmd_close Oct 05 15:06:46 mod_sql/4.11[22370]: connection 'default' count is now 1 Oct 05 15:06:46 mod_sql/4.11[22370]: exiting mysql cmd_close Oct 05 15:06:46 mod_sql/4.11[22370]: exiting mysql cmd_select Oct 05 15:06:46 mod_sql/4.11[22370]: cache miss for user 'maik' Oct 05 15:06:46 mod_sql/4.11[22370]: user 'maik' cached Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_name : maik Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_uid : 65534 Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_gid : 65534 Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_dir : /var/ftp/ Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_shell : Oct 05 15:06:46 mod_sql/4.11[22370]: <<< cmd_getpwnam Oct 05 15:06:46 mod_sql/4.11[22370]: >>> cmd_auth Oct 05 15:06:46 mod_sql/4.11[22370]: entering mysql cmd_escapestring Oct 05 15:06:46 mod_sql/4.11[22370]: exiting mysql cmd_escapestring Oct 05 15:06:46 mod_sql/4.11[22370]: cache hit for user 'maik' Oct 05 15:06:46 mod_sql/4.11[22370]: negative cache entry for user 'maik' Oct 05 15:06:46 mod_sql/4.11[22370]: <<< cmd_auth Oct 05 15:06:47 mod_sql/4.11[22370]: entering mysql cmd_exit Oct 05 15:06:47 mod_sql/4.11[22370]: entering mysql cmd_close Oct 05 15:06:47 mod_sql/4.11[22370]: connection 'default' closed Oct 05 15:06:47 mod_sql/4.11[22370]: connection 'default' count is now 0 Oct 05 15:06:47 mod_sql/4.11[22370]: exiting mysql cmd_close Oct 05 15:06:47 mod_sql/4.11[22370]: exiting mysql cmd_exit mein proftpd.conf sieht wie folgt aus: Code: serverType standalone SyslogLevel debug SystemLog /var/log/proftpd.system.log ServerIdent on "Stonki's Server" DeferWelcome on DefaultServer on DisplayLogin /messages/ftp.motd DisplayConnect /net/messages/ftp.pre DisplayFirstChdir index.txt Port 21 SQLAuthTypes Plaintext SQLAuthenticate users* SQLConnectInfo proftpd@localhost root SQLDefaultGID 65534 SQLDefaultUID 65534 SQLMinUserGID 100 SQLMinUserUID 500 SQLUserInfo ftp username uid gid password homedir shell SQLLog PASS counter SQLNamedQuery counter UPDATE "letzter_zugriff=now(), count=count+1 WHERE username='%u'" ftp 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 AllowForeignAddress on Umask 022 User nobody Group nogroup MaxClientsPerHost 3 "Nicht mehr als %m Verbindungen" MaxClients 5 "Leider sind schon %m Clients verbunden" AllowStoreRestart on AllowRetrieveRestart on MaxInstances 30 UseReverseDNS on TimeoutStalled 300 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" MaxLoginAttempts 3 RequireValidShell off Das ganze läuft auf nem Debian Sarge. Alle notwendigen Module dürften korrekt einkompeliert sein. Code: Compiled-in modules: mod_core.c mod_xfer.c mod_auth_unix.c mod_auth_file.c mod_auth.c mod_ls.c mod_log.c mod_site.c mod_sql.c mod_sql_mysql.c mod_cap.c Ich bin für jeden Hinweis dankbar. Titel: SQL Auth. Problem Beitrag von: freq.9 am 05. Oktober 2005, 19:29:15 Zitat USER maik (Login failed): No such user found Bist du sicher, dass es einen solchen User in der Datenbank gibts? Schau doch mal in die Logs. (/var/log/proftpd/*) Titel: maik Beitrag von: Anonymous am 06. Oktober 2005, 15:16:45 Zitat von: "freq.9" Zitat USER maik (Login failed): No such user found Bist du sicher, dass es einen solchen User in der Datenbank gibts? Schau doch mal in die Logs. (/var/log/proftpd/*) Du hast nicht ganz unrecht. Proftpd autentifiziert nicht gegen die MySQL Datenbank sondern gegen System-User. Ich habe aber in meiner Konfiguration folgende Angaben drin: Code: SQLAuthTypes Plaintext SQLAuthenticate users* SQLConnectInfo proftpd@localhost root SQLDefaultGID 65534 SQLDefaultUID 65534 SQLMinUserGID 100 SQLMinUserUID 500 SQLUserInfo ftp username uid gid password homedir shell Damit sollte doch gegen MySQL autentifiziert werden, oder? Woran könnte es liegen, dass immernoch gegen Systemuser autentifiziert wird? Titel: SQL Auth. Problem Beitrag von: Wörsty am 07. Oktober 2005, 20:43:48 Erstetze mal SQLAuthenticate (http://www.proftpd.de/index.php?id=54&directive_name=SQLAuthenticate) durch AuthOrder (http://www.proftpd.de/index.php?id=54&directive_name=AuthOrder)
Code: AuthOrder mod_sql.c Ansonsten gabs mal Probleme mit Debian: http://www.proftpd.de/forum/viewtopic.php?t=1015 |