Stats not updating for 1 account only

[fishfreek]

This server is running cPanel Build 9.7.2-CURRENT 11. Stats seem to update for every account but 1. When I run the runweblogs script and try to manually run the stast for this account I get the following message.

Webalizer V2.01-10 (Linux 2.4.21-9.0.1.ELsmp) English
Using logfile /usr/local/apache/domlogs/ftp.thc-ministry.net-ftp_log (ftp)
DNS Lookup (10): None to process
Using DNS cache file /home/thc-mini/tmp/webalizerftp/dns_cache.db
Creating output in /home/thc-mini/tmp/webalizerftp
Hostname for reports is 'ftp.thc'
Reading history file... webalizer.hist
Reading previous run data.. webalizer.current
No valid records found!
Complete

The user reports stats failing to update once we upgraded to the build of cpanel that we are currently using. When I visit the new Stats Confiruation applet Webalizer, Analog and Awstats are all checked. When I manually run stats on any other account on that server the process completes with out a problem.

The account is not in risk of being over their alloted disk space so I am somewhat at a loss as to whats going on.

[fishfreek]

To update I did a /upcp --force and updated to version 9.7.3-C4 but I still get the same result.

When looking in the accounts /log/ folder the log files are being updated as they all have the time/date stamp of today.

[vivek]

The user reports stats failing to update once we upgraded to the build of cpanel that we are currently using. When I visit the new Stats Confiruation applet Webalizer, Analog and Awstats are all checked. When I manually run stats on any other account on that server the process completes with out a problem.


In order to update the awstats in cpanel / whm server use the following commands

Check this :

1. Login to shell
2. cd /home/username/tmp/awstats
3. locate awstats.pl
4. cp /usr/local/cpanel/base/awstats.pl .
5. chown usrname:usrname awstats.pl
6. perl awstats.pl - config=domain - update
7. Check awstats in cpanel now.

---------------------------------------

Awstats problem - doesn't display full summary stats!

http://forums.cpanel.net/showthread....369#post133369



Link for awstats

http://freshmeat.net/redir/awstats/1...wstats-5.6.tgz

Also visit the link

http://awstats.sourceforge.net



Enjoy !!!

Vivek

[fishfreek]

How will chown'ing the awstats.pl script affect the other 100+ accounts on the server when it comes to stat compulation? Also how will this fix webalizer and analog stats that dont comple for this user?

[cPanelBilly]

please login as root to sheel and type /scripts/runweblogs
then enter the username.
Paste the output here.

[Dillard]

As today a client told me we have the same issue. Most accounts update their stats normally, except for a few. Once we ran /scripts/runweblog sometimes awstats was updated, but webalizer still not. I will include the output here:

