There was a configuration error. Now everything works as intended.
Hmmm, maybe I’m missing a point, dear lazyweb, but it seems as if proftpd in Etch is somewhat broken.
Ok, I have a setup with proftpd, SQL backend (psql) and quota. First the SQL backend:
Column | Type | Modifiers
userid | character varying(30) | not null
passwd | character varying(80) | not null
uid | integer |
gid | integer |
homedir | character varying(255) |
shell | character varying(255) |
clear | character varying(80) |
“userid_pkey” PRIMARY KEY, btree (userid)
“users_uid_key” UNIQUE, btree (uid)
“users_userid_key” UNIQUE, btree (userid)
#PostgresInfo localhost dbadmin dcf1330 vftp
SQLAuthenticate users* userset
SQLConnectInfo vftp dbadmin dcf1330
#SQLUserInfo users userid clear “uid” “gid” homedir shell
SQLNamedQuery userinfo FREEFORM “SELECT userid, clear, uid, gid, homedir, shell
The problem is now, that those files that are uploaded by ftp get owned by uid 65533 instead of the uid defined in the SQL table, whereas the gid is being set correctly. Example:
-rw-r–r– 1 65533 2101 14838 2007-06-11 15:34 front.jpg
Both, uid and gid, have the same value within the database (exampel is “2101” here), but only gid will be used correctly by proftpd when uploading files. I would prefer to use usrquota instead of grpquota, though.
I’m appreciating tips to solve this problem or to confirm that this is a proftpd bug! 🙂