icinga2 icon indicating copy to clipboard operation
icinga2 copied to clipboard

disable utf8 on IDO resource in icingaweb2 resource

Open kouk opened this issue 6 years ago • 5 comments

Fixes: https://github.com/jjethwa/icinga2/issues/121 Replaces: https://github.com/jjethwa/icinga2/pull/139

See below for an explanation: https://github.com/Icinga/icingaweb2/pull/3170 https://github.com/skm42/icinga2/issues/1

kouk avatar Mar 16 '18 09:03 kouk

It looks promising, that this is the actual issue. Thank you for your PR. I will review/test it later.

bebehei avatar Mar 16 '18 15:03 bebehei

works perfect and matches director requirement for utf8. Wasn't aware about it.

skm42 avatar Mar 17 '18 18:03 skm42

bebehei highlighted the question of migration https://github.com/jjethwa/icinga2/pull/139#issuecomment-373217507. Copied data directory created with https://github.com/jjethwa/icinga2/pull/140/commits/67bb188fd8448d7a5159a0fbc58c321eacf775bf and launched by docker-compose. content/etc/icingaweb2/resources.ini is not in place due to volume mount ./data/icinga/etc/icingaweb2:/etc/icingaweb2. After update of ./data/icinga/etc/icingaweb2/resources.ini graphite is looking ok and IDO looks like this:

MariaDB [(none)]> use icinga2idomysql
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 MariaDB [icinga2idomysql]> show variables like '%char%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8mb4 | | character_set_connection | utf8mb4 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | utf8mb4 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.00 sec) what about using ini_set in content/opt/setup/60-icingaweb2 to drop in configuration update?

skm42 avatar Mar 18 '18 10:03 skm42

any news? tired of changing charset on any container reinstall :)

fufar avatar Oct 12 '21 15:10 fufar

Hi @fufar

Sorry, I haven't looked at this one in a while, I think the workarounds in the referenced Issues/PRs are ok, right? If not, what are you having to modify?

jjethwa avatar Oct 12 '21 16:10 jjethwa