[Tunk 6.1] Invalid server time / timezone

[Thibaut DIRLIK (Logica)]

Hi,

I'm working on 6.1 trunk. I live in France and it's currently 10:16am . I'm running Ubuntu 11.04, in French. My /etc/timezone file contains Europe/Paris. I don't know why, but my server have -1 hour :

[2011-12-15 09:16:06,727][?] INFO:server:database hostname: localhost
[2011-12-15 09:16:06,727][?] INFO:server:database port: 5434
[2011-12-15 09:16:06,727][?] INFO:server:database user: thibaut
[2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported service: db
[2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported service: common
[2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported service: object
[2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported service: wizard
[2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported service: report
[2011-12-15 09:16:06,727][?] INFO:web-services:starting NET-RPC service on 0.0.0.0:8070

I tried forcing the --timezone to Europe/Paris, I got the same result. This is a problem for crons jobs.

Any clue ? Is it a bug ?

[Thibaut DIRLIK (Logica) (thibaut-dirlik)]

I'm not sure it's a duplicate bug. This bug has nothing to see with any addons. The patch provided for the other one has absolutely nothing to see with this one.

Are you sure about whar you are saying ?

[Thibaut DIRLIK (Logica) (thibaut-dirlik)]

This bug in not solved with latest version.

[Thibaut DIRLIK (Logica) (thibaut-dirlik)]

After doing some check, it seems that the server is set to UTC Timezone
automatically.
I try to pass --timezone="Europe/Paris", but nothing change. Paris is
UTC+0100 in winter, and my
server has -1hour in log messages.

The big problem is that with GTK Client, if you set a Timzone in user
preference of 'Europe/Paris',
then the client will show datetimes with +1 Hour, but the stored datetime
will be UTC.

This is a problem for us because for example when you get a list of objects
with a search() to get object created 'today' (datetime.datetime.today) you
might get
very strange result ! If it's 00:30am in the client, the date stored is
23:30pm !

So techically, the object was created 'today'.

Maybe I don't understand really well how it works, but this sounds
complicated.
How can I get a unified system here ?

2012/1/26 Thibaut DIRLIK (Logica) <email address hidden>

> This bug in not solved with latest version.
>
> ** This bug is no longer a duplicate of bug 902439
> wrong date format, wrong time
>
> --
> You received this bug notification because you are a member of OpenERP
> Committers, which is subscribed to OpenERP Server.
> https://bugs.launchpad.net/bugs/904632
>
> Title:
> [Tunk 6.1] Invalid server time / timezone
>
> Status in OpenERP Server:
> New
>
> Bug description:
> Hi,
>
> I'm working on 6.1 trunk. I live in France and it's currently 10:16am
> . I'm running Ubuntu 11.04, in French. My /etc/timezone file contains
> Europe/Paris. I don't know why, but my server have -1 hour :
>
> [2011-12-15 09:16:06,727][?] INFO:server:database hostname: localhost
> [2011-12-15 09:16:06,727][?] INFO:server:database port: 5434
> [2011-12-15 09:16:06,727][?] INFO:server:database user: thibaut
> [2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported
> service: db
> [2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported
> service: common
> [2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported
> service: object
> [2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported
> service: wizard
> [2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported
> service: report
> [2011-12-15 09:16:06,727][?] INFO:web-services:starting NET-RPC service
> on 0.0.0.0:8070
>
> I tried forcing the --timezone to Europe/Paris, I got the same result.
> This is a problem for crons jobs.
>
> Any clue ? Is it a bug ?
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-server/+bug/904632/+subscriptions
>

[Amit Parik (amit-parik)]

Hello Thibaut,

Currently for OpenERP 6.1 we uses exclusively UTC timestamps for server-side computations and storage.

One more thing for timezone GTK client and web both have different behavior, for web we don't set a timezone on user preference it's only working with GTK client.

So in GTK client according to the this timezone/timestamps the time difference is added to the local time, thats this -1 hrs different you have seen.

For more information would you please check the conversation of lp:918257.

Thank you!

[Thibaut DIRLIK (Logica) (thibaut-dirlik)]

Ok, thank you, I understand better.

2012/1/31 Amit Parik (OpenERP) <email address hidden>

> Hello Thibaut,
>
> Currently for OpenERP 6.1 we uses exclusively UTC timestamps for server-
> side computations and storage.
>
> One more thing for timezone GTK client and web both have different
> behavior, for web we don't set a timezone on user preference it's only
> working with GTK client.
>
> So in GTK client according to the this timezone/timestamps the time
> difference is added to the local time, thats this -1 hrs different you
> have seen.
>
> For more information would you please check the conversation of
> lp:918257.
>
> Thank you!
>
> ** Changed in: openobject-server
> Status: New => Incomplete
>
> --
> You received this bug notification because you are a member of OpenERP
> Committers, which is subscribed to OpenERP Server.
> https://bugs.launchpad.net/bugs/904632
>
> Title:
> [Tunk 6.1] Invalid server time / timezone
>
> Status in OpenERP Server:
> Incomplete
>
> Bug description:
> Hi,
>
> I'm working on 6.1 trunk. I live in France and it's currently 10:16am
> . I'm running Ubuntu 11.04, in French. My /etc/timezone file contains
> Europe/Paris. I don't know why, but my server have -1 hour :
>
> [2011-12-15 09:16:06,727][?] INFO:server:database hostname: localhost
> [2011-12-15 09:16:06,727][?] INFO:server:database port: 5434
> [2011-12-15 09:16:06,727][?] INFO:server:database user: thibaut
> [2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported
> service: db
> [2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported
> service: common
> [2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported
> service: object
> [2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported
> service: wizard
> [2011-12-15 09:16:06,727][?] DEBUG:web-services:Registered an exported
> service: report
> [2011-12-15 09:16:06,727][?] INFO:web-services:starting NET-RPC service
> on 0.0.0.0:8070
>
> I tried forcing the --timezone to Europe/Paris, I got the same result.
> This is a problem for crons jobs.
>
> Any clue ? Is it a bug ?
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-server/+bug/904632/+subscriptions
>