icinga2
icinga2 copied to clipboard
disable utf8 on IDO resource in icingaweb2 resource
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
It looks promising, that this is the actual issue. Thank you for your PR. I will review/test it later.
works perfect and matches director requirement for utf8. Wasn't aware about it.
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?
any news? tired of changing charset on any container reinstall :)
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?