sonicwave3 Posted August 30, 2013 Share Posted August 30, 2013 hallo jungs, ?hnlich dem problem von wild wolf l?sst seit einem update von php5 auf sueeze17 der proftpd keine logins mehr zu im log steht das der user nicht gefunden wird FTP session opened. USER kd18 (Login failed): No such user found. FTP session closed. in der ftp_users tabelle der froxlor datenbank steht dieser aber einwandfrei drin auch alle anderen user... welche sich ebenfalls nicht mehr einloggen k?nnen den tipp von wild wolf die tabelle ftp_users nochmal neu einzuf?gen habe ich durchgef?hrt leider ohne erfolg auch die komplette deinstallation mit anschliessender neuinstallation von proftpd laut diesem thread habe ich schon durchgef?hrt nat?rlich mit der anpassung der configs ?ber foxlors server konfiguration leider auch dies ohne erfolg mir f?llt auch nix mehr ein was es noch sein k?nnte habt ihr noch eine idee? Link to comment Share on other sites More sharing options...
d00p Posted August 30, 2013 Share Posted August 30, 2013 Im Proftp auch mod_sql wirklich aktiviert? Mysql-Verbindungsdaten stimmen 100%? Mehr f?llt mir da nicht ein. Das geht eigentlich immer problemlos Link to comment Share on other sites More sharing options...
sonicwave3 Posted August 30, 2013 Author Share Posted August 30, 2013 modules.conf # Install proftpd-mod-mysql or proftpd-mod-pgsql to use this LoadModule mod_sql.c die mysql zugangsdaten stimmen 100% gerade nochmal die sql.conf aus einem backup von letzter woche eingespielt und restartet ohne erfolg, leider immernoch no such user Link to comment Share on other sites More sharing options...
Sephiroth Posted August 30, 2013 Share Posted August 30, 2013 Okay einmal bitte Ausgabe folgender Befehle: proftpd -V proftpd -vv proftpd -l proftpd -td10 Weiterf?hrend kannst du mal die Debuginfos aktivieren f?r den Login. Das machst du indem du den Proftpd stoppst und dann manuell proftpd so startest: proftpd -nd10 Dann versuch dich einzuloggen und poste das Ergebnis hier. Achso und nat?rlich bitte deine komplette Konfiguration des Proftpd - ohne das SQL-Passwort nat?rlich. Link to comment Share on other sites More sharing options...
sonicwave3 Posted August 30, 2013 Author Share Posted August 30, 2013 proftpd -V Compile-time Settings: Version: 1.3.3a (maint) Platform: LINUX [Linux 3.0.68 x86_64] Built: Tue Jan 8 2013 14:41:26 UTC Built With: configure '--prefix=/usr' '--with-includes=/usr/include/postgresql:/usr/include/mysql' '--mandir=/usr/share/man' '--sysconfdir=/etc/proftpd' '--localstatedir=/var/run' '--libexecdir=/usr/lib/proftpd' '--enable-sendfile' '--enable-facl' '--enable-dso' '--enable-autoshadow' '--enable-ctrls' '--with-modules=mod_readme' '--enable-ipv6' '--enable-nls' '--build' 'x86_64-linux-gnu' '--with-shared=mod_unique_id:mod_site_misc:mod_load:mod_ban:mod_quotatab:mod_sql:mod_sql_mysql:mod_sql_postgres:mod_sql_sqlite:mod_sql_odbc:mod_dynmasq:mod_quotatab_sql:mod_ldap:mod_quotatab_ldap:mod_ratio:mod_tls:mod_rewrite:mod_radius:mod_wrap:mod_wrap2:mod_wrap2_file:mod_wrap2_sql:mod_quotatab_file:mod_quotatab_radius:mod_facl:mod_ctrls_admin:mod_vroot:mod_exec:mod_sftp:mod_sftp_pam:mod_sftp_sql:mod_shaper:mod_sql_passwd:mod_ifsession' 'build_alias=x86_64-linux-gnu' 'CFLAGS=-O2 -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -DHAVE_OPENSSL -DUSE_LDAP_TLS ' 'LDFLAGS=' 'CPPFLAGS=' CFLAGS: -O2 -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -DHAVE_OPENSSL -DUSE_LDAP_TLS -Wall LDFLAGS: -L$(top_srcdir)/lib LIBS: -lacl -lssl -lcrypto -lcap -lpam -lsupp -lcrypt -ldl -ldl -lz Files: Configuration File: /etc/proftpd/proftpd.conf Pid File: /var/run/proftpd.pid Scoreboard File: /var/run/proftpd.scoreboard Header Directory: /usr/include/proftpd Shared Module Directory: /usr/lib/proftpd Features: + Autoshadow support + Controls support + curses support - Developer support + DSO support + IPv6 support + Largefile support - Lastlog support + ncurses support + NLS support + OpenSSL support + POSIX ACL support + Shadow file support + Sendfile support + Trace support Tunable Options: PR_TUNABLE_BUFFER_SIZE = 1024 PR_TUNABLE_GLOBBING_MAX_MATCHES = 100000 PR_TUNABLE_GLOBBING_MAX_RECURSION = 8 PR_TUNABLE_HASH_TABLE_SIZE = 40 PR_TUNABLE_NEW_POOL_SIZE = 512 PR_TUNABLE_SCOREBOARD_BUFFER_SIZE = 80 PR_TUNABLE_SCOREBOARD_SCRUB_TIMER = 30 PR_TUNABLE_SELECT_TIMEOUT = 30 PR_TUNABLE_TIMEOUTIDENT = 10 PR_TUNABLE_TIMEOUTIDLE = 600 PR_TUNABLE_TIMEOUTLINGER = 30 PR_TUNABLE_TIMEOUTLOGIN = 300 PR_TUNABLE_TIMEOUTNOXFER = 300 PR_TUNABLE_TIMEOUTSTALLED = 3600 PR_TUNABLE_XFER_SCOREBOARD_UPDATES = 10 proftpd -vv ProFTPD Version: 1.3.3a (maint) Scoreboard Version: 01040003 Built: Tue Jan 8 2013 14:41:26 UTC Loaded modules: mod_ifsession/1.0 mod_dynmasq/0.3 mod_wrap2_file/1.2 mod_wrap2/2.0.6 mod_ban/0.5.5 mod_load/1.0.1 mod_rewrite/0.8 mod_wrap/1.2.3 mod_quotatab_radius.c mod_quotatab_sql.c mod_quotatab_file.c mod_quotatab/1.3.0 mod_sql_mysql/4.0.8 mod_sql/4.2.5 mod_tls/2.4.2 mod_ctrls_admin/0.9.6 mod_lang/0.9 mod_ctrls/0.9.4 mod_cap/1.0 mod_readme.c mod_auth_pam/1.1 mod_ident/1.0 mod_dso/0.5 mod_facts/0.1 mod_delay/0.6 mod_site.c mod_log.c mod_ls.c mod_auth.c mod_auth_file/0.8.3 mod_auth_unix.c mod_xfer.c mod_core.c proftpd -l Compiled-in modules: mod_core.c mod_xfer.c mod_auth_unix.c mod_auth_file.c mod_auth.c mod_ls.c mod_log.c mod_site.c mod_delay.c mod_facts.c mod_dso.c mod_ident.c mod_auth_pam.c mod_readme.c mod_cap.c mod_ctrls.c mod_lang.c proftpd -td10 Checking syntax of configuration file - using TCP receive buffer size of 87380 bytes - using TCP send buffer size of 16384 bytes - testing Unix domain socket using S_ISFIFO - testing Unix domain socket using S_ISSOCK - using S_ISSOCK macro for Unix domain socket detection - ROOT PRIVS at mod_core.c:304 - loading 'mod_ctrls_admin.c' - loading 'mod_tls.c' - mod_tls/2.4.2: using OpenSSL 0.9.8o 01 Jun 2010 - loading 'mod_sql.c' - loading 'mod_sql_mysql.c' - loading 'mod_quotatab.c' - loading 'mod_quotatab_file.c' - loading 'mod_quotatab_sql.c' - loading 'mod_quotatab_radius.c' - loading 'mod_wrap.c' - loading 'mod_rewrite.c' - loading 'mod_load.c' - loading 'mod_ban.c' - loading 'mod_wrap2.c' - loading 'mod_wrap2_file.c' - loading 'mod_dynmasq.c' - loading 'mod_ifsession.c' - RELINQUISH PRIVS at mod_core.c:326 - DenyFilter: compiling regex '\*.*/' - <IfModule>: using 'mod_dynmasq.c' section at line 52 - retrieved UID 105 for user 'proftpd' - retrieved GID 65534 for group 'nogroup' - ROOT PRIVS at mod_log.c:537 - RELINQUISH PRIVS at mod_log.c:542 - <IfModule>: using 'mod_quotatab.c' section at line 93 - <IfModule>: skipping 'mod_ratio.c' section at line 97 - <IfModule>: using 'mod_delay.c' section at line 105 - <IfModule>: using 'mod_ctrls.c' section at line 109 - ROOT PRIVS at mod_ctrls.c:110 - RELINQUISH PRIVS at mod_ctrls.c:112 - <IfModule>: using 'mod_ctrls_admin.c' section at line 117 - ROOT PRIVS at mod_core.c:304 - <IfModule>: using 'mod_sql.c' section at line 2 - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness (das sieht mir) - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness (komisch aus) - RELINQUISH PRIVS at mod_core.c:326 v3-1364.vxen.de - v3-1364.vxen.de - Config for v3-1364.vxen.de FTP Server: v3-1364.vxen.de - DeferWelcome v3-1364.vxen.de - DefaultServer v3-1364.vxen.de - ShowSymlinks v3-1364.vxen.de - TimeoutNoTransfer v3-1364.vxen.de - TimeoutStalled v3-1364.vxen.de - TimeoutIdle v3-1364.vxen.de - DisplayLogin v3-1364.vxen.de - DisplayChdir v3-1364.vxen.de - ListOptions v3-1364.vxen.de - DenyFilter v3-1364.vxen.de - UserID v3-1364.vxen.de - UserName v3-1364.vxen.de - GroupID v3-1364.vxen.de - GroupName v3-1364.vxen.de - Umask v3-1364.vxen.de - DirUmask v3-1364.vxen.de - AllowOverwrite v3-1364.vxen.de - TransferLog v3-1364.vxen.de - AllowRetrieveRestart v3-1364.vxen.de - AllowStoreRestart v3-1364.vxen.de - QuotaEngine v3-1364.vxen.de - DelayEngine v3-1364.vxen.de - DefaultRoot v3-1364.vxen.de - RequireValidShell v3-1364.vxen.de - AuthOrder v3-1364.vxen.de - SQLBackend v3-1364.vxen.de - SQLEngine v3-1364.vxen.de - SQLAuthenticate v3-1364.vxen.de - SQLAuthTypes v3-1364.vxen.de - SQLAuthenticate v3-1364.vxen.de - SQLConnectInfo v3-1364.vxen.de - SQLUserTable v3-1364.vxen.de - SQLUsernameField v3-1364.vxen.de - SQLPasswordField v3-1364.vxen.de - SQLUidField v3-1364.vxen.de - SQLGidField v3-1364.vxen.de - SQLHomedirField v3-1364.vxen.de - SQLShellField v3-1364.vxen.de - SQLGroupTable v3-1364.vxen.de - SQLGroupnameField v3-1364.vxen.de - SQLGroupGIDField v3-1364.vxen.de - SQLGroupMembersField v3-1364.vxen.de - SQLUserWhereClause v3-1364.vxen.de - SQLLog_PASS v3-1364.vxen.de - SQLNamedQuery_login v3-1364.vxen.de - SQLLog_RETR v3-1364.vxen.de - SQLNamedQuery_download v3-1364.vxen.de - SQLLog_STOR v3-1364.vxen.de - SQLNamedQuery_upload v3-1364.vxen.de - mod_lang/0.9: binding to text domain 'proftpd' using locale path '/usr/share/locale' v3-1364.vxen.de - mod_lang/0.9: using locale files in '/usr/share/locale' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'it': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'zh_CN': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'ja_JP': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'ru': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'bg_BG': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'zh_TW': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'fr_FR': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'ko_KR': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: added the following supported languages: en_US.UTF-8, en_US Syntax check complete. und der restart mit debug-log - using TCP receive buffer size of 87380 bytes - using TCP send buffer size of 16384 bytes - testing Unix domain socket using S_ISFIFO - testing Unix domain socket using S_ISSOCK - using S_ISSOCK macro for Unix domain socket detection - ROOT PRIVS at mod_core.c:304 - loading 'mod_ctrls_admin.c' - loading 'mod_tls.c' - mod_tls/2.4.2: using OpenSSL 0.9.8o 01 Jun 2010 - loading 'mod_sql.c' - loading 'mod_sql_mysql.c' - loading 'mod_quotatab.c' - loading 'mod_quotatab_file.c' - loading 'mod_quotatab_sql.c' - loading 'mod_quotatab_radius.c' - loading 'mod_wrap.c' - loading 'mod_rewrite.c' - loading 'mod_load.c' - loading 'mod_ban.c' - loading 'mod_wrap2.c' - loading 'mod_wrap2_file.c' - loading 'mod_dynmasq.c' - loading 'mod_ifsession.c' - RELINQUISH PRIVS at mod_core.c:326 - DenyFilter: compiling regex '\*.*/' - <IfModule>: using 'mod_dynmasq.c' section at line 52 - retrieved UID 105 for user 'proftpd' - retrieved GID 65534 for group 'nogroup' - ROOT PRIVS at mod_log.c:537 - RELINQUISH PRIVS at mod_log.c:542 - <IfModule>: using 'mod_quotatab.c' section at line 93 - <IfModule>: skipping 'mod_ratio.c' section at line 97 - <IfModule>: using 'mod_delay.c' section at line 105 - <IfModule>: using 'mod_ctrls.c' section at line 109 - ROOT PRIVS at mod_ctrls.c:110 - RELINQUISH PRIVS at mod_ctrls.c:112 - <IfModule>: using 'mod_ctrls_admin.c' section at line 117 - ROOT PRIVS at mod_core.c:304 - <IfModule>: using 'mod_sql.c' section at line 2 - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness - RELINQUISH PRIVS at mod_core.c:326 v3-1364.vxen.de - v3-1364.vxen.de - Config for v3-1364.vxen.de FTP Server: v3-1364.vxen.de - DeferWelcome v3-1364.vxen.de - DefaultServer v3-1364.vxen.de - ShowSymlinks v3-1364.vxen.de - TimeoutNoTransfer v3-1364.vxen.de - TimeoutStalled v3-1364.vxen.de - TimeoutIdle v3-1364.vxen.de - DisplayLogin v3-1364.vxen.de - DisplayChdir v3-1364.vxen.de - ListOptions v3-1364.vxen.de - DenyFilter v3-1364.vxen.de - UserID v3-1364.vxen.de - UserName v3-1364.vxen.de - GroupID v3-1364.vxen.de - GroupName v3-1364.vxen.de - Umask v3-1364.vxen.de - DirUmask v3-1364.vxen.de - AllowOverwrite v3-1364.vxen.de - TransferLog v3-1364.vxen.de - AllowRetrieveRestart v3-1364.vxen.de - AllowStoreRestart v3-1364.vxen.de - QuotaEngine v3-1364.vxen.de - DelayEngine v3-1364.vxen.de - DefaultRoot v3-1364.vxen.de - RequireValidShell v3-1364.vxen.de - AuthOrder v3-1364.vxen.de - SQLBackend v3-1364.vxen.de - SQLEngine v3-1364.vxen.de - SQLAuthenticate v3-1364.vxen.de - SQLAuthTypes v3-1364.vxen.de - SQLAuthenticate v3-1364.vxen.de - SQLConnectInfo v3-1364.vxen.de - SQLUserTable v3-1364.vxen.de - SQLUsernameField v3-1364.vxen.de - SQLPasswordField v3-1364.vxen.de - SQLUidField v3-1364.vxen.de - SQLGidField v3-1364.vxen.de - SQLHomedirField v3-1364.vxen.de - SQLShellField v3-1364.vxen.de - SQLGroupTable v3-1364.vxen.de - SQLGroupnameField v3-1364.vxen.de - SQLGroupGIDField v3-1364.vxen.de - SQLGroupMembersField v3-1364.vxen.de - SQLUserWhereClause v3-1364.vxen.de - SQLLog_PASS v3-1364.vxen.de - SQLNamedQuery_login v3-1364.vxen.de - SQLLog_RETR v3-1364.vxen.de - SQLNamedQuery_download v3-1364.vxen.de - SQLLog_STOR v3-1364.vxen.de - SQLNamedQuery_upload v3-1364.vxen.de - mod_lang/0.9: binding to text domain 'proftpd' using locale path '/usr/share/locale' v3-1364.vxen.de - mod_lang/0.9: using locale files in '/usr/share/locale' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'it': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'zh_CN': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'ja_JP': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'ru': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'bg_BG': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'zh_TW': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'fr_FR': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'ko_KR': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: added the following supported languages: en_US.UTF-8, en_US v3-1364.vxen.de - retrieved group ID: 65534 v3-1364.vxen.de - setting group ID: 65534 v3-1364.vxen.de - SETUP PRIVS at main.c:3134 v3-1364.vxen.de - ROOT PRIVS at main.c:2158 v3-1364.vxen.de - RELINQUISH PRIVS at main.c:2165 v3-1364.vxen.de - ROOT PRIVS at main.c:2493 v3-1364.vxen.de - opening scoreboard '/var/run/proftpd.scoreboard' v3-1364.vxen.de - RELINQUISH PRIVS at main.c:2519 v3-1364.vxen.de - ROOT PRIVS at mod_ctrls_admin.c:1180 v3-1364.vxen.de - opening scoreboard '/var/run/proftpd.scoreboard' v3-1364.vxen.de - RELINQUISH PRIVS at mod_ctrls_admin.c:1182 v3-1364.vxen.de - ROOT PRIVS at inet.c:348 v3-1364.vxen.de - RELINQUISH PRIVS at inet.c:411 v3-1364.vxen.de - ProFTPD 1.3.3a (maint) (built Tue Jan 8 2013 14:41:26 UTC) standalone mode STARTUP v3-1364.vxen.de - ROOT PRIVS at pidfile.c:48 v3-1364.vxen.de - RELINQUISH PRIVS at pidfile.c:50 v3-1364.vxen.de - scrubbing scoreboard v3-1364.vxen.de - ROOT PRIVS at scoreboard.c:1077 v3-1364.vxen.de - RELINQUISH PRIVS at scoreboard.c:1079 v3-1364.vxen.de - ROOT PRIVS at scoreboard.c:1117 v3-1364.vxen.de - RELINQUISH PRIVS at scoreboard.c:1151 v3-1364.vxen.de - ROOT PRIVS at main.c:1245 v3-1364.vxen.de - RELINQUISH PRIVS at main.c:1249 v3-1364.vxen.de - no matching vhost found for ::ffff:79.140.42.108#21, using 'v3-1364.vxen.de FTP Server' listening on wildcard address v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - ROOT PRIVS at main.c:1093 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - SETUP PRIVS at main.c:1098 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - session requested from client in unknown class v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - performing module session initializations v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - ROOT PRIVS at mod_quotatab.c:3555 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - RELINQUISH PRIVS at mod_quotatab.c:3557 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - ROOT PRIVS at mod_quotatab.c:3571 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - RELINQUISH PRIVS at mod_quotatab.c:3573 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - mod_sql/4.2.5: defaulting to 'mysql' backend v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - mod_cap/1.0: adding CAP_AUDIT_WRITE capability v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - mod_ident/1.0: ident lookup disabled v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - ROOT PRIVS at mod_auth.c:133 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - opening scoreboard '/var/run/proftpd.scoreboard' v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - RELINQUISH PRIVS at mod_auth.c:135 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - AuthOrder in effect, resetting auth module order v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - connected - local : ::ffff:79.140.42.108:21 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - connected - remote : ::ffff:93.217.200.18:55150 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - FTP session opened. v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'USER web1' to mod_rewrite v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'USER web1' to mod_tls v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'USER web1' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'USER web1' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'USER web1' to mod_delay v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'USER web1' to mod_auth v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching CMD command 'USER web1' to mod_auth v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching POST_CMD command 'USER web1' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching POST_CMD command 'USER web1' to mod_delay v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD command 'USER web1' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD command 'USER web1' to mod_log v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_tls v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap2 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_ban v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching CMD command 'PASS (hidden)' to mod_auth v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - retrieved UID 10000 for user 'web1' v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - retrieved group IDs: 10000, 10000 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - retrieved group names: web1, web1 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - USER web1 (Login failed): No such user found. v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_wrap2 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_delay v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'QUIT' to mod_rewrite v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'QUIT' to mod_tls v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'QUIT' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'QUIT' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching CMD command 'QUIT' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching POST_CMD command 'QUIT' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD command 'QUIT' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD command 'QUIT' to mod_log v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD command 'QUIT' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - FTP session closed. Link to comment Share on other sites More sharing options...
sonicwave3 Posted August 30, 2013 Author Share Posted August 30, 2013 sql.conf (copy & paste aus dem froxlor server konfigurations modul) <IfModule mod_sql.c> DefaultRoot ~ RequireValidShell off AuthOrder mod_sql.c SQLBackend mysql SQLEngine on SQLAuthenticate on SQLAuthTypes Crypt SQLAuthenticate users* groups* SQLConnectInfo froxlor@localhost froxlor MYSQL_PASSWORD SQLUserInfo ftp_users username password uid gid homedir shell SQLGroupInfo ftp_groups groupname gid members SQLUserWhereClause "login_enabled = 'y'" SQLLog PASS login SQLNamedQuery login UPDATE "last_login=now(), login_count=login_count+1 WHERE username='%u'" ftp_users SQLLog RETR download SQLNamedQuery download UPDATE "down_count=down_count+1, down_bytes=down_bytes+%b WHERE username='%u'" ftp_users SQLLog STOR upload SQLNamedQuery upload UPDATE "up_count=up_count+1, up_bytes=up_bytes+%b WHERE username='%u'" ftp_users QuotaEngine on QuotaShowQuotas on QuotaDisplayUnits Mb QuotaLock /var/lock/ftpd.quotatab.lock QuotaLimitTable sql:/get-quota-limit QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally SQLNamedQuery get-quota-limit SELECT "ftp_users.username AS name, ftp_quotalimits.quota_type, ftp_quotalimits.per_session, ftp_quotalimits.limit_type, panel_customers.diskspace*1024 AS bytes_in_avail, ftp_quotalimits.bytes_out_avail, ftp_quotalimits.bytes_xfer_avail, ftp_quotalimits.files_in_avail, ftp_quotalimits.files_out_avail, ftp_quotalimits.files_xfer_avail FROM ftp_users, ftp_quotalimits, panel_customers WHERE ftp_users.username = '%{0}' AND panel_customers.loginname = SUBSTRING_INDEX('%{0}', 'ftp', 1) AND quota_type ='%{1}'" SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used,bytes_out_used, bytes_xfer_used, files_in_used, files_out_used,files_xfer_used FROM ftp_quotatallies WHERE name = '%{0}' AND quota_type = '%{1}'" SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used= files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name= '%{6}' AND quota_type = '%{7}'" ftp_quotatallies SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4},%{5}, %{6}, %{7}" ftp_quotatallies </IfModule> modules.conf (ebenfalls) # Allow only user root to load and unload modules, but allow everyone # to see which modules have been loaded ModuleControlsACLs insmod,rmmod allow user root ModuleControlsACLs lsmod allow user * LoadModule mod_ctrls_admin.c LoadModule mod_tls.c # Install proftpd-mod-mysql or proftpd-mod-pgsql to use this LoadModule mod_sql.c # Install proftpd-mod-ldap to use this #LoadModule mod_ldap.c # # 'SQLBackend mysql' or 'SQLBackend postgres' directives are required # to have SQL authorization working. You can also comment out the # unused module here, in alternative. # # Install proftpd-mod-mysql to use this LoadModule mod_sql_mysql.c # Install proftpd-mod-pgsql to use this #LoadModule mod_sql_postgres.c #LoadModule mod_radius.c LoadModule mod_quotatab.c LoadModule mod_quotatab_file.c # Install proftpd-mod-ldap to use this #LoadModule mod_quotatab_ldap.c # Install proftpd-mod-pgsql or proftpd-mod-mysql to use this LoadModule mod_quotatab_sql.c LoadModule mod_quotatab_radius.c LoadModule mod_wrap.c LoadModule mod_rewrite.c LoadModule mod_load.c LoadModule mod_ban.c LoadModule mod_wrap2.c LoadModule mod_wrap2_file.c # Install proftpd-mod-pgsql or proftpd-mod-mysql to use this #LoadModule mod_wrap2_sql.c LoadModule mod_dynmasq.c # keep this module the last one LoadModule mod_ifsession.c proftpd.conf (ebenfalls) # # /etc/proftpd/proftpd.conf -- This is a basic ProFTPD configuration file. # To really apply changes reload proftpd after modifications. # # Includes DSO modules Include /etc/proftpd/modules.conf # Set off to disable IPv6 support which is annoying on IPv4 only boxes. UseIPv6 on ServerName "v3-1364.vxen.de FTP Server" ServerType standalone DeferWelcome off MultilineRFC2228 on DefaultServer on ShowSymlinks on TimeoutNoTransfer 600 TimeoutStalled 600 TimeoutIdle 1200 DisplayLogin welcome.msg DisplayChdir .message true ListOptions "-l" DenyFilter \*.*/ # Use this to jail all users in their homes # DefaultRoot ~ # Users require a valid shell listed in /etc/shells to login. # Use this directive to release that constrain. # RequireValidShell off # Port 21 is the standard FTP port. Port 21 # In some cases you have to specify passive ports range to by-pass # firewall limitations. Ephemeral ports can be used for that, but # feel free to use a more narrow range. # PassivePorts 49152 65534 # If your host was NATted, this option is useful in order to # allow passive tranfers to work. You have to use your public # address and opening the passive ports used on your firewall as well. # MasqueradeAddress 1.2.3.4 # This is useful for masquerading address with dynamic IPs: # refresh any configured MasqueradeAddress directives every 8 hours <IfModule mod_dynmasq.c> # DynMasqRefresh 28800 </IfModule> # To prevent DoS attacks, set the maximum number of child processes # to 30. If you need to allow more than 30 concurrent connections # at once, simply increase this value. Note that this ONLY works # in standalone mode, in inetd mode you should use an inetd server # that allows you to limit maximum number of processes per service # (such as xinetd) MaxInstances 30 # Set the user and group that the server normally runs at. User proftpd Group nogroup # Umask 022 is a good standard umask to prevent new files and dirs # (second parm) from being group and world writable. Umask 022 022 # Normally, we want files to be overwriteable. AllowOverwrite on # Uncomment this if you are using NIS or LDAP via NSS to retrieve passwords: # PersistentPasswd off # This is required to use both PAM-based authentication and local passwords # AuthOrder mod_auth_pam.c* mod_auth_unix.c # Be warned: use of this directive impacts CPU average load! # Uncomment this if you like to see progress and transfer rate with ftpwho # in downloads. That is not needed for uploads rates. # # UseSendFile off TransferLog /var/log/proftpd/xferlog SystemLog /var/log/proftpd/proftpd.log # Allow up- and downloads to be continued AllowRetrieveRestart On AllowStoreRestart On <IfModule mod_quotatab.c> QuotaEngine on </IfModule> <IfModule mod_ratio.c> Ratios off </IfModule> # Delay engine reduces impact of the so-called Timing Attack described in # http://security.lss.hr/index.php?page=details&ID=LSS-2004-10-02 # It is on by default. <IfModule mod_delay.c> DelayEngine off </IfModule> <IfModule mod_ctrls.c> ControlsEngine off ControlsMaxClients 2 ControlsLog /var/log/proftpd/controls.log ControlsInterval 5 ControlsSocket /var/run/proftpd/proftpd.sock </IfModule> <IfModule mod_ctrls_admin.c> AdminControlsEngine off </IfModule> # # Alternative authentication frameworks # #Include /etc/proftpd/ldap.conf Include /etc/proftpd/sql.conf # # This is used for FTPS connections # #Include /etc/proftpd/tls.conf jungs... vorab schonmal einen riesen dank das ihr so hinterher seid! hut ab! Link to comment Share on other sites More sharing options...
d00p Posted August 30, 2013 Share Posted August 30, 2013 Okay, versuch mal folgende ?nderungen in der sql.conf - SQLAuthenticate users* groups* + AuthOrder mod_sql.c + SQLAuthenticate users groups Link to comment Share on other sites More sharing options...
sonicwave3 Posted August 30, 2013 Author Share Posted August 30, 2013 #SQLAuthenticate users* groups* SQLAuthenticate users groups AuthOrder mod_sql.c - steht schon in zeile 4 der sql.conf proftpd -td10 Checking syntax of configuration file - using TCP receive buffer size of 87380 bytes - using TCP send buffer size of 16384 bytes - testing Unix domain socket using S_ISFIFO - testing Unix domain socket using S_ISSOCK - using S_ISSOCK macro for Unix domain socket detection - ROOT PRIVS at mod_core.c:304 - loading 'mod_ctrls_admin.c' - loading 'mod_tls.c' - mod_tls/2.4.2: using OpenSSL 0.9.8o 01 Jun 2010 - loading 'mod_sql.c' - loading 'mod_sql_mysql.c' - loading 'mod_quotatab.c' - loading 'mod_quotatab_file.c' - loading 'mod_quotatab_sql.c' - loading 'mod_quotatab_radius.c' - loading 'mod_wrap.c' - loading 'mod_rewrite.c' - loading 'mod_load.c' - loading 'mod_ban.c' - loading 'mod_wrap2.c' - loading 'mod_wrap2_file.c' - loading 'mod_dynmasq.c' - loading 'mod_ifsession.c' - RELINQUISH PRIVS at mod_core.c:326 - DenyFilter: compiling regex '\*.*/' - retrieved UID 105 for user 'proftpd' - retrieved GID 65534 for group 'nogroup' - ROOT PRIVS at mod_log.c:537 - RELINQUISH PRIVS at mod_log.c:542 - <IfModule>: using 'mod_quotatab.c' section at line 38 - <IfModule>: skipping 'mod_ratio.c' section at line 41 - <IfModule>: using 'mod_ctrls.c' section at line 47 - ROOT PRIVS at mod_ctrls.c:110 - RELINQUISH PRIVS at mod_ctrls.c:112 - <IfModule>: using 'mod_ctrls_admin.c' section at line 55 - ROOT PRIVS at mod_core.c:304 - <IfModule>: using 'mod_sql.c' section at line 2 - RELINQUISH PRIVS at mod_core.c:326 v3-1364.vxen.de - v3-1364.vxen.de - Config for v3-1364.vxen.de FTP Server: v3-1364.vxen.de - IdentLookups v3-1364.vxen.de - DeferWelcome v3-1364.vxen.de - DefaultServer v3-1364.vxen.de - ShowSymlinks v3-1364.vxen.de - AllowOverwrite v3-1364.vxen.de - TimeoutNoTransfer v3-1364.vxen.de - TimeoutStalled v3-1364.vxen.de - TimeoutIdle v3-1364.vxen.de - DisplayLogin v3-1364.vxen.de - ListOptions v3-1364.vxen.de - DenyFilter v3-1364.vxen.de - UserID v3-1364.vxen.de - UserName v3-1364.vxen.de - GroupID v3-1364.vxen.de - GroupName v3-1364.vxen.de - Umask v3-1364.vxen.de - DirUmask v3-1364.vxen.de - TransferLog v3-1364.vxen.de - QuotaEngine v3-1364.vxen.de - DelayEngine v3-1364.vxen.de - DefaultRoot v3-1364.vxen.de - RequireValidShell v3-1364.vxen.de - AuthOrder v3-1364.vxen.de - SQLBackend v3-1364.vxen.de - SQLEngine v3-1364.vxen.de - SQLAuthenticate v3-1364.vxen.de - SQLAuthTypes v3-1364.vxen.de - SQLAuthenticate v3-1364.vxen.de - SQLConnectInfo v3-1364.vxen.de - SQLUserTable v3-1364.vxen.de - SQLUsernameField v3-1364.vxen.de - SQLPasswordField v3-1364.vxen.de - SQLUidField v3-1364.vxen.de - SQLGidField v3-1364.vxen.de - SQLHomedirField v3-1364.vxen.de - SQLShellField v3-1364.vxen.de - SQLGroupTable v3-1364.vxen.de - SQLGroupnameField v3-1364.vxen.de - SQLGroupGIDField v3-1364.vxen.de - SQLGroupMembersField v3-1364.vxen.de - SQLUserWhereClause v3-1364.vxen.de - SQLLog_PASS v3-1364.vxen.de - SQLNamedQuery_login v3-1364.vxen.de - SQLLog_RETR v3-1364.vxen.de - SQLNamedQuery_download v3-1364.vxen.de - SQLLog_STOR v3-1364.vxen.de - SQLNamedQuery_upload v3-1364.vxen.de - mod_lang/0.9: binding to text domain 'proftpd' using locale path '/usr/share/locale' v3-1364.vxen.de - mod_lang/0.9: using locale files in '/usr/share/locale' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'it': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'zh_CN': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'ja_JP': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'ru': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'bg_BG': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'zh_TW': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'fr_FR': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'ko_KR': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: added the following supported languages: en_US.UTF-8, en_US Syntax check complete. zumindest scheint der eine fehler nicht mehr aufzutreten - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness und nochmal der restart mit debug-log - using TCP receive buffer size of 87380 bytes - using TCP send buffer size of 16384 bytes - testing Unix domain socket using S_ISFIFO - testing Unix domain socket using S_ISSOCK - using S_ISSOCK macro for Unix domain socket detection - ROOT PRIVS at mod_core.c:304 - loading 'mod_ctrls_admin.c' - loading 'mod_tls.c' - mod_tls/2.4.2: using OpenSSL 0.9.8o 01 Jun 2010 - loading 'mod_sql.c' - loading 'mod_sql_mysql.c' - loading 'mod_quotatab.c' - loading 'mod_quotatab_file.c' - loading 'mod_quotatab_sql.c' - loading 'mod_quotatab_radius.c' - loading 'mod_wrap.c' - loading 'mod_rewrite.c' - loading 'mod_load.c' - loading 'mod_ban.c' - loading 'mod_wrap2.c' - loading 'mod_wrap2_file.c' - loading 'mod_dynmasq.c' - loading 'mod_ifsession.c' - RELINQUISH PRIVS at mod_core.c:326 - DenyFilter: compiling regex '\*.*/' - retrieved UID 105 for user 'proftpd' - retrieved GID 65534 for group 'nogroup' - ROOT PRIVS at mod_log.c:537 - RELINQUISH PRIVS at mod_log.c:542 - <IfModule>: using 'mod_quotatab.c' section at line 38 - <IfModule>: skipping 'mod_ratio.c' section at line 41 - <IfModule>: using 'mod_ctrls.c' section at line 47 - ROOT PRIVS at mod_ctrls.c:110 - RELINQUISH PRIVS at mod_ctrls.c:112 - <IfModule>: using 'mod_ctrls_admin.c' section at line 55 - ROOT PRIVS at mod_core.c:304 - <IfModule>: using 'mod_sql.c' section at line 2 - RELINQUISH PRIVS at mod_core.c:326 v3-1364.vxen.de - v3-1364.vxen.de - Config for v3-1364.vxen.de FTP Server: v3-1364.vxen.de - IdentLookups v3-1364.vxen.de - DeferWelcome v3-1364.vxen.de - DefaultServer v3-1364.vxen.de - ShowSymlinks v3-1364.vxen.de - AllowOverwrite v3-1364.vxen.de - TimeoutNoTransfer v3-1364.vxen.de - TimeoutStalled v3-1364.vxen.de - TimeoutIdle v3-1364.vxen.de - DisplayLogin v3-1364.vxen.de - ListOptions v3-1364.vxen.de - DenyFilter v3-1364.vxen.de - UserID v3-1364.vxen.de - UserName v3-1364.vxen.de - GroupID v3-1364.vxen.de - GroupName v3-1364.vxen.de - Umask v3-1364.vxen.de - DirUmask v3-1364.vxen.de - TransferLog v3-1364.vxen.de - QuotaEngine v3-1364.vxen.de - DelayEngine v3-1364.vxen.de - DefaultRoot v3-1364.vxen.de - RequireValidShell v3-1364.vxen.de - AuthOrder v3-1364.vxen.de - SQLBackend v3-1364.vxen.de - SQLEngine v3-1364.vxen.de - SQLAuthenticate v3-1364.vxen.de - SQLAuthTypes v3-1364.vxen.de - SQLAuthenticate v3-1364.vxen.de - SQLConnectInfo v3-1364.vxen.de - SQLUserTable v3-1364.vxen.de - SQLUsernameField v3-1364.vxen.de - SQLPasswordField v3-1364.vxen.de - SQLUidField v3-1364.vxen.de - SQLGidField v3-1364.vxen.de - SQLHomedirField v3-1364.vxen.de - SQLShellField v3-1364.vxen.de - SQLGroupTable v3-1364.vxen.de - SQLGroupnameField v3-1364.vxen.de - SQLGroupGIDField v3-1364.vxen.de - SQLGroupMembersField v3-1364.vxen.de - SQLUserWhereClause v3-1364.vxen.de - SQLLog_PASS v3-1364.vxen.de - SQLNamedQuery_login v3-1364.vxen.de - SQLLog_RETR v3-1364.vxen.de - SQLNamedQuery_download v3-1364.vxen.de - SQLLog_STOR v3-1364.vxen.de - SQLNamedQuery_upload v3-1364.vxen.de - mod_lang/0.9: binding to text domain 'proftpd' using locale path '/usr/share/locale' v3-1364.vxen.de - mod_lang/0.9: using locale files in '/usr/share/locale' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'it': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'zh_CN': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'ja_JP': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'ru': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'bg_BG': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'zh_TW': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'fr_FR': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: skipping possible language 'ko_KR': not supported by setlocale(3); see `locale -a' v3-1364.vxen.de - mod_lang/0.9: added the following supported languages: en_US.UTF-8, en_US v3-1364.vxen.de - retrieved group ID: 65534 v3-1364.vxen.de - setting group ID: 65534 v3-1364.vxen.de - SETUP PRIVS at main.c:3134 v3-1364.vxen.de - ROOT PRIVS at main.c:2158 v3-1364.vxen.de - RELINQUISH PRIVS at main.c:2165 v3-1364.vxen.de - ROOT PRIVS at main.c:2493 v3-1364.vxen.de - opening scoreboard '/var/run/proftpd.scoreboard' v3-1364.vxen.de - RELINQUISH PRIVS at main.c:2519 v3-1364.vxen.de - ROOT PRIVS at mod_ctrls_admin.c:1180 v3-1364.vxen.de - opening scoreboard '/var/run/proftpd.scoreboard' v3-1364.vxen.de - RELINQUISH PRIVS at mod_ctrls_admin.c:1182 v3-1364.vxen.de - ROOT PRIVS at inet.c:348 v3-1364.vxen.de - RELINQUISH PRIVS at inet.c:411 v3-1364.vxen.de - ProFTPD 1.3.3a (maint) (built Tue Jan 8 2013 14:41:26 UTC) standalone mode STARTUP v3-1364.vxen.de - ROOT PRIVS at pidfile.c:48 v3-1364.vxen.de - RELINQUISH PRIVS at pidfile.c:50 v3-1364.vxen.de - ROOT PRIVS at main.c:1245 v3-1364.vxen.de - RELINQUISH PRIVS at main.c:1249 v3-1364.vxen.de - no matching vhost found for ::ffff:79.140.42.108#21, using 'v3-1364.vxen.de FTP Server' listening on wildcard address v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - ROOT PRIVS at main.c:1093 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - SETUP PRIVS at main.c:1098 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - session requested from client in unknown class v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - performing module session initializations v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - mod_sql/4.2.5: defaulting to 'mysql' backend v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - mod_cap/1.0: adding CAP_AUDIT_WRITE capability v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - mod_ident/1.0: ident lookup disabled v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - ROOT PRIVS at mod_auth.c:133 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - opening scoreboard '/var/run/proftpd.scoreboard' v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - RELINQUISH PRIVS at mod_auth.c:135 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - AuthOrder in effect, resetting auth module order v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - connected - local : ::ffff:79.140.42.108:21 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - connected - remote : ::ffff:93.217.200.18:55561 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - FTP session opened. v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'USER web1' to mod_rewrite v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'USER web1' to mod_tls v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'USER web1' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'USER web1' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'USER web1' to mod_delay v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'USER web1' to mod_auth v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching CMD command 'USER web1' to mod_auth v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching POST_CMD command 'USER web1' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching POST_CMD command 'USER web1' to mod_delay v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD command 'USER web1' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD command 'USER web1' to mod_log v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_tls v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap2 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_ban v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching CMD command 'PASS (hidden)' to mod_auth v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - retrieved UID 10000 for user 'web1' v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - retrieved group IDs: 10000, 10000 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - retrieved group names: web1, web1 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - USER web1 (Login failed): No such user found. v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_wrap2 v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_delay v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'QUIT' to mod_rewrite v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'QUIT' to mod_tls v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'QUIT' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching PRE_CMD command 'QUIT' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching CMD command 'QUIT' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching POST_CMD command 'QUIT' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD command 'QUIT' to mod_sql v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD command 'QUIT' to mod_log v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - dispatching LOG_CMD command 'QUIT' to mod_core v3-1364.vxen.de (p5DD9C812.dip0.t-ipconnect.de[::ffff:93.217.200.18]) - FTP session closed. Link to comment Share on other sites More sharing options...
sonicwave3 Posted August 31, 2013 Author Share Posted August 31, 2013 hab gerade noch was im log entdeckt kann es eventuell daran liegen? v3-1364.vxen.de - no matching vhost found for ::ffff:79.140.42.108#21, using 'v3-1364.vxen.de FTP Server' listening on wildcard address Link to comment Share on other sites More sharing options...
d00p Posted August 31, 2013 Share Posted August 31, 2013 Glaube ich nicht. Da ist ein Problem bei der Verbindung von Proftpd zu MySQL. Bitte pr?fe die Konfigurationen. Versuche auch 127.0.0.1 statt localhost f?r den MySQL-Server. Mehr spielt da eigentlich gar keine Rolle beim User "suchen". Link to comment Share on other sites More sharing options...
sonicwave3 Posted August 31, 2013 Author Share Posted August 31, 2013 ich habe es mal manuell ?ber die console versucht mich mit dem mysql server zu verbindenfroxlor als username, localhost als hostname und dem password aus der lib/userdata.inc.php mysql -u froxlor -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8437 Server version: 5.1.66-0+squeeze1 (Debian) Copyright © 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> da sieht alles perfekt aus oh man, das gibts doch nicht, mir f?llt echt nix mehr ein Link to comment Share on other sites More sharing options...
d00p Posted September 2, 2013 Share Posted September 2, 2013 Bitte pr?fe die Konfigurationen. Versuche auch 127.0.0.1 statt localhost f?r den MySQL-Server. Link to comment Share on other sites More sharing options...
sonicwave3 Posted September 2, 2013 Author Share Posted September 2, 2013 leider dennoch " no such user found" ich deinstallier jetzt nochmal den proftpd samt logs und configs und versuch es nochmal Link to comment Share on other sites More sharing options...
sonicwave3 Posted September 3, 2013 Author Share Posted September 3, 2013 auch eine erneute de/re -installation und config ohne erfolg sql.conf passt, localhost oder 127.0.0.1 macht keinen unterschied in der console kann ich mich mit froxlor und dem dazugeh?rigem passwort wunderbar einloggen Link to comment Share on other sites More sharing options...
d00p Posted September 3, 2013 Share Posted September 3, 2013 100% sicher das der User auch WIRKLICH in der Tabelle 'ftp_users' in der Datenbank 'froxlor' existiert? Link to comment Share on other sites More sharing options...
sonicwave3 Posted September 3, 2013 Author Share Posted September 3, 2013 ja, nat?rlich... habe gerade noch was entdeckt uid und gruppe werden zur?ckgegeben v3-1364.vxen.de (p5DD9D2B1.dip0.t-ipconnect.de[::ffff:93.217.210.177]) - retrieved UID 10000 for user 'web1' v3-1364.vxen.de (p5DD9D2B1.dip0.t-ipconnect.de[::ffff:93.217.210.177]) - retrieved group IDs: 10000, 10000 v3-1364.vxen.de (p5DD9D2B1.dip0.t-ipconnect.de[::ffff:93.217.210.177]) - retrieved group names: web1, web1 v3-1364.vxen.de (p5DD9D2B1.dip0.t-ipconnect.de[::ffff:93.217.210.177]) - USER web1 (Login failed): No such user found. Link to comment Share on other sites More sharing options...
d00p Posted September 4, 2013 Share Posted September 4, 2013 Ich kann dir nur noch anbieten, dass ich mir das mal auf deinem server anschaue...irgendwie kann das ja nich sein. Also, wenn du mir via mail oder hier als PM die zugangsdaten schickst, schau ich mal dr?ber Link to comment Share on other sites More sharing options...
Sephiroth Posted September 4, 2013 Share Posted September 4, 2013 Setz mal bitte folgende Einstellungen um: # Use this to jail all users in their homes DefaultRoot ~ # Users require a valid shell listed in /etc/shells to login. # Use this directive to release that constrain. RequireValidShell off Und dann noch die Frage ob dein nscd korrekt installiert ist (sollte zwar noch nicht zwingend erforderlich sein aber just-in-case) - das kannst du pr?fen indem du 'getent passwd' machst und nachsiehst ob dein virtueller Benutzer dort am Ende steht Link to comment Share on other sites More sharing options...
sonicwave3 Posted September 4, 2013 Author Share Posted September 4, 2013 hallo doctor die zeilen stehen standardm??ig schon in der sql.conf drin DefaultRoot ~ RequireValidShell off AuthOrder mod_sql.c Link to comment Share on other sites More sharing options...
d00p Posted September 4, 2013 Share Posted September 4, 2013 Also der einzige Fall bei dem ich das mal hatte war als jemand mit tls statt SSL verbinden wollte...ich nehme aber an du testest unverschl?sselt?! Link to comment Share on other sites More sharing options...
Sephiroth Posted September 4, 2013 Share Posted September 4, 2013 ah okay - nicht drauf geachtet dass in der sql.conf noch extra Anweisungen stehen. Ja dann kann man Remote nurnoch sagen: Config sieht gut und korrekt aus. M?sste man nach Intuition direkt aufm Server mal testen. Link to comment Share on other sites More sharing options...
sonicwave3 Posted September 5, 2013 Author Share Posted September 5, 2013 update: habe gerade aus verzweiflung in froxlor mal einen neuen user angelegt um zu sehen was passiert und welch wunder, der kann sich einloggen direkt nochmal einen anderen "alten" user genommen "no such user found" noch ein update: habe jetzt bei meinem eigenem user im froxlor mal das kennwort ge?ndert und die checkboxen f?r ftp-hauptzugang und statistikseiten mit angeklickt - gesichert - 5 min gewartet - und siehe da, es geht in der ftp_users tabelle ist das passwort jetzt wesentlich komplexer (l?nger) zum test noch einen anderen user das kennwort ?ndern lassen und es l?uft perfekt ich gehe davon aus das sich irgendwie die verschl?sselung ver?ndert hat der neu angelegte user hat jetzt auch ein wesentlich komplexeres kennwort bekommen da es erst mit dem update von php5 auf squeeze 17 nicht mehr funktionierte gehe ich davon aus das es damit zusammenh?ngt Link to comment Share on other sites More sharing options...
d00p Posted September 5, 2013 Share Posted September 5, 2013 dann w?rde ich doch vorschlagen, schau mal in der Tabelle wo die sich unterscheiden Link to comment Share on other sites More sharing options...
sonicwave3 Posted September 5, 2013 Author Share Posted September 5, 2013 das werde ich tun bitte schliessen UND RIESEN DANK NOCHMAL AN ALLE! Link to comment Share on other sites More sharing options...
d00p Posted September 5, 2013 Share Posted September 5, 2013 Mach ich gerne, sagst du zuk?nftigen Besuchern noch, was es war? Link to comment Share on other sites More sharing options...
sonicwave3 Posted September 5, 2013 Author Share Posted September 5, 2013 vielen dank mhh ich dacht ich hab es im post #22 gut erkl?rt also, ganz simple mal von allen ftp usern im froxlor panel die ftp hauptpassw?rter ?ndern lassen und nicht von der log-ausgabe "no such user" t?uschen lassen! Link to comment Share on other sites More sharing options...
Question
sonicwave3
hallo jungs,
?hnlich dem problem von wild wolf l?sst seit einem update von php5 auf sueeze17 der proftpd keine logins mehr zu
im log steht das der user nicht gefunden wird
in der ftp_users tabelle der froxlor datenbank steht dieser aber einwandfrei drin
auch alle anderen user... welche sich ebenfalls nicht mehr einloggen k?nnen
den tipp von wild wolf die tabelle ftp_users nochmal neu einzuf?gen habe ich durchgef?hrt
leider ohne erfolg
auch die komplette deinstallation mit anschliessender neuinstallation von proftpd laut diesem thread habe ich schon durchgef?hrt
nat?rlich mit der anpassung der configs ?ber foxlors server konfiguration
leider auch dies ohne erfolg
mir f?llt auch nix mehr ein was es noch sein k?nnte
habt ihr noch eine idee?
Link to comment
Share on other sites
25 answers to this question
Recommended Posts
Archived
This topic is now archived and is closed to further replies.