[OpenSER-Users] OpenSER location table timezones

[Adrian A]

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> 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> 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/fadd628b/attachment.htm