Cpanel Bandwidth Statistics Generation
The bandwidth statistics system in cPanel™ uses RRDTool [http://oss.oetiker.ch/rrdtool/] to track the data and generate
resulting graphs and meters. In cPanel™ 11.24 and prior versions, the way the RRDTool data was interpreted by the sys-tem could vary according to which subsystem was examining the data. This often resulted in inconsistent interpretations of the data, as well as missing data.
For cPanel™ 11.25, every aspect of the product that handled RRDTool data was overhauled and consolidated into a single subsystem. The end result is a consistent system that generates reliable and accurate statistics and data.
When customer tries to see statistics from watchdog, an error message appears
Internal error: failed to adjust system time in accordance with daylight savings time change.
Also Watchdog’s cron job reports the error
ERROR: WDExc
Error occurred while processing database query: ‘MySQL query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘group by service_id, type, round(unix_timestamp(time) / 7200, 0) having count(va’ at line 3′
To resolve this issue.
Unzip Parallels Plesk Panel version pack-sysstats and replace the file located in /usr/local/psa/libexec/modules/watchdog/cp/
http://kb.parallels.com/Attachments/14807/Attachments/pack-sysstats-for-9.5-10.zip
Unzip Parallels Plesk Panel version stats-graph and replace the file located in /usr/local/psa/admin/htdocs/modules/watchdog/
http://kb.parallels.com/Attachments/14807/Attachments/stats-graph-for-9.zip
Reference: http://parallels.com/
Cant see the Statistics module icon in the regular account editor.
For Parallels Plesk Sitebuilder for Linux/Unix
All modules icons are there except the statistics. What should I do to be able to access it?
Login to Sitebuilder Control Panel as admin and go to the Modules -> Statistics page.
To activate statistics reporting select check box Enable statistics located in the bottom left corner of the Statistics module screen.
Also, this module is available only for regular sites. It should be accessible in the left column at the Extra step. We need to add this module into an appropriate plan in the Plan Management section.
Reference: http://parallels.com/
stat - display file or file system status
The stat command provides a complete rundown of the status of a file on the filesystem:
With no option, `stat’ reports all information about the given files. But it also can be used to report the information of the file systems the given files are located on. If the files are links, `stat’ can also give information about the files the links point to.
root@dell:~# stat hdd
File: `hdd’
Size: 384 Blocks: 8 IO Block: 4096 regular file
Device: 802h/2050d Inode: 1358293 Links: 1
Access: (0644/-rw-r–r–) Uid: ( 0/ root) Gid: ( 0/ root)
Access: 2010-01-10 17:00:07.000000000 +0530
Modify: 2009-08-01 09:08:16.000000000 +0530
Change: 2009-08-01 09:08:16.000000000 +0530
The results from the stat command show just about everything you’d want to know about the file being examined, even down the major and minor device numbers of the device where the file is being stored.
