Home » Categories » Products » Nagios XI » Troubleshooting » Common Problems

Nagios XI - MSSQL Query Wizard - Invalid characters in the username

Problem Description

After running the MSSQL Query wizard your new service has an UNKNOWN state with the following error:

UNKNOWN: Invalid characters in the username.

 

This problem can occur when trying to connect using Windows authentication and your username is something like user\domain, it is complaining about the backslash (\).

 

 

Resolution

The check_mssql plugin can be updated to allow the backslash. Establish a terminal session to your Nagios XI server as the user root.

Execute the following command to open the /usr/local/nagios/libexec/check_mssql file in vi:

vi /usr/local/nagios/libexec/check_mssql

When using the vi editor, to make changes press i on the keyboard first to enter insert mode. Press Esc to exit insert mode.

 

Jump to line 347 by typing the following:

:347

and press Enter.

 

The line you are looking for should look like this:

if (!preg_match("/^[a-zA-Z0-9-_]{2,32}$/", $db_user)) {

 

Change it to (add \\\\):

if (!preg_match("/^[a-zA-Z0-9-_\\\\]{2,32}$/", $db_user)) {

 

When you have finished, save the changes in vi by typing:

:wq

and press Enter.

 

After making these changes go back into the XI web interface and force an immediate check of the service to test that it is working correctly.

 


 

Final Thoughts

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

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

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
Pages Not Displaying Correctly
Viewed 3215 times since Mon, Jan 25, 2016
Active Directory / LDAP - Troubleshooting Authentication Integration
Viewed 8331 times since Mon, Jun 26, 2017
Nagios XI - Status Information Cut Off At 256 Characters
Viewed 3501 times since Thu, Feb 25, 2016
Nagios XI - Apply Configuration Fails - Backend login to the Core Configuration failed
Viewed 10234 times since Tue, Aug 2, 2016
Nagios XI - SQL Error [nagiosxi] : ERROR: syntax error
Viewed 3259 times since Sun, Sep 10, 2017
Nagios XI - Installing XI Fails To Install Dependency pymssql
Viewed 2930 times since Mon, Oct 17, 2016
Nagios XI - Issues with mod_gearman and Performance Data Newlines: "\n"
Viewed 1884 times since Tue, Feb 2, 2016
Disabling Port 113 IDENT Requests
Viewed 2436 times since Tue, Mar 12, 2019
Nagios XI - MRTG Reports SNMP_Session Errors
Viewed 2193 times since Wed, Jul 27, 2016
Nagios XI - Resolving "Cannot connect to database" Error - Core Config Manager
Viewed 3583 times since Mon, Jan 25, 2016