PFSense PHP time is incorrect in America/Sao_Paulo time zone

cesarmsj

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?

stephenw10

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-timezonedb

What are you actually seeing?

Steve

mcury

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.

cesarmsj

@mcury Very very strange, because the correct one would not be GMT -3?

mcury

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 2019

https://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.

cesarmsj

@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?

cesarmsj

@mcury This is the problem, but I would like to know how to update tzdata correctly in pfsense.

stephenw10

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

cesarmsj

But the correct thing would be America/Sao_Paulo to be GMT -3

mcury

@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..

cesarmsj

@mcury America/Sao_Paulo is one more hour.

mcury

@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.

cesarmsj

@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/

mcury

I understand, but they calculate like this:
GMT + X = LT

So, X is added to GMT to reach the desired LT.

Can you see the message after Etc/GMT +3 --> (3 hours behind GMT) ?

cesarmsj

@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?

mcury

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

stephenw10

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

cesarmsj

@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

stephenw10

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

johnpoz

@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