[Proftpd-user] how is group quota working?

Kai Schaetzl <[email protected]>
Newsgroups gmane.network.proftpd.user
Message-ID <[email protected]>
Hello,

I'm checking out group quota with mod_quota_tab and sql and it doesn't 
seem to work. What am I doing wrong?

I have the table ftp_users, ftp_groups, ftp_quota_limits, 
ftp_quota_tallies, ftp_quota_limits as suggested by documentation and 
several tutorials. I edited them a bit and changed them to my needs. I set 
the NamedQueries accordingly. I can login, it all works fine, but applied 
is always only the user quota (seen with site quota command).

e.g.

ftp_users contains user testme_ftp1
ftp_groups contains a record with groupname=testme and members=testme_ftp1
ftp_quota_limits contains a record for the group testme with a quota_type 
of group. 
But it's not getting used. proftpd looks for name=testme_ftp1 with a 
quota-type of user and wants to insert the same quota_type user to 
tallies. If it can't find the user in limits it uses the default quota 
(and not the group quota). If I add a record for that user it uses the 
quota set there, no matter what I set for the group value.
Shouldn't it rather look for a record name=testme and quota_type=group?

The mysql log shows that it finds the group and also the group of user 
testme_ftp1, but it doesn't look a quota up for it. It doesn't look for 
any quota of type group.

What do I have to do to make it lookup and use the group quota?

Oh, and, btw, is there a list of all (named) variables you can use for sql 
queries? There are some in the examples, but these are only a few, I know 
there are more.

Thanks,

Kai

-- 
Get your web at Conactive Internet Services: http://www.conactive.com




------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
ProFTPD Users List   <[email protected]>
Unsubscribe problems?
http://www.proftpd.org/list-unsub.html
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.