[solved]Problem with ispcp-vrl-traff

[deptrai]

Recently, My Mysql server has died very often.
I checked processes and see that ispcp-vrl-traff was used 30-->55% of my 1Gb memory.

I tried killing that process and my memory rate returned as normal.

Please help me to fix that problem.

[BeNe]

This script counts the Traffic for your Domains.
You can find/edit it in the Cron and set it to a better time for you.
-> /etc/cron.d/ispcp

Code:

# Traffic
0,30    *       *       *       *  root /var/www/ispcp/engine/traffic/ispcp-srv-traff &>/var/log/ispcp/ispcp-srv-traff.log
0,30    *       *       *       *  root /var/www/ispcp/engine/traffic/ispcp-vrl-traff &>/var/log/ispcp/ispcp-vrl-traff.log
15,45   *       *       *       *  root /var/www/ispcp/engine/traffic/ispcp-vrl-traff-correction &>/var/log/ispcp/ispcp-vrl-traff-correction.log
30         23   *       *       *  root /var/www/ispcp/engine/tools/ispcp-httpd-logs-mngr &>/var/log/ispcp/ispcp-httpd-logs-mngr.log

Greez BeNe

[deptrai]

I installed ispcp-omega-1.0.0-rc2c
And in /ect/cron.d directory, there isn't a ispcp file. This directory contains 3 files:

awstats, ispcp.phpemp, php5

Content of ispcp.phpemp:

09,39 * * * * root /var/www/ispcp/engine/tools/ispcpphptemp.sh >/dev/null 2>&1

[BeNe]

Ok - this was changed in the new Version.
Try

Code:

# crontab -e

Greez BeNe

[deptrai]

I found in /etc/ispcp/crontab and /etc/ispcp/crontab/working the file crontab.conf.
But the syntax of this file:

Code:

# delayed tasks START.

# Quota
0               23              * * *  {QUOTA_ROOT_DIR}/ispcp-dsk-quota &>{LOG_DIR}/ispcp-qsk-quota.log

# Traffic
0,30    *               * * *  {TRAFF_ROOT_DIR}/ispcp-srv-traff &>{LOG_DIR}/ispcp-srv-traff.log
0,30    *               * * *  {TRAFF_ROOT_DIR}/ispcp-vrl-traff &>{LOG_DIR}/ispcp-vrl-traff.log
15,45   *               * * *  {TRAFF_ROOT_DIR}/ispcp-vrl-traff-correction &>{LOG_DIR}/ispcp-vrl-traff-correction.log
30              23              * * *  {TOOLS_ROOT_DIR}/ispcp-httpd-logs-mngr &>{LOG_DIR}/ispcp-httpd-logs-mngr.log

# Backup
0               1               * * *  {BACKUP_ROOT_DIR}/ispcp-backup-all yes &>{LOG_DIR}/ispcp-backup-all-mngr.log

# AWStats
30      */2     * * *   /usr/share/awstats/tools/awstats_updateall.pl now -awstatsprog=/usr/lib/cgi-bin/awstats/awstats.pl

# Rootkit Hunter
0               0,12    * * *   rkhunter --createlogfile --cronjob

# [{DMN_NAME}] backup task START.
# [{DMN_NAME}] backup task END.

# delayed tasks END.

That abnormal command syntax causes crontab not execute the ispcp-vrl-traff..

Or, may be i'm wrong

[BeNe]

This is the wrong file. You found the template.
What about this:

Code:

# crontab -e

Greez BeNe

[deptrai]

Oh yeah, i found this.
I forgot sudo in the beginning of the command:

Code:

# delayed tasks START.

# Quota
0               23              * * *  /var/www/ispcp/engine/quota/ispcp-dsk-qu$

# Traffic
0,30    *               * * *  /var/www/ispcp/engine/traffic/ispcp-srv-traff &>$
0,30    *               * * *  /var/www/ispcp/engine/traffic/ispcp-vrl-traff &>$
15,45   *               * * *  /var/www/ispcp/engine/traffic/ispcp-vrl-traff-co$
30              23              * * *  /var/www/ispcp/engine/tools/ispcp-httpd-$
...... continued..

I'm trying to edit it...