[solved] Proftpd Problem

[Wild Wolf]

Hallo zusammen.

Ich hatte Froxlor auf einem neuen Server aufgesetzt, und die Daten der alten Installation ?bernommen.

Soweit so gut, aber ich kann mich nicht verbinden. Er kann wohl net auf die ftp_user tabelle zugreifen.

 

Daten sind ALLE identisch.

habe schon die hostname angepasst. Muss ich ggf. beim ?ndern des Hostnames noch weitere ?nderungen vornehmen?

Vor 3 Tagen funktionierte noch alles ohne Probleme. Erst nach einem Serverdown ging es nicht mehr. Es wurde auch sonst nichts ge?ndert.

Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): FTP session opened.
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'USER XYZ' to mod_rewrite
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'USER XYZ' to mod_tls
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'USER XYZ' to mod_core
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'USER XYZ' to mod_core
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'USER XYZ' to mod_delay
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'USER XYZ' to mod_auth
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching CMD command 'USER XYZ' to mod_auth
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching POST_CMD command 'USER XYZ' to mod_sql
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching POST_CMD command 'USER XYZ' to mod_delay
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching LOG_CMD command 'USER XYZ' to mod_sql
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching LOG_CMD command 'USER XYZ' to mod_log
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'PASS (hidden)' to mod_tls
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'PASS (hidden)' to mod_core
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'PASS (hidden)' to mod_core
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap2
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'PASS (hidden)' to mod_ban
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'PASS (hidden)' to mod_sql
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'PASS (hidden)' to mod_delay
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching CMD command 'PASS (hidden)' to mod_auth
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): USER XYZ (Login failed): No such user found.
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_wrap2
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_delay
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth
Aug 10 14:39:02 atmainserver proftpd[11582] atmainserver (178-25-173-199-dynip.superkabel.de[::ffff:178.25.173.199]): FTP session closed.

proftpd.conf

#
# /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                      "Anime Thunder.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

# 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


DebugLevel 6

SQL.conf

<IfModule mod_sql.c>
DefaultRoot ~
RequireValidShell off
AuthOrder mod_sql.c

SQLBackend mysql
SQLEngine on
SQLAuthenticate on

SQLAuthTypes Crypt
SQLAuthenticate users* groups*
SQLConnectInfo froxlor@127.0.0.1 froxlor *********
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 A$
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 =$
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_$
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4},%{5}, %{6}, %{7}" ftp_quotatallies

</IfModule>

[Wild Wolf]

Problem behoben.

Ich habe einfach nochmal die FTP Tabellen neu eingespeilt und da gings