Proftpd setup with virtual user access and quota

Marco Segreto msegreto at sfsu.edu
Wed Jun 10 04:39:45 UTC 2009


Hi.

I've set up proftpd a guide which setups up ftp with virtual user 
accounts which are kept using a mysql database. I also set up quota to 
log in information for users. I got the user names and passwords to work 
but am still having problems getting the quota data to work, nothing is 
being populated in the mysql database after a user uploads files. There 
should also be a posting in the ftp client from the server on how much 
available space the user has but this doesn't show up either.

To configure proftpd I used both proftpd.conf and sql.conf and tried to 
put the correct directions in both files. In proftpd.conf I have the 
quota info:
    <IfModule mod_quotatab.c>
    QuotaEngine on
    QuotaDirectoryTally on
    QuotaDisplayUnites Mb
    QuotaShowQuotas on
    QuotaLimitTable sql:/get-quota-limit
    blah blah blah
    </IfModule>

In sql.conf I have all the rules so protfpd puts the correct information 
into the mysql database. These rules are long but start with:
    SQLNamedQuery
and are mysql commands for SELECTING and UPDATING.

It seems like quota isn't running at all on the ftp server. Any 
suggestions? SHoudl I move the IfModule mod_quotatab.c to sql.conf?




More information about the ubuntu-users mailing list