[OpenSER-Users] OpenSER location table timezones

[Adrian A]

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> 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
> http://lists.openser.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20080317/bdda8c86/attachment.htm