[Users] Problem with time zone of a desktop VM

[Roy Golan]

On 05/09/2013 03:31 PM, Michal Skrivanek wrote:
> On May 8, 2013, at 09:12 , Omer Frenkel <ofrenkel at redhat.com> wrote:
>
>>
>> ----- Original Message -----
>>> From: "Gianluca Cecchi" <gianluca.cecchi at gmail.com>
>>> To: "Omer Frenkel" <ofrenkel at redhat.com>
>>> Cc: "users" <users at ovirt.org>
>>> Sent: Sunday, May 5, 2013 9:54:25 PM
>>> Subject: Re: [Users] Problem with time zone of a desktop VM
>>>
>>> On Sun, May 5, 2013 at 10:34 AM, Omer Frenkel wrote:
>>>
>>>> you can change the default - 'DefaultTimeZone'
>>>> not sure if its in engine-config
>>>>
>>> Thanks but
>>> # engine-config -a | grep -i zone
>>> #
>>>
>>> # engine-config -l | grep -i zone
>>> #
>>>
>>> engine-config -g DefaultTimeZone
>>> Error fetching DefaultTimeZone value: no such entry. Please verify key
>>> name and property file support.
>>>
>>> Leaving apart for a momento the default, trying to solve my particular
>>> vm timezone problem
>>>
>>> engine=# select vm_name,time_zone from vm_static;
>>> vm_name |   time_zone
>>> ---------+----------------
>>> Blank   |
>>> infra   | Africa/Algiers
>>> winxp   |
>>> test    | Africa/Algiers
>>> (4 rows)
>>>
>>> infra and test are ok (CET actually in the gui) so
>>>
>>> engine=# update vm_static set time_zone='Africa/Algiers' where
>>> vm_name='winxp';
>>> UPDATE 1
>>> engine=# commit;
>>> COMMIT
>>> engine=# select vm_name,time_zone from vm_static;
>>> vm_name |   time_zone
>>> ---------+----------------
>>> Blank   |
>>> infra   | Africa/Algiers
>>> winxp   | Africa/Algiers
>>> test    | Africa/Algiers
>>> (4 rows)
>>>
>>>
>>> but also after engine service restart, I continue to see gmt-12 in
>>> edit vm in gui....
>>>
>>> tried also some commands in ovirt-shell but found no way...
>>>
>>> Any help would be appreciated... in charge I'm going to write
>>> something inside the wiki... if not already there ;-)
>> 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/
>
> Thanks,
> michal
>
>>> Gianluca
>>>
>> _______________________________________________
>> Users mailing list
>> Users at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users