[Users] Problem with time zone of a desktop VM

Hello, oVirt 3.2.1 on Fedora 18 all-in-one configuration. I created a Windows XP with wrong time zone (default that is UTC -12 .. why? Don't reply why not, please... ;-) Now if the VM is powered off and I edit it, I can't still change its timezone, because it is greyed out in initial run section. Tried to change inside guest but at next reboot it keeps with same problem. How can I change it after creation? How to change default so that it is not UTC-12 but matches my timezone for every desktop I create? Thanks, Gianluca

----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "users" <users@ovirt.org> Sent: Saturday, May 4, 2013 7:35:14 PM Subject: [Users] Problem with time zone of a desktop VM
Hello, oVirt 3.2.1 on Fedora 18 all-in-one configuration. I created a Windows XP with wrong time zone (default that is UTC -12 .. why? Don't reply why not, please... ;-) Now if the VM is powered off and I edit it, I can't still change its timezone, because it is greyed out in initial run section. Tried to change inside guest but at next reboot it keeps with same problem.
How can I change it after creation? How to change default so that it is not UTC-12 but matches my timezone for every desktop I create?
you can change the default - 'DefaultTimeZone' not sure if its in engine-config
Thanks, Gianluca _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

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 ;-) Gianluca

----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Omer Frenkel" <ofrenkel@redhat.com> Cc: "users" <users@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');
Gianluca

On May 8, 2013, at 09:12 , Omer Frenkel <ofrenkel@redhat.com> wrote:
----- Original Message -----
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Omer Frenkel" <ofrenkel@redhat.com> Cc: "users" <users@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 Thanks, michal
Gianluca
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

On May 8, 2013, at 09:12 , Omer Frenkel <ofrenkel@redhat.com> wrote:
From: "Gianluca Cecchi" <gianluca.cecchi@gmail.com> To: "Omer Frenkel" <ofrenkel@redhat.com> Cc: "users" <users@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,
----- Original Message ----- 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
On 05/09/2013 03:31 PM, Michal Skrivanek wrote: the patch and some discussion http://gerrit.ovirt.org/#/c/14248/
Thanks, michal
Gianluca
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

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? 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. Gianluca

On May 9, 2013, at 17:10 , Gianluca Cecchi <gianluca.cecchi@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
participants (4)
-
Gianluca Cecchi
-
Michal Skrivanek
-
Omer Frenkel
-
Roy Golan