#1  
Old 31st March 2009, 22:51
andypl andypl is offline
Member
 
Join Date: Mar 2006
Location: Radom, Poland
Posts: 93
Thanks: 1
Thanked 1 Time in 1 Post
Default Quota FTP

Hi

I have problem with quota size on pure-ftpd, debian 5 lenny, ISPConfig 3.0.1.
Set the Quota for website 100MB then customer adding ftp account with 1GB quota why ?
Next problem is customer create ftp account with 1MB quota the connecting to ftp like this account and uploading 2MB files why? if this user have only 1MB quota ?

Best Regards

EDIT:

Ok i resolve problem with reading quota size by pure-ftpd.
I still do not know why the customer can create account with ftp quota greater than the quota for the website

Solution to the problem of quota in the pure-ftpd:
I comment this line and change option from quota_files != '-1' to quota_files = '-1' in mysql.conf and limits for ftp session is now ok.

What is the option and what it serves? - quota_files != '-1'

#MySQLGetQTASZ SELECT quota_size FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files != '-1' AND username="\L"
MySQLGetQTASZ SELECT quota_size FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files = '-1' AND username="\L"


# Optional : ratios. The server has to be compiled with ratio support.

#MySQLGetRatioUL SELECT ul_ratio FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files != '-1' AND username="\L"
#MySQLGetRatioDL SELECT dl_ratio FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files != '-1' AND username="\L"

MySQLGetRatioUL SELECT ul_ratio FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files = '-1' AND username="\L"
MySQLGetRatioDL SELECT dl_ratio FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files = '-1' AND username="\L"


# Optional : bandwidth throttling.
# The server has to be compiled with throttling support.
# Values are in KB/s .

#MySQLGetBandwidthUL SELECT ul_bandwidth FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files != '-1' AND username="\L"
#MySQLGetBandwidthDL SELECT dl_bandwidth FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files != '-1' AND username="\L"

MySQLGetBandwidthUL SELECT ul_bandwidth FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files = '-1' AND username="\L"
MySQLGetBandwidthDL SELECT dl_bandwidth FROM ftp_user WHERE active = 'y' AND server_id = '2' AND quota_files = '-1' AND username="\L"

Last edited by andypl; 31st March 2009 at 23:34.
Reply With Quote
Sponsored Links
  #2  
Old 1st April 2009, 08:29
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,981
Thanks: 825
Thanked 5,371 Times in 4,218 Posts
Default

You missed to configure your harddisk were you stored the files for Linux usrquota and groupquota as described in the perfect setup guides for ispconfig 3.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 1st April 2009, 09:31
andypl andypl is offline
Member
 
Join Date: Mar 2006
Location: Radom, Poland
Posts: 93
Thanks: 1
Thanked 1 Time in 1 Post
Default

I do not think. I installed correctly quota
my fstab:

/ dev/hda3 on / type ext3 (rw, usrquota, grpquota, errors = remount-ro)

v2: ~ # ls-la /
total 109
drwxr-xr-x 22 root root 4096 Mar 31 11:49.
drwxr-xr-x 22 root root 4096 Mar 31 11:49 ..
-rw ------- 1 root root 10240 Mar 31 12:25 aquota.group
-rw ------- 1 root root 9216 Mar 31 23:06 aquota.user
Reply With Quote
  #4  
Old 1st April 2009, 09:44
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,981
Thanks: 825
Thanked 5,371 Times in 4,218 Posts
Default

But the quota system would not have allowed the user to store more files then and this is independant of all pureftpd settings. Something in your quota system seems not to be setup correctly.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 1st April 2009, 10:43
andypl andypl is offline
Member
 
Join Date: Mar 2006
Location: Radom, Poland
Posts: 93
Thanks: 1
Thanked 1 Time in 1 Post
Default

It can scan the disk but it shows me like this

quotacheck -avugm
quotacheck: Your kernel probably supports journaled quota but you are not using it. Consider switching to journaled quota to avoid running quotacheck after an unclean shutdown.
Reply With Quote
  #6  
Old 1st April 2009, 11:24
andypl andypl is offline
Member
 
Join Date: Mar 2006
Location: Radom, Poland
Posts: 93
Thanks: 1
Thanked 1 Time in 1 Post
Default

Ok this is a solution to the problem of quota under debian lenny with journaled quota
- new kernel - without journal quote enable
- edit the file fstab:
/ dev/hda3 / ext3 usrjquota = aquota.user, grpjquota = aquota.group, jqfmt = vfsv0, errors = remount-ro 0 1
Maybe someone this solution helpful
Reply With Quote
  #7  
Old 1st April 2009, 11:57
andypl andypl is offline
Member
 
Join Date: Mar 2006
Location: Radom, Poland
Posts: 93
Thanks: 1
Thanked 1 Time in 1 Post
 
Default

Quota size determines the maximum size for one file is transferred to the ftp server for example, set 1MB quota but the customer can send 15 files of 0.5 M because the file size is less than 1M
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Troubleshooting FTP bswinnerton Installation/Configuration 4 10th October 2008 19:34
proFTPd passive mode problems bisbell Server Operation 8 6th August 2008 21:12
Question about Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Debian Etch ikkem HOWTO-Related Questions 30 26th February 2008 19:38
ftp problems tgansert Installation/Configuration 20 27th May 2006 19:06
Website users? ctroyp General 25 6th January 2006 18:02


All times are GMT +2. The time now is 17:53.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.