[OpenSER-Users] OpenSER location table timezones

[Bogdan-Andrei Iancu]

Hi Adrian,

Try setting the same time on both servers - this will do the job, even 
if it is a dirty trick.

Regards,
Bogdan


Adrian A wrote:
> Also, changing the expires to TIMESTAMP from DATETIME causes location 
> lookups to fail, even though the value for expires seems to be in the 
> same format. I changed it back to DATETIME for now to get calls to 
> work again.
>
> Any help with this is appreciated.
>
>
> On Mon, Mar 17, 2008 at 11:57 AM, Adrian A <adrianvoip at gmail.com 
> <mailto:adrianvoip at gmail.com>> wrote:
>
>     Hello,
>
>     I changed the type to timestamp but the problem is still there.
>
>     E.g. Client registers to proxy located in PST, expires is set to:
>     2008-03-17 12:50:55 but time on EST server is 14:55:13 EDT 2008 so
>     within a minute the entry is deleted.
>
>     The MySQL timezone is set to the system timezone for these servers.
>
>     Thanks.
>
>
>     On Mon, Mar 17, 2008 at 2:26 AM, Alex Hermann <alex at speakup.nl
>     <mailto:alex at speakup.nl>> wrote:
>
>         On Monday 17 March 2008, Adrian A wrote:
>         > The issue is that when clients register to the proxy located
>         in the PST
>         > zone, the 'expires' time is much earlier than the current
>         time in EST. As a
>         > result, the proxy in EST deletes the entry from the location
>         table since it
>         > thinks it is stale.
>         >
>         > Is there any way around this, other than setting both proxy
>         servers to the
>         > same timezone?
>         Make the 'expires' column a TIMESTAMP type and make sure the
>         MySQL server
>         timezone is also correctly configured.
>
>
>         --
>         Greetings,
>
>         Alex Hermann
>
>         _______________________________________________
>         Users mailing list
>         Users at lists.openser.org <mailto:Users at lists.openser.org>
>         http://lists.openser.org/cgi-bin/mailman/listinfo/users
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.openser.org
> http://lists.openser.org/cgi-bin/mailman/listinfo/users
>