From: "Gianluca Cecchi" <gianluca.cecchi(a)gmail.com&gt; To: "users" <users(a)ovirt.org&gt; 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?

Thanks, Gianluca _______________________________________________ Users mailing list Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users

From: "Gianluca Cecchi" <gianluca.cecchi(a)gmail.com&gt; To: "Omer Frenkel" <ofrenkel(a)redhat.com&gt; Cc: "users" <users(a)ovirt.org&gt; 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 ;-)

Gianluca

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