Error daily sh

Yoan_DuM · 19 October 2021 12:54

Hi,

here is my ./daily.sh issue on debian 9.13 (stretch)

Any idea ?

Yoan_DuM · 19 October 2021 12:55

here is my validate.php

Yoan_DuM · 19 October 2021 14:43

after working few hours, update python and mariadb i’m here :

validate is ok

$ ./validate.php

Component	Version
LibreNMS	1.63-57-g0040f38d1
DB Schema	2020_04_19_010532_eventlog_sensor_reference_cleanup (164)
PHP	7.4.24
Python	3.5.3
MySQL	10.5.12-MariaDB-1:10.5.12+maria~stretch
RRDTool	1.6.0
SNMP	NET-SNMP 5.7.3
====================================

[OK] Composer Version: 1.10.23
[OK] Dependencies up-to-date.
[OK] Database connection successful
[OK] Database schema correct
[WARN] Your install is over 24 hours out of date, last update: Tue, 30 Jun 2020 14:09:39 +0000
[FIX]:
Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.
[WARN] Your local git branch is not master, this will prevent automatic updates.
[FIX]:
You can switch back to master with git checkout master

daily.sh

Supported PHP and Python version, switched back to master branch. OK

In AppServiceProvider.php line 45:

Call to undefined method Illuminate\Pagination\Paginator::useBootstrap()

In AppServiceProvider.php line 45:

Call to undefined method Illuminate\Pagination\Paginator::useBootstrap()

Updating to latest codebase OK

In AppServiceProvider.php line 45:

Call to undefined method Illuminate\Pagination\Paginator::useBootstrap()

In AppServiceProvider.php line 45:

Call to undefined method Illuminate\Pagination\Paginator::useBootstrap()

Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK
Caching Mac OUI data OK

but my webconsole doesn’t mach

Database inconsistent

Database inconsistencies found during a database error, please fix to continue.

Your database is out of date!

./lnms migrate

Yoan_DuM · 19 October 2021 14:52

$ ./validate.php

Component	Version
LibreNMS	21.10.0-20-g568d12cbd
DB Schema	2020_06_23_00522_alter_availability_perc_column (171)
PHP	7.4.24
Python	3.5.3
MySQL	10.5.12-MariaDB-1:10.5.12+maria~stretch
RRDTool	1.6.0
SNMP	NET-SNMP 5.7.3
====================================

[OK] Composer Version: 2.1.9
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate

Jellyfrog · 19 October 2021 15:43

Seems you solved it. Else delete the vendor folder and rerun the php dependency step from installation guide

Yoan_DuM · 20 October 2021 06:58

OK, done but I always have a problem with my base

./lnms migrate

In Connection.php line 703:

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the
manual. You have to change some columns to TEXT or BLOBs (SQL: alter table ports drop ifHighSpeed, drop ifHighSpeed_prev)

In Exception.php line 18:

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the
manual. You have to change some columns to TEXT or BLOBs

In PDOStatement.php line 117:

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the
manual. You have to change some columns to TEXT or BLOBs

$ ./lnms migrate --pretend

```
Application In Production!     *
```

Do you really wish to run this command? (yes/no) [no]:

y

