Cannot set timezone correctly [closed]

Question

Hi,

Seems I cannot set the timezone in 2.6RC, the "Last inventory" field is always show in GMT even I have force it into "Asia/Hong_Kong" at php.ini. It is showing correctly in phpinfo(). 

Is there any idea about this? Thanks.

date

date/time support	enabled
timelib version	2016.02
"Olson" Timezone Database Version	0.system
Timezone Database	internal
Default timezone	Asia/Hong_Kong

Directive	Local Value	Master Value
date.default_latitude	31.7667	31.7667
date.default_longitude	35.2333	35.2333
date.sunrise_zenith	90.583333	90.583333
date.sunset_zenith	90.583333	90.583333
date.timezone	Asia/Hong_Kong	Asia/Hong_Kong

Here is my OCS version info:

• PHP Version :
• Web Server :
• Database Server :
• Version OCSReports:

• 7.0.33
• Apache/2.4.25 (Debian)
• Debian 9.6 version 10.1.37-MariaDB-0+deb9u1
• 2.6RC

Answer 1

Same situation, Php time() gives me the right local time, but “last come” always 12 hours ahead ( ocs 2.6 on debian 10.2). At last I changed my MySQL time zone setting and the time is correct finally.

Maybe you could check your mysql time zone setting.

show variables like '%time_zone%';

https://mariadb.com/kb/en/time-zones/#global-server-time-zone

https://mariadb.com/kb/en/time-zones/#system-time-zone
 

dpkg-reconfigure tzdata

Answer 2

I change the server timezone before, restart the server and done.

Answer 3

Thanks all for the hints, it is ok now when I recheck.

MariaDB [(none)]> show variables like '%time_zone%';

+------------------+--------+

| Variable_name    | Value  |

+------------------+--------+

| system_time_zone | HKT    |

| time_zone        | SYSTEM |

+------------------+--------+

2 rows in set (0.15 sec)

Maybe a full reboot is required after all these changes to the timezone.