After ./daily.sh ran today we are not getting this error after logging into the WebUI we get this error (Unhandled MySQL Error [42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘updated_at’ in ‘field list’)
[root@librenms librenms]# ./validate.php
| Component | Version |
|---|---|
| LibreNMS | 1.43-46-g32a7c50 |
| DB Schema | 267 |
| PHP | 5.6.37 |
| MySQL | 5.5.48 |
| RRDTool | 1.3.8 |
| SNMP | NET-SNMP 5.5 |
====================================
[OK] Composer Version: 1.7.2
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] MySQL tables collation is wrong:
[FIX] Check http://bit.ly/2lAG9H8 for info on how to fix.
Tables:
mefinfo utf8 utf8_general_ci
[FAIL] MySQL column collation is wrong:
[FIX] Check H T T P S://t.libren.ms/-zdwk for info on how to fix.
Columns:
mefinfo mefType utf8 utf8_general_ci
mefinfo mefIdent utf8 utf8_general_ci
mefinfo mefAdmState utf8 utf8_general_ci
mefinfo mefRowState utf8 utf8_general_ci
[FAIL] Database: missing index (route/device)
[FAIL] Database: missing column (users/updated_at)
[FAIL] Database: missing column (users/remember_token)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (https://t.libren.ms/5gscd):
[FIX] Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE route ADD INDEX device (device_id,context_name,ipRouteDest,ipRouteNextHop);
ALTER TABLE users ADD updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER created_at;
ALTER TABLE users ADD remember_token varchar(100) NULL AFTER updated_at;
[FAIL] Missing PHP extension: mysqlnd
[FIX] Please install mysqlnd
[FAIL] Discovery has not completed in the last 24 hours.
[FIX] Check the cron job to make sure it is running and using discovery-wrapper.py
[WARN] fping6 does not have IPv6 support?!?!