www.ProFTPD.de

Ich habe dies ungelößte Problem schon in einem anderen Thread
beschrieben. Für einen Tip wäre ich dankbar.
Ich bekomme obige Fehlermeldung beim Versuch in das
Verzeichnis "incoming" zu wechseln als user ftpservice mit dieser Config:


<Directory /srv/ftp/ftp2/service/incoming>

<Limit all>
DenyAll
</Limit>
<Limit all>
AllowUser admin
</Limit>
<Limit STOR STOU LIST NLST CWD CDUP CWD PWD>
AllowUser ftpservice
</Limit>

</directory>

Bitte mal ein Debug posten. (proftpd -nd5)
Die Rechte von "incoming" stimmen?
Sprich ohne <Limit all>DenyAll</Limit> geht es?

Ich hab es jetzt mal mit folgender einfachen config versucht und mich
mit einem Benutzer der in der Gruppe service ist angemeldet.
Ich bekomme die gleiche Fehlermeldung. Der Benutzer kann sich
zwar anmelden landet in seinem homeverzeichnis, kann dann aber
nix mehr machen. Nach dem was ich eingestellt habe sollte er aber
wenigstens lesen können.

Sobald ich das DenyAll am Anfang herausnehme klappt es und der
Benutzer in der Gruppe Service kann sich anmelden.

------------------------------------------------------------------------------
<Directory />
<Limit all>
DenyAll
</limit>
</directory>

#
#
#
<Directory /srv/ftp/ftp2>
<Limit READ DIRS>
AllowGroup service
</Limit>
<Limit all>
AllowUser ftp2admin
</Limit>
</directory>
-------------------------------------------------------------------------------

Hier noch die komplette config

-------------------------------------------------------------------------------

Servertype Standalone
#ServerType         inetd
ServerName      "FTP Server"
DefaultServer      on
RootLogin       off
DefaultRoot         ~
UseReverseDNS           off
IdentLookups            off
Umask          002 002
MaxInstances       30
TimeoutStalled       600

<Class intern>
  From 172.18.
  From 192.168.31
</Class>

# deny all enhanced passive commands
<Limit EPSV EPRT>
    DenyAll
</Limit>


<VirtualHost 192.168.31.3>
ServerIdent       off
IdentLookups            off
ServerName         "- Welcome to FTP2"
DefaultRoot         ~
AllowRetrieveRestart on

<IfUser ftp2admin>
  <Limit LOGIN>
    AllowClass intern
    DenyAll
  </Limit>
</IfUser>

<IfGroup service>
  <Limit LOGIN>
    AllowClass intern
    DenyAll
  </Limit>
</IfGroup>

<IfUser ftp2service>
  <Limit LOGIN>
    DenyClass intern
  </Limit>
</IfUser>


<Directory />
  <Limit all>
    DenyAll
  </limit>
</directory>

#
#
#
<Directory /srv/ftp/ftp2>
  <Limit READ DIRS>
   AllowGroup service
  </Limit>
  <Limit all>
    AllowUser ftp2admin
  </Limit>
</directory>


#SQLLogFile /var/log/mysql/proftpd-sql.log
SQLAuthTypes Crypt
SQLAuthenticate users* groups*
SQLConnectInfo xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SQLUserInfo users username passwd NULL NULL homedir NULL SQLGroupInfo groups groupname id username SQLUserWhereClause "valid = 1" SQLDefaultGID 1000 SQLDefaultUID 1005 SQLHomedirOnDemand off RequireValidShell off SQLLog PASS updatelogin SQLNamedQuery updatelogin UPDATE "count=count+1, lastlogin=NOW() WHERE username = '%u'" users

### Log trafic (STOR, RETR commands)
SQLLog STOR,RETR,ERR_STOR,ERR_RETR logtrafic
SQLNamedQuery logtrafic FREEFORM "INSERT INTO history (username, filename, transfertype, transfersize, transferhost, transfertime, transferdate) VALUES('%u', '%F', '%m', %b, '%a', '%T', NOW())"

### Log user error events (ERR_* commands)
SQLLog ERR_* logevents
SQLNamedQuery logevents FREEFORM "INSERT INTO userevents (username, eventtype, description, eventdate) VALUES ('%u', '%m', '%r', NOW())"

</VirtualHost>


debug-log
-------------------------------------------------------------------------------

