Mysql: unknown variable


I have problem when i am trying to connect on mysql server

when i put mysql -u root-p i got this

mysql: unknown variable ‘default-time-zone=Europe/Amsterdam’

here is validate.php

Component Version
LibreNMS 21.4.0-62-ge40e1069d
DB Schema 2021_04_08_151101_add_foreign_keys_to_port_group_port_table (208)
PHP 7.4.16
Python 3.8.8
MySQL 10.5.9-MariaDB-1:10.5.9+maria~bionic
RRDTool 1.7.2


[OK] Composer Version: 2.0.13
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct

here is mariadb.cnf


Port or socket location where to connect

port = 3306

socket = /run/mysqld/mysqld.sock
default-time-zone= ‘Europe/Amsterdam’

Not related to LibreNMS, just MariaDB conf I think.

Following this:

Try removing time-zone line from mariadb.cnf and putting in an option file under the [mariadb] heading such as mariadb.conf.d/50-server.cnf or similar.

mariadb --help will report errors in the config if there are any.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.