[Dateizugriff] Gameserver - keine Map auswählbar, keine Config usw. (Debian 8 - Froxlor - proftpd )

#
# /etc/proftpd/proftpd.conf -- This is a basic ProFTPD configuration file.
# To really apply changes, reload proftpd after modifications, if
# it runs in daemon mode. It is not required in inetd/xinetd mode.
#


# Includes DSO modules
Include /etc/proftpd/modules.conf


# Set off to disable IPv6 support which is annoying on IPv4 only boxes.
UseIPv6				off
UseFTPUsers			on
# If set on you can experience a longer connection delay in many cases.
IdentLookups			off


ServerName                     "xxxxx.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 // ALS INFO, ist in sql.conf




# 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


# Logging onto /var/log/lastlog is enabled but set to off by default
#UseLastlog on


# In order to keep log file dates consistent after chroot, use timezone info
# from /etc/localtime.  If this is not set, and proftpd is configured to
# chroot (e.g. DefaultRoot or <Anonymous>), it will use the non-daylight
# savings timezone regardless of whether DST is in effect.
#SetEnv TZ :/etc/localtime


<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://www.securityfocus.com/bid/11430/discuss
# It is on by default.
<IfModule mod_delay.c>
DelayEngine on
</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          /// HIER WIRD SQL.conf integriert


#
# This is used for FTPS connections
#
Include /etc/proftpd/tls.conf


#
# Useful to keep VirtualHost/VirtualRoot directives separated
#
#Include /etc/proftpd/virtuals.conf


# A basic anonymous configuration, no upload directories.


# <Anonymous ~ftp>
#   User				ftp
#   Group				nogroup
#   # We want clients to be able to login with "anonymous" as well as "ftp"
#   UserAlias			anonymous ftp
#   # Cosmetic changes, all files belongs to ftp user
#   DirFakeUser	on ftp
#   DirFakeGroup on ftp
#
#   RequireValidShell		off
#
#   # Limit the maximum number of anonymous logins
#   MaxClients			10
#
#   # We want 'welcome.msg' displayed at login, and '.message' displayed
#   # in each newly chdired directory.
#   DisplayLogin			welcome.msg
#   DisplayChdir		.message
#
#   # Limit WRITE everywhere in the anonymous chroot
#   <Directory *>
#     <Limit WRITE>
#       DenyAll
#     </Limit>
#   </Directory>
#
#   # Uncomment this if you're brave.
#   # <Directory incoming>
#   #   # Umask 022 is a good standard umask to prevent new files and dirs
#   #   # (second parm) from being group and world writable.
#   #   Umask				022  022
#   #            <Limit READ WRITE>
#   #            DenyAll
#   #            </Limit>
#   #            <Limit STOR>
#   #            AllowAll
#   #            </Limit>
#   # </Directory>
#
# </Anonymous>


# Include other custom configuration files
Include /etc/proftpd/conf.d/

#
# Proftpd sample configuration for SQL-based authentication.
#
# (This is not to be used if you prefer a PAM-based SQL authentication)
#


<IfModule mod_sql.c>


DefaultRoot ~
RequireValidShell off
AuthOrder mod_sql.c mod_auth_unix.c
AuthUserFile /etc/proftpd/ftpd.passwd
AuthGroupFile /etc/proftpd/ftpd.group
#
# Choose a SQL backend among MySQL or PostgreSQL.
# Both modules are loaded in default configuration, so you have to specify the backend
# or comment out the unused module in /etc/proftpd/modules.conf.
# Use 'mysql' or 'postgres' as possible values.
#
SQLBackend	mysql
#
SQLEngine on
SQLAuthenticate on
#
# Use both a crypted or plaintext password
SQLAuthTypes Crypt


SQLAuthenticate users* groups*


#
# Connection
SQLConnectInfo user@127.0.0.1 db pw
#
# Describes both users/groups tables
#
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>

Aufruf im Userbackend - Serververwaltung
FTP-Passwort in den Einstellungen um User selbst gesetzt -
2017-05-24 10:14:39,758 vserver proftpd[28535] vserverde (vserverde[IP]): USER user (Login failed): Incorrect password
2017-05-24 10:14:39,759 vserver proftpd[28535] vserverde (vserverde[IP]): FTP session closed.
2017-05-24 10:15:28,347 vserver proftpd[28571] vserverde (vserverde[IP]): FTP session opened.


Aufgrund dessen versucht für den FTp User das Passwort selbst per Putty zu setzen
passwd user
selbes Passwort wie im ersten Schritt gesetzt - Aufruf Datei Editor im Browser - FTP-Log


2017-05-24 10:15:28,566 vserver proftpd[28571] vserverde (vserverde[IP]): USER user: Login successful.
2017-05-24 10:15:28,567 vserver proftpd[28571] vserverde (vserverde[IP]): FTP session closed.
2017-05-24 10:15:30,311 vserver proftpd[28573] vserverde (vserverde[IP]): FTP session opened.
2017-05-24 10:15:30,543 vserver proftpd[28573] vserverde (vserverde[IP]): USER user: Login successful.
2017-05-24 10:15:30,545 vserver proftpd[28573] vserverde (vserverde[IP]): FTP session closed.


Trotzdem keine Möglichkeit Dateien zu speichern, Maps zu ändern etc.