- parsing '/usr/etc/proftpd.conf' configuration
- <Directory />: adding section for resolved path '/'
- <Directory /srv/ftp/ftp2>: adding section for resolved path '/srv/ftp/ftp2'
- 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 server-hostname -
server-hostname - Config for FTP Server  server-hostname - Limit server-hostname - DenyAll server-hostname - DefaultServer server-hostname - RootLogin server-hostname - DefaultRoot server-hostname - IdentLookups server-hostname - Umask server-hostname - DirUmask server-hostname - TimeoutStalled server-hostname -
server-hostname - Config for - Welcome to FTP2 Server
server-hostname - Limit
server-hostname - AllowUser
server-hostname - Limit
server-hostname - AllowGroup
server-hostname - AllowRetrieveRestart
server-hostname - SQLAuthTypes
server-hostname - SQLAuthenticate
server-hostname - SQLConnectInfo
server-hostname - SQLDefaultGID
server-hostname - SQLDefaultUID
server-hostname - SQLHomedirOnDemand
server-hostname - RequireValidShell
server-hostname - SQLLog_PASS
server-hostname - SQLNamedQuery_updatelogin
server-hostname - SQLLog_STOR
server-hostname - SQLLog_RETR
server-hostname - SQLLog_ERR_STOR
server-hostname - SQLLog_ERR_RETR
server-hostname - SQLNamedQuery_logtrafic
server-hostname - SQLLog_ERR_*
server-hostname - SQLNamedQuery_logevents
server-hostname - Limit
server-hostname - DenyAll
server-hostname - AllowRetrieveRestart
server-hostname - SQLAuthTypes
server-hostname - SQLAuthenticate
server-hostname - SQLConnectInfo
server-hostname - SQLDefaultGID
server-hostname - SQLDefaultUID
server-hostname - SQLHomedirOnDemand
server-hostname - RequireValidShell
server-hostname - SQLLog_PASS
server-hostname - SQLNamedQuery_updatelogin
server-hostname - SQLLog_STOR
server-hostname - SQLLog_RETR
server-hostname - SQLLog_ERR_STOR
server-hostname - SQLLog_ERR_RETR
server-hostname - SQLNamedQuery_logtrafic
server-hostname - SQLLog_ERR_*
server-hostname - SQLNamedQuery_logevents
server-hostname - <IfUser>
server-hostname - Limit
server-hostname - Allow
server-hostname - IfUserList
server-hostname - <IfGroup>
server-hostname - Limit
server-hostname - AllowClass
server-hostname - DenyAll
server-hostname - IfGroupList
server-hostname - <IfUser>
server-hostname - Limit
server-hostname - AllowClass
server-hostname - DenyAll
server-hostname - IfUserList
server-hostname - ServerIdent
server-hostname - IdentLookups
server-hostname - DefaultRoot
server-hostname - AllowRetrieveRestart
server-hostname - SQLAuthTypes
server-hostname - SQLAuthenticate
server-hostname - SQLConnectInfo
server-hostname - SQLUserTable
server-hostname - SQLUsernameField
server-hostname - SQLPasswordField
server-hostname - SQLHomedirField
server-hostname - SQLGroupTable
server-hostname - SQLGroupnameField
server-hostname - SQLGroupGIDField
server-hostname - SQLGroupMembersField
server-hostname - SQLUserWhereClause
server-hostname - SQLDefaultGID
server-hostname - SQLDefaultUID
server-hostname - SQLHomedirOnDemand
server-hostname - RequireValidShell
server-hostname - SQLLog_PASS
server-hostname - SQLNamedQuery_updatelogin
server-hostname - SQLLog_STOR
server-hostname - SQLLog_RETR
server-hostname - SQLLog_ERR_STOR
server-hostname - SQLLog_ERR_RETR
server-hostname - SQLNamedQuery_logtrafic
server-hostname - SQLLog_ERR_*
server-hostname - SQLNamedQuery_logevents
server-hostname - ProFTPD 1.2.10 (stable) (built Mon Mar 7 17:55:26 CET 2005) standalone mode STARTUP ftpserver (server-ip[server-ip]) - FTP session requested from class 'intern' ftpserver (server-ip[server-ip]) - connected - local : 192.168.31.3:21 ftpserver (server-ip[server-ip]) - connected - remote : server-ip:16496 ftpserver (server-ip[server-ip]) - FTP session opened. ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'USER testuser' to mod_core ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'USER testuser' to mod_core ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'USER testuser' to mod_auth ftpserver (server-ip[server-ip]) - dispatching CMD command 'USER testuser' to mod_auth ftpserver (server-ip[server-ip]) - dispatching POST_CMD command 'USER testuser' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD command 'USER testuser' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD command 'USER testuser' to mod_log ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth ftpserver (server-ip[server-ip]) - dispatching CMD command 'PASS (hidden)' to mod_auth ftpserver (server-ip[server-ip]) -
ftpserver (server-ip[server-ip]) - Config for - Welcome to FTP2: ftpserver (server-ip[server-ip]) - / ftpserver (server-ip[server-ip]) - /srv/ftp/ftp2
ftpserver (server-ip[server-ip]) - Limit
ftpserver (server-ip[server-ip]) - AllowUser
ftpserver (server-ip[server-ip]) - Limit
ftpserver (server-ip[server-ip]) - AllowGroup
ftpserver (server-ip[server-ip]) - AllowRetrieveRestart
ftpserver (server-ip[server-ip]) - SQLAuthTypes
ftpserver (server-ip[server-ip]) - SQLAuthenticate
ftpserver (server-ip[server-ip]) - SQLConnectInfo
ftpserver (server-ip[server-ip]) - SQLDefaultGID
ftpserver (server-ip[server-ip]) - SQLDefaultUID
ftpserver (server-ip[server-ip]) - SQLHomedirOnDemand
ftpserver (server-ip[server-ip]) - RequireValidShell
ftpserver (server-ip[server-ip]) - SQLLog_PASS
ftpserver (server-ip[server-ip]) - SQLNamedQuery_updatelogin
ftpserver (server-ip[server-ip]) - SQLLog_STOR
ftpserver (server-ip[server-ip]) - SQLLog_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR
ftpserver (server-ip[server-ip]) - SQLNamedQuery_logtrafic
ftpserver (server-ip[server-ip]) - SQLLog_ERR_*
ftpserver (server-ip[server-ip]) - SQLNamedQuery_logevents
ftpserver (server-ip[server-ip]) - SQLLog_PASS
ftpserver (server-ip[server-ip]) - SQLLog_STOR
ftpserver (server-ip[server-ip]) - SQLLog_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_*
ftpserver (server-ip[server-ip]) - SQLLog_PASS
ftpserver (server-ip[server-ip]) - SQLLog_STOR
ftpserver (server-ip[server-ip]) - SQLLog_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_*
ftpserver (server-ip[server-ip]) - Limit
ftpserver (server-ip[server-ip]) - DenyAll
ftpserver (server-ip[server-ip]) - AllowRetrieveRestart ftpserver (server-ip[server-ip]) - SQLAuthTypes ftpserver (server-ip[server-ip]) - SQLAuthenticate ftpserver (server-ip[server-ip]) - SQLConnectInfo ftpserver (server-ip[server-ip]) - SQLDefaultGID ftpserver (server-ip[server-ip]) - SQLDefaultUID ftpserver (server-ip[server-ip]) - SQLHomedirOnDemand ftpserver (server-ip[server-ip]) - RequireValidShell ftpserver (server-ip[server-ip]) - SQLLog_PASS ftpserver (server-ip[server-ip]) - SQLNamedQuery_updatelogin ftpserver (server-ip[server-ip]) - SQLLog_STOR ftpserver (server-ip[server-ip]) - SQLLog_RETR ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR ftpserver (server-ip[server-ip]) - SQLNamedQuery_logtrafic ftpserver (server-ip[server-ip]) - SQLLog_ERR_* ftpserver (server-ip[server-ip]) - SQLNamedQuery_logevents ftpserver (server-ip[server-ip]) - SQLLog_PASS ftpserver (server-ip[server-ip]) - SQLLog_STOR ftpserver (server-ip[server-ip]) - SQLLog_RETR ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR ftpserver (server-ip[server-ip]) - SQLLog_ERR_* ftpserver (server-ip[server-ip]) - <IfUser> ftpserver (server-ip[server-ip]) - Limit
ftpserver (server-ip[server-ip]) - Allow
ftpserver (server-ip[server-ip]) - IfUserList ftpserver (server-ip[server-ip]) - <IfGroup> ftpserver (server-ip[server-ip]) - Limit
ftpserver (server-ip[server-ip]) - AllowClass
ftpserver (server-ip[server-ip]) - DenyAll
ftpserver (server-ip[server-ip]) - IfGroupList ftpserver (server-ip[server-ip]) - <IfUser> ftpserver (server-ip[server-ip]) - Limit
ftpserver (server-ip[server-ip]) - AllowClass
ftpserver (server-ip[server-ip]) - DenyAll
ftpserver (server-ip[server-ip]) - IfUserList ftpserver (server-ip[server-ip]) - ServerIdent ftpserver (server-ip[server-ip]) - IdentLookups ftpserver (server-ip[server-ip]) - DefaultRoot ftpserver (server-ip[server-ip]) - AllowRetrieveRestart ftpserver (server-ip[server-ip]) - SQLAuthTypes ftpserver (server-ip[server-ip]) - SQLAuthenticate ftpserver (server-ip[server-ip]) - SQLConnectInfo ftpserver (server-ip[server-ip]) - SQLUserTable ftpserver (server-ip[server-ip]) - SQLUsernameField ftpserver (server-ip[server-ip]) - SQLPasswordField ftpserver (server-ip[server-ip]) - SQLHomedirField ftpserver (server-ip[server-ip]) - SQLGroupTable ftpserver (server-ip[server-ip]) - SQLGroupnameField ftpserver (server-ip[server-ip]) - SQLGroupGIDField ftpserver (server-ip[server-ip]) - SQLGroupMembersField ftpserver (server-ip[server-ip]) - SQLUserWhereClause ftpserver (server-ip[server-ip]) - SQLDefaultGID ftpserver (server-ip[server-ip]) - SQLDefaultUID ftpserver (server-ip[server-ip]) - SQLHomedirOnDemand ftpserver (server-ip[server-ip]) - RequireValidShell ftpserver (server-ip[server-ip]) - SQLLog_PASS ftpserver (server-ip[server-ip]) - SQLNamedQuery_updatelogin ftpserver (server-ip[server-ip]) - SQLLog_STOR ftpserver (server-ip[server-ip]) - SQLLog_RETR ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR ftpserver (server-ip[server-ip]) - SQLNamedQuery_logtrafic ftpserver (server-ip[server-ip]) - SQLLog_ERR_* ftpserver (server-ip[server-ip]) - SQLNamedQuery_logevents ftpserver (server-ip[server-ip]) - CURRENT-CLIENTS ftpserver (server-ip[server-ip]) - CURRENT-CLASS ftpserver (server-ip[server-ip]) - CURRENT-CLIENTS-CLASS-intern ftpserver (server-ip[server-ip]) - USER ftpserver (server-ip[server-ip]) - USER testuser: Login successful. ftpserver (server-ip[server-ip]) - Preparing to chroot() the environment, path = '/srv/ftp/ftp2' ftpserver (server-ip[server-ip]) - Environment successfully chroot()ed. ftpserver (server-ip[server-ip]) - in dir_check_full(): path = '/', fullpath = '/srv/ftp/ftp2/'. ftpserver (server-ip[server-ip]) - dispatching POST_CMD command 'PASS (hidden)' to mod_sql ftpserver (server-ip[server-ip]) - dispatching POST_CMD command 'PASS (hidden)' to mod_cap ftpserver (server-ip[server-ip]) - mod_cap/1.0: capabilities '= cap_net_bind_service+ep' ftpserver (server-ip[server-ip]) - dispatching POST_CMD command 'PASS (hidden)' to mod_ifsession ftpserver (server-ip[server-ip]) - mod_ifsession/0.9: merging <IfGroup> directives in ftpserver (server-ip[server-ip]) -
ftpserver (server-ip[server-ip]) - Config for - Welcome to FTP2 : ftpserver (server-ip[server-ip]) - / ftpserver (server-ip[server-ip]) - /srv/ftp/ftp2
ftpserver (server-ip[server-ip]) - Limit
ftpserver (server-ip[server-ip]) - AllowUser
ftpserver (server-ip[server-ip]) - Limit
ftpserver (server-ip[server-ip]) - AllowGroup
ftpserver (server-ip[server-ip]) - AllowRetrieveRestart
ftpserver (server-ip[server-ip]) - SQLAuthTypes
ftpserver (server-ip[server-ip]) - SQLAuthenticate
ftpserver (server-ip[server-ip]) - SQLConnectInfo
ftpserver (server-ip[server-ip]) - SQLDefaultGID
ftpserver (server-ip[server-ip]) - SQLDefaultUID
ftpserver (server-ip[server-ip]) - SQLHomedirOnDemand
ftpserver (server-ip[server-ip]) - RequireValidShell
ftpserver (server-ip[server-ip]) - SQLLog_PASS
ftpserver (server-ip[server-ip]) - SQLNamedQuery_updatelogin
ftpserver (server-ip[server-ip]) - SQLLog_STOR
ftpserver (server-ip[server-ip]) - SQLLog_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR
ftpserver (server-ip[server-ip]) - SQLNamedQuery_logtrafic
ftpserver (server-ip[server-ip]) - SQLLog_ERR_*
ftpserver (server-ip[server-ip]) - SQLNamedQuery_logevents
ftpserver (server-ip[server-ip]) - SQLLog_PASS
ftpserver (server-ip[server-ip]) - SQLLog_STOR
ftpserver (server-ip[server-ip]) - SQLLog_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_*
ftpserver (server-ip[server-ip]) - SQLLog_PASS
ftpserver (server-ip[server-ip]) - SQLLog_STOR
ftpserver (server-ip[server-ip]) - SQLLog_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_*
ftpserver (server-ip[server-ip]) - SQLLog_PASS
ftpserver (server-ip[server-ip]) - SQLLog_STOR
ftpserver (server-ip[server-ip]) - SQLLog_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_*
ftpserver (server-ip[server-ip]) - SQLLog_PASS
ftpserver (server-ip[server-ip]) - SQLLog_STOR
ftpserver (server-ip[server-ip]) - SQLLog_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_*
ftpserver (server-ip[server-ip]) - SQLLog_PASS
ftpserver (server-ip[server-ip]) - SQLLog_STOR
ftpserver (server-ip[server-ip]) - SQLLog_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR
ftpserver (server-ip[server-ip]) - SQLLog_ERR_*
ftpserver (server-ip[server-ip]) - Limit
ftpserver (server-ip[server-ip]) - DenyAll
ftpserver (server-ip[server-ip]) - AllowRetrieveRestart ftpserver (server-ip[server-ip]) - SQLAuthTypes ftpserver (server-ip[server-ip]) - SQLAuthenticate ftpserver (server-ip[server-ip]) - SQLConnectInfo ftpserver (server-ip[server-ip]) - SQLDefaultGID ftpserver (server-ip[server-ip]) - SQLDefaultUID ftpserver (server-ip[server-ip]) - SQLHomedirOnDemand ftpserver (server-ip[server-ip]) - RequireValidShell ftpserver (server-ip[server-ip]) - SQLLog_PASS ftpserver (server-ip[server-ip]) - SQLNamedQuery_updatelogin ftpserver (server-ip[server-ip]) - SQLLog_STOR ftpserver (server-ip[server-ip]) - SQLLog_RETR ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR ftpserver (server-ip[server-ip]) - SQLNamedQuery_logtrafic ftpserver (server-ip[server-ip]) - SQLLog_ERR_* ftpserver (server-ip[server-ip]) - SQLNamedQuery_logevents ftpserver (server-ip[server-ip]) - SQLLog_PASS ftpserver (server-ip[server-ip]) - SQLLog_STOR ftpserver (server-ip[server-ip]) - SQLLog_RETR ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR ftpserver (server-ip[server-ip]) - SQLLog_ERR_* ftpserver (server-ip[server-ip]) - SQLLog_PASS ftpserver (server-ip[server-ip]) - SQLLog_STOR ftpserver (server-ip[server-ip]) - SQLLog_RETR ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR ftpserver (server-ip[server-ip]) - SQLLog_ERR_* ftpserver (server-ip[server-ip]) - <IfUser> ftpserver (server-ip[server-ip]) - Limit
ftpserver (server-ip[server-ip]) - Allow
ftpserver (server-ip[server-ip]) - IfUserList ftpserver (server-ip[server-ip]) - <IfGroup> ftpserver (server-ip[server-ip]) - Limit
ftpserver (server-ip[server-ip]) - AllowClass
ftpserver (server-ip[server-ip]) - DenyAll
ftpserver (server-ip[server-ip]) - IfGroupList ftpserver (server-ip[server-ip]) - <IfUser> ftpserver (server-ip[server-ip]) - Limit
ftpserver (server-ip[server-ip]) - AllowClass
ftpserver (server-ip[server-ip]) - DenyAll
ftpserver (server-ip[server-ip]) - IfUserList ftpserver (server-ip[server-ip]) - ServerIdent ftpserver (server-ip[server-ip]) - IdentLookups ftpserver (server-ip[server-ip]) - DefaultRoot ftpserver (server-ip[server-ip]) - AllowRetrieveRestart ftpserver (server-ip[server-ip]) - SQLAuthTypes ftpserver (server-ip[server-ip]) - SQLAuthenticate ftpserver (server-ip[server-ip]) - SQLConnectInfo ftpserver (server-ip[server-ip]) - SQLUserTable ftpserver (server-ip[server-ip]) - SQLUsernameField ftpserver (server-ip[server-ip]) - SQLPasswordField ftpserver (server-ip[server-ip]) - SQLHomedirField ftpserver (server-ip[server-ip]) - SQLGroupTable ftpserver (server-ip[server-ip]) - SQLGroupnameField ftpserver (server-ip[server-ip]) - SQLGroupGIDField ftpserver (server-ip[server-ip]) - SQLGroupMembersField ftpserver (server-ip[server-ip]) - SQLUserWhereClause ftpserver (server-ip[server-ip]) - SQLDefaultGID ftpserver (server-ip[server-ip]) - SQLDefaultUID ftpserver (server-ip[server-ip]) - SQLHomedirOnDemand ftpserver (server-ip[server-ip]) - RequireValidShell ftpserver (server-ip[server-ip]) - SQLLog_PASS ftpserver (server-ip[server-ip]) - SQLNamedQuery_updatelogin ftpserver (server-ip[server-ip]) - SQLLog_STOR ftpserver (server-ip[server-ip]) - SQLLog_RETR ftpserver (server-ip[server-ip]) - SQLLog_ERR_STOR ftpserver (server-ip[server-ip]) - SQLLog_ERR_RETR ftpserver (server-ip[server-ip]) - SQLNamedQuery_logtrafic ftpserver (server-ip[server-ip]) - SQLLog_ERR_* ftpserver (server-ip[server-ip]) - SQLNamedQuery_logevents ftpserver (server-ip[server-ip]) - CURRENT-CLIENTS ftpserver (server-ip[server-ip]) - CURRENT-CLASS ftpserver (server-ip[server-ip]) - CURRENT-CLIENTS-CLASS-intern ftpserver (server-ip[server-ip]) - USER ftpserver (server-ip[server-ip]) - authenticated ftpserver (server-ip[server-ip]) - Limit ftpserver (server-ip[server-ip]) - AllowClass ftpserver (server-ip[server-ip]) - DenyAll ftpserver (server-ip[server-ip]) - dispatching POST_CMD command 'PASS (hidden)' to mod_quotatab ftpserver (server-ip[server-ip]) - dispatching POST_CMD command 'PASS (hidden)' to mod_log ftpserver (server-ip[server-ip]) - dispatching POST_CMD command 'PASS (hidden)' to mod_ls ftpserver (server-ip[server-ip]) - dispatching POST_CMD command 'PASS (hidden)' to mod_auth ftpserver (server-ip[server-ip]) - dispatching LOG_CMD command 'PASS (hidden)' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD command 'PASS (hidden)' to mod_log ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'SYST' to mod_core ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'SYST' to mod_core ftpserver (server-ip[server-ip]) - dispatching CMD command 'SYST' to mod_core ftpserver (server-ip[server-ip]) - dispatching POST_CMD command 'SYST' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD command 'SYST' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD command 'SYST' to mod_log ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'FEAT' to mod_core ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'FEAT' to mod_core ftpserver (server-ip[server-ip]) - dispatching CMD command 'FEAT' to mod_core ftpserver (server-ip[server-ip]) - dispatching POST_CMD command 'FEAT' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD command 'FEAT' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD command 'FEAT' to mod_log ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'PWD' to mod_core ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'PWD' to mod_core ftpserver (server-ip[server-ip]) - dispatching CMD command 'PWD' to mod_core ftpserver (server-ip[server-ip]) - dispatching POST_CMD command 'PWD' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD command 'PWD' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD command 'PWD' to mod_log ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'TYPE A' to mod_core ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'TYPE A' to mod_core ftpserver (server-ip[server-ip]) - dispatching CMD command 'TYPE A' to mod_xfer ftpserver (server-ip[server-ip]) - dispatching POST_CMD command 'TYPE A' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD command 'TYPE A' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD command 'TYPE A' to mod_log ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'PORT serverip,64,113' to mod_core ftpserver (server-ip[server-ip]) - dispatching PRE_CMD command 'PORT serverip,64,113' to mod_core ftpserver (server-ip[server-ip]) - dispatching CMD command 'PORT serverip,64,113' to mod_core ftpserver (server-ip[server-ip]) - dispatching POST_CMD_ERR command 'PORT serverip,64,113' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD_ERR command 'PORT serverip,64,113' to mod_sql ftpserver (server-ip[server-ip]) - dispatching LOG_CMD_ERR command 'PORT serverip,64,113' to mod_log server-hostname - ProFTPD terminating (signal 2) server-hostname - ProFTPD 1.2.10 standalone mode SHUTDOWN server-hostname - deleting existing scoreboard '/usr/var/proftpd/proftpd.scoreboard'
ftpserver (server-ip[server-ip]) - ProFTPD terminating (signal 2) ftpserver (server-ip[server-ip]) - FTP session closed.

