Werde nurnoch disconnected

[derjasa]

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

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?

[VolGas]

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, Erklärungen dazu: ->hier...)

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.
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 und auch viel Erfolg!

mfg.
  VolGas

[derjasa]

vielen Dank für deine Hilfe! Das hat mich schon einen ganzen Schritt weiter gebracht!