Validate.php - updated_at wrong schema

1

Hello, I*m new to LibreNMS and did a new, clean installation.

./validate.php brings the following error message:

Component Version
LibreNMS b1a414e7858dc9ca4adbf18bae7fb254dfd6a58f
DB Schema 184
PHP 7.0.15-0ubuntu0.16.04.4
MySQL 10.0.29-MariaDB-0ubuntu0.16.04.1
RRDTool 1.5.5
SNMP NET-SNMP 5.7.3

==========================================================

[OK] Database connection successful
[FAIL] Database: incorrect column (users/updated_at)
[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):
ALTER TABLE users CHANGE updated_at updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP;
[WARN] You have not added any devices yet.

Could you please tell me what to do? Server is a new Ubuntu 16.04.02 LTS.

Thank you.

2

The first thing would be to read the message in the output :slight_smile: It tells you where to post for that specific FAIL.

However, you can run that ALTER statement in mysql safely.

3

Thank you very much for your quick response. The database error is fixed/gone by the given input.

Now I’ve got:

[WARN] Your install is out of date, last update: Thu, 06 Apr 2017 21:02:37 +0000

4

If you are just on normal daily updates that’s to be expected, you can update by running ./daily.sh

5

Thank you very much. Everything is fine now.