Hätte mich nur mal interessiert ob das ein Bug ist oder nicht.
Oder ob ich das falsch konfiguriert habe.
Ich kann das beliebig für Verzeichnisse reproduzieren.


Frank

system ? Debian ?

ist eine suse 9.1 mit selbstgemachtem proftpd.

any hints would be appreciated!

ich bin da ein wenig ratlos. Ich wuerde es mal OHNE mod_sql probieren...

cu
stonki

Ohne geht es leider nicht, weil die Gruppen benötigt werden.
Das ganze geht auch nur in Verbindung mit MyFTPAdmin.



Frank

Du kannst es ja mal Testweise ohne Mod_sql probieren ob dann das Problem auch auftaucht. So kann man zumindest den Fehler eingrenzen...

cu
stonki

Es existieren nur Mysqlbenutzer und Gruppen. Macht das Sinn? Dann muss
ich das Ganze erst auf Unixsystemebene nachbilden.

naja, ich bin eben der Meinung, dass das an mod_sql liegt und irgendwelchen Problemen mit Deiner SQL Installation. Muss nicht, kann aber - ist so ein bauchgefühl....  Das könnte man so mal testen.

AHH, eins noch:
SQLLOGFILE /var/log/proftpd.sql.log

in Deine ProFTPD.conf rein und probier noch mal von vorne und poste die Ausgabe hier im Forum.-

