Fresh Install this is output when ./validate.php for first time after creating database following DOC’s.
librenms@librenms:~$ ./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 |
| SNMP | NET-SNMP 5.8 |
====================================
[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
[FIX]:
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