Database Timezone error with Campaigns

N

normathens

Beginner
I just had a clean install of Campaings installed and I get this error:

"Informational Alert: Your database's timezone is not set to UTC. Please update it."

Screenshot - https://prnt.sc/8QeJ_3KdDC0Z

The server is on AlmaLinux8

Please let me know how to set the timezone for the database properly.
 
I can't locate where to put the
default_time_zone = '+00:00';

The server runs AlmaLinux 8

Here is the etc/my.cnf file (attached)

Please help.
 

Attachments

You can add
default_time_zone = '+00:00';

in file like this

[mysqld]
default_time_zone = '+00:00';

[client-server]

before [client-server]. after adding the timezone Restart the MySQL Server.

Note: If you don't have enough experience on the server side, it is advisable to seek guidance from an individual who specializes in server-side technologies.
 
Last edited:
I tried adding the

default_time_zone = '+00:00';

line to that file and the whole Mumara setup became unavailable.
Had to revert back.
 
I've inserted the command you tell me, but there is still an issue.
Screenshots attached
 

Attachments

  • Edited Records.jpg
    Edited Records.jpg
    22.4 KB · Views: 3
  • Erros Persists.jpg
    Erros Persists.jpg
    85 KB · Views: 2
You must log in or register to reply here.
Back
Top