===========================================
| Component | Version |
|---|---|
| LibreNMS | 23.4.1-50-g927446db7 (2023-05-02T15:02:50-04:00) |
| DB Schema | 2023_04_12_174529_modify_ports_table (250) |
| PHP | 8.2.5 |
| Python | 3.8.10 |
| Database | MariaDB 10.3.38-MariaDB-0ubuntu0.20.04.1 |
| RRDTool | 1.7.2 |
| SNMP | 5.8 |
| =========================================== |
[OK] Composer Version: 2.5.5
[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] Database and column collations are correct
[FAIL] We have detected that your database schema may be wrong
Database: incorrect column (syslog/facility)
Database: incorrect column (syslog/level)
Database: incorrect column (syslog/program)
Database: extra table (log)
[FIX]:
Run the following SQL statements to fix it
SQL Statements:
ALTER TABLE syslog CHANGE facility facility varchar(10) NULL ;
ALTER TABLE syslog CHANGE level level varchar(10) NULL ;
ALTER TABLE syslog CHANGE program program varchar(32) NULL ;
DROP TABLE log;
Attempt to fix this issue (y or n)?:n
[OK] MySQl and PHP time match
[OK] Distributed Polling setting is enabled globally
[OK] Connection to memcached is ok
[OK] Connected to rrdcached
[OK] Active pollers found
[OK] Dispatcher Service not detected
[OK] Locks are functional
[OK] Python poller wrapper is polling
[OK] Redis is unavailable
[OK] rrdtool version ok
[OK] Connected to rrdcached
I have two alerts that sends emails with graphs. One for memory utilization and another for CPU usage. Both were working prior to 9/1/2022. Since then when alerts are generated for CPU usage I get emails stating no processors. Memory utilization alerts still work and the emails contain the graphs. Nothing was changed from the templates that are used. I’m at a loss here as everything was working fine.