It appears that after the automatic update from yesterday evening that our LibreNMS instance is no longer working as it will not connect to the database based upon running the ./validate.php script. Data is no longer being written to the database, devices are not showing any data since 12:15 AM
Validate Results: (GUI)
Results of ./validate.php (Comamnd Line)
librenms@librenms:~$ ./validate.php
====================================
Component | Version
--------- | -------
LibreNMS | 22.8.0-42-gc2761b4e1
DB Schema | 2022_07_03_1947_add_app_data (244)
PHP | 8.1.9
Python | 3.8.10
Database | MariaDB 10.5.15-MariaDB-1:10.5.15+maria~bionic
RRDTool | 1.7.2
SNMP | 5.8
====================================
[OK] Composer Version: 2.4.1
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database Schema is current
[OK] SQL Server meets minimum requirements
[OK] lower_case_table_names is enabled
[OK] MySQL engine is optimal
[OK]
[OK] Database schema correct
[OK] MySQl and PHP time match
**[FAIL] No active polling method detected**
[OK] Dispatcher Service not detected
[OK] Locks are functional
**[FAIL] No active python wrapper pollers found**
[OK] Redis is unavailable
[OK] rrdtool version ok
[OK] Connected to rrdcached
Results of database connections:
MariaDB [librenms]> show processlist;
+-------+----------+-----------------+----------+---------+------+----------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-------+----------+-----------------+----------+---------+------+----------+------------------+----------+
| 30348 | librenms | localhost:55544 | librenms | Sleep | 2715 | | NULL | 0.000 |
| 30569 | librenms | localhost:59296 | librenms | Sleep | 2113 | | NULL | 0.000 |
| 30912 | librenms | localhost:45572 | librenms | Sleep | 1813 | | NULL | 0.000 |
| 47658 | librenms | localhost:37896 | librenms | Sleep | 1212 | | NULL | 0.000 |
| 52649 | librenms | localhost:38938 | librenms | Sleep | 911 | | NULL | 0.000 |
| 53333 | librenms | localhost:50446 | librenms | Sleep | 612 | | NULL | 0.000 |
| 53335 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 53336 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 53337 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 53338 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 53339 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 53340 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 53341 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 53342 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 53343 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 53345 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 53344 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 53346 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 53347 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 53348 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 53349 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 53350 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 53351 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 53352 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 53419 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 53450 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 53454 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 53460 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 53594 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 53605 | librenms | localhost | librenms | Sleep | 18 | | NULL | 0.000 |
| 53699 | librenms | localhost | librenms | Sleep | 45 | | NULL | 0.000 |
| 53749 | librenms | localhost | librenms | Sleep | 21 | | NULL | 0.000 |
| 54607 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 54628 | librenms | localhost | librenms | Sleep | 24 | | NULL | 0.000 |
| 54826 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55102 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55385 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55414 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55422 | librenms | localhost | librenms | Sleep | 36 | | NULL | 0.000 |
| 55423 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55430 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55431 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55432 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55434 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55438 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55441 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55442 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55443 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55444 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55455 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55458 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55459 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55460 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55468 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55475 | librenms | localhost:50630 | librenms | Sleep | 312 | | NULL | 0.000 |
| 55477 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55478 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55480 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55481 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55482 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55483 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55484 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55485 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55486 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55487 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55488 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55489 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55490 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55491 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55492 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55493 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55494 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55495 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55496 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55497 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55498 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55499 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 55500 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55501 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55502 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55503 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55732 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55848 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55875 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 55975 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 56037 | librenms | localhost | librenms | Sleep | 10 | | NULL | 0.000 |
| 56209 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 56245 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 56251 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 56346 | librenms | localhost | librenms | Sleep | 34 | | NULL | 0.000 |
| 56447 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 56463 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 56600 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 56696 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 57090 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 57504 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 57634 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 57788 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 57815 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 57988 | librenms | localhost | librenms | Sleep | 17 | | NULL | 0.000 |
| 58002 | librenms | localhost | librenms | Sleep | 182 | | NULL | 0.000 |
| 58005 | librenms | localhost | librenms | Sleep | 177 | | NULL | 0.000 |
| 58006 | librenms | localhost | librenms | Sleep | 177 | | NULL | 0.000 |
| 58017 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58023 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58025 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58026 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58027 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58029 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58030 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58031 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58032 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58033 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58034 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58035 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58036 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58037 | librenms | localhost | librenms | Sleep | 9 | | NULL | 0.000 |
| 58038 | librenms | localhost | librenms | Sleep | 3 | | NULL | 0.000 |
| 58041 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58043 | root | localhost | librenms | Query | 0 | starting | show processlist | 0.000 |
| 58044 | librenms | localhost | librenms | Sleep | 2 | | NULL | 0.000 |
| 58048 | librenms | localhost:56148 | librenms | Sleep | 12 | | NULL | 0.000 |
| 58049 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58050 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58051 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58052 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58053 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58054 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58055 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58056 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58057 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58058 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58059 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58060 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58207 | librenms | localhost | librenms | Sleep | 1 | | NULL | 0.000 |
| 58211 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58212 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58213 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58214 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58215 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58216 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58217 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58218 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58219 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58220 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58221 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58222 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58223 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58307 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58448 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
| 58486 | librenms | localhost | librenms | Sleep | 0 | | NULL | 0.000 |
+-------+----------+-----------------+----------+---------+------+----------+------------------+----------+
151 rows in set (0.002 sec)
pastebin output of:
root@librenms:/mnt/librenms# su librenms
librenms@librenms:~$ ./discovery.php -h HOSTNAME -d | ./pbin.sh
Paste endpoint: https://p.libren.ms/api/create
title:
name: librenms
private: 1
expire: 0
https://p.libren.ms/view/4f945498
librenms@librenms:~$ ./poller.php -h HOSTNAME -r -f -d | ./pbin.sh
Paste endpoint: https://p.libren.ms/api/create
title:
name: librenms
private: 1
expire: 0
https://p.libren.ms/view/3f0fe5c9
Not writing to database, not showing SNMP results in the GUI:
