[Users] Problem with time zone of a desktop VM

[Omer Frenkel]

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

> 
> Gianluca
>