Issue MariaDB Settings issue due to Plesk Update

[MHC_1]

Server operating system version

Alma Linux 9.8

Plesk version and microupdate number

Obsidian 18.0.80

Our Plesk Server was recently updated from 18.0.78 (I think) to 18.0.80 #5 .

## ISSUE

MariaDB updates does not preserve Timezone data settings inside MariaDB. Other settings seem to be preserved.

Our MariaDB uses +1:00 timezone. On EVERY recent significant Plesk update the update always resets the MariaDB timezone to SYSTEM ; which is not correct and causes various other secondary issues.

Please can Plesk updates involving MariaDB set the timezone settings to what they are before the update.

System config settings:
time_zone = SYSTEM​

SHOULD BE:

System config settings:
time_zone = +1:00

(as set before the update).

(not sure whats going on with this formatting, can't change above text back to non-bold on this forum GUI. )

 

[LRLD]

To preserve your settings you should create a file in the /etc/mysql/mariadb.conf.d directory...

/etc/mysql/mariadb.conf.d/99-timezone.cnf

[mariadb]
time_zone = +1:00

Note: These are Ubuntu paths, and are probably different on Alma, but you should be able to do the same.
The main mariadb.cnf should have list of where to to add the settings.

I hope that helps.

LD

 

[MHC_1]

To preserve your settings you should create a file in the /etc/mysql/mariadb.conf.d directory...

/etc/mysql/mariadb.conf.d/99-timezone.cnf

[mariadb]
time_zone = +1:00

Note: These are Ubuntu paths, and are probably different on Alma, but you should be able to do the same.
The main mariadb.cnf should have list of where to to add the settings.

I hope that helps.

LD

Useful to know! Thank you!