Icingaweb2 and cyrillic

Icinga Web
1

Hi

this problem was discussed, but the proposed solutions did not help
in new install icingaweb cyrillic dysplay_name view as ‘?’

изображение

  • Icinga Web 2 version - 2.8.2

  • Used modules and their versions (System - About)
    |Name|Version|
    |[director]|1.8.0|
    |[fileshipper]|1.2.0|
    |[incubator]|0.6.0|
    |[ipl]|v0.5.0|
    |[monitoring]|2.8.2|
    |[reactbundle]|0.9.0|
    |[x509]|1.0.0|

  • Web browser used
    Firefox - lasted
    Edge - lasted

  • Icinga 2 version used (icinga2 --version)
    r2.12.3-1

  • PHP version used (php --version)
    7.4.3

  • Server operating system and version
    Ubuntu Server 20.04

in file ‘/etc/icingaweb2/resources.ini’
[icinga_ido]
type = “db”
db = “mysql”
host = “localhost”
dbname = “ido_icinga2”
username = “ido_icinga2”
password = “”
charset = “latin1”
persistent = “0”
use_ssl = “0”

2

I solved the problem )))

i install mariadb from packets

apt install mariadb-server

with this installation default character set - utf8mb4
for Icinga IDO we need change it to “latin1” before IDO base install

my ansible task for solved it

- name: configure default-character in MariaDB configuration files
  become: yes
  lineinfile: 
    dest: "{{ item }}"
    regexp: '^default-character-set = utf8mb4'
    insertbefore: BOF
    line: 'default-character-set = latin1'
    state: present
  loop:
    - "/etc/mysql/mariadb.conf.d/50-client.cnf"
    - "/etc/mysql/mariadb.conf.d/50-mysql-clients.cnf"

- name: configure default-character in MariaDB 50-server.cnf files
  become: yes
  lineinfile:
    dest: "/etc/mysql/mariadb.conf.d/50-server.cnf"
    regexp: "{{ item.regexp }}"
    line: "{{ item.line }}"
  loop:
    - { regexp: '^character-set-server  = utf8mb4', line: 'character-set-server = Latin1' }
    - { regexp: '^collation-server      = utf8mb4_general_ci', line: 'collation-server = latin1_bin' }

- name: restart mariadb
  become: yes
  service:
    name: mysql
    state: restarted