Re: [Proftpd-user] how is group quota working?

> 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

Could you provide the mod_quotatab configuration that you are using?

> 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?

The mod_quotatab module first looks for an applicable user limit.  And then, if it doesn't find one, it looks for an applicable group limit.  And if none found, it looks for an applicable class limit.  Finally, there's the "all" limit.

  http://www.proftpd.org/docs/contrib/mod_quotatab.html#Usage

It sounds like you have an (unexpected?) user limit being found?

> 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.

Most of the LogFormat variables should be usable in SQL queries:
  http://www.proftpd.org/docs/modules/mod_log.html#LogFormat

Hope this helps,
TJ

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