Servus.
ich möchte einen ProftpD mit SQL Unterstützung aufsetzen.
Dies habe ich nach dieser anleitung https://www.digitalocean.com/community/tutorials/how-to-set-up-proftpd-with-a-mysql-backend-on-ubuntu-12-10
versucht.
Es scheint soweit auch alles zulaufen. nur einloggen kann ich mich nicht auf dem FTP.
Jetzt kommt ne menge gelogtes von einem Verbindungs versuch . Logs vorher geleert .
proftpd -nd10 log
root@vps***38:~# proftpd -nd10 vps***38.ovh.net proftpd[2824]: using PCRE 8.30 2012-02-04 vps***38.ovh.net proftpd[2824]: using TCP receive buffer size of 87380 bytes vps***38.ovh.net proftpd[2824]: using TCP send buffer size of 16384 bytes vps***38.ovh.net proftpd[2824]: testing Unix domain socket using S_ISFIFO vps***38.ovh.net proftpd[2824]: testing Unix domain socket using S_ISSOCK vps***38.ovh.net proftpd[2824]: using S_ISSOCK macro for Unix domain socket detection vps***38.ovh.net proftpd[2824]: ROOT PRIVS at mod_core.c:358 vps***38.ovh.net proftpd[2824]: loading 'mod_ctrls_admin.c' vps***38.ovh.net proftpd[2824]: loading 'mod_tls.c' vps***38.ovh.net proftpd[2824]: mod_tls/2.4.3: using OpenSSL 1.0.1e 11 Feb 2013 vps***38.ovh.net proftpd[2824]: loading 'mod_sql.c' vps***38.ovh.net proftpd[2824]: loading 'mod_sql_mysql.c' vps***38.ovh.net proftpd[2824]: loading 'mod_radius.c' vps***38.ovh.net proftpd[2824]: loading 'mod_quotatab.c' vps***38.ovh.net proftpd[2824]: loading 'mod_quotatab_file.c' vps***38.ovh.net proftpd[2824]: loading 'mod_quotatab_radius.c' vps***38.ovh.net proftpd[2824]: loading 'mod_wrap.c' vps***38.ovh.net proftpd[2824]: loading 'mod_rewrite.c' vps***38.ovh.net proftpd[2824]: loading 'mod_load.c' vps***38.ovh.net proftpd[2824]: loading 'mod_ban.c' vps***38.ovh.net proftpd[2824]: loading 'mod_wrap2.c' vps***38.ovh.net proftpd[2824]: loading 'mod_wrap2_file.c' vps***38.ovh.net proftpd[2824]: loading 'mod_dynmasq.c' vps***38.ovh.net proftpd[2824]: loading 'mod_exec.c' vps***38.ovh.net proftpd[2824]: loading 'mod_shaper.c' vps***38.ovh.net proftpd[2824]: loading 'mod_ratio.c' vps***38.ovh.net proftpd[2824]: loading 'mod_site_misc.c' vps***38.ovh.net proftpd[2824]: loading 'mod_sftp.c' vps***38.ovh.net proftpd[2824]: mod_sftp/0.9.8: using OpenSSL 1.0.1e 11 Feb 2013 vps***38.ovh.net proftpd[2824]: loading 'mod_sftp_pam.c' vps***38.ovh.net proftpd[2824]: loading 'mod_facl.c' vps***38.ovh.net proftpd[2824]: mod_facl/0.4: registered 'facl' FS vps***38.ovh.net proftpd[2824]: loading 'mod_unique_id.c' vps***38.ovh.net proftpd[2824]: loading 'mod_copy.c' vps***38.ovh.net proftpd[2824]: loading 'mod_deflate.c' vps***38.ovh.net proftpd[2824]: mod_deflate/0.5.5: using zlib 1.2.7 vps***38.ovh.net proftpd[2824]: loading 'mod_ifversion.c' vps***38.ovh.net proftpd[2824]: loading 'mod_tls_memcache.c' vps***38.ovh.net proftpd[2824]: mod_tls_memcache/0.1: notice: unable to register 'memcache' SSL session cache: Memcache support not enabled vps***38.ovh.net proftpd[2824]: loading 'mod_ifsession.c' vps***38.ovh.net proftpd[2824]: RELINQUISH PRIVS at mod_core.c:380 vps***38.ovh.net proftpd[2824]: DenyFilter: compiling regex '\*.*/' vps***38.ovh.net proftpd[2824]: <IfModule>: using 'mod_dynmasq.c' section at line 56 vps***38.ovh.net proftpd[2824]: retrieved UID 103 for user 'proftpd' vps***38.ovh.net proftpd[2824]: retrieved GID 65534 for group 'nogroup' vps***38.ovh.net proftpd[2824]: ROOT PRIVS at mod_log.c:588 vps***38.ovh.net proftpd[2824]: RELINQUISH PRIVS at mod_log.c:593 vps***38.ovh.net proftpd[2824]: <IfModule>: using 'mod_quotatab.c' section at line 102 vps***38.ovh.net proftpd[2824]: <IfModule>: using 'mod_ratio.c' section at line 106 vps***38.ovh.net proftpd[2824]: <IfModule>: using 'mod_delay.c' section at line 114 vps***38.ovh.net proftpd[2824]: <IfModule>: using 'mod_ctrls.c' section at line 118 vps***38.ovh.net proftpd[2824]: ROOT PRIVS at mod_ctrls.c:112 vps***38.ovh.net proftpd[2824]: RELINQUISH PRIVS at mod_ctrls.c:114 vps***38.ovh.net proftpd[2824]: <IfModule>: using 'mod_ctrls_admin.c' section at line 126 vps***38.ovh.net proftpd[2824]: ROOT PRIVS at mod_core.c:358 vps***38.ovh.net proftpd[2824]: RELINQUISH PRIVS at mod_core.c:380 vps***38.ovh.net proftpd[2824]: ROOT PRIVS at mod_core.c:358 vps***38.ovh.net proftpd[2824]: warning: handling possibly truncated configuration data at line 31 of '/etc/proftpd/sql.conf' vps***38.ovh.net proftpd[2824]: RELINQUISH PRIVS at mod_core.c:380 vps***38.ovh.net proftpd[2824]: warning: handling possibly truncated configuration data at line 194 of '/etc/proftpd/proftpd.conf' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: Config for VPS1 ProFTPdAdmin: vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: IdentLookups vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: DeferWelcome vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: MultilineRFC2228 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: DefaultServer vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ShowSymlinks vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: TimeoutNoTransfer vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: TimeoutStalled vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: TimeoutIdle vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: DisplayLogin vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: DisplayChdir vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ListOptions vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: DenyFilter vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: DefaultRoot vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: UserID vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: UserName vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: GroupID vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: GroupName vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: Umask vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: DirUmask vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: AllowOverwrite vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: TransferLog vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: QuotaEngine vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: Ratios vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: DelayEngine vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLBackend vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLAuthTypes vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLAuthenticate vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLConnectInfo vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLUserTable vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLUsernameField vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLPasswordField vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLUidField vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLGidField vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLHomedirField vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLShellField vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLGroupTable vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLGroupnameField vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLGroupGIDField vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLGroupMembersField vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLMinID vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLLog_PASS vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLNamedQuery_updatecount vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLLog_STOR vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLLog_DELE vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLNamedQuery_modified vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SQLLogFile vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: RequireValidShell vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ROOT PRIVS at mod_delay.c:425 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: RELINQUISH PRIVS at mod_delay.c:430 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: mod_lang/0.9: binding to text domain 'proftpd' using locale path '/usr/share/locale' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: mod_lang/0.9: using locale files in '/usr/share/locale' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: mod_lang/0.9: skipping possible language 'ko_KR': not supported by setlocale(3); see `locale -a' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: mod_lang/0.9: skipping possible language 'ru_RU': not supported by setlocale(3); see `locale -a' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: mod_lang/0.9: skipping possible language 'fr_FR': not supported by setlocale(3); see `locale -a' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: mod_lang/0.9: skipping possible language 'bg_BG': not supported by setlocale(3); see `locale -a' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: mod_lang/0.9: skipping possible language 'en_US': not supported by setlocale(3); see `locale -a' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: mod_lang/0.9: skipping possible language 'zh_CN': not supported by setlocale(3); see `locale -a' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: mod_lang/0.9: skipping possible language 'it_IT': not supported by setlocale(3); see `locale -a' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: mod_lang/0.9: skipping possible language 'ja_JP': not supported by setlocale(3); see `locale -a' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: mod_lang/0.9: skipping possible language 'zh_TW': not supported by setlocale(3); see `locale -a' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: retrieved group ID: 65534 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: setting group ID: 65534 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: SETUP PRIVS at main.c:3325 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ROOT PRIVS at main.c:2295 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: RELINQUISH PRIVS at main.c:2304 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ROOT PRIVS at main.c:2662 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: opening scoreboard '/var/run/proftpd.scoreboard' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: RELINQUISH PRIVS at main.c:2688 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ROOT PRIVS at mod_ctrls_admin.c:1338 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: opening scoreboard '/var/run/proftpd.scoreboard' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: RELINQUISH PRIVS at mod_ctrls_admin.c:1340 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ROOT PRIVS at inet.c:347 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: RELINQUISH PRIVS at inet.c:410 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ProFTPD 1.3.4a (maint) (built Thu Sep 4 2014 14:41:08 UTC) standalone mode STARTUP vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ROOT PRIVS at pidfile.c:47 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: RELINQUISH PRIVS at pidfile.c:49 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu: ROOT PRIVS at main.c:1261 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu: RELINQUISH PRIVS at main.c:1265 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu: no matching vhost found for ::ffff:37.59.111.94#21, using 'VPS1 ProFTPdAdmin' listening on wildcard address vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): ROOT PRIVS at main.c:1076 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): SETUP PRIVS at main.c:1081 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): session requested from client in unknown class vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): performing module session initializations vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): mod_unique_id/0.2: generating unique session ID vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): mod_unique_id/0.2: unique session ID is 'VEODtiU7b15P8dIsAAALCTWB' vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): ROOT PRIVS at mod_sql.c:5385 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): RELINQUISH PRIVS at mod_sql.c:5387 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): mod_sql/4.3: defaulting to 'mysql' backend vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): mod_cap/1.1: adding CAP_AUDIT_WRITE capability vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): mod_ident/1.0: ident lookup disabled vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): ROOT PRIVS at mod_delay.c:1650 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): RELINQUISH PRIVS at mod_delay.c:1655 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): ROOT PRIVS at mod_auth.c:129 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): opening scoreboard '/var/run/proftpd.scoreboard' vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): RELINQUISH PRIVS at mod_auth.c:131 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): connected - local : ::ffff:37.59.111.94:21 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): connected - remote : 9.2*.2*.*:59168 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): FTP session opened. vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'USER a' to mod_exec vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'USER a' to mod_rewrite vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'USER a' to mod_tls vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'USER a' to mod_core vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'USER a' to mod_core vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'USER a' to mod_delay vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'USER a' to mod_auth vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching CMD command 'USER a' to mod_ratio vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching CMD command 'USER a' to mod_auth vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching POST_CMD command 'USER a' to mod_exec vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching POST_CMD command 'USER a' to mod_sql vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching POST_CMD command 'USER a' to mod_delay vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching LOG_CMD command 'USER a' to mod_sql vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching LOG_CMD command 'USER a' to mod_log vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_exec vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_tls vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_core vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_core vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_shaper vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): ROOT PRIVS at mod_shaper.c:1998 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): RELINQUISH PRIVS at mod_shaper.c:2000 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap2 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_ban vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_radius vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_sql vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_delay vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching PRE_CMD command 'PASS (hidden)' to mod_auth vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching CMD command 'PASS (hidden)' to mod_auth vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): retrieved UID 5500 for user 'a' vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): no supplemental groups found for user 'a' vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): ROOT PRIVS at mod_auth_pam.c:311 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): RELINQUISH PRIVS at mod_auth_pam.c:481 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): USER a (Login failed): No such user found. vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_exec vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_shaper vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_wrap2 vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_radius vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_delay vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth vps***38.ovh.net proftpd[2825] 94.ip-37-*-*.eu (p4**********t.de[9.2*.2*.*]): FTP session closed. ^Cvps92638.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ProFTPD terminating (signal 2) vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ROOT PRIVS at main.c:2063 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ROOT PRIVS at mod_delay.c:1531 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: RELINQUISH PRIVS at mod_delay.c:1536 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: RELINQUISH PRIVS at main.c:2088 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ProFTPD 1.3.4a standalone mode SHUTDOWN vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: ROOT PRIVS at main.c:2095 vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: deleting existing scoreboard '/var/run/proftpd.scoreboard' vps***38.ovh.net proftpd[2824] 94.ip-37-*-*.eu: RELINQUISH PRIVS at main.c:2097
/var/log/proftpd/sql.log
Okt 19 11:35:48 mod_sql/4.3[2835]: defaulting to 'mysql' backend Okt 19 11:35:48 mod_sql/4.3[2835]: backend module 'mod_sql_mysql/4.0.8' Okt 19 11:35:48 mod_sql/4.3[2835]: backend api 'mod_sql_api_v1' Okt 19 11:35:48 mod_sql/4.3[2835]: >>> sql_sess_init Okt 19 11:35:48 mod_sql/4.3[2835]: entering mysql cmd_defineconnection Okt 19 11:35:48 mod_sql/4.3[2835]: name: 'default' Okt 19 11:35:48 mod_sql/4.3[2835]: user: 'ftpd' Okt 19 11:35:48 mod_sql/4.3[2835]: host: 'localhost' Okt 19 11:35:48 mod_sql/4.3[2835]: db: 'ftpd' Okt 19 11:35:48 mod_sql/4.3[2835]: port: '3306' Okt 19 11:35:48 mod_sql/4.3[2835]: ttl: '0' Okt 19 11:35:48 mod_sql/4.3[2835]: exiting mysql cmd_defineconnection Okt 19 11:35:48 mod_sql/4.3[2835]: connection 'default' successfully established Okt 19 11:35:48 mod_sql/4.3[2835]: mod_sql engine : on Okt 19 11:35:48 mod_sql/4.3[2835]: negative_cache : off Okt 19 11:35:48 mod_sql/4.3[2835]: authenticate : users groups Okt 19 11:35:48 mod_sql/4.3[2835]: usertable : ftpuser Okt 19 11:35:48 mod_sql/4.3[2835]: userid field : userid Okt 19 11:35:48 mod_sql/4.3[2835]: password field : passwd Okt 19 11:35:48 mod_sql/4.3[2835]: UID field : uid Okt 19 11:35:48 mod_sql/4.3[2835]: GID field : gid Okt 19 11:35:48 mod_sql/4.3[2835]: homedir field : homedir Okt 19 11:35:48 mod_sql/4.3[2835]: shell field : shell Okt 19 11:35:48 mod_sql/4.3[2835]: group table : ftpgroup Okt 19 11:35:48 mod_sql/4.3[2835]: groupname field : groupname Okt 19 11:35:48 mod_sql/4.3[2835]: grp GID field : gid Okt 19 11:35:48 mod_sql/4.3[2835]: grp members field : members Okt 19 11:35:48 mod_sql/4.3[2835]: SQLMinUserUID : 500 Okt 19 11:35:48 mod_sql/4.3[2835]: SQLMinUserGID : 500 Okt 19 11:35:48 mod_sql/4.3[2835]: SQLDefaultUID : 65533 Okt 19 11:35:48 mod_sql/4.3[2835]: SQLDefaultGID : 65533 Okt 19 11:35:48 mod_sql/4.3[2835]: <<< sql_sess_init Okt 19 11:35:49 mod_sql/4.3[2835]: >>> sql_pre_pass Okt 19 11:35:49 mod_sql/4.3[2835]: <<< sql_pre_pass Okt 19 11:35:49 mod_sql/4.3[2835]: >>> cmd_getpwnam Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_escapestring Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_open Okt 19 11:35:49 mod_sql/4.3[2835]: MySQL client version: 5.5.38 Okt 19 11:35:49 mod_sql/4.3[2835]: MySQL server version: 5.5.38-0+wheezy1 Okt 19 11:35:49 mod_sql/4.3[2835]: MySQL connection character set now 'utf8' (from 'UTF-8') Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' opened Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' count is now 2 Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_open Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_close Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' count is now 1 Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_close Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_escapestring Okt 19 11:35:49 mod_sql/4.3[2835]: cache miss for user 'a' Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_select Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_open Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' count is now 2 Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_open Okt 19 11:35:49 mod_sql/4.3[2835]: query "SELECT userid, passwd, uid, gid, homedir, shell FROM ftpuser WHERE (userid='a') LIMIT 1" Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_close Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' count is now 1 Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_close Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_select Okt 19 11:35:49 mod_sql/4.3[2835]: cache miss for user 'a' Okt 19 11:35:49 mod_sql/4.3[2835]: user 'a' cached Okt 19 11:35:49 mod_sql/4.3[2835]: + pwd.pw_name : a Okt 19 11:35:49 mod_sql/4.3[2835]: + pwd.pw_uid : 5500 Okt 19 11:35:49 mod_sql/4.3[2835]: + pwd.pw_gid : 5500 Okt 19 11:35:49 mod_sql/4.3[2835]: + pwd.pw_dir : /home/files Okt 19 11:35:49 mod_sql/4.3[2835]: + pwd.pw_shell : /sbin/nologin Okt 19 11:35:49 mod_sql/4.3[2835]: <<< cmd_getpwnam Okt 19 11:35:49 mod_sql/4.3[2835]: >>> cmd_gid2name Okt 19 11:35:49 mod_sql/4.3[2835]: cache miss for GID '5500' Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_select Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_open Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' count is now 2 Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_open Okt 19 11:35:49 mod_sql/4.3[2835]: query "SELECT groupname FROM ftpgroup WHERE (gid = 5500) LIMIT 1" Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_close Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' count is now 1 Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_close Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_select Okt 19 11:35:49 mod_sql/4.3[2835]: <<< cmd_gid2name Okt 19 11:35:49 mod_sql/4.3[2835]: >>> cmd_getgroups Okt 19 11:35:49 mod_sql/4.3[2835]: cache hit for user 'a' Okt 19 11:35:49 mod_sql/4.3[2835]: cache miss for GID '5500' Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_select Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_open Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' count is now 2 Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_open Okt 19 11:35:49 mod_sql/4.3[2835]: query "SELECT groupname FROM ftpgroup WHERE (gid = 5500) LIMIT 1" Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_close Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' count is now 1 Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_close Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_select Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_escapestring Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_open Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' count is now 2 Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_open Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_close Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' count is now 1 Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_close Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_escapestring Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_select Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_open Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' count is now 2 Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_open Okt 19 11:35:49 mod_sql/4.3[2835]: query "SELECT groupname, gid, members FROM ftpgroup WHERE (members = 'a' OR members LIKE 'a,%' OR members LIKE '%,a' OR members LIKE '%,a,%')" Okt 19 11:35:49 mod_sql/4.3[2835]: entering mysql cmd_close Okt 19 11:35:49 mod_sql/4.3[2835]: connection 'default' count is now 1 Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_close Okt 19 11:35:49 mod_sql/4.3[2835]: exiting mysql cmd_select Okt 19 11:35:49 mod_sql/4.3[2835]: <<< cmd_getgroups Okt 19 11:35:50 mod_sql/4.3[2835]: >>> cmd_auth Okt 19 11:35:50 mod_sql/4.3[2835]: entering mysql cmd_escapestring Okt 19 11:35:50 mod_sql/4.3[2835]: entering mysql cmd_open Okt 19 11:35:50 mod_sql/4.3[2835]: connection 'default' count is now 2 Okt 19 11:35:50 mod_sql/4.3[2835]: exiting mysql cmd_open Okt 19 11:35:50 mod_sql/4.3[2835]: entering mysql cmd_close Okt 19 11:35:50 mod_sql/4.3[2835]: connection 'default' count is now 1 Okt 19 11:35:50 mod_sql/4.3[2835]: exiting mysql cmd_close Okt 19 11:35:50 mod_sql/4.3[2835]: exiting mysql cmd_escapestring Okt 19 11:35:50 mod_sql/4.3[2835]: cache hit for user 'a' Okt 19 11:35:50 mod_sql/4.3[2835]: >>> cmd_check Okt 19 11:35:50 mod_sql/4.3[2835]: checking password using SQLAuthType 'OpenSSL' Okt 19 11:35:50 mod_sql/4.3[2835]: no digest found in password hash Okt 19 11:35:50 mod_sql/4.3[2835]: 'OpenSSL' SQLAuthType handler reports failure Okt 19 11:35:50 mod_sql/4.3[2835]: checking password using SQLAuthType 'Crypt' Okt 19 11:35:50 mod_sql/4.3[2835]: 'Crypt' SQLAuthType handler reports failure Okt 19 11:35:50 mod_sql/4.3[2835]: <<< cmd_check Okt 19 11:35:50 mod_sql/4.3[2835]: <<< cmd_auth Okt 19 11:35:51 mod_sql/4.3[2835]: entering mysql cmd_exit Okt 19 11:35:51 mod_sql/4.3[2835]: entering mysql cmd_close Okt 19 11:35:51 mod_sql/4.3[2835]: connection 'default' closed Okt 19 11:35:51 mod_sql/4.3[2835]: connection 'default' count is now 0 Okt 19 11:35:51 mod_sql/4.3[2835]: exiting mysql cmd_close Okt 19 11:35:51 mod_sql/4.3[2835]: exiting mysql cmd_exit
Meine SQL
-- phpMyAdmin SQL Dump -- version 4.2.10 -- http://www.phpmyadmin.net -- -- Host: localhost -- Erstellungszeit: 19. Okt 2014 um 11:40 -- Server Version: 5.5.38-0+wheezy1 -- PHP-Version: 5.4.4-14+deb7u14 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Datenbank: `ftpd` -- -- -------------------------------------------------------- -- -- Tabellenstruktur für Tabelle `ftpuser` -- CREATE TABLE IF NOT EXISTS `ftpuser` ( `id` int(10) unsigned NOT NULL, `userid` varchar(32) NOT NULL DEFAULT '', `passwd` varchar(32) NOT NULL DEFAULT '', `uid` smallint(6) NOT NULL DEFAULT '5500', `gid` smallint(6) NOT NULL DEFAULT '5500', `homedir` varchar(255) NOT NULL DEFAULT '', `shell` varchar(16) NOT NULL DEFAULT '/sbin/nologin', `count` int(11) NOT NULL DEFAULT '0', `accessed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='ProFTP user table'; -- -- Daten für Tabelle `ftpuser` -- INSERT INTO `ftpuser` (`id`, `userid`, `passwd`, `uid`, `gid`, `homedir`, `shell`, `count`, `accessed`, `modified`) VALUES (1, 'a', 'DMF1ucDxtqgxw5niaXcmYQ==', 5500, 5500, '/home/files', '/sbin/nologin', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); -- -- Indizes der exportierten Tabellen -- -- -- Indizes für die Tabelle `ftpuser` -- ALTER TABLE `ftpuser` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `userid` (`userid`); -- -- AUTO_INCREMENT für exportierte Tabellen -- -- -- AUTO_INCREMENT für Tabelle `ftpuser` -- ALTER TABLE `ftpuser` MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Proftpd log zeit natürlich no such User. der Filezilla 530
Soweit ich das verstehe schaut er ja inder Datenbank nach und findet auch einen User "a". nur sehe ich keinen Grund warum dieser nicht in das System eintreten darf ?