bach# /scripts/runweblogs
Log checker loaded ok..
What user's logs did you want to update? jbproduc
==> Loading Config (cpanellogd) .... Done
==> cpaneld(logger) 8.0 Starting (1 processor system).....
==> Shared RRDTOOL support enabled
Processing jbproduc...
[add subdomain] jbproduc personeel.jbproductions.nl
[add subdomain] jbproduc peter.jbproductions.nl
[add subdomain] jbproduc office.jbproductions.nl
Run Logs jbproduc,jbproductions.nl,3145728000,personeel.jbproductions.nl peter.jbproductions.nl office.jbproductions.nl
LANGUAGE: english /usr/local/cpanel/lang/.english
Update status for /var/cpanel/bandwidth/jbproduc-http.rrd: (26)
Processing exim stats for jbproduc.......Done
Update status for /var/cpanel/bandwidth/jbproduc-all.rrd: (26)
LANGUAGE: english /usr/local/cpanel/lang/.english
Archive Status: 0
About to fork() [ALL DOMAINS: personeel.jbproductions.nl peter.jbproductions.nl office.jbproductions.nl]
Webalizer V2.01-10 (FreeBSD 5.1-RELEASE-p16) English
Using logfile /usr/local/apache/domlogs/jbproductions.nl (clf)
DNS Lookup (10): Error: Unable to open DNS cache file /home/jbproduc/tmp/webalizer/dns_cache.db
Creating output in /home/jbproduc/tmp/webalizer
Hostname for reports is 'jbproductions.nl'
Reading history file... webalizer.hist
Reading previous run data.. webalizer.current
Error: Unable to restore run data (12)
Webalizer V2.01-10 (FreeBSD 5.1-RELEASE-p16) English
Using logfile /usr/local/apache/domlogs/personeel.jbproductions.nl (clf)
DNS Lookup (10): Error: Unable to open DNS cache file /home/jbproduc/tmp/webalizer/dns_cache.db
Creating output in /home/jbproduc/tmp/webalizer/personeel.jbproductions.nl
Hostname for reports is 'personeel.jbproductions.nl'
Reading history file... webalizer.hist
Reading previous run data.. webalizer.current
No valid records found!
Webalizer V2.01-10 (FreeBSD 5.1-RELEASE-p16) English
Using logfile /usr/local/apache/domlogs/peter.jbproductions.nl (clf)
DNS Lookup (10): Error: Unable to open DNS cache file /home/jbproduc/tmp/webalizer/dns_cache.db
Creating output in /home/jbproduc/tmp/webalizer/peter.jbproductions.nl
Hostname for reports is 'peter.jbproductions.nl'
Reading history file... webalizer.hist
Reading previous run data.. webalizer.current
No valid records found!
Webalizer V2.01-10 (FreeBSD 5.1-RELEASE-p16) English
Using logfile /usr/local/apache/domlogs/office.jbproductions.nl (clf)
DNS Lookup (10): Error: Unable to open DNS cache file /home/jbproduc/tmp/webalizer/dns_cache.db
Creating output in /home/jbproduc/tmp/webalizer/office.jbproductions.nl
Hostname for reports is 'office.jbproductions.nl'
History file not found...
Previous run data not found...
No valid records found!
Update for config "/home/jbproduc/tmp/awstats/awstats.jbproductions.nl.conf"
With data in log file "/usr/local/apache/domlogs/jbproductions.nl"...
Phase 1 : First bypass old records, searching new record...
Direct access to last remembered record is out of file.
So searching it from beginning of log file...
Phase 2 : Now process new records (Flush history on disk after 20000 hosts)...
Error: History file "/home/jbproduc/tmp/awstats/awstats072004.jbproductions.nl.txt" is corrupted (End of section VISITOR not found).
Restore a recent backup of this file (data for this month will be restored to backup date), remove it (data for month will be lost), or remove the corrupted section in file (data for at least this section will be lost).
Update for config "/home/jbproduc/tmp/awstats/awstats.personeel.jbproductions.nl.conf"
With data in log file "/usr/local/apache/domlogs/personeel.jbproductions.nl"...
Phase 1 : First bypass old records, searching new record...
Direct access to last remembered record is out of file.
So searching it from beginning of log file...
Jumped lines in file: 0
Parsed lines in file: 0
 Found 0 dropped records,
 Found 0 corrupted records,
 Found 0 old records,
 Found 0 new qualified records.
Update for config "/home/jbproduc/tmp/awstats/awstats.peter.jbproductions.nl.conf"
With data in log file "/usr/local/apache/domlogs/peter.jbproductions.nl"...
Phase 1 : First bypass old records, searching new record...
Direct access to last remembered record is out of file.
So searching it from beginning of log file...
Jumped lines in file: 0
Parsed lines in file: 0
 Found 0 dropped records,
 Found 0 corrupted records,
 Found 0 old records,
 Found 0 new qualified records.
Update for config "/home/jbproduc/tmp/awstats/awstats.office.jbproductions.nl.conf"
With data in log file "/usr/local/apache/domlogs/office.jbproductions.nl"...
Phase 1 : First bypass old records, searching new record...
Searching new records from beginning of log file...
Jumped lines in file: 0
Parsed lines in file: 0
 Found 0 dropped records,
 Found 0 corrupted records,
 Found 0 old records,
 Found 0 new qualified records.
