Timezone Issue!

Jurel

My osticket timezone is showing wrong even tho i have set everything in correct time.
I want my osticket timezone to be "Asia / Manila" or +8:00GMT
This is my current config.

Profile > Preferences

PHP and Database (mysql) on Osticket web browser

mysql terminal

Ubuntu timezone

PHP

ntozier

Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance. The more information you give us the better we will be able to assist you. Thank you.

Environment details? (see Admin panel -> Dashboard -> Information)

Change your Database timezone to be the correct one. You appear to have it set to System and that does not appear to be working.

See @KevinTheJedi posts here:
https://forum.osticket.com/d/96690-correct-timezones-wrong-time/18

Jurel

ntozier

this is my Environment details .

I have already change my timezone of database to "+8" but my system_time_zone won't change.
Any recommendation? already change my file on "/etc/mysql/my.cnf" to this

Jurel

ntozier
i actually tried what kevin suggested on the link and change my file to this.

and this is the output on my osticket browser
it changes from PST to +8 but still interpreted as America/Los_Angeles and the timezone issue still not fixed.

See Ticket time

from OS time

This are new ticket generated not an old ticket.

Please Help!

Jurel

After giving it a time, it changes now to Asia/Shanghai which is also the same timezone as Manila. Thanks, this is now solved!