cu
stonki

Folgende Testconfig:

<Directory /srv/ftp/ftp2>
  <Limit all>
    AllowUser admin
  </Limit>
  <Limit WRITE>
    DenyGroup service
  </Limit>
</directory>

<Directory /srv/ftp/ftp2/test>

<Limit all>
DenyAll
</Limit>
<Limit all>
AllowUser admin
</Limit>
<Limit STOR STOU LIST NLST CWD CDUP CWD PWD>
AllowUser ftpservice
AllowUser user2
</Limit>

</directory>


Dabei Benutze ich auf einem Interface zwei IP Adressen und darüber
pro Adresse einen FTP Server. Das heißt es gibt zwei virtual
hosts.




SQL Log:


Mar 21 11:52:23 mod_sql/4.11[26787]: backend module 'mod_sql_mysql/4.04'
Mar 21 11:52:23 mod_sql/4.11[26787]: backend api    'mod_sql_api_v1'
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> sql_getconf
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_defineconnection
Mar 21 11:52:23 mod_sql/4.11[26787]:  name: 'default'
Mar 21 11:52:23 mod_sql/4.11[26787]:  user: 'ftpuser2'
Mar 21 11:52:23 mod_sql/4.11[26787]:  host: 'localhost'
Mar 21 11:52:23 mod_sql/4.11[26787]:    db: 'ftp2'
Mar 21 11:52:23 mod_sql/4.11[26787]:  port: '3306'
Mar 21 11:52:23 mod_sql/4.11[26787]:   ttl: '0'
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_defineconnection
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' opened
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 1
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: backend successfully connected.
Mar 21 11:52:23 mod_sql/4.11[26787]: mod_sql status     : on
Mar 21 11:52:23 mod_sql/4.11[26787]: negative_cache     : off
Mar 21 11:52:23 mod_sql/4.11[26787]: authenticate       : users groups
Mar 21 11:52:23 mod_sql/4.11[26787]: usertable          : users
Mar 21 11:52:23 mod_sql/4.11[26787]: userid field       : username
Mar 21 11:52:23 mod_sql/4.11[26787]: password field     : passwd
Mar 21 11:52:23 mod_sql/4.11[26787]: uid field          : NULL
Mar 21 11:52:23 mod_sql/4.11[26787]: gid field          : NULL
Mar 21 11:52:23 mod_sql/4.11[26787]: homedir field      : homedir
Mar 21 11:52:23 mod_sql/4.11[26787]: shell field        : NULL
Mar 21 11:52:23 mod_sql/4.11[26787]: homedirondemand    : false
Mar 21 11:52:23 mod_sql/4.11[26787]: group table        : groups
Mar 21 11:52:23 mod_sql/4.11[26787]: groupname field    : groupname
Mar 21 11:52:23 mod_sql/4.11[26787]: grp gid field      : id
Mar 21 11:52:23 mod_sql/4.11[26787]: grp members field  : username
Mar 21 11:52:23 mod_sql/4.11[26787]: SQLMinUserUID      : 999
Mar 21 11:52:23 mod_sql/4.11[26787]: SQLMinUserGID      : 999
Mar 21 11:52:23 mod_sql/4.11[26787]: SQLDefaultUID      : 1005
Mar 21 11:52:23 mod_sql/4.11[26787]: SQLDefaultGID      : 1000
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< sql_getconf
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_getgroups
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_escapestring
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_escapestring
Mar 21 11:52:23 mod_sql/4.11[26787]: cache miss for user 'user2'
Mar 21 11:52:23 mod_sql/4.11[26787]: : entering    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 2
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: query "SELECT username, passwd, homedir FROM users WHERE (username='user2') and ((valid = 1)) LIMIT 1"
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 1
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: cache miss for user 'user2'
Mar 21 11:52:23 mod_sql/4.11[26787]: user 'user2' cached
Mar 21 11:52:23 mod_sql/4.11[26787]: + pwd.pw_name  : user2
Mar 21 11:52:23 mod_sql/4.11[26787]: + pwd.pw_uid   : 1005
Mar 21 11:52:23 mod_sql/4.11[26787]: + pwd.pw_gid   : 1000
Mar 21 11:52:23 mod_sql/4.11[26787]: + pwd.pw_dir   : /srv/ftp/ftp2
Mar 21 11:52:23 mod_sql/4.11[26787]: + pwd.pw_shell :
Mar 21 11:52:23 mod_sql/4.11[26787]: cache miss for gid '1000'
Mar 21 11:52:23 mod_sql/4.11[26787]: : entering    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 2
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: query "SELECT groupname FROM groups WHERE (id = 1000) LIMIT 1"
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 1
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: : entering    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 2
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: query "SELECT groupname, id, username FROM groups WHERE (username = 'user2' OR username LIKE 'user2,%' OR username LIKE '%,user2' OR username LIKE '%,user2,%')"
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 1
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: cache miss for group 'service'
Mar 21 11:52:23 mod_sql/4.11[26787]: group 'service' cached
Mar 21 11:52:23 mod_sql/4.11[26787]: + grp.gr_name : service
Mar 21 11:52:23 mod_sql/4.11[26787]: + grp.gr_gid  : 72
Mar 21 11:52:23 mod_sql/4.11[26787]: + grp.gr_mem  : user2
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_getgroups
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_getgroups
Mar 21 11:52:23 mod_sql/4.11[26787]: cache hit for user 'user2'
Mar 21 11:52:23 mod_sql/4.11[26787]: cache miss for gid '1000'
Mar 21 11:52:23 mod_sql/4.11[26787]: : entering    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 2
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: query "SELECT groupname FROM groups WHERE (id = 1000) LIMIT 1"
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 1
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: : entering    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 2
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: query "SELECT groupname, id, username FROM groups WHERE (username = 'user2' OR username LIKE 'user2,%' OR username LIKE '%,user2' OR username LIKE '%,user2,%')"
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 1
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: cache hit for group 'service'
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_getgroups
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_getpwnam
Mar 21 11:52:23 mod_sql/4.11[26787]: cache hit for user 'user2'
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_getpwnam
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_gid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: cache miss for gid '1000'
Mar 21 11:52:23 mod_sql/4.11[26787]: : entering    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 2
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: query "SELECT groupname FROM groups WHERE (id = 1000) LIMIT 1"
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 1
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_gid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_auth
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_escapestring
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_escapestring
Mar 21 11:52:23 mod_sql/4.11[26787]: cache hit for user 'user2'
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_check
Mar 21 11:52:23 mod_sql/4.11[26787]: checking auth_type Crypt
Mar 21 11:52:23 mod_sql/4.11[26787]: 'Crypt' auth handler reports success
Mar 21 11:52:23 mod_sql/4.11[26787]: cache hit for user 'user2'
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_check
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_auth
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_getpwnam
Mar 21 11:52:23 mod_sql/4.11[26787]: cache hit for user 'user2'
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_getpwnam
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> log_master
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> _process_named_query
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_escapestring
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_escapestring
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_update
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 2
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: query "UPDATE users SET count=count+1, lastlogin=NOW() WHERE username = 'user2'"
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 1
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_update
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< _process_named_query
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< log_master
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_gid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: cache miss for gid '1000'
Mar 21 11:52:23 mod_sql/4.11[26787]: : entering    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 2
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: query "SELECT groupname FROM groups WHERE (id = 1000) LIMIT 1"
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 1
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_gid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_uid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: matched current user
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_uid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_gid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: cache miss for gid '1000'
Mar 21 11:52:23 mod_sql/4.11[26787]: : entering    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 2
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: query "SELECT groupname FROM groups WHERE (id = 1000) LIMIT 1"
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 1
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_gid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_uid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: matched current user
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_uid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_gid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: cache miss for gid '1000'
Mar 21 11:52:23 mod_sql/4.11[26787]: : entering    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 2
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_open
Mar 21 11:52:23 mod_sql/4.11[26787]: query "SELECT groupname FROM groups WHERE (id = 1000) LIMIT 1"
Mar 21 11:52:23 mod_sql/4.11[26787]: entering    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: connection 'default' count is now 1
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_close
Mar 21 11:52:23 mod_sql/4.11[26787]: exiting    mysql cmd_select
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_gid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: >>> cmd_uid2name
Mar 21 11:52:23 mod_sql/4.11[26787]: matched current user
Mar 21 11:52:23 mod_sql/4.11[26787]: <<< cmd_uid2name
Mar 21 11:52:24 mod_sql/4.11[26787]: >>> err_master
Mar 21 11:52:24 mod_sql/4.11[26787]: >>> _process_named_query
Mar 21 11:52:24 mod_sql/4.11[26787]: entering    mysql cmd_escapestring
Mar 21 11:52:24 mod_sql/4.11[26787]: exiting    mysql cmd_escapestring
Mar 21 11:52:24 mod_sql/4.11[26787]: entering    mysql cmd_escapestring
Mar 21 11:52:24 mod_sql/4.11[26787]: exiting    mysql cmd_escapestring
Mar 21 11:52:24 mod_sql/4.11[26787]: entering    mysql cmd_escapestring
Mar 21 11:52:24 mod_sql/4.11[26787]: exiting    mysql cmd_escapestring
Mar 21 11:52:24 mod_sql/4.11[26787]: entering    mysql cmd_query
Mar 21 11:52:24 mod_sql/4.11[26787]: entering    mysql cmd_open
Mar 21 11:52:24 mod_sql/4.11[26787]: connection 'default' count is now 2
Mar 21 11:52:24 mod_sql/4.11[26787]: exiting    mysql cmd_open
Mar 21 11:52:24 mod_sql/4.11[26787]: query "INSERT INTO userevents (username, eventtype, description, eventdate) VALUES ('user2', 'PORT', 'PORT ftpserver-ip,223,137', NOW())"
Mar 21 11:52:24 mod_sql/4.11[26787]: entering    mysql cmd_close
Mar 21 11:52:24 mod_sql/4.11[26787]: connection 'default' count is now 1
Mar 21 11:52:24 mod_sql/4.11[26787]: exiting    mysql cmd_close
Mar 21 11:52:24 mod_sql/4.11[26787]: exiting    mysql cmd_query
Mar 21 11:52:24 mod_sql/4.11[26787]: <<< _process_named_query
Mar 21 11:52:24 mod_sql/4.11[26787]: <<< err_master

