Statistics not compiling.

[nenad]

Is there something wrong within this crontab file?

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

[falko]

No, it's looking good.

[Mountainman]

Got a similar/same problem here...

I installed ISPConfig on Debian Sarge according to the Perfect Setup Guide.

When I want to view website statistics ( and yes the site has been visited...), I go to http://website.com/stats and log in with a correct Username / Pass. After I logged in I'm presented with a 403.

When I look into the stats-dir, it appears to be empty ( together with it's web# directory ).

I did a grep on cron-errors in /var/log/syslog and /var/log/messages, in syslog it says:

Jun  4 00:02:01 highmountain /USR/SBIN/CRON[9720]: (logcheck) CMD (   if [ -x /usr/sbin/logcheck ]; then nice -n10 /usr/sbin/logcheck; fi)
Jun  4 00:09:01 highmountain /USR/SBIN/CRON[10587]: (root) CMD (  [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxlifetime) -print0 | xargs -r -0 rm)
Jun  4 00:17:01 highmountain /USR/SBIN/CRON[10706]: (root) CMD (   run-parts --report /etc/cron.hourly)
Jun  4 00:39:01 highmountain /USR/SBIN/CRON[10999]: (root) CMD (  [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxlifetime) -print0 | xargs -r -0 rm)
Jun  4 01:02:01 highmountain /USR/SBIN/CRON[11308]: (logcheck) CMD (   if [ -x /usr/sbin/logcheck ]; then nice -n10 /usr/sbin/logcheck; fi)
Jun  4 01:09:01 highmountain /USR/SBIN/CRON[12159]: (root) CMD (  [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxlifetime) -print0 | xargs -r -0 rm)
Jun  4 01:17:01 highmountain /USR/SBIN/CRON[12274]: (root) CMD (   run-parts --report /etc/cron.hourly)
Jun  4 01:30:22 highmountain crontab[12466]: (root) BEGIN EDIT (root)
Jun  4 01:31:03 highmountain crontab[12466]: (root) REPLACE (root)
Jun  4 01:31:03 highmountain crontab[12466]: (root) END EDIT (root)

The grep on /var/log/messages doesn't show anything.

Then I did the /etc/init.d/cron stop and the pkill cron, crontab -e and a save of the crontab. After 24 hours stats still won't compile.

When I do a :

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

The shell doesn't give any feedback...

[till]

Originally Posted by Mountainman

When I do a :

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

The shell doesn't give any feedback...

How long did you wait? It may take half an hour or longer, depending on the traffic of your sites. Did the cursor return?

Please post the output of:

ls -la /var/log/httpd

[falko]

Is webalizer installed? What's the output of

which webalizer

?

[Mountainman]

@ Till:

the cursor returned almost instantly

ls -la /var/log/httpd:

total 9184
drwxr-xr-x   2 root root    4096 2006-06-04 02:53 .
drwxr-xr-x  13 root root    4096 2006-06-03 06:25 ..
lrwxrwxrwx   1 root root      46 2006-06-04 02:53 ispconfig_access_log -> /var/l                                                 og/httpd/ispconfig_access_log_2006_06_04
-rw-r--r--   1 root root    5269 2006-05-29 23:43 ispconfig_access_log_2006_05_2                                                 9
-rw-r--r--   1 root root 1006171 2006-05-30 23:59 ispconfig_access_log_2006_05_3                                                 0
-rw-r--r--   1 root root 2486815 2006-05-31 23:59 ispconfig_access_log_2006_05_3                                                 1
-rw-r--r--   1 root root 3364061 2006-06-01 23:57 ispconfig_access_log_2006_06_0                                                 1
-rw-r--r--   1 root root  940818 2006-06-02 23:19 ispconfig_access_log_2006_06_0                                                 2
-rw-r--r--   1 root root  671685 2006-06-03 23:56 ispconfig_access_log_2006_06_0                                                 3
-rw-r--r--   1 root root  883059 2006-06-04 20:26 ispconfig_access_log_2006_06_0                                                 4

@Falko:

yes I've got webalizer installed;

which webalizer:

/usr/bin/webalizer

[till]

Please run the script:

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

Did you get any errors? If not, run the webalizer script afterwards:

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

[Mountainman]

Hi Till,

I did get some errors :

Warning: include(/home/admispconfig/ispconfig/lib/config.inc.php): failed to open stream: Permission denied in /root/ispconfig/scripts/lib/config.inc.php on line 30

Warning: include(): Failed opening '/home/admispconfig/ispconfig/lib/config.inc.php' for inclusion (include_path='.:') in /root/ispconfig/scripts/lib/config.inc.php on line 30
Could not connect to MySQL server!

What should i do?

[falko]

What's the output of

ls -la /home/admispconfig/ispconfig/lib

?

[Mountainman]

highmountain:/# ls -la /home/admispconfig/ispconfig/lib
total 76
drwxr-xr-x  6 admispconfig admispconfig  4096 2006-05-29 11:46 .
drwxr-xr-x  8 admispconfig admispconfig  4096 2006-06-05 13:08 ..
-rwxr-xr-x  1 admispconfig admispconfig  6340 2006-05-22 22:17 app.inc.php
-rwxr-xr-x  1 admispconfig admispconfig  1768 2006-05-22 22:17 banner.inc.php
drwxr-xr-x  2 admispconfig admispconfig  4096 2006-05-22 22:17 classes
-rw-------  1 admispconfig admispconfig  6433 2006-05-29 11:46 config.inc.php
-rwxr-xr-x  1 admispconfig admispconfig   354 2006-05-22 22:17 copyright.inc.php
-rwxr-xr-x  1 admispconfig admispconfig  7502 2006-05-22 22:17 go_info.inc.php
drwxr-xr-x  2 admispconfig admispconfig  4096 2006-05-22 22:17 help
-rwxr-xr-x  1 admispconfig admispconfig   324 2006-05-22 22:17 index.php
drwxr-xr-x  2 admispconfig admispconfig  4096 2006-05-22 22:17 lang
drwxr-xr-x  2 admispconfig admispconfig  4096 2006-05-22 22:17 plugins
-rwxr-xr-x  1 admispconfig admispconfig     5 2006-05-22 22:17 preload.inc.php
-rwxr-xr-x  1 admispconfig admispconfig 11876 2006-05-22 22:17 session.inc.php