vicidial_campaign_stats not updated

[PierreDeux]

Hi
I've just performed a big update from 2.4 to 2.8.
I have installed completely new web and dialer servers using vicibox 5.0.03 ISO and updated old DB using .sql files, coming with vicibox.
Now it's VERSION: 2.8-409a BUILD: 130809-1410. Everything works fine, except realtime and brief campaign stats ("8 Day outbound call count for this campaign"). Real time is constantly 0 (both outbound and inbound calls are not counted), as for "8 day outbound" - this block is completely missing in my campaign settings page. I've checked the DB - it's fine and has no problems, server log does not contain anything suspicious too. I've tried to force campaign stats refresh - no luck here too, it's still "Y" and realtime is still with 0 instead of today's stats.
I have vicidial_campaign_stats and vicidial_campaign_server_stats tables in my db, both are fine, however vicidial_campaign_stats is not updated at all.
Any ideas how I can fix that?

[PierreDeux]

I forgot to mention that both Outbound calling report and Inbound daily reports are showing correct numbers for today (so I believe vicidial_log table is fine).

[PierreDeux]

Just found multiple records like this in logs:
[Sun Nov 03 13:12:34 2013] [error] [client X.X.X.X] PHP Warning: mysqli_query() expects parameter 1 to be mysqli, string given in /srv/www/htdocs/agc/functions.php on line 1554, referer: http://mydomain.com/agc/vicidial.php

[PierreDeux]

I was able to fix mysqli error, however it was not a reason for realtime issue

[PierreDeux]

So I found the issue:
vicibox-install incorrectly sets up cron and keepalive values for the first server in the cluster. Keepalive values are missing 5 and 7.

[williamconley]

Unless of course the new Vicibox installer would put that on the DB server ... which you did not install with this version of the installer.

Good post back!

[arunvsadnikov]

Great post back, I was trying to figure out similar issue in our cluster and your post saved my day. @PierreDeux