Hi Guys,Is someone able to point me in the right direction please, it appears since the clocks moving forward 1hr here in the uk over the weekend all our tickets are now showing 3 hours behind.  I have read various posts on this and edited the php.in file to show the time zone as Europe/London but it doesn't make any difference.I have attached a screenshot of my config, the only thing I can see is the Database time zone is showing as IST but I have no idea how to change this.Thanks for any help in advance.

Capture.JPG

@[deleted]01The database is running MariaDb 10, the whole system is hosted on a synology nas if that makes any difference to file locations.Thanks

What do you get when you run SHOW GLOBAL VARIABLES LIKE 'time_zone'

the response back from running an SQL Query is SYSTEM.  I have checked the synology server and the time is correct on the box.

That sounds strange according to the documentation https://mariadb.com/kb/en/library/time-zones/ the timezone on the system and the db should be synced if you have system.

I have norrowed the problem down but have no idea how to fix it, it seems to be a Synology issue. If you go into control panel and then regional options the time is correct and the time zone is also correct.  If however I change the timezone to GMT+2 Eastern European Standard Time everything works correctly in OSticket. 

@[deleted]So your db variable returns SYSTEM and your server timezone is correct, right? What does Admin Panel > Dashboard > Information say for the two time zone sections labeled 'date.timezone' and 'Timezone'?Cheers.

@[deleted]Correct, db variable returns SYSTEM and the server timezone is showing correctly.  If I look in Admin Panel >Dashbord>Information date.timezone is showing as Europe/Dublin but Timezone is showing as IST Interpreted as Europe/Helsinki.  The only way I can get this to work at the moment it to set the timezone on the nas forward 2 hours.

@[deleted]We've been getting a lot of these types of reports, only from people in Europe right now. There seems to be something going on with that 'Interpreted As' part. We will look into this and try to figure out what's going on.In the meantime can you try this and get back to me? https://github.com/osTicket/osTicket/pull/4186(make sure you have your MySQL timezone tables populated and then set your `@@session.time_zone` and `@@global.time_zone` MySQL variables to 'Europe/Dublin' specifically)Cheers.

@[deleted]Also have something else for you to try. Please try updating your server's zonefiles. Once you do, restart the server and re-test the issue. I got word that some servers keep the old zonefiles from before the US changed their DST and for 2 weeks or so people's times will be off. So please update those zonefiles and get back to me.Cheers.

Write a Reply...