|
Titel: Werde nurnoch disconnected Beitrag von: derjasa am 05. Dezember 2006, 00:15:33 Hi,
folgendes Problem. Ich habe heute Abend Mysql 5.0.30 installiert als Debian Backport. Seit dem funktioniert Proftpd leider nicht mehr, daher ich bekomme eine Verbindung und dann werde ich direkt wieder disconnected. Nehme ich den Mysql Part aus der Proftpd Config, können sich die lokalen Benutzer wieder verbinden, aber halt nicht die virtuellen :( Zitat 00:08:18 root@couch-heads:/home/jasa/proftpd-1.3.0a$ /usr/local/sbin/proftpd --nodaemon -d9 - mod_tls/2.1.1: using OpenSSL 0.9.7e 25 Oct 2004 - parsing '/etc/proftpd.conf' configuration - FS: using system open() - FS: using system read() - dispatching directive 'ServerName' to module mod_core - dispatching directive 'ServerType' to module mod_core - dispatching directive 'DeferWelcome' to module mod_core - dispatching directive 'ShowSymlinks' to module mod_ls - dispatching directive 'MultilineRFC2228' to module mod_core - dispatching directive 'DefaultServer' to module mod_core - dispatching directive 'ShowSymlinks' to module mod_ls - dispatching directive 'AllowOverwrite' to module mod_xfer - dispatching directive 'UseReverseDNS' to module mod_core - dispatching directive 'IdentLookups' to module mod_core - dispatching directive 'AllowStoreRestart' to module mod_xfer - dispatching directive 'AllowRetrieveRestart' to module mod_xfer - dispatching directive 'AllowForeignAddress' to module mod_core - dispatching directive 'MaxClientsPerHost' to module mod_auth - dispatching directive 'MaxClients' to module mod_auth - dispatching directive 'MaxLoginAttempts' to module mod_auth - dispatching directive 'MaxInstances' to module mod_core - dispatching directive 'LogFormat' to module mod_log - dispatching directive 'TimeoutNoTransfer' to module mod_xfer - dispatching directive 'TimeoutStalled' to module mod_xfer - dispatching directive 'TimeoutIdle' to module mod_core - dispatching directive 'DisplayLogin' to module mod_core - dispatching directive 'DisplayFirstChdir' to module mod_core - dispatching directive 'DenyFilter' to module mod_core - DenyFilter: compiling deny regex '\*.*/' - dispatching directive 'DefaultRoot' to module mod_auth - dispatching directive 'Port' to module mod_core - FS: using system read() - dispatching directive 'MaxInstances' to module mod_core - dispatching directive 'User' to module mod_core - dispatching auth request "getpwnam" to module mod_radius - dispatching auth request "getpwnam" to module mod_sql - dispatching auth request "getpwnam" to module mod_auth_file - dispatching auth request "getpwnam" to module mod_auth_unix - dispatching directive 'Group' to module mod_core - dispatching auth request "getgrnam" to module mod_radius - dispatching auth request "getgrnam" to module mod_sql - dispatching auth request "getgrnam" to module mod_auth_file - dispatching auth request "getgrnam" to module mod_auth_unix - dispatching directive '<Directory>' to module mod_core - <Directory /*>: deferring resolution of path - dispatching directive 'Umask' to module mod_core - dispatching directive 'AllowOverwrite' to module mod_xfer - dispatching directive 'HideNoAccess' to module mod_core - dispatching directive '</Directory>' to module mod_core - dispatching directive '<Limit>' to module mod_core - dispatching directive 'IgnoreHidden' to module mod_core - dispatching directive '</Limit>' to module mod_core - dispatching directive '<Global>' to module mod_core - dispatching directive 'TransferLog' to module mod_core - dispatching directive 'ExtendedLog' to module mod_log - dispatching directive 'PathDenyFilter' to module mod_core - PathDenyFilter: compiling deny regex '.quota$' - dispatching directive '</Global>' to module mod_core - dispatching directive '<IfModule>' to module mod_core - <IfModule>: using 'mod_delay.c' section at line 85 - dispatching directive 'DelayEngine' to module mod_delay - dispatching directive '</IfModule>' to module mod_core - dispatching directive 'SQLAuthTypes' to module mod_sql - dispatching directive 'SQLAuthenticate' to module mod_sql - FS: using system read() - dispatching directive 'SQLConnectInfo' to module mod_sql - dispatching directive 'SQLUserInfo' to module mod_sql - dispatching directive 'SQLGroupInfo' to module mod_sql - dispatching directive 'SQLMinID' to module mod_sql - dispatching directive 'QuotaEngine' to module mod_quotatab - dispatching directive 'QuotaShowQuotas' to module mod_quotatab - dispatching directive 'QuotaDisplayUnits' to module mod_quotatab - dispatching directive 'SQLNamedQuery' to module mod_sql - dispatching directive 'SQLNamedQuery' to module mod_sql - FS: using system read() - dispatching directive 'SQLNamedQuery' to module mod_sql - dispatching directive 'SQLNamedQuery' to module mod_sql - dispatching directive 'QuotaLock' to module mod_quotatab - dispatching directive 'QuotaLimitTable' to module mod_quotatab - dispatching directive 'QuotaTallyTable' to module mod_quotatab - FS: using system read() - FS: using system close() couch-heads - couch-heads - Config for couch-heads.de: couch-heads - Limit couch-heads - IgnoreHidden couch-heads - /* couch-heads - Umask couch-heads - DirUmask couch-heads - AllowOverwrite couch-heads - HideNoAccess couch-heads - ShowSymlinks couch-heads - AllowStoreRestart couch-heads - AllowRetrieveRestart couch-heads - AllowForeignAddress couch-heads - MaxClientsPerHost couch-heads - MaxClients couch-heads - DisplayLogin couch-heads - DisplayFirstChdir couch-heads - DenyFilter couch-heads - SQLAuthTypes couch-heads - SQLAuthenticate couch-heads - SQLConnectInfo couch-heads - SQLMinID couch-heads - SQLNamedQuery_get-quota-limit couch-heads - SQLNamedQuery_get-quota-tally couch-heads - SQLNamedQuery_update-quota-tally couch-heads - SQLNamedQuery_insert-quota-tally couch-heads - TransferLog couch-heads - PathDenyFilter couch-heads - DeferWelcome couch-heads - ShowSymlinks couch-heads - DefaultServer couch-heads - ShowSymlinks couch-heads - AllowOverwrite couch-heads - IdentLookups couch-heads - AllowStoreRestart couch-heads - AllowRetrieveRestart couch-heads - AllowForeignAddress couch-heads - MaxClientsPerHost couch-heads - MaxClients couch-heads - MaxLoginAttempts couch-heads - TimeoutNoTransfer couch-heads - TimeoutStalled couch-heads - TimeoutIdle couch-heads - DisplayLogin couch-heads - DisplayFirstChdir couch-heads - DenyFilter couch-heads - DefaultRoot couch-heads - UserID couch-heads - UserName couch-heads - GroupID couch-heads - GroupName couch-heads - DelayEngine couch-heads - SQLAuthTypes couch-heads - SQLAuthenticate couch-heads - SQLConnectInfo couch-heads - SQLUserTable couch-heads - SQLUsernameField couch-heads - SQLPasswordField couch-heads - SQLUidField couch-heads - SQLGidField couch-heads - SQLHomedirField couch-heads - SQLShellField couch-heads - SQLGroupTable couch-heads - SQLGroupnameField couch-heads - SQLGroupGIDField couch-heads - SQLGroupMembersField couch-heads - SQLMinID couch-heads - QuotaEngine couch-heads - QuotaShowQuotas couch-heads - QuotaDisplayUnits couch-heads - SQLNamedQuery_get-quota-limit couch-heads - SQLNamedQuery_get-quota-tally couch-heads - SQLNamedQuery_update-quota-tally couch-heads - SQLNamedQuery_insert-quota-tally couch-heads - QuotaLock couch-heads - QuotaLimitTable couch-heads - QuotaTallyTable couch-heads - TransferLog couch-heads - ExtendedLog couch-heads - PathDenyFilter couch-heads - dispatching auth request "getgroups" to module mod_radius couch-heads - dispatching auth request "getgroups" to module mod_sql couch-heads - dispatching auth request "getgroups" to module mod_auth_file couch-heads - dispatching auth request "getgroups" to module mod_auth_unix couch-heads - SETUP PRIVS at main.c:2897 couch-heads - ROOT PRIVS at main.c:1991 couch-heads - RELINQUISH PRIVS at main.c:1998 couch-heads - ROOT PRIVS at main.c:2346 couch-heads - opening scoreboard '/var/run/proftpd/proftpd.scoreboard' couch-heads - RELINQUISH PRIVS at main.c:2372 couch-heads - ROOT PRIVS at inet.c:323 couch-heads - RELINQUISH PRIVS at inet.c:381 couch-heads - ProFTPD 1.3.0a (stable) (built Mo 4. Dez 23:59:10 CET 2006) standalone mode STARTUP couch-heads - ROOT PRIVS at main.c:2209 couch-heads - RELINQUISH PRIVS at main.c:2211 couch-heads - FS: using system lstat() couch-heads - FS: using system lstat() couch-heads - ROOT PRIVS at main.c:1176 couch-heads - RELINQUISH PRIVS at main.c:1180 couch-heads - no matching vhost found for 85.14.216.151#21, using DefaultServer 'couch-heads.de' couch-heads (84.60.246.208[84.60.246.208]) - ROOT PRIVS at main.c:1025 couch-heads (84.60.246.208[84.60.246.208]) - SETUP PRIVS at main.c:1030 couch-heads (84.60.246.208[84.60.246.208]) - FTP session requested from unknown class couch-heads (84.60.246.208[84.60.246.208]) - performing module session initializations couch-heads (84.60.246.208[84.60.246.208]) - ROOT PRIVS at mod_quotatab_sql.c:721 couch-heads - FS: using system lstat() couch-heads (84.60.246.208[84.60.246.208]) - RELINQUISH PRIVS at mod_quotatab_sql.c:726 couch-heads (84.60.246.208[84.60.246.208]) - FTP session closed. couch-heads - FS: using system lstat() Ich habe Proftpd bereits einmal neu aus den Sourcen gebaut. Leider ohne erfolg. Das Problem besteht beim Debian standard Package wie auch beim selbst compilierten. Weiß einer Rat? Titel: Re: Werde nurnoch disconnected Beitrag von: VolGas am 05. Dezember 2006, 07:10:29 Hi!
Zuerst einmal muß ich sagen, daß ich es als eine blöde Idee finde, mit Debian-Mitteln zu versuchen, eben jenes selbst auszutricksen. Wenn man schon nicht die "alten Brocken" von Debian haben möchte, dann sollte man -meiner Meinung nach- konsequent alle benötigten Binaries selbst compilieren. Entsprechende Debian-Pakete vorher natürlich entfernen lassen! In Deinem Debug-Output könnte ich leider nichts relevantes erkennen, deshalb kann ich nur eine generell gültige Antwort geben: der ProFTPD muß mit einer gültigen Version des SQL-Clients verlinkt sein. Dies ist ganz sicher nicht der Fall bei einer Debian-Version. Deshalb benötigst Du die Sourcefiles Deines neuen mySQL und mußt den ProFTPD mit den korrekten Pfaden dorthin mit "--with-includes" und "--with-libraries" neu compilieren. (Siehe auch Posting ->hier (http://www.proftpd.de/forum/index.php/topic,1989.msg9444.html#msg9444), Erklärungen dazu: ->hier (http://www.proftpd.de/forum/index.php/topic,2185.msg10312.html#msg10312)...) Sollte dies auch noch nicht helfen, gilt folgendes: SQL-Fehler werden im Debug-Modus nicht ausgegeben. Um ihnen dennoch auf die Schliche zu kommen, benutze ->SQLLogFile (http://www.proftpd.de/Direktiven.54.0.html#336). Die entstehende Datenmenge ist immens, daher schalte am besten zuerst einmal alles SQL-mäßige aus, was für den laufenden Betrieb nicht unbedingt benötigt wird. (z.B. QuotaEngine) In dem Logfile findest Du alle SQL-Queries, Antworten und auch Fehlermeldungen. Viel Spaß dabei ;D und auch viel Erfolg! mfg. VolGas Titel: Re: Werde nurnoch disconnected Beitrag von: derjasa am 05. Dezember 2006, 12:02:26 vielen Dank für deine Hilfe! Das hat mich schon einen ganzen Schritt weiter gebracht!
|