Page 1 of 1

Realtime screen showing time on status wrong

PostPosted: Mon Feb 21, 2011 5:49 am
by fibres
Hi guys

I have just moved one of our customers to a new server.
As per suggestion to a post in support I have used the latest version of Vicibox Redux, and installed using the SVN option.

The install was really easy! Very nice work. Saves a lot of messing about.

Once installed I dropped all the tables from the database, imported the vicidial 1.2 database from our old server and ran the upgrade_2.4.sql file.
I then did the ADMIN_update_server_ip to fix that.

Everything is working great so far except one issue

When I click on the realtime screen every agent is showiong as having been on each status for 300:00 and counts from there instead of 0:00

Can anyone give me an idea of what is causing that

Regards

PostPosted: Mon Feb 21, 2011 12:11 pm
by williamconley
imported the vicidial 1.2 database
there is no vicidial 1.2. you wanna try that again?

did you read the UPGRADE.txt file in your sources folder?

if your prior version was 2.0.5 and you upgraded to 2.4 ... you missed a step. The database must upgrade to 2.2 before 2.4.

if your prior version was 2.0.4 and you upgraded to 2.4 ... you missed TWO steps. The database must upgrade to 2.0.5, then 2.2 before 2.4.

PostPosted: Mon Feb 21, 2011 12:29 pm
by fibres
Doh!!!

It is 2.2 we upgraded from. So hopefully I havent missed a step.

It seems to be an issue with the GMT offset.

I have looked in admin-servers and our server had a gmt offset of -5 which would be exactly 300 seconds.

I have ammended it here to 0 but still got the issue.

Is there anywhere else I need to change this?

Regards

PostPosted: Mon Feb 21, 2011 12:58 pm
by williamconley
there are 300 seconds in 5 hours? are you sure? 8)

PostPosted: Mon Feb 21, 2011 7:32 pm
by fibres
Sorry I meant 300 mins. Which is exactly how many mins we are seeing on realtime screen.

Regards

PostPosted: Mon Feb 21, 2011 7:50 pm
by williamconley
do you have all the time sources in your system set the same? (apache, mysql, OS...?) with the same ZONE settings as well?

perhaps you should try installing Vicibox Redux instead? (it does mean you can concentrate on stuff other than how to install this software ... let Kumba do that for you instead ... after all, that's what we all don't pay him for, right? 8))

PostPosted: Tue Feb 22, 2011 8:59 am
by floydans
I had the same problem on vicibox 3.1.6.
I think it depends on the timezone set in your apache php.ini (which for some reason it's not set to the correct one).

You can check you have the right timezone in your admin section in the top right corner (for instance check it displays correct date and time).

Then, if it's wrong there try to vi your /etc/php5/apache2/php.ini, locate the timezone line and change it to the correct one for you.


As for me I had to change it like this:

from
date.timezone = "US/Eastern" (or whatever it was)
To
date.timezone = "Europe/Rome"

Hope it helps

PostPosted: Tue Feb 22, 2011 9:01 am
by floydans
...and make sure you restart apache after changing php.ini

PostPosted: Tue Feb 22, 2011 2:20 pm
by Kumba
Instructions added here: http://www.vicidial.org/VICIDIALforum/v ... hp?t=15336

I also had to modify the vicibox installer since the DEFAULT_TIMEZONE variable is different then the TIMEZONE variable. DEFAULT_TIMEZONE is what I set when I created the image, however the live-CD installer only changes the TIMEZONE field in /etc/sysconfig/clock. ViciBox v.3.1.9 was released because of it.

PostPosted: Thu Mar 03, 2011 5:24 pm
by fibres
Thanks for the tips.

I found the issue in php.ini and fixed.

Thanks for all you guys help as usual!