Nagios Support Forum

Hello, select is here: mysql> SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME -> FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'nagios'; +----------------------------+------------------------+ | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | +----------------------------+----...

Hello, after upgrade nagiosXI from version 5.6.12 to 5.7.1 are all checks and hosts in pending state. In log file /usr/local/nagios/var/nagios.log i see this error: DO-3: ndo_return = 1 (Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=') [159222...