Domain Disk and Traffic Usage Report

[FeG]

Hi,

(10-08-2008 07:29 PM)aseques Wrote:  Note: It's too late for this to be added to 1.0.0?

I suppose it is too late, since no new features are applied anymore - afaik. But that has to be decided by developers, not by me...

At least the script is so easy to install that it would be no tragedy if it'll be not added to 1.0.0 ..

Regards
FeG

[DaSilva]

(10-08-2008 06:46 PM)FeG Wrote:  

(10-08-2008 05:13 AM)DaSilva Wrote:  Can you add a date -1 month like:

"=== ispCP - Domain Disk and Traffic Usage Report for 09.2008 ==="

I've added a date to the header, like this:

Code:

=== ispCP - Domain Disk and Traffic Usage Report (YYYY-MM-DD) ===

Quote:because I want to add the cronjob every first day in a month at 0:00.

You shouldn't do this because you'll get zero traffic always... This script reports the traffic of the current months, so you'll have to run it on the last day of each month, but this will be a bit difficult with cron ... you could run it on 28nd of each month, maybe..


Regards
FeG

Thanks, I will try it out.
Now I have added this cronjob:

59 23 31 1,3,5,7,8,10,12 * /etc/ispcp/ispcp-domainreport-cronjob.sh
59 23 30 4,6,9,11 * /etc/ispcp/ispcp-domainreport-cronjob.sh
59 23 28 2 * /etc/ispcp/ispcp-domainreport-cronjob.sh

[victor531]

Hi,
Thanks BeNe, you are right, my script didn't have writing permission, now , it work's fine

Saludos cordiales

Victor

[aseques]

Is there anyone that has updated this script to group the results by distributor?
Having a monthly summary send by mail would be very useful

[BeNe]

Quote:Is there anyone that has updated this script to group the results by distributor?

I know none. But it is more or less a simple SQL Query. You can try to use "ORDER BY"

Greez BeNe

[pgentoo]

Great contribution. I'm sure this (or a version of it) will make it in post 1.0.

Just an FYI, if you are running gentoo, you'll need to install the "mailx" package.

-
pGentoo

[crafter]

I'm not meaning to hijack the thread, but I have created a PHP version that does the same thing and then sends out an email to the customer if there is overusage.

What's missing is the calculation for a reseller, as the reseller would normally be the party that is billed for overusage, which they will pass to their own clients. Also useful for the reseller is to provide a breakdown by owned domains.

Regards
Pradesh

[fulltilt]

nice works - should a daily cron job run the script?

(01-16-2010 09:56 AM)crafter Wrote:  I'm not meaning to hijack the thread, but I have created a PHP version that does the same thing and then sends out an email to the customer if there is overusage.

What's missing is the calculation for a reseller, as the reseller would normally be the party that is billed for overusage, which they will pass to their own clients. Also useful for the reseller is to provide a breakdown by owned domains.

Regards
Pradesh

[crafter]

Yes, fulltilt

I schedule it for midnight:
- In /etc/cron.d/daily/ispcp
---------------------------------------------------------
# resource usage - send email to customer - added by Pradesh - 2009/11/07
@daily root php /var/www/ispcp/engine/tools/usage_reports.php &>/var/log/ispcp/usage_reports.log
---------------------------------------------------------

You can guess that I installed the script in var/www/ispcp/engine/tools/usage_reports.php

[fulltilt]

getting some errors:

Code:

/var/www/ispcp/engine/tools/usage_reports.php: line 1: ?php: No such file or directory
/var/www/ispcp/engine/tools/usage_reports.php: line 3: /backup: is a directory
/var/www/ispcp/engine/tools/usage_reports.php: line 4: razor-agent.log: command not found
/var/www/ispcp/engine/tools/usage_reports.php: line 5: razor-agent.log: command not found
/var/www/ispcp/engine/tools/usage_reports.php: line 6: razor-agent.log: command not found
/var/www/ispcp/engine/tools/usage_reports.php: line 7: razor-agent.log: command not found
/var/www/ispcp/engine/tools/usage_reports.php: line 8: syntax error near unexpected token `('
/var/www/ispcp/engine/tools/usage_reports.php: line 8: ` * Copyright (c) 2009, Datacraft Software'

Warning: Division by zero in /var/www/ispcp/engine/tools/usage_reports.php on line 123

Warning: Division by zero in /var/www/ispcp/engine/tools/usage_reports.php on line 123

Warning: Division by zero in /var/www/ispcp/engine/tools/usage_reports.php on line 123

Warning: Division by zero in /var/www/ispcp/engine/tools/usage_reports.php on line 123