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
Nagios XI - Downloading A System Profile
Viewed 3195 times since Wed, Jul 19, 2017
Nagios XI - Last Check Time Not Updating
Viewed 10898 times since Tue, Jan 6, 2015
Nagios XI - Event Data Is Stale
Viewed 2740 times since Wed, Jan 27, 2016
NRPE - Agent and Plugin Explained
Viewed 35864 times since Fri, Jul 14, 2017
Nagios XI - Configuration Applies, but still get "Configuration File Is Out Of Date" Error
Viewed 2414 times since Tue, Jan 26, 2016
Nagios XI - Warning: Duplicate definition found for contact ’xi_default_contact’
Viewed 2768 times since Tue, Jan 26, 2016
Nagios XI - Hosts Pending/Gray
Viewed 6447 times since Tue, Jan 6, 2015
Nagios XI - How To Test Check Commands From The Command-line
Viewed 24552 times since Tue, Jan 26, 2016
API changes in Nagios XI 5.7
Viewed 788 times since Tue, Feb 23, 2021
Nagios XI - ICMP and Ping Checks Stopped Graphing
Viewed 6631 times since Mon, Jan 25, 2016