Ever since DST started, all of our ticket time stamps have been behind by one hour. My users reside in a timezone that does not do DST. As far as I can tell my time settings are consistently set, so I'm hoping to gain some insight into what I may have overlooked. Here's some relevant information about our installation. Note that PHP settings reflect timezone of "America/Phoenix" which is correct. The database timezone shows MST (Interpreted as America/Denver) which could certainly be part of the problem:Default timezone is set to America/Phoenix:As you might expect, PHP.ini has the timezone set:Here are my server time settings:Originally I did not have a timezone set explicitly on MYSQL so it defaulted to SYSTEM. Thinking this might have been part of the issue I set the zone to -07 in my.cnf:However this has not made any impact on the time setting reflected on the dashboard or in the tickets themselves (all services have been restarted). Any suggestions on where I need to focus my efforts would be greatly appreciated.
This does not appear to be a "Suggestions and Feedback". Moving thread to Troubleshooting and Problems.
I updated my default-time-zone parameter in "my.cnf" to reference America/Phoenix, in hope that any ambiguity regarding DST would be removed. After restarting services I confirmed that the setting has taken effect:However, OSTicket still shows "MST (interpreted as America/Denver)" under "Database Information and Usage". What needs to happen to get this working as expected?
Is your time fixed and osTicket isn't updating that section to 'America/Phoenix'? Or is your time still wrong and it still isn't updating?
Time is still wrong, and database information is still showing "MST (Interpreted as America/Denver)".
Found the following thread where greezybacon states that they are "querying global.system_time_zone from mysql": https://github.com/osTicket/osTicket/issues/2277 This adds another interesting wrinkle which I don't think I've seen anyone mention in the numerous threads about time issues. If I query this variable it shows that I'm using MST for system, which is true as shown in the system time settings pictured in my original post. However, we are MST WITHOUT DST. Could this potentially be contributing to my issue?
It seems possible. Try changing your system_time_zone from MST to America/Phoenix and see if this helps!
My understanding is that this value is pulled directly from the underlying OS, and is not something I can change directly through MySQL. Please correct me if I'm wrong here. As you can see in the original screenshot of my server OS time settings, the time zone is already set to "America/Phoenix".
there is a new pull request that might help with this:https://github.com/osTicket/osTicket/pull/3783