Webalizer V2.01-10 (FreeBSD 5.1-RELEASE-p16) English
Using logfile /usr/local/apache/domlogs/ftp.jbproductions.nl-ftp_log (ftp)
DNS Lookup (10): Error: Unable to open DNS cache file /home/jbproduc/tmp/webalizerftp/dns_cache.db
Creating output in /home/jbproduc/tmp/webalizerftp
Hostname for reports is 'ftp.jbproductions.nl'
Reading history file... webalizer.hist
Reading previous run data.. webalizer.current
No valid records found!
Complete

The errors for dns_cache.db is a strange one, all the dates and time (also for good working accounts) are the same, the userperms are right. so this beats me...

[fishfreek]

What I found was a config file in the /tmp direcotry. I cant recall the name of the confit but it was something like stats.conf. In this file there was the individual stats applications and then either a YES or NO beside them. As best I can guess this file was written with the help of the new stats config feature in cpanel. Now while the stats config feature showed all the stats as being checked when I looked at this config file they where listed as NO. After changing them to YES I reran the stats and everything worked. YOu might want to check there.

[easyhoster1]

Here is the problem

Error: History file "/home/jbproduc/tmp/awstats/awstats072004.jbproductions.nl.txt" is corrupted (End of section VISITOR not found).

Delete awstats072004.jbproductions.nl.txt and then run

/scripts/runweblogs again and this will fix that users stats.

As today a client told me we have the same issue. Most accounts update their stats normally, except for a few. Once we ran /scripts/runweblog sometimes awstats was updated, but webalizer still not. I will include the output here:

