Home » Categories » Multiple Categories

Nagios XI - Disabling Database UTF8 Connectivity


This document describes how to disable UTF8 connectivity to the MySQL / MariaDB databases for Nagios XI. By default Nagios XI uses UTF8 however sometimes this needs to be disabled to allow MySQL / MariaDB to define the connectivity method.

This configuration ensures that characters from different languages can be correctly stored and retrieved in the databases. An example of where this is commonly used is when creating Dashboards in Nagios XI as per this screenshot:




The configuration directive explained in this documentation was introduced in Nagios XI 5.4.13 to address some issues that resulting in the names appearing garbled or with ??? instead of the correct character, for example:



If you do experience garbled or ??? characters, following this KB article will resolve the issue.



The Nagios XI Configuration Directive

The following configuration directive was added in Nagios XI 5.4.13:

$cfg['db_conn_utf8'] = 0;


To determine if you currently have that directive enabled, establish a terminal session to your Nagios XI server as the root user and execute the following command:

grep db_conn_utf8 /usr/local/nagiosxi/html/config.inc.php


If the grep command produces NO output then the directive does not exist in your configuration and it needs to be added. This can be added with the following command:

printf "\n\$cfg['db_conn_utf8'] = 0;\n" >> /usr/local/nagiosxi/html/config.inc.php


If the grep command produced output then it can be changed with the following command (sets it to 0):

sed -i "s/db_conn_utf8'\] =.*/db_conn_utf8'\] = 0;/g" /usr/local/nagiosxi/html/config.inc.php

Defining the directive to 0 will resolve the issue you for garbled or ??? characters.


If you wanted to change it to 1 then use the following command:

sed -i "s/db_conn_utf8'\] =.*/db_conn_utf8'\] = 1;/g" /usr/local/nagiosxi/html/config.inc.php



The change takes effect immediately.



Final Thoughts

For any support related questions please visit the Nagios Support Forums at:


0 (0)
Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Nagios XI - MSSQL Wizards - Adaptive Server connection failed
Viewed 1240 times since Thu, Aug 3, 2017
Nagios XI - ICMP and Ping Checks Stopped Graphing
Viewed 2997 times since Mon, Jan 25, 2016
Nagios XI - Virtual Machine Notes
Viewed 2555 times since Thu, Jan 28, 2016
Nagios XI - Using SSL with XI Active Directory
Viewed 1541 times since Thu, Jan 28, 2016
Nagios XI - Enabling Memcached Support
Viewed 1720 times since Wed, Jan 27, 2016
Pages Not Displaying Correctly
Viewed 3128 times since Mon, Jan 25, 2016
NDOUtils - Message Queue Exceeded
Viewed 8172 times since Thu, Jan 21, 2016
Nagios XI - WMI Troubleshooting
Viewed 3855 times since Mon, Apr 24, 2017
Nagios XI - Configuration Verification Failed
Viewed 5732 times since Mon, Jan 25, 2016
Nagios Core - Nagios did not exit in a timely manner
Viewed 3287 times since Wed, Jan 27, 2016