ISPconfig is not processing apache logs: the web Traffic overview and stats are gone

[KingBeto]

Hi everyone!
I have a very big problem.. My ISPconfig is not processing the Apache Logs.
Therefore the system does not have any web statistics and the Traffic overview is wrong since it is only processing ftp and email traffic.

Here I have an example. Note that the web traffic is not processed, but I have the same amount of visits in Google Analytics each month:

Month, Web, FTP, Mail, Overall
11/2009:, 0.00, 9.65, 29.74, 39.38
10/2009:, 0.00, 26.41, 33.20, 59.61
09/2009:, 9756.34, 21.90, 40.51, 9818.74
08/2009:, 428163.42, 1999.26, 69.78, 430232.46


I checked the apache httpd.conf and everything is ok... And I checked the web.log file that the apache generates and it is OK too.

Since the ISPconfig is not processing the web.log file, it does not delete old logs after the rotation, so old logs are accumulating and using all the disc space..

Does anyone had the same problem? Any Idea of what should I do?? I'm lost and it is a very serious problem for me! Thank you!!

[till]

Please post the output of:

crontab -l

[KingBeto]

# crontab -l
1 1 * * * /scripts/snapshot-adverit.sh
1 2 * * * /scripts/snapshot-mysql.sh
0 4 * * * /root/ispconfig/php/php /root/ispconfig/scripts/shell/awstats.php &> /dev/null
30 00 * * * /root/ispconfig/php/php /root/ispconfig/scripts/shell/logs.php &> /dev/null
59 23 * * * /root/ispconfig/php/php /root/ispconfig/scripts/shell/ftp_logs.php &> /dev/null
59 23 * * * /root/ispconfig/php/php /root/ispconfig/scripts/shell/mail_logs.php &> /dev/null
59 23 * * * /root/ispconfig/php/php /root/ispconfig/scripts/shell/cleanup.php &> /dev/null
0 4 * * * /root/ispconfig/php/php /root/ispconfig/scripts/shell/webalizer.php &> /dev/null
0,30 * * * * /root/ispconfig/php/php /root/ispconfig/scripts/shell/check_services.php &> /dev/null
15 3,15 * * * /root/ispconfig/php/php /root/ispconfig/scripts/shell/quota_msg.php &> /dev/null
40 00 * * * /root/ispconfig/php/php /root/ispconfig/scripts/shell/traffic.php &> /dev/null
05 02 * * * /root/ispconfig/php/php /root/ispconfig/scripts/shell/backup.php &> /dev/null
41 5 * * * /etc/webmin/cron/tempdelete.pl

Thank you!

[till]

Please run this command as root:

/root/ispconfig/php/php /root/ispconfig/scripts/shell/logs.php

and when it is finished, run:

/root/ispconfig/php/php /root/ispconfig/scripts/shell/webalizer.php

Do you get any errors?

[KingBeto]

Here it is. Please Note that for some reason, the ispconfig creates junk folders in the /var/www folder.
Like the folder "/var/www/foPath.2; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; OfficeLiveConnector.1.3;fficeLivePatch.0.0)" without quotes.



root@azul:~# /root/ispconfig/php/php /root/ispconfig/scripts/shell/logs.php

Warning: readlink(): Invalid argument in /root/ispconfig/scripts/shell/logs.php on line 125

Warning: readlink(): Invalid argument in /root/ispconfig/scripts/shell/logs.php on line 125
sh: -c: line 0: syntax error near unexpected token `)'
sh: -c: line 0: `chown -R 0:web0 /var/www/foPath.2; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0)"'



root@azul:~# /root/ispconfig/php/php /root/ispconfig/scripts/shell/webalizer.php
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
[...]

Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
Warning: Truncating oversized referrer field
15194 records (15194 ignored) in 3.00 seconds, 5064/sec
359872 records (359872 ignored) in 76.50 seconds, 4704/sec
2182 records (2182 ignored) in 0.00 seconds
57468789 records (57468789 ignored) in 94860.50 seconds, 605/sec
root@azul:~#

[till]

There is strange directory in /var/www/ which causes the script to stop. Please take a look in /var/www/, there must be a directory with the name "foPath.2; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0)". Delete that directory and run the scripts again.