bach# /scripts/runweblogs
Log checker loaded ok..
What user's logs did you want to update? jbproduc
==> Loading Config (cpanellogd) .... Done
==> cpaneld(logger) 8.0 Starting (1 processor system).....
==> Shared RRDTOOL support enabled
Processing jbproduc...
[add subdomain] jbproduc personeel.jbproductions.nl
[add subdomain] jbproduc peter.jbproductions.nl
[add subdomain] jbproduc office.jbproductions.nl
Run Logs jbproduc,jbproductions.nl,3145728000,personeel.jbproductions.nl peter.jbproductions.nl office.jbproductions.nl
LANGUAGE: english /usr/local/cpanel/lang/.english
Update status for /var/cpanel/bandwidth/jbproduc-http.rrd: (26)
Processing exim stats for jbproduc.......Done
Update status for /var/cpanel/bandwidth/jbproduc-all.rrd: (26)
LANGUAGE: english /usr/local/cpanel/lang/.english
Archive Status: 0
About to fork() [ALL DOMAINS: personeel.jbproductions.nl peter.jbproductions.nl office.jbproductions.nl]
Webalizer V2.01-10 (FreeBSD 5.1-RELEASE-p16) English
Using logfile /usr/local/apache/domlogs/jbproductions.nl (clf)
DNS Lookup (10): Error: Unable to open DNS cache file /home/jbproduc/tmp/webalizer/dns_cache.db
Creating output in /home/jbproduc/tmp/webalizer
Hostname for reports is 'jbproductions.nl'
Reading history file... webalizer.hist
Reading previous run data.. webalizer.current
Error: Unable to restore run data (12)
Webalizer V2.01-10 (FreeBSD 5.1-RELEASE-p16) English
Using logfile /usr/local/apache/domlogs/personeel.jbproductions.nl (clf)
DNS Lookup (10): Error: Unable to open DNS cache file /home/jbproduc/tmp/webalizer/dns_cache.db
Creating output in /home/jbproduc/tmp/webalizer/personeel.jbproductions.nl
Hostname for reports is 'personeel.jbproductions.nl'
Reading history file... webalizer.hist
Reading previous run data.. webalizer.current
No valid records found!
Webalizer V2.01-10 (FreeBSD 5.1-RELEASE-p16) English
Using logfile /usr/local/apache/domlogs/peter.jbproductions.nl (clf)
DNS Lookup (10): Error: Unable to open DNS cache file /home/jbproduc/tmp/webalizer/dns_cache.db
Creating output in /home/jbproduc/tmp/webalizer/peter.jbproductions.nl
Hostname for reports is 'peter.jbproductions.nl'
Reading history file... webalizer.hist
Reading previous run data.. webalizer.current
No valid records found!
Webalizer V2.01-10 (FreeBSD 5.1-RELEASE-p16) English
Using logfile /usr/local/apache/domlogs/office.jbproductions.nl (clf)
DNS Lookup (10): Error: Unable to open DNS cache file /home/jbproduc/tmp/webalizer/dns_cache.db
Creating output in /home/jbproduc/tmp/webalizer/office.jbproductions.nl
Hostname for reports is 'office.jbproductions.nl'
History file not found...
Previous run data not found...
No valid records found!
Update for config "/home/jbproduc/tmp/awstats/awstats.jbproductions.nl.conf"
With data in log file "/usr/local/apache/domlogs/jbproductions.nl"...
Phase 1 : First bypass old records, searching new record...
Direct access to last remembered record is out of file.
So searching it from beginning of log file...
Phase 2 : Now process new records (Flush history on disk after 20000 hosts)...
Error: History file "/home/jbproduc/tmp/awstats/awstats072004.jbproductions.nl.txt" is corrupted (End of section VISITOR not found).
Restore a recent backup of this file (data for this month will be restored to backup date), remove it (data for month will be lost), or remove the corrupted section in file (data for at least this section will be lost).
Update for config "/home/jbproduc/tmp/awstats/awstats.personeel.jbproductions.nl.conf"
With data in log file "/usr/local/apache/domlogs/personeel.jbproductions.nl"...
Phase 1 : First bypass old records, searching new record...
Direct access to last remembered record is out of file.
So searching it from beginning of log file...
Jumped lines in file: 0
Parsed lines in file: 0
 Found 0 dropped records,
 Found 0 corrupted records,
 Found 0 old records,
 Found 0 new qualified records.
Update for config "/home/jbproduc/tmp/awstats/awstats.peter.jbproductions.nl.conf"
With data in log file "/usr/local/apache/domlogs/peter.jbproductions.nl"...
Phase 1 : First bypass old records, searching new record...
Direct access to last remembered record is out of file.
So searching it from beginning of log file...
Jumped lines in file: 0
Parsed lines in file: 0
 Found 0 dropped records,
 Found 0 corrupted records,
 Found 0 old records,
 Found 0 new qualified records.
Update for config "/home/jbproduc/tmp/awstats/awstats.office.jbproductions.nl.conf"
With data in log file "/usr/local/apache/domlogs/office.jbproductions.nl"...
Phase 1 : First bypass old records, searching new record...
Searching new records from beginning of log file...
Jumped lines in file: 0
Parsed lines in file: 0
 Found 0 dropped records,
 Found 0 corrupted records,
 Found 0 old records,
 Found 0 new qualified records.
Webalizer V2.01-10 (FreeBSD 5.1-RELEASE-p16) English
Using logfile /usr/local/apache/domlogs/ftp.jbproductions.nl-ftp_log (ftp)
DNS Lookup (10): Error: Unable to open DNS cache file /home/jbproduc/tmp/webalizerftp/dns_cache.db
Creating output in /home/jbproduc/tmp/webalizerftp
Hostname for reports is 'ftp.jbproductions.nl'
Reading history file... webalizer.hist
Reading previous run data.. webalizer.current
No valid records found!
Complete

The errors for dns_cache.db is a strange one, all the dates and time (also for good working accounts) are the same, the userperms are right. so this beats me...