Hello,
I run LibreNMS voor a few years now on a Centos 8 VM. Today i have to do a yum update because many patches need to be installed/upgraded.
After the yum update everything looks fine. LibreNMS Webgui is working with no errors.
But when i do a ./validate.php i see de following output:
./validate.php
| Component | Version |
|---|---|
| LibreNMS | 21.9.0 |
| DB Schema | 2021_25_01_0129_isis_adjacencies_nullable (217) |
| PHP | 7.4.23 |
| Python | 3.6.8 |
| MySQL | 10.3.28-MariaDB |
| RRDTool | 1.7.0 |
| SNMP | NET-SNMP 5.8 |
| ==================================== |
[OK] Composer Version: 2.1.6
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Database: incorrect column (notifications/datetime)
[FAIL] Database: incorrect column (users/created_at)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (LibreNMS) or the community site (Report database schema issues here - LibreNMS Community):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
SET TIME_ZONE=‘+00:00’;
ALTER TABLE notifications CHANGE datetime datetime timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:00’ ;
ALTER TABLE users CHANGE created_at created_at timestamp NOT NULL DEFAULT ‘1970-01-02 00:00:01’ ;
I have not change my timezone by myself but maybe the yum update did. I have use the SQL statements to fix the problem, but that doesn’t help.
#timedatectl
Local time: Mon 2021-09-20 14:22:47 CEST
Universal time: Mon 2021-09-20 12:22:47 UTC
RTC time: Mon 2021-09-20 12:22:47
Time zone: Europe/Amsterdam (CEST, +0200)
System clock synchronized: yes
NTP service: active
RTC in local TZ: no
Kind regards,
Jorg Schrievers