From Chunky Tortoise, 6 Years ago, written in Plain Text.
Embed
  1. root@librenms:/opt/librenms# ./validate.php
  2. ==========================================================
  3. Component | Version
  4. --------- | -------
  5. LibreNMS  | 52fabcb77014e14fde082b49d896d8263b6c4db7
  6. DB Schema | 195
  7. PHP       | 7.0.18-0ubuntu0.16.04.1
  8. MySQL     | 10.0.29-MariaDB-0ubuntu0.16.04.1
  9. RRDTool   | 1.5.5
  10. SNMP      | NET-SNMP 5.7.3
  11. ==========================================================
  12.  
  13. [OK]    Database connection successful
  14. [FAIL]  Database: missing table (processors)
  15. [FAIL]  Database: missing table (storage)
  16. [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):
  17.   CREATE TABLE `processors` (`device_id` int(11) NOT NULL, `entPhysicalIndex` int(11) NOT NULL DEFAULT '0', `hrDeviceIndex` int(11) NULL, `processor_descr` varchar(64) NOT NULL, `processor_id` int(11) NOT NULL  auto_increment, `processor_index` varchar(32) NOT NULL, `processor_oid` varchar(128) NOT NULL, `processor_perc_warn` int(11) NULL DEFAULT '75', `processor_precision` int(11) NOT NULL DEFAULT '1', `processor_type` varchar(16) NOT NULL, `processor_usage` int(11) NOT NULL, PRIMARY KEY (`processor_id`), INDEX `device_id` (`device_id`), INDEX `device_id_2` (`device_id`));
  18.   CREATE TABLE `storage` (`device_id` int(11) NOT NULL, `storage_deleted` tinyint(1) NOT NULL DEFAULT '0', `storage_descr` text NOT NULL, `storage_free` bigint(20) NOT NULL DEFAULT '0', `storage_id` int(11) NOT NULL  auto_increment, `storage_index` int(11) NOT NULL, `storage_mib` varchar(16) NOT NULL, `storage_perc` int(11) NOT NULL DEFAULT '0', `storage_perc_warn` int(11) NULL DEFAULT '60', `storage_size` bigint(20) NOT NULL, `storage_type` varchar(32) NULL, `storage_units` int(11) NOT NULL, `storage_used` bigint(20) NOT NULL DEFAULT '0', PRIMARY KEY (`storage_id`), UNIQUE `index_unique` (`device_id`,`storage_mib`,`storage_index`), INDEX `device_id` (`device_id`), INDEX `device_id_2` (`device_id`));
  19. [FAIL]  The poller has never run, check the cron job
  20. [WARN]  You have not added any devices yet.
  21.