PFSense PHP time is incorrect in America/Sao_Paulo time zone
-
The president of Brazil canceled daylight saving time in the country this year and it appears that many systems have not been updated. The latest version of PFSense, 2.4.5-RELEASE-p1, has the correct system time, but not PHP, as PHP searches for a system-independent timezone database. Netgate
could you update the PHP timezone, please, or is there already a patch patch? -
Hmm, looks like we have a version that should contain that in 2.4.5:
https://github.com/pfsense/FreeBSD-ports/tree/RELENG_2_4_5/misc/pecl-timezonedbWhat are you actually seeing?
Steve
-
I noticed that too.
Changed from America/Sao_Paulo to GMT +3 and it fixed for me.It was showing the wrong time in logs, now I don't remember if it was one hour ahead or one hour earlier.
Also, in the dashboard, same problem. -
@mcury Very very strange, because the correct one would not be GMT -3?
-
Yes, I guess the tzdata is not up to date.
Remember that the new government changed how the summertime in Brazil works? It happened in 2019https://pt.wikipedia.org/wiki/Hor%C3%A1rio_de_ver%C3%A3o_no_Brasil#:~:text=No%20dia%2025%20de%20abril,vai%20aumentar%20produtividade%20do%20trabalhador.
But this is only a guess, not sure if this is the problem indeed.
-
@stephenw10 Is this an official repository? Why doesn't this updated package come with the latest version of pfsense? What would be the most correct process of updating pecl-timezonedb?
-
@mcury This is the problem, but I would like to know how to update tzdata correctly in pfsense.
-
Yes, that is the pfSense repo and that is the 2.4.5 release branch. That is the version that's in 2.4.5p1.
But I assume you are setting Sao Paulo directly and seeing GMT+2 instead?
Steve
-
But the correct thing would be America/Sao_Paulo to be GMT -3
-
@cesarmsj Can you check if you are seeing one hour ahead or one hour earlier?
Unfortunately if I change now to answer Stephenw10, it will mess up my logs.
I don't know how to update tzdata manually.. -
@mcury America/Sao_Paulo is one more hour.
-
@cesarmsj One hour ahead then.
Answering Stephenw10, yes it is showing GMT +2, which means 2 hours behind than GMT. America/Sao_Paulo should be GMT +3, which is 3 hours behind GMT. -
@mcury Why do they say it's GMT +3, I ask again, wouldn't it be GMT -3? See: https://greenwichmeantime.com/time-zone/south-america/brazil/time-brazil/
-
I understand, but they calculate like this:
GMT + X = LTSo, X is added to GMT to reach the desired LT.
Can you see the message after Etc/GMT +3 --> (3 hours behind GMT) ?
-
@mcury
Our PFSense is in version: 2.4.5-RELEASE (amd64) built on Tue Mar 24 15:25:50 EDT 2020 FreeBSD 11.3-STABLE)But anyway, will this be fixed in the next version to be released?
-
I'm not sure, as far as I'm aware, they didn't know about the summertime changes in Brazil.
2.5.0 is coming, maybe it will be fixed by then.Change to GMT +3 for now, and it will fix it until a patch or a new version is released.
Same behavior on 2.4.5p1
2.4.5-RELEASE-p1 (arm)
built on Tue Jun 02 17:45:24 EDT 2020
FreeBSD 11.3-STABLE -
It looks correct in 2.5 though:
Current date/time Sun Nov 22 17:47:20 -03 2020
3hrs difference when I set Sao Paulo.
It's unlikely this will be corrected before 2.5 is released. I would just set GMT+3 until then.
Steve
-
@stephenw10
Is it possible that PFSense 2.5 stable version will take time to be released? The fix may be included in private FreeBSD 12 updates.Here are the links I've been reading, but we can't put this dev version into production until LTS is released:
https://www.netgate.com/blog/pfsense-2-5-0-development-snapshots-now-available.html
https://docs.netgate.com/pfsense/en/latest/releases/2-5-0.html
-
I'm not sure what you're asking there.
The next version of pfSense will be released when it's ready. You can follow the open issues here: https://redmine.pfsense.org/projects/pfsense/issues?query_id=106
Steve
-
@cesarmsj said in PFSense PHP time is incorrect in America/Sao_Paulo time zone:
into production until LTS is released:
Never seen a LTS version of pfsense ;) If that was what your asking.. Here is the lifecycle for hardware. Never seen anything like that for pfsense version. Normally the old version drops off support once its be replaced with new new version, they normally support the previous version. But not the one before that.
https://www.netgate.com/support/product-lifecycle.html
pfsense versions and if supported
https://docs.netgate.com/pfsense/en/latest/releases/versions.html