WindfluechterNet Blog

UPDATE:
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:

Table “public.users”
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) |
Indexes:
“userid_pkey” PRIMARY KEY, btree (userid)
“users_uid_key” UNIQUE, btree (uid)
“users_userid_key” UNIQUE, btree (userid)

Proftpd.conf:

[…]
RequireValidShell off
DefaultRoot /home/%u
AuthOrder mod_sql.c
#PostgresInfo localhost dbadmin dcf1330 vftp
SQLAuthTypes Plaintext
SQLAuthenticate users* userset
SQLConnectInfo vftp dbadmin dcf1330
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserGID 2100000
SQLMinUserUID 400000000
#SQLUserInfo users userid clear “uid” “gid” homedir shell
SQLNamedQuery userinfo FREEFORM “SELECT userid, clear, uid, gid, homedir, shell
SQLUserInfo custom:/userinfo

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! 🙂