mySQL error (/validate.php)

From Kelvin, 6 Years ago, written in Plain Text.
URL https://p.libren.ms/view/27699e19
Embed
Download Paste or View Raw
  1. ====================================
  2. Component | Version
  3. --------- | -------
  4. LibreNMS  | 1.31.03-60-g838f91a
  5. DB Schema | ?
  6. PHP       | 7.0.22
  7. MySQL     | ?
  8. RRDTool   | 1.4.8
  9. SNMP      | NET-SNMP 5.7.2
  10. ====================================
  11.  
  12. [FAIL]  Error connecting to your database Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
  13. [FAIL]  Database: missing table (access_points)
  14. [FAIL]  Database: missing table (alerts)
  15. [FAIL]  Database: missing table (alert_log)
  16. [FAIL]  Database: missing table (alert_map)
  17. [FAIL]  Database: missing table (alert_rules)
  18. [FAIL]  Database: missing table (alert_schedule)
  19. [FAIL]  Database: missing table (alert_schedule_items)
  20. [FAIL]  Database: missing table (alert_templates)
  21. [FAIL]  Database: missing table (alert_template_map)
  22. [FAIL]  Database: missing table (api_tokens)
  23. [FAIL]  Database: missing table (applications)
  24. [FAIL]  Database: missing table (authlog)
  25. [FAIL]  Database: missing table (bgpPeers)
  26. [FAIL]  Database: missing table (bgpPeers_cbgp)
  27. [FAIL]  Database: missing table (bills)
  28. [FAIL]  Database: missing table (bill_data)
  29. [FAIL]  Database: missing table (bill_history)
  30. [FAIL]  Database: missing table (bill_perms)
  31. [FAIL]  Database: missing table (bill_ports)
  32. [FAIL]  Database: missing table (bill_port_counters)
  33. [FAIL]  Database: missing table (callback)
  34. [FAIL]  Database: missing table (cef_switching)
  35. [FAIL]  Database: missing table (ciscoASA)
  36. [FAIL]  Database: missing table (component)
  37. [FAIL]  Database: missing table (component_prefs)
  38. [FAIL]  Database: missing table (component_statuslog)
  39. [FAIL]  Database: missing table (config)
  40. [FAIL]  Database: missing table (customers)
  41. [FAIL]  Database: missing table (dashboards)
  42. [FAIL]  Database: missing table (dbSchema)
  43. [FAIL]  Database: missing table (devices)
  44. [FAIL]  Database: missing table (devices_attribs)
  45. [FAIL]  Database: missing table (devices_perms)
  46. [FAIL]  Database: missing table (device_graphs)
  47. [FAIL]  Database: missing table (device_groups)
  48. [FAIL]  Database: missing table (device_group_device)
  49. [FAIL]  Database: missing table (device_mibs)
  50. [FAIL]  Database: missing table (device_oids)
  51. [FAIL]  Database: missing table (device_perf)
  52. [FAIL]  Database: missing table (entPhysical)
  53. [FAIL]  Database: missing table (entPhysical_state)
  54. [FAIL]  Database: missing table (eventlog)
  55. [FAIL]  Database: missing table (graph_types)
  56. [FAIL]  Database: missing table (graph_types_dead)
  57. [FAIL]  Database: missing table (hrDevice)
  58. [FAIL]  Database: missing table (ipsec_tunnels)
  59. [FAIL]  Database: missing table (ipv4_addresses)
  60. [FAIL]  Database: missing table (ipv4_mac)
  61. [FAIL]  Database: missing table (ipv4_networks)
  62. [FAIL]  Database: missing table (ipv6_addresses)
  63. [FAIL]  Database: missing table (ipv6_networks)
  64. [FAIL]  Database: missing table (juniAtmVp)
  65. [FAIL]  Database: missing table (links)
  66. [FAIL]  Database: missing table (loadbalancer_rservers)
  67. [FAIL]  Database: missing table (loadbalancer_vservers)
  68. [FAIL]  Database: missing table (locations)
  69. [FAIL]  Database: missing table (mac_accounting)
  70. [FAIL]  Database: missing table (mefinfo)
  71. [FAIL]  Database: missing table (mempools)
  72. [FAIL]  Database: missing table (mibdefs)
  73. [FAIL]  Database: missing table (munin_plugins)
  74. [FAIL]  Database: missing table (munin_plugins_ds)
  75. [FAIL]  Database: missing table (netscaler_vservers)
  76. [FAIL]  Database: missing table (notifications)
  77. [FAIL]  Database: missing table (notifications_attribs)
  78. [FAIL]  Database: missing table (ospf_areas)
  79. [FAIL]  Database: missing table (ospf_instances)
  80. [FAIL]  Database: missing table (ospf_nbrs)
  81. [FAIL]  Database: missing table (ospf_ports)
  82. [FAIL]  Database: missing table (packages)
  83. [FAIL]  Database: missing table (pdb_ix)
  84. [FAIL]  Database: missing table (pdb_ix_peers)
  85. [FAIL]  Database: missing table (perf_times)
  86. [FAIL]  Database: missing table (plugins)
  87. [FAIL]  Database: missing table (pollers)
  88. [FAIL]  Database: missing table (poller_groups)
  89. [FAIL]  Database: missing table (ports)
  90. [FAIL]  Database: missing table (ports_adsl)
  91. [FAIL]  Database: missing table (ports_fdb)
  92. [FAIL]  Database: missing table (ports_perms)
  93. [FAIL]  Database: missing table (ports_stack)
  94. [FAIL]  Database: missing table (ports_statistics)
  95. [FAIL]  Database: missing table (ports_stp)
  96. [FAIL]  Database: missing table (ports_vlans)
  97. [FAIL]  Database: missing table (port_association_mode)
  98. [FAIL]  Database: missing table (processes)
  99. [FAIL]  Database: missing table (processors)
  100. [FAIL]  Database: missing table (proxmox)
  101. [FAIL]  Database: missing table (proxmox_ports)
  102. [FAIL]  Database: missing table (pseudowires)
  103. [FAIL]  Database: missing table (route)
  104. [FAIL]  Database: missing table (sensors)
  105. [FAIL]  Database: missing table (sensors_to_state_indexes)
  106. [FAIL]  Database: missing table (services)
  107. [FAIL]  Database: missing table (session)
  108. [FAIL]  Database: missing table (slas)
  109. [FAIL]  Database: missing table (state_indexes)
  110. [FAIL]  Database: missing table (state_translations)
  111. [FAIL]  Database: missing table (storage)
  112. [FAIL]  Database: missing table (stp)
  113. [FAIL]  Database: missing table (syslog)
  114. [FAIL]  Database: missing table (tnmsneinfo)
  115. [FAIL]  Database: missing table (toner)
  116. [FAIL]  Database: missing table (ucd_diskio)
  117. [FAIL]  Database: missing table (users)
  118. [FAIL]  Database: missing table (users_prefs)
  119. [FAIL]  Database: missing table (users_widgets)
  120. [FAIL]  Database: missing table (vlans)
  121. [FAIL]  Database: missing table (vminfo)
  122. [FAIL]  Database: missing table (vrfs)
  123. [FAIL]  Database: missing table (vrf_lite_cisco)
  124. [FAIL]  Database: missing table (widgets)
  125. [FAIL]  Database: missing table (wireless_sensors)
  126. [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):
  127.          CREATE TABLE `access_points` (`accesspoint_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `channel` tinyint(4) unsigned NOT NULL DEFAULT '0', `deleted` tinyint(1) NOT NULL DEFAULT '0', `device_id` int(11) NOT NULL DEFAULT 'NULL', `interference` tinyint(3) unsigned NOT NULL DEFAULT 'NULL', `mac_addr` varchar(24) NOT NULL DEFAULT 'NULL', `name` varchar(255) NOT NULL DEFAULT 'NULL', `numactbssid` tinyint(4) NOT NULL DEFAULT '0', `numasoclients` smallint(6) NOT NULL DEFAULT '0', `nummonbssid` tinyint(4) NOT NULL DEFAULT '0', `nummonclients` smallint(6) NOT NULL DEFAULT '0', `radioutil` tinyint(4) NOT NULL DEFAULT '0', `radio_number` tinyint(4) NULL DEFAULT 'NULL', `txpow` tinyint(4) NOT NULL DEFAULT '0', `type` varchar(16) NOT NULL DEFAULT 'NULL', PRIMARY KEY (`accesspoint_id`), INDEX `deleted` (`deleted`), INDEX `name` (`name`,`radio_number`));
  128.          CREATE TABLE `alerts` (`alerted` int(11) NOT NULL DEFAULT 'NULL', `device_id` int(11) NOT NULL DEFAULT 'NULL', `id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `open` int(11) NOT NULL DEFAULT 'NULL', `rule_id` int(11) NOT NULL DEFAULT 'NULL', `state` int(11) NOT NULL DEFAULT 'NULL', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE `unique_alert` (`device_id`,`rule_id`), INDEX `rule_id` (`rule_id`), INDEX `device_id` (`device_id`));
  129.          CREATE TABLE `alert_log` (`details` longblob NULL DEFAULT 'NULL', `device_id` int(11) NOT NULL DEFAULT 'NULL', `id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `rule_id` int(11) NOT NULL DEFAULT 'NULL', `state` int(11) NOT NULL DEFAULT 'NULL', `time_logged` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), INDEX `rule_id` (`rule_id`), INDEX `device_id` (`device_id`), INDEX `time_logged` (`time_logged`));
  130.          CREATE TABLE `alert_map` (`id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `rule` int(11) NOT NULL DEFAULT '0', `target` varchar(255) NOT NULL, PRIMARY KEY (`id`));
  131.          CREATE TABLE `alert_rules` (`device_id` varchar(255) NOT NULL, `disabled` tinyint(1) NOT NULL DEFAULT 'NULL', `extra` varchar(255) NOT NULL DEFAULT 'NULL', `id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `name` varchar(255) NOT NULL DEFAULT 'NULL', `proc` varchar(80) NULL DEFAULT 'NULL', `query` text NOT NULL DEFAULT 'NULL', `rule` text NOT NULL DEFAULT 'NULL', `severity` enum('ok','warning','critical') NOT NULL DEFAULT 'NULL', PRIMARY KEY (`id`), UNIQUE `name` (`name`), INDEX `device_id` (`device_id`));
  132.          CREATE TABLE `alert_schedule` (`end` datetime NOT NULL DEFAULT '1970-01-02 00:00:01', `end_recurring_dt` date NULL DEFAULT 'NULL', `end_recurring_hr` time NOT NULL DEFAULT '00:00:00', `notes` text NOT NULL DEFAULT 'NULL', `recurring` tinyint(1) unsigned NOT NULL DEFAULT '0', `recurring_day` varchar(15) NULL DEFAULT 'NULL', `schedule_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `start` datetime NOT NULL DEFAULT '1970-01-02 00:00:01', `start_recurring_dt` date NOT NULL DEFAULT '1970-01-01', `start_recurring_hr` time NOT NULL DEFAULT '00:00:00', `title` varchar(255) NOT NULL DEFAULT 'NULL', PRIMARY KEY (`schedule_id`));
  133.          CREATE TABLE `alert_schedule_items` (`item_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `schedule_id` int(11) NOT NULL DEFAULT 'NULL', `target` varchar(255) NOT NULL DEFAULT 'NULL', PRIMARY KEY (`item_id`), INDEX `schedule_id` (`schedule_id`));
  134.          CREATE TABLE `alert_templates` (`id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `name` varchar(255) NOT NULL DEFAULT 'NULL', `rule_id` varchar(255) NOT NULL DEFAULT ',', `template` longtext NOT NULL DEFAULT 'NULL', `title` varchar(255) NULL DEFAULT 'NULL', `title_rec` varchar(255) NULL DEFAULT 'NULL', PRIMARY KEY (`id`));
  135.          CREATE TABLE `alert_template_map` (`alert_rule_id` int(11) NOT NULL DEFAULT 'NULL', `alert_templates_id` int(11) NOT NULL DEFAULT 'NULL', `id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, PRIMARY KEY (`id`), INDEX `alert_templates_id` (`alert_templates_id`,`alert_rule_id`));
  136.          CREATE TABLE `api_tokens` (`description` varchar(100) NOT NULL DEFAULT 'NULL', `disabled` tinyint(1) NOT NULL DEFAULT '0', `id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `token_hash` varchar(255) NULL DEFAULT 'NULL', `user_id` int(11) NOT NULL DEFAULT 'NULL', PRIMARY KEY (`id`), UNIQUE `token_hash` (`token_hash`));
  137.          CREATE TABLE `applications` (`app_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `app_instance` varchar(255) NOT NULL DEFAULT 'NULL', `app_state` varchar(32) NOT NULL DEFAULT 'UNKNOWN', `app_state_prev` varchar(32) NULL DEFAULT 'NULL', `app_status` varchar(8) NOT NULL DEFAULT 'NULL', `app_type` varchar(64) NOT NULL DEFAULT 'NULL', `device_id` int(11) NOT NULL DEFAULT 'NULL', `discovered` tinyint(4) NOT NULL DEFAULT '0', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`app_id`), UNIQUE `unique_index` (`device_id`,`app_type`));
  138.          CREATE TABLE `authlog` (`address` text NOT NULL DEFAULT 'NULL', `datetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `result` text NOT NULL DEFAULT 'NULL', `user` text NOT NULL DEFAULT 'NULL', PRIMARY KEY (`id`));
  139.          CREATE TABLE `bgpPeers` (`astext` varchar(64) NOT NULL DEFAULT 'NULL', `bgpLocalAddr` text NOT NULL DEFAULT 'NULL', `bgpPeerAdminStatus` text NOT NULL DEFAULT 'NULL', `bgpPeerFsmEstablishedTime` int(11) NOT NULL DEFAULT 'NULL', `bgpPeerIdentifier` text NOT NULL DEFAULT 'NULL', `bgpPeerInTotalMessages` int(11) NOT NULL DEFAULT 'NULL', `bgpPeerInUpdateElapsedTime` int(11) NOT NULL DEFAULT 'NULL', `bgpPeerInUpdates` int(11) NOT NULL DEFAULT 'NULL', `bgpPeerOutTotalMessages` int(11) NOT NULL DEFAULT 'NULL', `bgpPeerOutUpdates` int(11) NOT NULL DEFAULT 'NULL', `bgpPeerRemoteAddr` text NOT NULL DEFAULT 'NULL', `bgpPeerRemoteAs` bigint(20) NOT NULL DEFAULT 'NULL', `bgpPeerState` text NOT NULL DEFAULT 'NULL', `bgpPeer_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `context_name` varchar(128) NULL DEFAULT 'NULL', `device_id` int(11) NOT NULL DEFAULT 'NULL', PRIMARY KEY (`bgpPeer_id`), INDEX `device_id` (`device_id`));
  140.          CREATE TABLE `bgpPeers_cbgp` (`AcceptedPrefixes` int(11) NOT NULL DEFAULT 'NULL', `AcceptedPrefixes_delta` int(11) NOT NULL DEFAULT 'NULL', `AcceptedPrefixes_prev` int(11) NOT NULL DEFAULT 'NULL', `AdvertisedPrefixes` int(11) NOT NULL DEFAULT 'NULL', `AdvertisedPrefixes_delta` int(11) NOT NULL DEFAULT 'NULL', `AdvertisedPrefixes_prev` int(11) NOT NULL DEFAULT 'NULL', `afi` varchar(16) NOT NULL DEFAULT 'NULL', `bgpPeerIdentifier` varchar(64) NOT NULL DEFAULT 'NULL', `context_name` varchar(128) NULL DEFAULT 'NULL', `DeniedPrefixes` int(11) NOT NULL DEFAULT 'NULL', `DeniedPrefixes_delta` int(11) NOT NULL DEFAULT 'NULL', `DeniedPrefixes_prev` int(11) NOT NULL DEFAULT 'NULL', `device_id` int(11) NOT NULL DEFAULT 'NULL', `PrefixAdminLimit` int(11) NOT NULL DEFAULT 'NULL', `PrefixClearThreshold` int(11) NOT NULL DEFAULT 'NULL', `PrefixThreshold` int(11) NOT NULL DEFAULT 'NULL', `safi` varchar(16) NOT NULL DEFAULT 'NULL', `SuppressedPrefixes` int(11) NOT NULL DEFAULT 'NULL', `SuppressedPrefixes_delta` int(11) NOT NULL DEFAULT 'NULL', `SuppressedPrefixes_prev` int(11) NOT NULL DEFAULT 'NULL', `WithdrawnPrefixes` int(11) NOT NULL DEFAULT 'NULL', `WithdrawnPrefixes_delta` int(11) NOT NULL DEFAULT 'NULL', `WithdrawnPrefixes_prev` int(11) NOT NULL DEFAULT 'NULL', UNIQUE `unique_index` (`device_id`,`bgpPeerIdentifier`,`afi`,`safi`), INDEX `device_id` (`device_id`,`bgpPeerIdentifier`));
  141.          CREATE TABLE `bills` (`bill_autoadded` tinyint(1) NOT NULL DEFAULT 'NULL', `bill_cdr` bigint(20) NULL DEFAULT 'NULL', `bill_custid` varchar(64) NOT NULL DEFAULT 'NULL', `bill_day` int(11) NOT NULL DEFAULT '1', `bill_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `bill_last_calc` datetime NOT NULL DEFAULT 'NULL', `bill_name` text NOT NULL DEFAULT 'NULL', `bill_notes` varchar(256) NOT NULL DEFAULT 'NULL', `bill_quota` bigint(20) NULL DEFAULT 'NULL', `bill_ref` varchar(64) NOT NULL DEFAULT 'NULL', `bill_type` text NOT NULL DEFAULT 'NULL', `dir_95th` varchar(3) NOT NULL DEFAULT 'NULL', `rate_95th` bigint(20) NOT NULL DEFAULT 'NULL', `rate_95th_in` bigint(20) NOT NULL DEFAULT 'NULL', `rate_95th_out` bigint(20) NOT NULL DEFAULT 'NULL', `rate_average` bigint(20) NOT NULL DEFAULT 'NULL', `rate_average_in` bigint(20) NOT NULL DEFAULT 'NULL', `rate_average_out` bigint(20) NOT NULL DEFAULT 'NULL', `total_data` bigint(20) NOT NULL DEFAULT 'NULL', `total_data_in` bigint(20) NOT NULL DEFAULT 'NULL', `total_data_out` bigint(20) NOT NULL DEFAULT 'NULL', UNIQUE `bill_id` (`bill_id`));
  142.          CREATE TABLE `bill_data` (`bill_id` int(11) NOT NULL DEFAULT 'NULL', `delta` bigint(11) NOT NULL DEFAULT 'NULL', `in_delta` bigint(11) NOT NULL DEFAULT 'NULL', `out_delta` bigint(11) NOT NULL DEFAULT 'NULL', `period` int(11) NOT NULL DEFAULT 'NULL', `timestamp` datetime NOT NULL DEFAULT 'NULL', PRIMARY KEY (`bill_id`,`timestamp`), INDEX `bill_id` (`bill_id`));
  143.          CREATE TABLE `bill_history` (`bill_allowed` bigint(20) NOT NULL DEFAULT 'NULL', `bill_datefrom` datetime NOT NULL DEFAULT 'NULL', `bill_dateto` datetime NOT NULL DEFAULT 'NULL', `bill_hist_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `bill_id` int(11) NOT NULL DEFAULT 'NULL', `bill_overuse` bigint(20) NOT NULL DEFAULT 'NULL', `bill_percent` decimal(10,2) NOT NULL DEFAULT 'NULL', `bill_type` text NOT NULL DEFAULT 'NULL', `bill_used` bigint(20) NOT NULL DEFAULT 'NULL', `dir_95th` varchar(3) NOT NULL DEFAULT 'NULL', `pdf` longblob NULL DEFAULT 'NULL', `rate_95th` bigint(20) NOT NULL DEFAULT 'NULL', `rate_95th_in` bigint(20) NOT NULL DEFAULT 'NULL', `rate_95th_out` bigint(20) NOT NULL DEFAULT 'NULL', `rate_average` bigint(20) NOT NULL DEFAULT 'NULL', `rate_average_in` bigint(20) NOT NULL DEFAULT 'NULL', `rate_average_out` bigint(20) NOT NULL DEFAULT 'NULL', `traf_in` bigint(20) NOT NULL DEFAULT 'NULL', `traf_out` bigint(20) NOT NULL DEFAULT 'NULL', `traf_total` bigint(20) NOT NULL DEFAULT 'NULL', `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`bill_hist_id`), UNIQUE `unique_index` (`bill_id`,`bill_datefrom`,`bill_dateto`), INDEX `bill_id` (`bill_id`));
  144.          CREATE TABLE `bill_perms` ();
  145.          CREATE TABLE `bill_ports` ();
  146.          CREATE TABLE `bill_port_counters` (`bill_id` int(11) NOT NULL DEFAULT 'NULL', `in_counter` bigint(20) NULL DEFAULT 'NULL', `in_delta` bigint(20) NOT NULL DEFAULT '0', `out_counter` bigint(20) NULL DEFAULT 'NULL', `out_delta` bigint(20) NOT NULL DEFAULT '0', `port_id` int(11) NOT NULL DEFAULT 'NULL', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`port_id`,`bill_id`));
  147.          CREATE TABLE `callback` (`callback_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `name` char(64) NOT NULL DEFAULT 'NULL', `value` char(64) NOT NULL DEFAULT 'NULL', PRIMARY KEY (`callback_id`));
  148.          CREATE TABLE `cef_switching` (`afi` varchar(4) NOT NULL DEFAULT 'NULL', `cef_index` int(11) NOT NULL DEFAULT 'NULL', `cef_path` varchar(16) NOT NULL DEFAULT 'NULL', `cef_switching_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `device_id` int(11) NOT NULL DEFAULT 'NULL', `drop` int(11) NOT NULL DEFAULT 'NULL', `drop_prev` int(11) NOT NULL DEFAULT 'NULL', `entPhysicalIndex` int(11) NOT NULL DEFAULT 'NULL', `punt` int(11) NOT NULL DEFAULT 'NULL', `punt2host` int(11) NOT NULL DEFAULT 'NULL', `punt2host_prev` int(11) NOT NULL DEFAULT 'NULL', `punt_prev` int(11) NOT NULL DEFAULT 'NULL', `updated` int(11) NOT NULL DEFAULT 'NULL', `updated_prev` int(11) NOT NULL DEFAULT 'NULL', PRIMARY KEY (`cef_switching_id`), UNIQUE `device_id` (`device_id`,`entPhysicalIndex`,`afi`,`cef_index`));
  149.          CREATE TABLE `ciscoASA` (`ciscoASA_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `data` bigint(20) NOT NULL DEFAULT 'NULL', `device_id` int(11) NOT NULL DEFAULT 'NULL', `disabled` tinyint(4) NOT NULL DEFAULT '0', `high_alert` bigint(20) NOT NULL DEFAULT 'NULL', `low_alert` bigint(20) NOT NULL DEFAULT 'NULL', `oid` varchar(255) NOT NULL DEFAULT 'NULL', PRIMARY KEY (`ciscoASA_id`), INDEX `device_id` (`device_id`));
  150.          CREATE TABLE `component` (`device_id` int(11) unsigned NOT NULL DEFAULT 'NULL', `disabled` tinyint(1) NOT NULL DEFAULT '0', `error` varchar(255) NULL DEFAULT 'NULL', `id` int(11) unsigned NOT NULL DEFAULT 'NULL' auto_increment, `ignore` tinyint(1) NOT NULL DEFAULT '0', `label` varchar(255) NULL DEFAULT 'NULL', `status` tinyint(1) NOT NULL DEFAULT '0', `type` varchar(50) NOT NULL DEFAULT 'NULL', PRIMARY KEY (`id`), INDEX `device` (`device_id`), INDEX `type` (`type`));
  151.          CREATE TABLE `component_prefs` (`attribute` varchar(255) NOT NULL DEFAULT 'NULL', `component` int(11) unsigned NOT NULL DEFAULT 'NULL', `id` int(11) unsigned NOT NULL DEFAULT 'NULL' auto_increment, `value` text NOT NULL DEFAULT 'NULL', PRIMARY KEY (`id`), INDEX `component` (`component`));
  152.          CREATE TABLE `component_statuslog` (`component_id` int(11) unsigned NOT NULL DEFAULT 'NULL', `id` int(11) unsigned NOT NULL DEFAULT 'NULL' auto_increment, `message` text NULL DEFAULT 'NULL', `status` tinyint(1) NOT NULL DEFAULT '0', `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), INDEX `device` (`component_id`));
  153.          CREATE TABLE `config` (`config_default` varchar(512) NOT NULL DEFAULT 'NULL', `config_descr` varchar(100) NOT NULL DEFAULT 'NULL', `config_disabled` enum('0','1') NOT NULL DEFAULT '0', `config_group` varchar(50) NOT NULL DEFAULT 'NULL', `config_group_order` int(11) NOT NULL DEFAULT 'NULL', `config_hidden` enum('0','1') NOT NULL DEFAULT '0', `config_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `config_name` varchar(255) NOT NULL DEFAULT 'NULL', `config_sub_group` varchar(50) NOT NULL DEFAULT 'NULL', `config_sub_group_order` int(11) NOT NULL DEFAULT 'NULL', `config_value` varchar(512) NOT NULL DEFAULT 'NULL', PRIMARY KEY (`config_id`), UNIQUE `uniqueindex_configname` (`config_name`));
  154.          CREATE TABLE `customers` (`customer_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `level` tinyint(4) NOT NULL DEFAULT '0', `password` char(32) NOT NULL DEFAULT 'NULL', `string` char(64) NOT NULL DEFAULT 'NULL', `username` char(64) NOT NULL DEFAULT 'NULL', PRIMARY KEY (`customer_id`), UNIQUE `username` (`username`));
  155.          CREATE TABLE `dashboards` (`access` int(1) NOT NULL DEFAULT '0', `dashboard_id` int(11) NOT NULL DEFAULT 'NULL' auto_increment, `dashboard_name` varchar(255) NOT NULL DEFAULT 'NULL', `user_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`dashboard_id`));
  156.          CREATE TABLE `dbSchema` (`version` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`version`));
  157.           and 83 more...
  158. [FAIL]  Disk space where /opt/librenms is located is empty!!!
  159. [FAIL]  rrdtool location is incorrect or bin not installed.
  160.         You can also manually set the path to rrdtool by placing the following in config.php:
  161.         $config['rrdtool'] = "/path/to/rrdtool";
  162. [FAIL]  The poller has never run, check the cron job
  163. [WARN]  You have not added any devices yet.
  164.  


Reply to "mySQL error (/validate.php)"