I have been struggling with this for the last 2 days.
The problem is whenever I create a ticket via the web form creation page of osticket, the time of the ticket creation displayed in the tickets list page of osticket is one hour less than the real creation time.
For example one ticket created at 15:01 is displayed in osticket as having been created at 14:01.
I am using osticket V. 1.10 (901e5ea)
Apache/osticket and mysql are running on the same machine (Centos7).
I have confirmed in the osticket database table that the ticket is created with the correct hour. but it is displayed with one hour less in osticket.
I have configured osticket timezone correctly according to my location (Europe/Lisbon)
I have set mysql timezones also according to my location on my.cnf file and populated mysql timezone tables from my centos7 /usr/share/zoneinfo directory
the centos7 OS timezone is also configured to Europe/Lisbon
the agent profile in osticket is also configured to Europe/Lisbon
Apache / PHP also configured in httpd.conf and php.ini to the correct location:
- in httpd.conf added line
SetEnv TZ Europe/Lisbon
- in php.ini
A PHP test file opened in a web browser with the command "echo date_default_timezone_get();" gives this:
Something strange is in the osticket configuration (first image) because mysql timezone altough configured as Europe/Lisbon is being interpreted as Europe/Paris by osticket.
Another question is Daylight Saving Times. Maybe the question also relates to this, but now I dont see any option to deal with this in OSTicket altough in previous osticket versions we had an option to activate/deactivate DST.
And I think this misconfiguration is also no allowing me to get a lock on a ticket. With a Collision Avoidance Duration of 5 minutes I can never answer a ticket because it gives the error "This action requires a lock. Please try again".
With a Collision Avoidance Duration bigger than 60 minutes then I can answer ticket.
Do not know what else can I try/change.
Maybe I am missing something obvious but I am out of ideas.
Any help would be appreciated
Thank you very much