Thanks for your answer, much appreciated!
So what I am taking away from this is:
- it doesn’t matter what the encoding was when the DB was created, as long as I put “
latin1” in the IDO resource config
The only difference, as fas as I can see, is that I am using a different MySQL/MariaDB version.
Im installing via Ansible atm (to learn it 
)
The db parts
- name: Create a new database with name 'icinga'
mysql_db:
name: icinga2
state: present
login_user: 'root'
login_password: "{{ mysql_root_password }}"
- name: Create icinga mysql user
mysql_user:
login_user: 'root'
login_password: "{{ mysql_root_password }}"
name: icinga2
password: "{{ icinga_user_password }}"
host: "{{ item }}"
priv: "icinga2.*:SELECT,INSERT,UPDATE,DELETE,DROP,CREATE,VIEW,INDEX,EXECUTE"
state: present
loop:
- 127.0.0.1
- ::1
- localhost
- name: Import /usr/share/icinga2-ido-mysql/schema/mysql.sql
mysql_db:
login_user: 'root'
login_password: "{{ mysql_root_password }}"
state: import
name: icinga2
target: /usr/share/icinga2-ido-mysql/schema/mysql.sql
Anything under /usr/share/icinga2-ido-mysql/schema/upgrade/ is only needed when upgrading from a lower version and not when doing a new installation, correct?
Even though I think I am doing everything correctly the umlauts and special characters are still not displayed correctly. As said in my first post I even dropped the databases from the ansible install and re-did that by hand on the cli, still without success.