Server Time problem

Hello
My SugarCRM seems to have the wrong time. I have set the timezone to Pacific/Auckland, but when I look at the time as displayed on the console window in WMPlayer I see the time (NZST) is 12 hours ahead of the actual NZST time. When I change it to other time zones such as London, it is still 12hours ahead of the current London time.
So I booted up my OTRS Jumpbox to see if it had the same issue. It didn't. It is set to Pacific/Auckland (NZST) and the time is correct!
Could this be a bug with the SugarCRM Jumpbox? Has anyone else experienced it? Is there something I can do to resolve?
Cheers in advance!

Server Time problem

I have just tested out sugarcrm-1.0.7 release, our latest, and it appears to set Timezone correctly for me. I was able to go into the JumpBox admin portal and change the timezone there (as shown here. The console shows the correct time after it has has time to refresh (10-20 seconds).

Are you changing the timezone as shown above or somewhere in the SugarCRM app?

Austin

Yes, am changing the

Yes, am changing the timezone on the jumpbox. see here for a screenshot of the jbox console and the world clock in igoogle.

http://www.alsweiler.com/portals/0/temp/jumpbox.jpg

the jumpbox is running 11 hours ahead of the actual time.

How is the time on jumpbox set? it doesn't seem to be aligned to the host system time... Does it get it from an internet service or something?

Server Time problem

Well, since you are using VMWare server, the best option is to keep the guest (JumpBox) time synced with the host time. Check your JumpBox.vmx file for that guest and make sure it says:

tools.syncTime = "TRUE"

if not, shut the JumpBox down and make it say TRUE then restart. I does seem like the problem is that the guest time is off since the timezone is correct. It is supposed to ship with that enabled I will doublecheck and see that it does. Let me know how it works out.

Austin

Yep, the tools.syncTime is

Yep, the tools.syncTime is set to TRUE. I just noticed that VMware Server Console is reporting that "You do not have VMware tools installed". I don't get this messgae with my other JumpBoxes. Could it be that VMware tools is not installed or working properly on the guest (sugarcrm 1.0.7 jbox)?

Thanks again for your help
Mike

Server Time problem

Ok, the "You do not have VMware tools installed" message is erroneous in this release. There is a setting in the JumpBox.vmx file that is causing that message so, if you can, shut it down and completely remove the line that says

tools.statusMsgs.disable = "true"

Actually, before shutting it down, if you want to, you can test to see if the tools are active on the command line if you are using a Linux host (probably on windows too but I haven't tried). First get a list of all of the registered virtual machines on your host:

vmware-cmd -l

then copy the whole path to the sugarcrm JumpBox and run the gettoolslastactive command like this (substituting your correct path):

vmware-cmd /appliances/godber/sugarcrm-1.0.7/JumpBox.vmx gettoolslastactive

if it returns gettoolslastactive() = 1 then the tools are running and vmware-cmd can communicate with them, and the time should be synced.

But lets start by removing that "tools.statusMsgs.disable" line and restarting it if that is an option. I don't think this should effect the time sync but I guess its possible. Oh, if you have registered this JumpBox you could SSH in and run sudo ntpdate pool.ntp.org to sync it once but if it keeps drifting and the time sync setting is set to true that is a problem.

Austin

Good news Austin!

Good news Austin!

gettoolslastactive came back as true.

I removed the statusMsgs.disable parameter from the vmx file. As you suspected, this made no difference to the time.

My Jumpbox is registered, so I was able to SSH in and run ntpupdate. This worked a treat and I now am running on the right time. I'll monitor it over the coming days to see how it goes... I can understand why it might drift a little over time, but can't imagine why it was running almost exactly 11 hours fast. Time (excuse the pun!) will tell.

Thank you very much for your speedy assistance on this Austin. Go JumpBox.

Mike

Server Time problem

Good to hear. Let me know if it drifts. It shouldn't with the timesync setting. But we will see whats up.

Austin

Server Time problem

That would definitely explain it. I will check that.

Austin

Server Time problem

We have two SugarCRM JumpBoxes, is this the SugarCRM 4.5.1 from here:

http://www.jumpbox.com/app/sugarcrm

or the beta of SugarCRM 5 from the JumpBox Proving Grounds: http://www.jumpbox.net

Austin

Hi Austin Sorry, it is the

Hi Austin
Sorry, it is the 4.5.1 version.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.