www.ProFTPD.de

ProFTPD => ProFTPD - Deutsch => Thema gestartet von: Ubbo am 18. Oktober 2005, 20:26:46



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