LibreNMS don`t dysplay graphs mpls>sap for Nokia devices

[Sergey_D]

librenms does not display the mpls>sap selection url in the Nokia device graphs. But if I type in the browser /device/device=3/tab=routing/proto=mpls/view=sap/, I can see these graphs as shown in the screenshot.
Why doesn’t librenms generate a url for selecting these graphs?

[Craig]

Please run .validate.php and make sure you are the latest release.

[Sergey_D]

./validate.php

Component	Version
LibreNMS	21.2.0-52-g61316ce2c
DB Schema	2021_02_09_122930_migrate_to_utf8mb4 (201)
PHP	7.3.20
Python	3.6.8
MySQL	10.3.17-MariaDB
RRDTool	1.7.0
SNMP	NET-SNMP 5.8

====================================

[OK] Composer Version: 2.0.11
[OK] Dependencies up-to-date.
[OK] Database connection successful
[WARN] Your database schema has extra migrations (2021_02_09_122930_migrate_to_utf8mb4). If you just switched to the stable release from the daily release, your database is in between releases and this will be resolved with the next release.
[FAIL] MySQL tables collation is wrong:
[FIX]:
Check http://bit.ly/2lAG9H8 for info on how to fix.
Tables:
alert_device_map utf8mb4 utf8mb4_unicode_ci
alert_group_map utf8mb4 utf8mb4_unicode_ci
alert_location_map utf8mb4 utf8mb4_unicode_ci
alert_log utf8mb4 utf8mb4_unicode_ci
alert_rules utf8mb4 utf8mb4_unicode_ci
alert_schedulables utf8mb4 utf8mb4_unicode_ci
alert_schedule utf8mb4 utf8mb4_unicode_ci
alert_template_map utf8mb4 utf8mb4_unicode_ci
alert_templates utf8mb4 utf8mb4_unicode_ci
alert_transport_groups utf8mb4 utf8mb4_unicode_ci
alert_transport_map utf8mb4 utf8mb4_unicode_ci
alert_transports utf8mb4 utf8mb4_unicode_ci
alerts utf8mb4 utf8mb4_unicode_ci
api_tokens utf8mb4 utf8mb4_unicode_ci
application_metrics utf8mb4 utf8mb4_unicode_ci
and 121 more…
[FAIL] MySQL column collation is wrong:
[FIX]:
Check https://t.libren.ms/-zdwk for info on how to fix.
Columns:
access_points name utf8mb4 utf8mb4_unicode_ci
access_points type utf8mb4 utf8mb4_unicode_ci
access_points mac_addr utf8mb4 utf8mb4_unicode_ci
alert_rules rule utf8mb4 utf8mb4_unicode_ci
alert_rules severity utf8mb4 utf8mb4_unicode_ci
alert_rules extra utf8mb4 utf8mb4_unicode_ci
alert_rules name utf8mb4 utf8mb4_unicode_ci
alert_rules query utf8mb4 utf8mb4_unicode_ci
alert_rules builder utf8mb4 utf8mb4_unicode_ci
alert_rules proc utf8mb4 utf8mb4_unicode_ci
alert_schedulables alert_schedulable_type utf8mb4 utf8mb4_unicode_ci
alert_schedule recurring_day utf8mb4 utf8mb4_unicode_ci
alert_schedule title utf8mb4 utf8mb4_unicode_ci
alert_schedule notes utf8mb4 utf8mb4_unicode_ci
alert_templates name utf8mb4 utf8mb4_unicode_ci
and 497 more…
[FAIL] Database: incorrect column (mpls_services/svc_oid)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE mpls_services CHANGE svc_oid svc_oid int unsigned NOT NULL ;
[WARN] Your install is over 24 hours out of date, last update: Sat, 13 Mar 2021 00:10:14 +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 contains modified files, this could prevent automatic updates.
[FIX]:
You can fix this with ./scripts/github-remove
Modified Files:
bootstrap/cache/.gitignore
logs/.gitignore
rrd/.gitignore
storage/app/.gitignore
storage/app/public/.gitignore
storage/debugbar/.gitignore
storage/framework/cache/.gitignore
storage/framework/cache/data/.gitignore
storage/framework/sessions/.gitignore
storage/framework/testing/.gitignore
storage/framework/views/.gitignore
storage/logs/.gitignore

[Craig]

Try to do a ./daily.sh and it still does not update the table below, then jump on discord for help.

[FAIL] Database: incorrect column (mpls_services/svc_oid)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE mpls_services CHANGE svc_oid svc_oid int unsigned NOT NULL ;

Also, the the lines,

[FAIL] Database: incorrect column (mpls_services/svc_oid)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
[FIX]:
Run the following SQL statements to fix.
SQL Statements:
ALTER TABLE mpls_services CHANGE svc_oid svc_oid int unsigned NOT NULL ;
[WARN] Your install is over 24 hours out of date, last update: Sat, 13 Mar 2021 00:10:14 +0000
[FIX]:
Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.

I would do a ./daily.sh

Craig

[Sergey_D]

1.
*./daily.sh is running every night by cron. *
I ran it manually:

librenms@backup1~]$ ./daily.sh
Updating to latest codebase OK
Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK

2.
I fixed the database table mpls_services

[librenms@backup1 ~]$ ./validate.php

Component	Version
LibreNMS	21.2.0-53-g92bf7d5ef
DB Schema	2021_02_09_122930_migrate_to_utf8mb4 (201)
PHP	7.3.20
Python	3.6.8
MySQL	10.3.17-MariaDB
RRDTool	1.7.0
SNMP	NET-SNMP 5.8

====================================

[OK] Composer Version: 2.0.11
[OK] Dependencies up-to-date.
[OK] Database connection successful
[WARN] Your database schema has extra migrations (2021_02_09_122930_migrate_to_utf8mb4). If you just switched to the stable release from the daily release, your database is in between releases and this will be resolved with the next release.
[FAIL] MySQL tables collation is wrong:
[FIX]:
Check http://bit.ly/2lAG9H8 for info on how to fix.
Tables:
alert_device_map utf8mb4 utf8mb4_unicode_ci
alert_group_map utf8mb4 utf8mb4_unicode_ci
alert_location_map utf8mb4 utf8mb4_unicode_ci
alert_log utf8mb4 utf8mb4_unicode_ci
alert_rules utf8mb4 utf8mb4_unicode_ci
alert_schedulables utf8mb4 utf8mb4_unicode_ci
alert_schedule utf8mb4 utf8mb4_unicode_ci
alert_template_map utf8mb4 utf8mb4_unicode_ci
alert_templates utf8mb4 utf8mb4_unicode_ci
alert_transport_groups utf8mb4 utf8mb4_unicode_ci
alert_transport_map utf8mb4 utf8mb4_unicode_ci
alert_transports utf8mb4 utf8mb4_unicode_ci
alerts utf8mb4 utf8mb4_unicode_ci
api_tokens utf8mb4 utf8mb4_unicode_ci
application_metrics utf8mb4 utf8mb4_unicode_ci
and 121 more…
[FAIL] MySQL column collation is wrong:
[FIX]:
Check https://t.libren.ms/-zdwk for info on how to fix.
Columns:
access_points name utf8mb4 utf8mb4_unicode_ci
access_points type utf8mb4 utf8mb4_unicode_ci
access_points mac_addr utf8mb4 utf8mb4_unicode_ci
alert_rules rule utf8mb4 utf8mb4_unicode_ci
alert_rules severity utf8mb4 utf8mb4_unicode_ci
alert_rules extra utf8mb4 utf8mb4_unicode_ci
alert_rules name utf8mb4 utf8mb4_unicode_ci
alert_rules query utf8mb4 utf8mb4_unicode_ci
alert_rules builder utf8mb4 utf8mb4_unicode_ci
alert_rules proc utf8mb4 utf8mb4_unicode_ci
alert_schedulables alert_schedulable_type utf8mb4 utf8mb4_unicode_ci
alert_schedule recurring_day utf8mb4 utf8mb4_unicode_ci
alert_schedule title utf8mb4 utf8mb4_unicode_ci
alert_schedule notes utf8mb4 utf8mb4_unicode_ci
alert_templates name utf8mb4 utf8mb4_unicode_ci
and 497 more…
[OK] Database schema correct
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX]:
You can fix this with ./scripts/github-remove
Modified Files:
bootstrap/cache/.gitignore
logs/.gitignore
rrd/.gitignore
storage/app/.gitignore
storage/app/public/.gitignore
storage/debugbar/.gitignore
storage/framework/cache/.gitignore
storage/framework/cache/data/.gitignore
storage/framework/sessions/.gitignore
storage/framework/testing/.gitignore
storage/framework/views/.gitignore
storage/logs/.gitignore

3.
I can’t fix the table and column collation because I get an error

[librenms@backup1 ~]$ mysql -p -u librenms librenms < /opt/librenms/sql-schema/171.sql
Enter password:
ERROR 1146 (42S02) at line 2: Table ‘librenms.alert_map’ doesn’t exist