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.<br>
<br>Any help with this is appreciated.<br><br><br><div class="gmail_quote">On Mon, Mar 17, 2008 at 11:57 AM, Adrian A <<a href="mailto:adrianvoip@gmail.com">adrianvoip@gmail.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello,<br><br>I changed the type to timestamp but the problem is still there. <br><br>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.<br>
<br>The MySQL timezone is set to the system timezone for these servers.<br><br>Thanks.<div><div></div><div class="Wj3C7c"><br><br><div class="gmail_quote">On Mon, Mar 17, 2008 at 2:26 AM, Alex Hermann <<a href="mailto:alex@speakup.nl" target="_blank">alex@speakup.nl</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>On Monday 17 March 2008, Adrian A wrote:<br>
> The issue is that when clients register to the proxy located in the PST<br>
> zone, the 'expires' time is much earlier than the current time in EST. As a<br>
> result, the proxy in EST deletes the entry from the location table since it<br>
> thinks it is stale.<br>
><br>
> Is there any way around this, other than setting both proxy servers to the<br>
> same timezone?<br>
</div>Make the 'expires' column a TIMESTAMP type and make sure the MySQL server<br>
timezone is also correctly configured.<br>
<br>
<br>
--<br>
Greetings,<br>
<br>
Alex Hermann<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.openser.org" target="_blank">Users@lists.openser.org</a><br>
<a href="http://lists.openser.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.openser.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div><br>
</div></div></blockquote></div><br>