HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   again on webalizer stats (http://www.howtoforge.com/forums/showthread.php?t=7231)

gilas 3rd October 2006 10:51

again on webalizer stats
 
Dear Falko and folks,
this is a very annoying problem. Some months ago I installed successfully ispconfig and webalizer. Then I reinstalled ispconfig 2.2.6 and since installation webalizer seems not work propely.

I tried all you suggest: edit crontab etc., waited for 24 hours and then ran the php program to force the system to a manual creation of the records:

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

(CLI mode), nothing appears.

Then I tried to restart ispconfig, none -- and check log errors (/var/log/messages), give a wich webalizer command.

All seems to be really OK, I can login and view the stats, but the stats are not update..... could you help me??

Thank you....

till 4th October 2006 10:12

Quote:

php /root/ispconfig/scripts/shell/webalizer.php
This is not correct, you use the wrong PHP binary! The correct command is:

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

But you will have to run the logsplit script (logs.php) before you run the webslizer script.

gilas 4th October 2006 11:40

none....
 
I ran:
/root/ispconfig/php/php -q /root/ispconfig/scripts/shell/logs.php

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

but nothing seems appear.... no logs on video... just less than half second the linux prompt returns, but no messages or other...

what can I do more?

falko 4th October 2006 17:45

What's the output of
Code:

df -h
?

Jack98 6th October 2006 03:43

Same problem
 
I have the same problem here. Same origin, same results. Have performed same tests with same results.

The result of my df -h is:

/dev/mapper/VolGroup00-LogVol00
179G 5.0G 165G 3% /
/dev/sda1 99M 14M 80M 15% /boot
/dev/shm 474M 0 474M 0% /dev/shm

Thanks, Jack

Jack98 6th October 2006 05:18

Fixed it
 
Hello all again,

I have fixed it. The problem seemed to be that in my last update, ispconfig have updated the script (webalizer.php in this case) and not the ispconfig tables in the DB. So webalizer.php was checking in the table for a new field in the table isp_isp_web called webalizer_stats to have value 1, but that field was not in my table. So just added it, filled it with 1's and it worked!

Then I have manually created temporary symbolic links of /homw/www/www.mysite.com/log/web.log to the months I lost... and run webalizer again...

logs.php restored the links after that (I previously have deleted them all)

Any question? just post...

Jack
http://www.latinexperts.com

gilas 6th October 2006 16:16

thanks!
 
Just solved like Jack98 suggest.... unfortunately some days ago I added a table named: 'webalizer_stat' and not ' webalized_stats' so that ISPConfig was not running as expected.
Now I've updated the tables manually and all seems to work....

thank you again!


All times are GMT +2. The time now is 12:20.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.