|
Titel: SysCP - ProFTPD - MySQL Beitrag von: Dumby am 30. April 2005, 21:15:50 Hallo,
ich nutze ProFTPD im Zusammenhang mit SysCP auf einem Debian Sarge System. Der FTP Deamon läuft und springt auch auf Verbindungsversuche an. Jedoch erwiedert der server meinem Client '530 Login Incorrect'. Ich habe meine Config sowie das SQL-Logfile angehängt. Und ja, ich habe andere Threads die sich mit dem Thema beschäftigen bereits gelesen, aber keine Lösung gefunden. Über Hilfe wäre ich sehr Dankbar. Grüße Dumby Config: Code: ServerName "85.10.XXX.XXX FTP Server" ServerType standalone DeferWelcome off MultilineRFC2228 on DefaultServer on ShowSymlinks on AllowOverwrite on TimeoutNoTransfer 600 TimeoutStalled 600 TimeoutIdle 1200 DisplayLogin welcome.msg DisplayFirstChdir .message ListOptions "-l" DenyFilter \*.*/ Port 21 MaxInstances 30 # Set the user and group that the server normally runs at. User nobody Group nogroup <Directory /*> # Umask 022 is a good standard umask to prevent new files and dirs # (second parm) from being group and world writable. Umask 022 022 # Normally, we want files to be overwriteable. AllowOverwrite on </Directory> DefaultRoot ~ RequireValidShell off SQLLOGFILE /var/log/proftpd.sqllog SQLAuthTypes Crypt Plaintext SQLAuthenticate users* groups* SQLConnectInfo syscp@localhost ******* ********** SQLUserInfo ftp_users username password uid gid homedir shell SQLGroupInfo ftp_groups groupname gid members SQLUserWhereClause "login_enabled = 'y'" SQLLog PASS login SQLNamedQuery login UPDATE "last_login=now(), login_count=login_count+1 WHERE username='%u'" ftp_users SQLLog RETR download SQLNamedQuery download UPDATE "down_count=down_count+1, down_bytes=down_bytes+%b WHERE username='%u'" ftp_users SQLLog STOR upload SQLNamedQuery upload UPDATE "up_count=up_count+1, up_bytes=up_bytes+%b WHERE username='%u'" ftp_users SQL-Logfile Code: Apr 30 21:09:48 mod_sql/4.11[20598]: >>> cmd_getgroups Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for user '******' Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for group ****** Apr 30 21:09:48 mod_sql/4.11[20598]: : entering mysql cmd_select Apr 30 21:09:48 mod_sql/4.11[20598]: entering mysql cmd_open Apr 30 21:09:48 mod_sql/4.11[20598]: connection 'default' count is now 2 Apr 30 21:09:48 mod_sql/4.11[20598]: exiting mysql cmd_open Apr 30 21:09:48 mod_sql/4.11[20598]: query "SELECT groupname, gid, members FROM ftp_groups WHERE (members = '******' OR members LIKE '******,%' OR members LIK E '%,******' OR members LIKE '%,******,%')" Apr 30 21:09:48 mod_sql/4.11[20598]: entering mysql cmd_close Apr 30 21:09:48 mod_sql/4.11[20598]: connection 'default' count is now 1 Apr 30 21:09:48 mod_sql/4.11[20598]: exiting mysql cmd_close Apr 30 21:09:48 mod_sql/4.11[20598]: exiting mysql cmd_select Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for group '******' Apr 30 21:09:48 mod_sql/4.11[20598]: <<< cmd_getgroups Apr 30 21:09:48 mod_sql/4.11[20598]: >>> cmd_getpwnam Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for user '******' Apr 30 21:09:48 mod_sql/4.11[20598]: <<< cmd_getpwnam Apr 30 21:09:48 mod_sql/4.11[20598]: >>> cmd_gid2name Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for group ****** Apr 30 21:09:48 mod_sql/4.11[20598]: <<< cmd_gid2name Apr 30 21:09:48 mod_sql/4.11[20598]: >>> cmd_auth Apr 30 21:09:48 mod_sql/4.11[20598]: entering mysql cmd_escapestring Apr 30 21:09:48 mod_sql/4.11[20598]: exiting mysql cmd_escapestring Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for user '******' Apr 30 21:09:48 mod_sql/4.11[20598]: >>> cmd_check Apr 30 21:09:48 mod_sql/4.11[20598]: checking auth_type Crypt Apr 30 21:09:48 mod_sql/4.11[20598]: checking auth_type Plaintext Apr 30 21:09:48 mod_sql/4.11[20598]: 'Plaintext' auth handler reports success Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for user '******' Apr 30 21:09:48 mod_sql/4.11[20598]: <<< cmd_check Apr 30 21:09:48 mod_sql/4.11[20598]: <<< cmd_auth Apr 30 21:09:48 mod_sql/4.11[20598]: >>> cmd_getpwnam Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for user '******' Apr 30 21:09:48 mod_sql/4.11[20598]: <<< cmd_getpwnam Apr 30 21:09:48 mod_sql/4.11[20598]: entering mysql cmd_close Apr 30 21:09:48 mod_sql/4.11[20598]: connection 'default' closed Apr 30 21:09:48 mod_sql/4.11[20598]: connection 'default' count is now 0 Apr 30 21:09:48 mod_sql/4.11[20598]: exiting mysql cmd_close Titel: SysCP - ProFTPD - MySQL Beitrag von: Anonymous am 01. Mai 2005, 11:15:34 Habe festgestellt, dass man sich mit den Shell-Users einloggen kann, liegt also wohl am MySQL Code, fehler finde ich aber nicht.
|