loip104
Goto Top

Proftpd mit mod sql Login nicht möglich

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-w ...

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 . finde leider keine möglichkeit für einen spoiler oder hide inder formatierung.


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 ?

Content-Key: 252422

Url: https://administrator.de/contentid/252422

Ausgedruckt am: 28.03.2024 um 11:03 Uhr

Mitglied: Gersen
Gersen 21.10.2014 um 12:58:14 Uhr
Goto Top
Hallo,

wenn Du nach der Anleitung vorgegangen bist, hast Du auch das Passwort des Nutzers mit MySQL-Mitteln eingetragen/vergeben. In dem Falle müsstest Du
SQLAuthTypes Backend
anstelle des von Dir verwendeten "Crypt" verwenden (Fehlermeldung bei Dir: 'Crypt' SQLAuthType handler reports failure ).

Siehe auch hier.

Gruß,
Gersen