THIS KNOWLEDGE BASE HAS BEEN ARCHIVED AND IS NO LONGER BEING UPDATED
Please visit library.nagios.com/docs for the latest and most up-to-date documentation.
Home » Categories » Multiple Categories

Nagios XI - Disabling Database UTF8 Connectivity

Overview

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:

http://support.nagios.com/forum/



Special Offer For Knowledgebase Visitors! Get a huge discount on Nagios Log Server by clicking below.

Get 60% Off Nagios Log Server!

Did you know? Nagios provides complete monitoring of: Windows, Linux, UNIX, Servers, Websites, SNMP, DHCP, DNS, Email, Storage, Files, Apache, IIS, EC2, and more!

1 (3)
Article Rating (3 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 - Understanding the Nagios XI Directory Structure
Viewed 9171 times since Thu, Jan 28, 2016
Nagios XI - Crashed Database Tables
Viewed 70257 times since Tue, Jan 27, 2015
PHPMailer - Troubleshooting Using Debug Logging
Viewed 42713 times since Tue, Aug 14, 2018
Nagios XI - Oracle Services Critical After Nagios XI Upgrade
Viewed 8327 times since Wed, Jan 27, 2016
Nagios Core - Failed to register iobroker
Viewed 9437 times since Wed, Sep 20, 2017
Slack Notifications Stopped Working
Viewed 6756 times since Wed, Mar 18, 2020
Nagios XI - MRTG Reports SNMP_Session Errors
Viewed 8853 times since Wed, Jul 27, 2016
ERROR: Please add the ’Optional’ channel to your Red Hat systems subscriptions
Viewed 30904 times since Tue, Jan 26, 2016
Nagios XI - Installing Latest SourceGuardian Loaders
Viewed 10988 times since Mon, Jun 18, 2018
Nagios XI - Login Screen Keeps Redirecting To Itself
Viewed 9346 times since Wed, Jan 27, 2016