Ich bekomme auch beim "user2" login folgenden syslog Eintrag:

[...]
Mar 21 12:37:33 www proftpd[27028]: warning: "- Welcome to FTP Server" address/port (192.168.10.1:21) already in use by "FTP Server"

Die IP auf dem der Server liegt ist aber 192.168.10.3???

Kann das eventuell etwas mit dem IP Setup zu tuen haben?

Ich bekomme die IP Aliase nur über "ip addr" abgezeigt.

2: eth0: <BROADCAST,MULTICAST,UP> mtu 1500 qdisc pfifo_fast qlen 1000
    link/ether 00:0d:61:71:19:4c brd ff:ff:ff:ff:ff:ff
    inet 192.168.10.1/24 brd 192.168.10.255 scope global eth0
    inet 192.168.10.2/24 brd 192.168.10.255 scope global secondary eth0
    inet 192.168.10.3/24 brd 192.168.10.255 scope global secondary eth0
    inet 192.168.10.4/24 brd 192.168.10.255 scope global secondary eth0
          valid_lft forever preferred_lft forever

Normalerweise hat man ja eth0 bis eth0:0,1,2 Interfaces.

das selbe Problem habe ich auch (seit dem ich mein debian upgradet habe)
ich kriege immer dies fehle meldung bei der begrenzete userrechte


http://www.proftpd.de/forum/viewtopic.php?t=1572

ich habe
<Limit ALL>
DenyALL
</Limit>

weg gemacht und dies hingefügt
<Limit DELE MKD  RMD RNTO  XMKD XMKD XRMDD   >
         DenyAll
  </Limit>

ich denke neu proftp hat andere syntax vernunft als alter version

ahhh, Du hast recht. Und zwar gibt es "LIMIT PORT". Und das wird dann natuerlich bei "LIMIT ALL" auch mit verboten..

cu
stonki

MOMENTO was macht genau limit port ?

bei der LIMIT anweisung gibt es einiger atribute,für den ich keine dokumantasyon finden kann sowir XMKD

was ist die unterschiet MKD und XMKD?