#1  
Old 27th June 2012, 16:39
globiws globiws is offline
Junior Member
 
Join Date: Jun 2012
Posts: 16
Thanks: 0
Thanked 1 Time in 1 Post
Default Quota necessary?

I am looking to use ISPConfig in a production cluster. Since there will be paid support plans soon, this makes it a much more attractive alternative.

Like many, I am installing on virtualized servers - in my case Rackspace cloud servers. And like many, I cannot get quota to work on these machines.

Quotacheck works fine, but quotaon returns multiple errors, including not being supported on the kernel.

Now, I am looking to change my corporate billing process, and move away from traditional hosting "plans", and simply charge for disk space and bandwidth actual usage.

The ISPConfig interface shows bandwidth, but I'm having a few strange behaviours with disk usage, probably due to quota. The usage is not being updated properly, but every now and then, it is.

I'm assuming that real-time updating is not working because quota is not running, but when I run quotacheck, it updates things.

I'm not totally sure yet, because I've only noticed this, and haven't tested all the way.

Can someone please clarify for me how ISPConfig calculates disk space used, and what it needs for this? Is quota required, and what does quota REALLY do? And how does ISPConfig calculate MySQL and mail disk usage?

Thanks,
-Andreas
Reply With Quote
Sponsored Links
  #2  
Old 27th June 2012, 19:37
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,405
Thanks: 834
Thanked 5,496 Times in 4,326 Posts
Default

ISPConfig calls the command !repquota" and displays its output. Thats all.

Quote:
And how does ISPConfig calculate MySQL and mail disk usage?
There is no mysql quota.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 27th June 2012, 19:46
globiws globiws is offline
Junior Member
 
Join Date: Jun 2012
Posts: 16
Thanks: 0
Thanked 1 Time in 1 Post
Default

Thank you.

I have confirmed that it is quotacheck which fixes the stats.

When I ran repquota, it gave wrong readings (old).
After quotacheck, repquota had the correct stats.

Is this supposed to run daily or something? Or do I need to add a cron job to run quotacheck?

Is there a workaround to get the space used by a client's mysql db's?

Cheers,
-Andreas
Reply With Quote
  #4  
Old 28th June 2012, 10:42
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,405
Thanks: 834
Thanked 5,496 Times in 4,326 Posts
 
Default

Quote:
Is this supposed to run daily or something?
Normally it has to be run just once after you installed quota and never again. Seems as quota is broken on your filesystem if you have to run it again.

Quote:
Is there a workaround to get the space used by a client's mysql db's?
Mysql has no quota implemeneted and the mysql databases belong to the mysql user and not web user, so they dont fall under the website quota limit.

The only thing you might do is to write a plugin that queries mysql for the database sizes even if it can not restrict the size or you use the du command on the shell to get the size of the directory which contains the database. But the du command will work only for myisam tables and not innodb.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
Problem with Quota on ubuntu 11.10 /nginx/ISPConfig 3 mattias88 Installation/Configuration 4 21st September 2012 00:38
dovecot start problem veneficus Installation/Configuration 3 10th April 2012 17:39
Cron issue in Debian 6 Nolan Installation/Configuration 6 18th April 2011 16:36
chgrp error new user DKA General 15 28th July 2008 17:45
Problems with copy & paste dspuser Server Operation 3 23rd May 2006 17:21


All times are GMT +2. The time now is 02:19.


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