Display Text does not work

In the “Availability Map” widget, When “mode select” set to “only services”, no matter you choose Hostname or Sysname for “Display Text” field, the boxes display empty.

Version 21.2.0-46-g9cd963e3a - Thu Mar 11 2021 21:28:53 GMT+0800
Database Schema 2021_02_21_203415_location_add_fixed_coordinates_flag (200)
Web Server Apache/2.4.41 (Ubuntu)
PHP 7.4.3
Python 3.8.5
MySQL 5.7.33
Laravel 8.27.0
RRDtool 1.7.2

Please run

./validate.php and post the return.

[email protected]:~$ ./validate.php

Component Version
LibreNMS 21.2.0-52-g61316ce2c
DB Schema 2021_02_21_203415_location_add_fixed_coordinates_flag (200)
PHP 7.4.3
Python 3.8.5
MySQL 5.7.33
RRDTool 1.7.2
SNMP NET-SNMP 5.8

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

[OK] Composer Version: 2.0.11
[OK] Dependencies up-to-date.
[OK] Database connection successful
[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_schedulables utf8mb4 utf8mb4_unicode_ci
alert_transport_groups utf8mb4 utf8mb4_unicode_ci
alert_transport_map utf8mb4 utf8mb4_unicode_ci
alert_transports utf8mb4 utf8mb4_unicode_ci
application_metrics utf8mb4 utf8mb4_unicode_ci
availability utf8mb4 utf8mb4_unicode_ci
cache utf8mb4 utf8mb4_unicode_ci
cache_locks utf8mb4 utf8mb4_unicode_ci
cef_switching utf8mb4 utf8mb4_unicode_ci
component utf8mb4 utf8mb4_unicode_ci
component_prefs utf8mb4 utf8mb4_unicode_ci
component_statuslog utf8mb4 utf8mb4_unicode_ci
and 50 more…
[FAIL] MySQL column collation is wrong:
[FIX]:
Check https://t.libren.ms/-zdwk for info on how to fix.
Columns:
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_templates name utf8mb4 utf8mb4_unicode_ci
alert_templates template utf8mb4 utf8mb4_unicode_ci
alert_templates title utf8mb4 utf8mb4_unicode_ci
alert_templates title_rec utf8mb4 utf8mb4_unicode_ci
alert_transport_groups transport_group_name utf8mb4 utf8mb4_unicode_ci
alert_transport_map target_type utf8mb4 utf8mb4_unicode_ci
alert_transports transport_name utf8mb4 utf8mb4_unicode_ci
and 260 more…
[OK] Database schema correct

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