www.ProFTPD.de

Hi Guys,

I have a working installation with Proftp and mysql. Everything works fine, except for one thing. My ftp server runs under user www and group www, the same as my apache does.

I made a directory (/home/ftp) which I use for my ftp data. But I cannot control the users rights. Only if set the directory to 777, and if a user creates a new file or directory I have to set it to 777 before the user can delete it again.

Does any of you have an idea to this problem ?

I have created the users with groups and so on.

On my unix system the /home/ftp/test is chmod 775 and chown www:www

I have this in my proftpd.conf file:

<Directory /home/ftp/test>
  AllowOverwrite on
  <Limit READ>
    AllowAll
  </Limit>
  <Limit MKD RETR STOR>
    AllowGroup gruppe1
  </Limit>
  <Limit DELE RMD>
    AllowGroup gruppe1
  </Limit>
</Directory>


SQLAuthTypes                    Backend
SQLAuthenticate                 users* groups* usersetfast groupsetfast
SQLConnectInfo                  proftpd@localhost:3306 proftpdb password PERSESSION
SQLGroupInfo                    groups groupname gid members
SQLUserInfo                     users userid passwd uid gid homedir shell
SQLUserWhereClause              "LoginAllowed=1"
SQLLogFile /var/log/proftpd_sql.log
SQLLog PASS counter
SQLNamedQuery counter UPDATE "last_login=now(), count=count+1 WHERE userid='%u'" users

SQLLog EXIT time_logout
SQLNamedQuery time_logout UPDATE "last_logout=now() WHERE userid='%u'" users

SQLLog RETR,STOR,APPE,STOU transfer_success
SQLNamedQuery  transfer_success INSERT "'', '%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'c'" xfer_stats

SQLLog ERR_RETR,ERR_STOR,ERR_APPE,ERR_STOU transfer_error
SQLNamedQuery  transfer_error INSERT "'', '%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i'" xfer_stats

------- -------- ---------
I have a user called test, which has home in the /home/ftp/test and is member of "gruppe1" but he write in the directory ???

What is wrong ?

1) After login your server will run with the UID and GID of the login user.  
2) use Umask.