[Tickets #2684] NEW: Win2K, PHP, time() and TZ

Mon Sep 26 20:06:03 PDT 2005

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=2684
-----------------------------------------------------------------------
 Ticket             | 2684
 Created By         | rharvey at hyvernion.com
 Summary            | Win2K, PHP, time() and TZ
 Queue              | Horde Base
 Version            | 3.0.5
 State              | Unconfirmed
 Priority           | 3. High
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------

rharvey at hyvernion.com (2005-09-26 20:06) wrote:

This may be similiar to ticket #1088.  I hope I can supply enough
information to keep this from being marked bogus. heh

OS: Windows 2000
Apache: 2.0.54
PHP: 5.0.4
MySQL: 4.1.13

My server is set to TZ EDT.

After installing Horde I noticed the time being reported by PHP was
UTC/GMT/Zulu but my TZ was still EDT (PHP and Horde).  I did some research
thinking it was a PHP config error on my part.  I found PHP (4.3.3) Bug
#25825 where PHP on Win2K defaults to UTC time and cannot be changed back at
times, sometimes a simple reboot will work.  The problem was corrected in
PHP5 by having PHP reset the TZ variable back to original server TZ after
each connection.  Of course, the problem described below may be totally
unrelated.

I made sure it was Horde by rebooting the system and verifing the time to be
correct and being reported correctly by PHP.  I then logged in to all my
known correctly working web apps, checking the time each step of the way.  I
logged into Horde last.  As soon as I logged into Horde *poof* the time was
UTC (+5 of EDT).

Since the time is +5 off and EDT is suppose to be -5 of GMT I tried to reset
the TZ in Horde to be Pacific/Honolulu time -10 of GMT.  Thinking if Horde
makes it +5 it would be correct.  Rebooted and seen the correct time being
reported by PHP and logged into Horde.  Back to UTC, ignoring the TZ set in
Horde and PHP.

This lil prob renders Horde unusable as Tasks, Mail and the Planner all have
incorrect UTC times.  I first noticed this when I was testing out the Tasks
part of Horde and created an alarm and looked to see why it didn't go off.

Summary:  Horde causes PHP to report GMT time, regardless of TZ set in PHP
or Horde.