Time difference between the reports in the remote CDR database and FreePBX: 1 hour

General Help
1

Hello,

my CDR reports are being generated on my external MariaDB server. The connection logs on the external database server are being recorded with the correct time. However, in the FreePBX web interface, the reports under the menu item Reports => Call Recordings Detailed Reports are displayed with the wrong time. The time difference is +1 hour. What could be causing this? The correct time zones are configured in FreePBX and in the php.ini file. The same applies to FreePBX itself.

2026_03_22_cdr-report

freepbx*CLI> cdr show active

Channels with Call Detail Record (CDR) Information
--------------------------------------------------
Channel                   Dst. Channel              LastApp         Start    Answer   End      Billsec  Duration
PJSIP/10-00000002         PJSIP/telekom_0217390#### Dial            22:44:35 22:44:37 22:44:43 00000006 00000008

What else can I check?

Regards, Stefan Harbich

2

Daylight saving

3

Where can I check that? Where can I change that?

The time is correct in the Debian terminal, in the CLI, and in PHP. But not in the web UI under Reports => Call Recording Detailed Reports (+1h).

4

Run this command on both machines and post results

timedatectl status

5

mariadb server

root@postgres-02:~# timedatectl status 
               Local time: Tue 2026-03-24 13:59:29 CET
           Universal time: Tue 2026-03-24 12:59:29 UTC
                 RTC time: n/a
                Time zone: Europe/Berlin (CET, +0100)
System clock synchronized: yes
              NTP service: inactive
          RTC in local TZ: no

freepbx server

root@freepbx:~# timedatectl status
               Local time: Di 2026-03-24 13:57:54 CET
           Universal time: Di 2026-03-24 12:57:54 UTC
                 RTC time: Di 2026-03-24 12:57:53
                Time zone: Europe/Berlin (CET, +0100)
System clock synchronized: yes
              NTP service: active
          RTC in local TZ: no

MariaDB asteriskcdrdb:

2026_03_24_cdr-report-mariadb

freepbx webui:

2026_03_24_cdr-report-webui

6

Php is the only other place where you would set a time zone.

What if you try changing php time to blank and let it get system time

7

You’re the best. It works. Same time in the web UI under Reports => Call Recording Detailed Reports

Why?

8

I checked my php settings and hovered over question mark, it says right there that you can leave it blank.

I have no idea why, I never had to touch it in the first place.