Hello,
I ran './validate.php
got this:
====================================
Component | Version |
---|---|
LibreNMS | 1.42.01-31-g9f04b58 |
DB Schema | 258 |
PHP | 7.1.19 |
MySQL | 5.1.73 |
RRDTool | 1.3.8 |
SNMP | NET-SNMP 5.5 |
====================================
[OK] Composer Version: 1.7.1
[OK] Dependencies up-to-date.
string(397) "id
int(11) NOT NULL auto_increment, parent_poller
varchar(255) NOT NULL DEFAULT ‘’ , poller_type
varchar(255) NOT NULL DEFAULT ‘’ , depth
int(11) unsigned NOT NULL , devices
int(11) unsigned NOT NULL , worker_seconds
double unsigned NOT NULL , workers
int(11) unsigned NOT NULL , frequency
int(11) unsigned NOT NULL , PRIMARY KEY (parent_poller
,poller_type
), UNIQUE id
(id
)"
[OK] Database connection successful
[FAIL] Database: missing table (poller_cluster_stats)
[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):
[FIX] Run the following SQL statements to fix.
SQL Statements:
CREATE TABLE poller_cluster_stats
(id
int(11) NOT NULL auto_increment, parent_poller
varchar(255) NOT NULL DEFAULT ‘’ , poller_type
varchar(255) NOT NULL DEFAULT ‘’ , depth
int(11) unsigned NOT NULL , devices
int(11) unsigned NOT NULL , worker_seconds
double unsigned NOT NULL , workers
int(11) unsigned NOT NULL , frequency
int(11) unsigned NOT NULL , PRIMARY KEY (parent_poller
,poller_type
), UNIQUE id
(id
));
I get when I go to create the table -
mysql> use librenms;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql>
CREATE TABLE
poller_cluster_stats(
idint(11) NOT NULL auto_increment,
parent_pollervarchar(255) NOT NULL DEFAULT '' ,
poller_typevarchar(255) NOT NULL DEFAULT '' ,
depthint(11) unsigned NOT NULL ,
devicesint(11) unsigned NOT NULL ,
worker_secondsdouble unsigned NOT NULL ,
workersint(11) unsigned NOT NULL ,
frequencyint(11) unsigned NOT NULL , PRIMARY KEY (
parent_poller,
poller_type), UNIQUE
id(
id));
ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes
Work around?