I get this when I try to login. It just errors out and can’t get past the this. Any help would be appreciated. Thank you.
“Unhandled MySQL Error [42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘updated_at’ in ‘field list’”
Here is the output.
./validate.php
| Component | Version |
|---|---|
| LibreNMS | 1.43-119-g6242f94 |
| DB Schema | 268 |
| PHP | 7.0.30 |
| MySQL | 5.5.47-MariaDB |
| RRDTool | 1.4.8 |
| SNMP | NET-SNMP 5.7.2 |
====================================
[OK] Composer Version: 1.7.2
[OK] Dependencies up-to-date.
[OK] Database connection successful
[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 Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
[FIX] Run the following SQL statements to fix.
SQL Statements:
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] We have found some files that are owned by a different user than librenms, this will stop you updating automatically and / or rrd files being updated causing graphs to fail.
[FIX] sudo chown -R librenms:librenms /opt/librenms
sudo setfacl -d -m g::rwx /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
sudo chmod -R ug=rwX /opt/librenms/rrd /opt/librenms/logs /opt/librenms/bootstrap/cache/ /opt/librenms/storage/
Files:
/opt/librenms/html/plugins/Weathermap/configs
/opt/librenms/html/plugins/Weathermap/configs/testing.conf
/opt/librenms/.git/index