[Users] Problem with time zone of a desktop VM
Michal Skrivanek
michal.skrivanek at redhat.com
Thu May 9 11:13:49 EDT 2013
On May 9, 2013, at 17:10 , Gianluca Cecchi <gianluca.cecchi at gmail.com> wrote:
> On Thu, May 9, 2013 at 4:17 PM, Roy Golan wrote:
>
>>>>
>>>> well i dont really know, just a long shot,
>>>> try to clear utc_diff in vm_dynamic:
>>>> update vm_dynamic set utc_diff = null where vm_guid=(select vm_guid from
>>>> vm_static where vm_name='winxp');
>>>
>>> Martin's actively working on TZ defaults. There was an issue where this
>>> default was not actually applied(I don't think it's discussed in the bug) so
>>> most likely that's why your db changes are not reflected
>>> https://bugzilla.redhat.com/show_bug.cgi?id=873795
>>
>> the patch and some discussion http://gerrit.ovirt.org/#/c/14248/
>
> For the defaults considerations:
> Unfortunately the bug is not visible to me...
> regarding the patch: is it included in 3.2.2? Will it be included in 3.3?
will be in 3.3, yes
it's not finished yet, but it's not complicated and should be in "master" soon
>
> For my particular VM
>
> engine=# select a.vm_name,b.utc_diff from vm_static a, vm_dynamic b
> where a.vm_guid=b.vm_guid;
> vm_name | utc_diff
> ---------+----------
> winxp | 50394
> infra | -1
> test |
> (3 rows)
>
> engine=# update vm_dynamic set utc_diff = null where vm_guid=(select
> vm_guid from vm_static where vm_name='winxp');
> UPDATE 1
>
> engine=# select a.vm_name,b.utc_diff from vm_static a, vm_dynamic b
> where a.vm_guid=b.vm_guid;
> vm_name | utc_diff
> ---------+----------
> winxp |
> infra | -1
> test |
> (3 rows)
>
> engine=# commit;
> COMMIT
>
> engine-# \q
>
> restart of engine and now on boot my vm got UTC time (here in Italy
> 16:30 and VM got 14:30), so it seems some effect was put in place.
>
> After that I noticed that for this VM it was set also internet time in
> sync with time.windows.com so I unset it and ran another shutdown and
> power on, but this seems did'nt influence.
>
> Then I shutdown and set in db utc_diff to -1 (like infra VM that is
> set in web gui as GMT+1) restart engine and power on but it keeps two
> hours behind
>
> Then I manually set the time to 16:40 in windows and shutdown and
> power on and the time was retained. Thanks.
>
> Nevertheless in the GUI I continue to have the VM configured in Edit
> --> Initial Run with GMT-12 and every new VM by default gets that if I
> don't manually change it during creation.
yes, that's the bug, it doesn't honor the configuration default set in vdc_options. That will be addressed
Thanks,
michal
> Gianluca
More information about the Users
mailing list