Http error 500 - issue

Help
1

We have a server running for the last 4 months and 2 days ago started the Error 500 on the web access. I really need to resolve these.

[root@librenms librenms]# ./validate.php

Component Version
LibreNMS 1.43-76-g3e4315c
DB Schema 267
PHP 7.0.31
MySQL 5.5.60-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: incorrect column (notifications/datetime)
[FAIL] Database: incorrect column (users/created_at)
[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 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’ ;
[FAIL] Missing PHP extension: mysqlnd
[FIX] Please install mysqlnd
[FAIL] The poller (librenms.domain.local) has not completed within the last 5 minutes, check the cron job.

I ran the ./daily.sh with no problem manually.

2

Hi @Ivan_Rivera

Error 500

Database

Just run the statements of validate.php

3

Hi,
I ran the ./validate.php

See the log… What I can do for resolve these?

[root@librenms logs]# /opt/librenms/validate.php

Component Version
LibreNMS 1.43-77-ge0e08e9
DB Schema 267
PHP 7.0.31
MySQL 5.5.60-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: incorrect column (notifications/datetime)
[FAIL] Database: incorrect column (users/created_at)
[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 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’ ;
[FAIL] Missing PHP extension: mysqlnd
[FIX] Please install mysqlnd

4

Issued resolver with these:

CentOS 7 with PHP 7.2 example:
yum swap php72w-mysql php72w-mysqln