DropPortsIfHighSpeed: alter table ports drop ifHighSpeed, drop ifHighSpeed_prev
AlterDevicesSnmpAlgoColumns: ALTER TABLE devices CHANGE authalgo authalgo VARCHAR(10) CHARACTER SET utf8 DEFAULT NULL COLLATE utf8_unicode_ci, CHANGE cryptoalgo cryptoalgo VARCHAR(10) CHARACTER SET utf8 DEFAULT NULL COLLATE utf8_unicode_ci
AddDevicePerfIndex: alter table device_perf add index device_perf_device_id_timestamp_index(device_id, timestamp)
DropUptimeColumnOutages: alter table device_outages drop uptime
CreateCacheTable: create table cache (key varchar(255) not null, value text not null, expiration int not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’
CreateCacheTable: alter table cache add unique cache_key_unique(key)
CreateServiceTemplatesDeviceGroupTable: create table service_templates_device_group (service_template_id int unsigned not null, device_group_id int unsigned not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’
CreateServiceTemplatesDeviceGroupTable: alter table service_templates_device_group add primary key service_templates_device_group_relationship_primary(service_template_id, device_group_id)
CreateServiceTemplatesDeviceGroupTable: alter table service_templates_device_group add index service_templates_device_group_service_template_id_index(service_template_id)
CreateServiceTemplatesDeviceGroupTable: alter table service_templates_device_group add index service_templates_device_group_device_group_id_index(device_group_id)
CreateServiceTemplatesDeviceTable: create table service_templates_device (service_template_id int unsigned not null, device_id int unsigned not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’
CreateServiceTemplatesDeviceTable: alter table service_templates_device add primary key service_templates_device_relationship_primary(service_template_id, device_id)
CreateServiceTemplatesDeviceTable: alter table service_templates_device add index service_templates_device_service_template_id_index(service_template_id)
CreateServiceTemplatesDeviceTable: alter table service_templates_device add index service_templates_device_device_id_index(device_id)
CreateServiceTemplatesTable: create table service_templates (id int unsigned not null auto_increment primary key, ip text null, type varchar(255) not null, dtype varchar(16) not null default ‘static’, drules text null, dgtype varchar(16) not null default ‘static’, dgrules text null, desc text null, param text null, ignore tinyint(1) not null default ‘0’, changed timestamp not null default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, disabled tinyint(1) not null default ‘0’, name varchar(255) not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’
ExtendServicesTableForServiceTemplatesTable: ALTER TABLE services CHANGE service_ip service_ip TEXT CHARACTER SET utf8 DEFAULT NULL COLLATE utf8_unicode_ci, CHANGE service_desc service_desc TEXT CHARACTER SET utf8 DEFAULT NULL COLLATE utf8_unicode_ci, CHANGE service_param service_param TEXT CHARACTER SET utf8 DEFAULT NULL COLLATE utf8_unicode_ci, CHANGE service_ignore service_ignore TINYINT(1) DEFAULT ‘0’ NOT NULL, CHANGE service_message service_message TEXT CHARACTER SET utf8 DEFAULT NULL COLLATE utf8_unicode_ci, CHANGE service_ds service_ds TEXT CHARACTER SET utf8 DEFAULT NULL COLLATE utf8_unicode_ci
ExtendServicesTableForServiceTemplatesTable: alter table services add service_template_id int unsigned not null default ‘0’, add service_name varchar(255) null
AddForeignKeysToServiceTemplatesDeviceGroupTable: alter table service_templates_device_group add constraint service_templates_device_group_service_template_id_foreign foreign key (service_template_id) references service_templates (id) on delete CASCADE on update RESTRICT
AddForeignKeysToServiceTemplatesDeviceGroupTable: alter table service_templates_device_group add constraint service_templates_device_group_device_group_id_foreign foreign key (device_group_id) references device_groups (id) on delete CASCADE on update RESTRICT
AddForeignKeysToServiceTemplatesDeviceTable: alter table service_templates_device add constraint service_templates_device_service_template_id_foreign foreign key (service_template_id) references service_templates (id) on delete CASCADE on update RESTRICT
AddForeignKeysToServiceTemplatesDeviceTable: alter table service_templates_device add constraint service_templates_device_device_id_foreign foreign key (device_id) references devices (device_id) on delete CASCADE on update RESTRICT
AddAlertLogIndex: alter table alert_log add index alert_log_rule_id_device_id_index(rule_id, device_id)
AddAlertLogIndex: alter table alert_log add index alert_log_rule_id_device_id_state_index(rule_id, device_id, state)
CreateCacheLocksTable: create table cache_locks (key varchar(255) not null, owner varchar(255) not null, expiration int not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’
CreateCacheLocksTable: alter table cache_locks add primary key cache_locks_key_primary(key)
AddPrimaryKeyBillPerms: select column_name as column_name from information_schema.columns where table_schema = ? and table_name = ?
AddPrimaryKeyBillPerms: alter table bill_perms add id bigint unsigned not null auto_increment primary key first
AddPrimaryKeyBillPorts: select column_name as column_name from information_schema.columns where table_schema = ? and table_name = ?
AddPrimaryKeyBillPorts: alter table bill_ports add id bigint unsigned not null auto_increment primary key first
AddPrimaryKeyDevicesPerms: select column_name as column_name from information_schema.columns where table_schema = ? and table_name = ?
AddPrimaryKeyDevicesPerms: alter table devices_perms add id bigint unsigned not null auto_increment primary key first
AddPrimaryKeyEntphysicalState: select column_name as column_name from information_schema.columns where table_schema = ? and table_name = ?
AddPrimaryKeyEntphysicalState: alter table entPhysical_state add id bigint unsigned not null auto_increment primary key first
AddPrimaryKeyIpv4Mac: select column_name as column_name from information_schema.columns where table_schema = ? and table_name = ?
AddPrimaryKeyIpv4Mac: alter table ipv4_mac add id bigint unsigned not null auto_increment primary key first
AddPrimaryKeyJuniatmvp: select column_name as column_name from information_schema.columns where table_schema = ? and table_name = ?
AddPrimaryKeyJuniatmvp: alter table juniAtmVp add id bigint unsigned not null auto_increment primary key first
AddPrimaryKeyLoadbalancerVservers: select column_name as column_name from information_schema.columns where table_schema = ? and table_name = ?
AddPrimaryKeyLoadbalancerVservers: alter table loadbalancer_vservers add id bigint unsigned not null auto_increment primary key first
AddPrimaryKeyPortsPerms: select column_name as column_name from information_schema.columns where table_schema = ? and table_name = ?
AddPrimaryKeyPortsPerms: alter table ports_perms add id bigint unsigned not null auto_increment primary key first
AddPrimaryKeyProcesses: select column_name as column_name from information_schema.columns where table_schema = ? and table_name = ?
AddPrimaryKeyProcesses: alter table processes add id bigint unsigned not null auto_increment primary key first
AddPrimaryKeyTransportGroupTransport: select column_name as column_name from information_schema.columns where table_schema = ? and table_name = ?
AddPrimaryKeyTransportGroupTransport: alter table transport_group_transport add id bigint unsigned not null auto_increment primary key first
MempoolsAddOids: ALTER TABLE mempools CHANGE mempool_descr mempool_descr VARCHAR(128) CHARACTER SET utf8 NOT NULL COLLATE utf8_unicode_ci
MempoolsAddOids: alter table mempools add mempool_class varchar(32) not null default ‘system’ after mempool_type, add mempool_perc_oid varchar(255) null after mempool_perc, add mempool_used_oid varchar(255) null after mempool_used, add mempool_free_oid varchar(255) null after mempool_free, add mempool_total_oid varchar(255) null after mempool_total
MempoolsAddOids: alter table mempools drop hrDeviceIndex
MempoolsAddOids: update devices set last_discovered = ? where device_id in (select distinct device_id from mempools)
AllowNullableOspfColumns: ALTER TABLE ospf_areas CHANGE ospfAuthType ospfAuthType VARCHAR(64) CHARACTER SET utf8 DEFAULT NULL COLLATE utf8_unicode_ci
AddTosToOspfPorts: alter table ospf_ports add ospfIfMetricIpAddress varchar(32) null after ospfIfAuthType, add ospfIfMetricAddressLessIf int null after ospfIfMetricIpAddress, add ospfIfMetricTOS int null after ospfIfMetricAddressLessIf, add ospfIfMetricValue int null after ospfIfMetricTOS, add ospfIfMetricStatus varchar(32) null after ospfIfMetricValue
AddPowerstateEnumToVminfo: select id, vmwVmState from vminfo order by vminfo.id asc limit 100 offset 0
AddPowerstateEnumToVminfo: ALTER TABLE vminfo CHANGE vmwVmState vmwVmState SMALLINT UNSIGNED NOT NULL
CreatePortGroupPortTable: select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = ‘BASE TABLE’
CreatePortGroupPortTable: create table port_group_port (port_group_id int unsigned not null, port_id int unsigned not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’
CreatePortGroupPortTable: alter table port_group_port add primary key port_group_port_port_group_id_port_id_primary(port_group_id, port_id)
CreatePortGroupPortTable: alter table port_group_port add index port_group_port_port_group_id_index(port_group_id)
CreatePortGroupPortTable: alter table port_group_port add index port_group_port_port_id_index(port_id)
CreatePortGroupsTable: select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = ‘BASE TABLE’
CreatePortGroupsTable: create table port_groups (id int unsigned not null auto_increment primary key, name varchar(255) not null, desc varchar(255) null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’
CreatePortGroupsTable: alter table port_groups add unique port_groups_name_unique(name)
FixInvalidDates: select TABLE_NAME, COLUMN_NAME from information_schema.columns where table_schema = ? and COLUMN_TYPE in (?, ?)
RemovePerfTimes: drop table perf_times
MigrateToUtf8mb4: ALTER SCHEMA librenms DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci;
MigrateToUtf8mb4: select TABLE_NAME from information_schema.tables where table_schema = ?
MigrateToUtf8mb4: select * from information_schema.columns where table_schema = ? and CHARACTER_SET_NAME is not null and COLLATION_NAME is not null and (CHARACTER_SET_NAME != ? or COLLATION_NAME != ?)
LocationAddFixedCoordinatesFlag: alter table locations add fixed_coordinates tinyint(1) not null default ‘0’
RenameTonerTable: rename table toner to printer_supplies
RenamePrinterColumns: failed to dump queries. This may be due to changing database columns using Doctrine, which is not supported while pretending to run migrations.
ServiceTemplatesCleanup: failed to dump queries. This may be due to changing database columns using Doctrine, which is not supported while pretending to run migrations.
ChangeCacheToMediumtext: failed to dump queries. This may be due to changing database columns using Doctrine, which is not supported while pretending to run migrations.
AddForeignKeysToPortGroupPortTable: alter table port_group_port add constraint port_group_port_port_group_id_foreign foreign key (port_group_id) references port_groups (id) on delete CASCADE
AddForeignKeysToPortGroupPortTable: alter table port_group_port add constraint port_group_port_port_id_foreign foreign key (port_id) references ports (port_id) on delete CASCADE
CreateSessionsTable: create table sessions (id varchar(255) not null, user_id bigint unsigned null, ip_address varchar(45) null, user_agent text null, payload text not null, last_activity int not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’
CreateSessionsTable: alter table sessions add primary key sessions_id_primary(id)
CreateSessionsTable: alter table sessions add index sessions_user_id_index(user_id)
CreateSessionsTable: alter table sessions add index sessions_last_activity_index(last_activity)
SlasAddRttField: ALTER TABLE slas CHANGE sla_nr sla_nr INT UNSIGNED NOT NULL
SlasAddRttField: alter table slas add rtt double(8, 2) unsigned null after rtt_type
AlterBillHistoryMaxMin: alter table bill_history add bill_peak_out bigint null after traf_total, add bill_peak_in bigint null after bill_peak_out
PluginsAddVersionAndSettings: alter table plugins add version int not null default ‘1’, add settings longtext null
AddSyslogIndexes: alter table syslog add index syslog_device_id_program_index(device_id, program)
AddSyslogIndexes: alter table syslog add index syslog_device_id_priority_index(device_id, priority)
ConfigValueToMediumText: ALTER TABLE config CHANGE config_value config_value MEDIUMTEXT CHARACTER SET utf8 NOT NULL COLLATE utf8_unicode_ci
CreatePushSubscriptionsTable: create table push_subscriptions (id bigint unsigned not null auto_increment primary key, subscribable_type varchar(255) not null, subscribable_id bigint unsigned not null, endpoint varchar(500) not null, public_key varchar(255) null, auth_token varchar(255) null, content_encoding varchar(255) null, description varchar(255) null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’
CreatePushSubscriptionsTable: alter table push_subscriptions add index push_subscriptions_subscribable_type_subscribable_id_index(subscribable_type, subscribable_id)
CreatePushSubscriptionsTable: alter table push_subscriptions add unique push_subscriptions_endpoint_unique(endpoint)
CreateHrSystemTable: create table hrSystem (hrSystem_id int unsigned not null auto_increment primary key, device_id int unsigned not null, hrSystemNumUsers int not null default ‘0’, hrSystemProcesses int not null default ‘0’, hrSystemMaxProcesses int not null default ‘0’) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’
CreateHrSystemTable: alter table hrSystem add index hrsystem_device_id_index(device_id)
AddDeviceOutagesIndex: select column_name as column_name from information_schema.columns where table_schema = ? and table_name = ?
AddDeviceOutagesIndex: alter table device_outages add id bigint unsigned not null auto_increment primary key first
UpdateHrSystemTable: failed to dump queries. This may be due to changing database columns using Doctrine, which is not supported while pretending to run migrations.
CreateIsisAdjacenciesTable: create table isis_adjacencies (id int unsigned not null auto_increment primary key, device_id int not null, port_id int not null, ifIndex int not null, isisISAdjState varchar(13) not null, isisISAdjNeighSysType varchar(128) not null, isisISAdjNeighSysID varchar(128) not null, isisISAdjNeighPriority varchar(128) not null, isisISAdjLastUpTime bigint unsigned not null, isisISAdjAreaAddress varchar(128) not null, isisISAdjIPAddrType varchar(128) not null, isisISAdjIPAddrAddress varchar(128) not null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’
CreateIsisAdjacenciesTable: alter table isis_adjacencies add index isis_adjacencies_device_id_index(device_id)
CreateIsisAdjacenciesTable: alter table isis_adjacencies add index isis_adjacencies_port_id_index(port_id)
CreateIsisAdjacenciesTable: alter table isis_adjacencies add index isis_adjacencies_ifindex_index(ifIndex)
IsisAdjacenciesAddAdminStatus: alter table isis_adjacencies add isisCircAdminState varchar(16) not null default ‘off’
IsisAdjacenciesNullable: failed to dump queries. This may be due to changing database columns using Doctrine, which is not supported while pretending to run migrations.

I’m not the king of base,I’m a newbie, anyone can help me ?

Thank u

Jellyfrog · 20 October 2021 07:43

This is outside of librenms control.
Your database table format is likely not set to dynamic. Etc. Google these errors

system · 18 January 2022 07:43

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.