|
Titel: proftpd + mysql, nur 1 user funktioniert! -.- Beitrag von: Zipferl am 28. Juni 2005, 14:48:01 hallo
hier meine proftpd.conf: ServerName "xxxxxxxxxxxxxxxxxx" ServerType standalone DefaultServer on Port 21 Umask 022 RequireValidShell off DefaultRoot ~ <Global> SQLConnectInfo proftpd@localhost:3389 xxxx xxxxxxxx SQLAuthenticate users groups SQLAuthTypes Crypt Backend Plaintext SQLUserInfo users userid passwd uid gid homedir shell SQLGroupInfo groups groupid gid members SQLLog PASS logincount SQLNamedQuery logincount UPDATE "login_count=login_count+1 WHERE userid='%u'" users SQLLog PASS lastlogin SQLNamedQuery lastlogin UPDATE "last_login=now() WHERE userid='%u'" users SQLLog RETR dlbytescount SQLNamedQuery dlbytescount UPDATE "dl_bytes=dl_bytes+%b WHERE userid='%u'" users SQLLog RETR dlcount SQLNamedQuery dlcount UPDATE "dl_count=dl_count+1 WHERE userid='%u'" users SQLLog STOR ulbytescount SQLNamedQuery ulbytescount UPDATE "ul_bytes=ul_bytes+%b WHERE userid='%u'" users SQLLog STOR ulcount SQLNamedQuery ulcount UPDATE "ul_count=ul_count+1 WHERE userid='%u'" users SQLUserWhereClause "disabled!=1" SQLLOGFILE /var/log/proftpd.sql </Global> MaxInstances 30 User nobody Group nogroup <Directory /> AllowOverwrite on </Directory> problem ist: ich komm nur mit EINEM einzigen user drauf (welcher auch systemuser ist) wenn ich das pw von ihm änder, das es nicht mehr mit dem systemuser übereinstimmt, hab ich keinen zugriff mehr :look) hab ich benutzt, nach mehreren stunden suchen hab ichs aufgegeben Titel: proftpd + mysql, nur 1 user funktioniert! -.- Beitrag von: Zipferl am 30. Juni 2005, 08:17:04 weiss keiner warum?
Titel: proftpd + mysql, nur 1 user funktioniert! -.- Beitrag von: stonki am 30. Juni 2005, 10:23:55 Zitat von: "Zipferl" weiss keiner warum? a) SqlLogFile /var/log/proftpd.log b) Proftpd -n -d5 starten c) Einloggen d) Logs anschauen ggf. hier posten NIMM aber einen SQL user, der NICHT am System angemeldet ist ! Titel: proftpd + mysql, nur 1 user funktioniert! -.- Beitrag von: Zipferl am 30. Juni 2005, 11:22:03 danke schon mal für die hilfe!
hier das consolenfenster: Code: - parsing '/usr/local/etc/proftpd.conf' configuration - <Directory />: adding section for resolved path '/' Config for xxxxxxxxxxxxxx: / AllowOverwrite Umask SQLConnectInfo SQLAuthTypes RequireValidShell SQLAuthenticate DefaultServer Umask UserID UserName GroupID GroupName SQLConnectInfo SQLAuthTypes SQLUserTable SQLUsernameField SQLPasswordField SQLUidField SQLGidField SQLHomedirField RequireValidShell SQLGroupTable SQLGroupnameField SQLGroupGIDField SQLGroupMembersField SQLAuthenticate SQLLogFile Bind deleting existing scoreboard '/usr/local/var/proftpd/proftpd.scoreboard' ProFTPD 1.2.10 (stable) (built Thu Jun 30 09:29:05 CEST 2005) standalone mode STARTUP (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - FTP session requested from unknown class (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - connected - local : 212.126.64.77:21 (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - connected - remote : 85.124.4.14:3261 (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - FTP session opened. (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching PRE_CMD command 'USER test' to mod_core (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching PRE_CMD command 'USER test' to mod_core (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching PRE_CMD command 'USER test' to mod_auth (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching CMD command 'USER test' to mod_auth (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - no supplemental groups found for user 'test' (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching POST_CMD command 'USER test' to mod_sql (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching LOG_CMD command 'USER test' to mod_sql (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching LOG_CMD command 'USER test' to mod_log (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching CMD command 'PASS (hidden)' to mod_auth (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - no supplemental groups found for user 'test' (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - USER test (Login failed): Incorrect password. (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth (85-124-4-14.dynamic.xdsl-line.inode.at[85.124.4.14]) - FTP session closed. und hier das log: Code: Jun 30 11:26:28 mod_sql/4.11[5222]: backend module 'mod_sql_mysql/4.04' Jun 30 11:26:28 mod_sql/4.11[5222]: backend api 'mod_sql_api_v1' Jun 30 11:26:28 mod_sql/4.11[5222]: >>> sql_getconf Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_defineconnection Jun 30 11:26:28 mod_sql/4.11[5222]: name: 'default' Jun 30 11:26:28 mod_sql/4.11[5222]: user: 'root' Jun 30 11:26:28 mod_sql/4.11[5222]: host: 'localhost' Jun 30 11:26:28 mod_sql/4.11[5222]: db: 'proftpd' Jun 30 11:26:28 mod_sql/4.11[5222]: port: '3389' Jun 30 11:26:28 mod_sql/4.11[5222]: ttl: '0' Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_defineconnection Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_open Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' opened Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 1 Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_open Jun 30 11:26:28 mod_sql/4.11[5222]: backend successfully connected. Jun 30 11:26:28 mod_sql/4.11[5222]: mod_sql status : on Jun 30 11:26:28 mod_sql/4.11[5222]: negative_cache : off Jun 30 11:26:28 mod_sql/4.11[5222]: authenticate : users groups Jun 30 11:26:28 mod_sql/4.11[5222]: usertable : users Jun 30 11:26:28 mod_sql/4.11[5222]: userid field : userid Jun 30 11:26:28 mod_sql/4.11[5222]: password field : passwd Jun 30 11:26:28 mod_sql/4.11[5222]: uid field : uid Jun 30 11:26:28 mod_sql/4.11[5222]: gid field : gid Jun 30 11:26:28 mod_sql/4.11[5222]: homedir field : homedir Jun 30 11:26:28 mod_sql/4.11[5222]: shell field : NULL Jun 30 11:26:28 mod_sql/4.11[5222]: homedirondemand : false Jun 30 11:26:28 mod_sql/4.11[5222]: group table : groups Jun 30 11:26:28 mod_sql/4.11[5222]: groupname field : groupid Jun 30 11:26:28 mod_sql/4.11[5222]: grp gid field : gid Jun 30 11:26:28 mod_sql/4.11[5222]: grp members field : members Jun 30 11:26:28 mod_sql/4.11[5222]: SQLMinUserUID : 999 Jun 30 11:26:28 mod_sql/4.11[5222]: SQLMinUserGID : 999 Jun 30 11:26:28 mod_sql/4.11[5222]: SQLDefaultUID : 65533 Jun 30 11:26:28 mod_sql/4.11[5222]: SQLDefaultGID : 65533 Jun 30 11:26:28 mod_sql/4.11[5222]: <<< sql_getconf Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_getgroups Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_escapestring Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_escapestring Jun 30 11:26:28 mod_sql/4.11[5222]: cache miss for user 'test' Jun 30 11:26:28 mod_sql/4.11[5222]: : entering mysql cmd_select Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_open Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 2 Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_open Jun 30 11:26:28 mod_sql/4.11[5222]: query "SELECT userid, passwd, uid, gid, homedir FROM users WHERE (userid='test') LIMIT 1" Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_close Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 1 Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_close Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_select Jun 30 11:26:28 mod_sql/4.11[5222]: cache miss for user 'test' Jun 30 11:26:28 mod_sql/4.11[5222]: user 'test' cached Jun 30 11:26:28 mod_sql/4.11[5222]: + pwd.pw_name : test Jun 30 11:26:28 mod_sql/4.11[5222]: + pwd.pw_uid : 10000 Jun 30 11:26:28 mod_sql/4.11[5222]: + pwd.pw_gid : 65534 Jun 30 11:26:28 mod_sql/4.11[5222]: + pwd.pw_dir : /home Jun 30 11:26:28 mod_sql/4.11[5222]: + pwd.pw_shell : Jun 30 11:26:28 mod_sql/4.11[5222]: cache miss for gid '65534' Jun 30 11:26:28 mod_sql/4.11[5222]: : entering mysql cmd_select Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_open Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 2 Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_open Jun 30 11:26:28 mod_sql/4.11[5222]: query "SELECT groupid FROM groups WHERE (gid = 65534) LIMIT 1" Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_close Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 1 Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_close Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_select Jun 30 11:26:28 mod_sql/4.11[5222]: : entering mysql cmd_select Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_open Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 2 Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_open Jun 30 11:26:28 mod_sql/4.11[5222]: query "SELECT groupid, gid, members FROM groups WHERE (groupid = 'nogroup')" Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_close Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 1 Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_close Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_select Jun 30 11:26:28 mod_sql/4.11[5222]: cache miss for group 'nogroup' Jun 30 11:26:28 mod_sql/4.11[5222]: group 'nogroup' cached Jun 30 11:26:28 mod_sql/4.11[5222]: + grp.gr_name : nogroup Jun 30 11:26:28 mod_sql/4.11[5222]: + grp.gr_gid : 65534 Jun 30 11:26:28 mod_sql/4.11[5222]: + grp.gr_mem : Jun 30 11:26:28 mod_sql/4.11[5222]: : entering mysql cmd_select Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_open Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 2 Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_open Jun 30 11:26:28 mod_sql/4.11[5222]: query "SELECT groupid, gid, members FROM groups WHERE (members = 'test' OR members LIKE 'test,%' OR members LIKE '%,test' OR members LIKE '%,test,%')" Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_close Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 1 Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_close Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_select Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_getgroups Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_getgroups Jun 30 11:26:28 mod_sql/4.11[5222]: cache hit for user 'test' Jun 30 11:26:28 mod_sql/4.11[5222]: cache hit for group nogroup Jun 30 11:26:28 mod_sql/4.11[5222]: : entering mysql cmd_select Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_open Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 2 Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_open Jun 30 11:26:28 mod_sql/4.11[5222]: query "SELECT groupid, gid, members FROM groups WHERE (members = 'test' OR members LIKE 'test,%' OR members LIKE '%,test' OR members LIKE '%,test,%')" Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_close Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 1 Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_close Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_select Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_getgroups Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_getpwnam Jun 30 11:26:28 mod_sql/4.11[5222]: cache hit for user 'test' Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_getpwnam Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_gid2name Jun 30 11:26:28 mod_sql/4.11[5222]: cache hit for group nogroup Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_gid2name Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_auth Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_escapestring Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_escapestring Jun 30 11:26:28 mod_sql/4.11[5222]: cache hit for user 'test' Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_check Jun 30 11:26:28 mod_sql/4.11[5222]: checking auth_type Backend Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_checkauth Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_checkauth Jun 30 11:26:28 mod_sql/4.11[5222]: checking auth_type Plaintext Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_check Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_auth Jun 30 11:26:28 mod_sql/4.11[5222]: >>> cmd_check Jun 30 11:26:28 mod_sql/4.11[5222]: checking auth_type Backend Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_checkauth Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_checkauth Jun 30 11:26:28 mod_sql/4.11[5222]: checking auth_type Plaintext Jun 30 11:26:28 mod_sql/4.11[5222]: <<< cmd_check Jun 30 11:26:28 mod_sql/4.11[5222]: entering mysql cmd_close Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' closed Jun 30 11:26:28 mod_sql/4.11[5222]: connection 'default' count is now 0 Jun 30 11:26:28 mod_sql/4.11[5222]: exiting mysql cmd_close mir sagt das leider nicht viel, was hier steht :? Titel: proftpd + mysql, nur 1 user funktioniert! -.- Beitrag von: stonki am 30. Juni 2005, 13:45:33 logge Dich mal mysql ein, und mache die Abfrage:
SELECT userid, passwd, uid, gid, homedir FROM users WHERE (userid='test'); poste mal das ergebnis hier: Titel: proftpd + mysql, nur 1 user funktioniert! -.- Beitrag von: Zipferl am 30. Juni 2005, 13:55:47 Code: +--------+-------------------------------------------+-------+-------+---------+ | userid | passwd | uid | gid | homedir | +--------+-------------------------------------------+-------+-------+---------+ | test | *E0EA3C55BFA00FCA9982220481B3602D89E0C8C8 | 10000 | 65534 | /home | +--------+-------------------------------------------+-------+-------+---------+ 1 row in set (0.00 sec) was ich mittlerweile auch mitbekommen habe ist, das die mysqlversion 4.1.12 passwörter irgendwie anders verschlüsselt oder so, allerdings wenn es daran liegt frag ich mich, warum ich mich mit einem account am ftp einloggen kann Titel: proftpd + mysql, nur 1 user funktioniert! -.- Beitrag von: stonki am 30. Juni 2005, 15:36:33 Zitat von: "Zipferl" Code: +--------+-------------------------------------------+-------+-------+---------+ | userid | passwd | uid | gid | homedir | +--------+-------------------------------------------+-------+-------+---------+ | test | *E0EA3C55BFA00FCA9982220481B3602D89E0C8C8 | 10000 | 65534 | /home | +--------+-------------------------------------------+-------+-------+---------+ 1 row in set (0.00 sec) was ich mittlerweile auch mitbekommen habe ist, das die mysqlversion 4.1.12 passwörter irgendwie anders verschlüsselt oder so, allerdings wenn es daran liegt frag ich mich, warum ich mich mit einem account am ftp einloggen kann existiert der andere account im System ? Wenn ja, dann wird das Password ggf. genommen. Also ich würde als password mal "test" eintragen und dann nochmal probieren. Ich denke, das liegt daran. cu stonki Titel: proftpd + mysql, nur 1 user funktioniert! -.- Beitrag von: Zipferl am 30. Juni 2005, 16:07:37 sobald ich das passwort änder komm ich gar nicht mehr rein
Titel: proftpd + mysql, nur 1 user funktioniert! -.- Beitrag von: stonki am 30. Juni 2005, 18:17:50 Zitat von: "Zipferl" sobald ich das passwort änder komm ich gar nicht mehr rein darf denn der User ueberhaupt ins verzeichnis "/home/" von den Rechten ? Schau Dir IMMER das SQL und Debug Log an |