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.