Fresh Install

Fresh Install this is output when ./validate.php for first time after creating database following DOC’s.

[email protected]:~$ ./validate.php

Component Version
LibreNMS 21.9.0-62-gb5b532fbc
DB Schema 2021_25_01_0129_isis_adjacencies_nullable (220)
PHP 7.4.3
Python 3.8.10
MySQL 10.3.31-MariaDB-0ubuntu0.20.04.1
RRDTool 1.7.2


[OK] Composer Version: 2.1.8
[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
Run the following SQL statements to fix it
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 created one last week following DOC’s and worked just fine. I had to update mysql and life was good.
not sure what’s happening.

edit playing around with this and got it to work doing this (as root) mysql -u librenms -p librenms then asked for password entered password