|
Titel: Login mit echten Accs bei MySQL Login trotz users* Beitrag von: Ubbo am 18. Oktober 2005, 20:26:46 Hallo,
also ich habe Pro-FTPD (1.3.0rc2) firsch mit MySQL-Module kompiliert. Der Login über MySQL läuft auch wunderbar. So jetzt musste ich aber ensetzt feststellen, dass man sich immer noch mit normalen Accounts, also die es wirklich auf meinem System gibt, einloggen kann, und so in das entsprechende Home-Verzeichnis gelangt. Da ich aber die Docs & FAQs gelesen habe, steht in meiner proftpd.conf folgendes: Zitat SQLAuthTypes Plaintext SQLAuthenticate users* SQLConnectInfo db@localhost username password SQLDefaultGID 1004 #SQLDefaultUID 1004 ... Laut Tutorial soll hier ja _nur_ die Authentifizierung per MySQL funktionieren, allerdings funktioniert bei mir beides. Auch wenn ich das * entferne, ändert sich nichts. Man kann sich sowohl über Accounts aus der MySQL-Tabelle als auch über reale Accounts einloggen. Weiß jemand Rat? Wurde das in 1.3.0 geändert oder ist das ein Bug? Ich benutze Ubuntu. Hier der Log von proftpd: Code: localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching PRE_CMD command 'USER admin' to mod_core localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching PRE_CMD command 'USER admin' to mod_core localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching PRE_CMD command 'USER admin' to mod_delay localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching PRE_CMD command 'USER admin' to mod_auth localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "endpwent" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "endpwent" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "endpwent" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "endgrent" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "endgrent" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "endgrent" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching CMD command 'USER admin' to mod_auth localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getgroups" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getgroups" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getgroups" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching POST_CMD command 'USER admin' to mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching POST_CMD command 'USER admin' to mod_delay localhost.localdomain (localhost.localdomain[127.0.0.1]) - mod_delay/0.5: selecting median interval from 83 values localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching LOG_CMD command 'USER admin' to mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching LOG_CMD command 'USER admin' to mod_log localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getgroups" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getgroups" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getgroups" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "endpwent" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "endpwent" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "endpwent" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "endgrent" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "endgrent" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "endgrent" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching CMD command 'PASS (hidden)' to mod_auth localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getpwnam" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getpwnam" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getpwnam" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "gid2name" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "gid2name" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "gid2name" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "auth" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "auth" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "auth" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - ROOT PRIVS at mod_auth_unix.c:423 localhost.localdomain (localhost.localdomain[127.0.0.1]) - RELINQUISH PRIVS at mod_auth_unix.c:488 localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "check" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "check" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "check" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - user admin authenticated by mod_auth_unix.c localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "setgrent" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "setgrent" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "setgrent" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - ROOT PRIVS at mod_auth.c:447 localhost.localdomain (localhost.localdomain[127.0.0.1]) - RELINQUISH PRIVS at mod_auth.c:449 localhost.localdomain (localhost.localdomain[127.0.0.1]) - USER PRIVS 1000 at mod_auth.c:1026 localhost.localdomain (localhost.localdomain[127.0.0.1]) - RELINQUISH PRIVS at mod_auth.c:1028 localhost.localdomain (localhost.localdomain[127.0.0.1]) - localhost.localdomain (localhost.localdomain[127.0.0.1]) - Config for Andavos Server: localhost.localdomain (localhost.localdomain[127.0.0.1]) - Limit localhost.localdomain (localhost.localdomain[127.0.0.1]) - DenyAll localhost.localdomain (localhost.localdomain[127.0.0.1]) - DefaultServer localhost.localdomain (localhost.localdomain[127.0.0.1]) - Umask localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLAuthTypes localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLAuthenticate localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLConnectInfo localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLDefaultGID localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLMinUserGID localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLMinUserUID localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLUserTable localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLUsernameField localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLPasswordField localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLUidField localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLGidField localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLHomedirField localhost.localdomain (localhost.localdomain[127.0.0.1]) - SQLShellField localhost.localdomain (localhost.localdomain[127.0.0.1]) - UserID localhost.localdomain (localhost.localdomain[127.0.0.1]) - UserName localhost.localdomain (localhost.localdomain[127.0.0.1]) - GroupID localhost.localdomain (localhost.localdomain[127.0.0.1]) - GroupName localhost.localdomain (localhost.localdomain[127.0.0.1]) - DefaultRoot localhost.localdomain (localhost.localdomain[127.0.0.1]) - AllowOverwrite localhost.localdomain (localhost.localdomain[127.0.0.1]) - CURRENT-CLIENTS localhost.localdomain (localhost.localdomain[127.0.0.1]) - USER localhost.localdomain (localhost.localdomain[127.0.0.1]) - USER admin: Login successful. localhost.localdomain (localhost.localdomain[127.0.0.1]) - ROOT PRIVS at mod_auth.c:1097 localhost.localdomain (localhost.localdomain[127.0.0.1]) - opening TransferLog '/var/log/xferlog' localhost.localdomain (localhost.localdomain[127.0.0.1]) - RELINQUISH PRIVS at mod_auth.c:1126 localhost.localdomain (localhost.localdomain[127.0.0.1]) - USER PRIVS 1000 at mod_auth.c:596 localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getpwnam" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getpwnam" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getpwnam" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - RELINQUISH PRIVS at mod_auth.c:600 localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "setpwent" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "setpwent" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "setpwent" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "setgrent" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "setgrent" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "setgrent" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getpwent" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getpwent" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getpwent" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getgrent" to module mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getgrent" to module mod_auth_file localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching auth request "getgrent" to module mod_auth_unix localhost.localdomain (localhost.localdomain[127.0.0.1]) - Preparing to chroot() the environment, path = '/home/admin' localhost.localdomain (localhost.localdomain[127.0.0.1]) - ROOT PRIVS at mod_auth.c:61 localhost.localdomain (localhost.localdomain[127.0.0.1]) - FS: using system chroot() localhost.localdomain (localhost.localdomain[127.0.0.1]) - RELINQUISH PRIVS at mod_auth.c:68 localhost.localdomain (localhost.localdomain[127.0.0.1]) - Environment successfully chroot()ed. localhost.localdomain (localhost.localdomain[127.0.0.1]) - ROOT PRIVS at mod_auth.c:1169 localhost.localdomain (localhost.localdomain[127.0.0.1]) - SETUP PRIVS at mod_auth.c:1176 localhost.localdomain (localhost.localdomain[127.0.0.1]) - FS: using system chdir() localhost.localdomain (localhost.localdomain[127.0.0.1]) - in dir_check_full(): path = '/', fullpath = '/home/admin/'. localhost.localdomain (localhost.localdomain[127.0.0.1]) - FS: using system stat() localhost.localdomain (localhost.localdomain[127.0.0.1]) - FS: using system stat() localhost.localdomain (localhost.localdomain[127.0.0.1]) - FS: using system stat() localhost.localdomain (localhost.localdomain[127.0.0.1]) - FS: using system stat() localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching POST_CMD command 'PASS (hidden)' to mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching POST_CMD command 'PASS (hidden)' to mod_cap localhost.localdomain (localhost.localdomain[127.0.0.1]) - mod_cap/1.0: capabilities '= cap_net_bind_service+ep' localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching POST_CMD command 'PASS (hidden)' to mod_delay localhost.localdomain (localhost.localdomain[127.0.0.1]) - mod_delay/0.5: selecting median interval from 59 values localhost.localdomain (localhost.localdomain[127.0.0.1]) - mod_delay/0.5: delaying for 219966 usecs localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching POST_CMD command 'PASS (hidden)' to mod_log localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching POST_CMD command 'PASS (hidden)' to mod_ls localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching POST_CMD command 'PASS (hidden)' to mod_auth localhost.localdomain (localhost.localdomain[127.0.0.1]) - ROOT PRIVS: ID switching disabled localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching LOG_CMD command 'PASS (hidden)' to mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching LOG_CMD command 'PASS (hidden)' to mod_log localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching PRE_CMD command 'SYST' to mod_core localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching PRE_CMD command 'SYST' to mod_core localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching CMD command 'SYST' to mod_core localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching POST_CMD command 'SYST' to mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching LOG_CMD command 'SYST' to mod_sql localhost.localdomain (localhost.localdomain[127.0.0.1]) - dispatching LOG_CMD command 'SYST' to mod_log Dabei ist admin der lokale Account |