Bandwidth counter screwed up

Yesterday my bandwidth screwed up for all sites
yesterdays bandwidth got multiplied by about 1000 before it got counted
eg. yesterday total bandwidth for this month was 75GB today its 50021GB!!!! and the MRTG is normal so it is a mistake (possibly by upgrading to cpanel 6 and then the auto update downgraded it back to 5.3)

I know cpanel keeps the apache log files and i know where it is
I really dont want to have to write a script to process the log files for apache and change the value of the bandwidth usage in /var/cpanel/bandwidth

Is there something i can run that will recalculate the bandwidth without me having to write my own?

--
Eric

 

i made a script to recalculate the bandwidth
since other have this problem i will post it here too

must be run as root
it wont count as much traffic as cpanel did for some reason but its better then nothing

backup your /var/cpanel/bandwidth first
cpanel 6 seems to count bandwidth fine, just the first time after upgrading it doesnt work


#!/usr/bin/perl

opendir (DIR,&/var/cpanel/users&
while ($fileName = readdir(DIR)) {
next if ($fileName !~ /\w/);
$ls[$x] = $fileName;
$x+=1;
}
closedir(DIR);

$grandtotal = &0&;

foreach $acc (@ls){
next if $acc eq &&;

open (FILE,&/var/cpanel/users/$acc&
@lines =&FILE&;
close (FILE);

foreach $line (@lines){
$line =~ s/\n//g;
$line =~ s/\r//g;
($name,$value) = split(/\=/,$line);

if ($name ne &DNS&amp{
($x,$y) = split(/DNS/,$name);
if ($y ne &&amp{
$userdomains = &$userdomains|$value&;
}
} else {
$userdomains = &$value&;
}
}

(@domains) = split(/\|/,$userdomains);

$totalbw = &0&;
foreach $domain (@domains){
$thisdomain = &0&;
if (-e &/usr/local/apache/domlogs/$domain&amp{
open (FILE,&/usr/local/apache/domlogs/$domain&
@logfile =&FILE&;
close (FILE);

foreach $logline (@logfile){
($crap,$crap,$useful) = split(/\&/,$logline);
($crap,$crap,$bytes) = split(/\ /,$useful);
if ($bytes !~ /^[0-9]*$/i){
} else {
if ($bytes & 0){
$bytes = $bytes - $bytes - $bytes;
}

if ($bytes & 0){
$bytes = &0&;
}

$thisdomain = $thisdomain + $bytes;
$totalbw = $totalbw + $bytes;
$grandtotal = $grandtotal + $bytes;
}
}

@logfile = ('','');

open (FILE,&/var/cpanel/bandwidth/$domain&
@bwlines =&FILE&;
close (FILE);

$newfile = &&;
foreach $bwline (@bwlines){
$bwline =~ s/\n//g;
$bwline =~ s/\r//g;

($mon,$bytes) = split(/\=/,$bwline);

if ($mon eq &01.2003&amp{
$bwline = &01.2003=$thisdomain&;
}

$newfile = &$newfile$bwline\n&;
}

open (FILE,&&/var/cpanel/bandwidth/$domain&
print FILE &$newfile&;
close (FILE);
$newfile = &&;
}
}

$newfile = &&;
open (FILE,&/var/cpanel/bandwidth/$acc&
@bwlines =&FILE&;
close (FILE);

foreach $bwline (@bwlines){
$bwline =~ s/\n//g;
$bwline =~ s/\r//g;

($mon,$bytes) = split(/\=/,$bwline);

if ($mon eq &01.2003&amp{
$bwline = &01.2003=$totalbw&;
}

$newfile = &$newfile$bwline\n&;
}

open (FILE,&&/var/cpanel/bandwidth/$acc&
print FILE &$newfile&;
close (FILE);
$newfile = &&;

}

 

no dont replace anything
just run it

/var/cpanel/bandwidth is a directory
you should backup its contents before running that script

 

weird...
mine works fine now
it was only the first time

maybe try what happened to me

downgrade cpanel 6.0 to 5.3 using the update function in WHM
and then install 6.0 again over it

 

ahh thats whats causing it
upgrade back to 6.0

i think when you downgrade it keeps the bandwith counter from 6.0 or something

because thats what happened to me
i upgraded to 6.0 but i had my server set to auto update and STABLE releases, so it downgraded me to 5.3 automatically

6.0 works fine, but if you try to downgrade it then it causes this problem

 

The script i posted before was specifically written to fix the problem with Janauarys bandwidth

If your running it this month be sure to change where i have written 01.2003 to 02.2003 otherwise it will screw up

 

try restoring a httpd.conf from a few days ago when everything was working (unless you recently added new domains)

cpanel keeps multiple backups of httpd.conf every time it changes it
look in /usr/local/apache/conf (i think thats right)

what script is it that is terminating?

 

It probably means your server ran out of memory
That script loads the apache log files into memory so it will take a huge amount of memory to run the script

I just made it as a quick fix, so this didnt matter to me because i only needed to run it once