Page 1 of 2
check_mssql_health doesn't run as nagios user
Posted: Thu Jun 11, 2015 10:41 am
by Goodie
Hi,
I have installed Nagios Core 4.0.8 on Centos 7, I'm having issues running the check_mysql_health plugin as the standard user account `nagios` in terminal and through the nagios web front end.
I have installed the required pre-requisites for the check_mssql_health plugin i.e DBD::Sysbase etc.
i.e. running the below command as root from the terminal works, I have a server entry in freetds.conf
Code: Select all
./check_mssql_health --server=SERVER --username=DOMAIN\\NagiosSQL --password=Password --mode=connected-users
However running the command as user `nagios` receives the below error
Code: Select all
CRITICAL - cannot connect to SERVER. install_driver(Sybase) failed: Can't locate DBD/Sybase.pm in @INC (@INC contains: . /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5) at (eval 14) line 3.
Perhaps the DBD::Sybase perl module hasn't been fully installed,
or perhaps the capitalisation of 'Sybase' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge, mysql.
at ./check_mssql_health line 3192.
I believe it is an issue with permissions, however, I'm unsure where.
Any help will be appricated. Thanks
Re: check_mssql_health doesn't run as nagios user
Posted: Thu Jun 11, 2015 10:58 am
by jdalrymple
Start with selinux:
Code: Select all
[jdalrymple@localhost ~]$ getenforce
Disabled
If Enabled do a
Code: Select all
[jdalrymple@localhost ~]$ sudo setenforce 0
If not that then perhaps Nagios embedded perl is giving you problems:
To tell Nagios to NOT use the embedded Perl interpreter for a particular script, add this line to the Perl script:
Either line must be located within the first 10 lines of a script for Nagios to detect it.
Re: check_mssql_health doesn't run as nagios user
Posted: Thu Jun 11, 2015 3:59 pm
by Goodie
Thanks for the quick reply jdairymple, selinux is in permissive mode, I'll try the other suggest when I'm back at work tomorrow.
I forgot to mention I have other nations plugins working, it' just the SQL one I'm having issue with.
Re: check_mssql_health doesn't run as nagios user
Posted: Fri Jun 12, 2015 2:53 am
by Goodie
HI jdalrymple,
I have tried disabling SElinux and adding the extra line in to the perl script, I'm still getting the same error.
Any more idea's I can try?
Thanks
Re: check_mssql_health doesn't run as nagios user
Posted: Fri Jun 12, 2015 10:24 am
by tgriep
Could you run the following and post the output here?
Code: Select all
ll /usr/local/nagios/libexec/check_mssql_health
grep nag /etc/passwd
grep nag /etc/group
Can you show how you compiled the check_mssql_health plugin?
Re: check_mssql_health doesn't run as nagios user
Posted: Fri Jun 12, 2015 11:53 am
by Goodie
I'll give it ago on Monday when I'm back in the office.
Thanks
Re: check_mssql_health doesn't run as nagios user
Posted: Fri Jun 12, 2015 11:57 am
by tgriep
No problem. Keep us in the loop.
Re: check_mssql_health doesn't run as nagios user
Posted: Mon Jun 15, 2015 5:53 am
by Goodie
HI tgriep,
Please see the information requested below
Code: Select all
[root@9-srv-nagios ~]# grep nag /etc/passwd
nagios:x:1001:1001::/home/nagios:/bin/bash
[root@9-srv-nagios ~]# grep nag /etc/group
nagios:x:1001:apache,nagios
nagcmd:x:1002:apache,nagios
I compiled the check_mssql_health plugin using the below commands following the readme file that came with the plugin
Code: Select all
./configure --prefix=BASEDIRECTORY --with-nagios-user=SOMEUSER --with-nagios-group=SOMEGROUP --with-perl=PATH_TO_PERL --with-statefiles-dir=STATE_PATH
Where the
BASEDIRECTORY = /usr/local/nagios'
SOMEUSER = nagios
SOMEGROUP = i have tried `nagios` and `nagcmd`
PATH_TO_PERL = /usr/bin/perl
STATE_PATH = I left as the default `/tmp`
Additional info, I found a post that said if the plugin was ran by root it only allowed root to edit the contents of the folder /var/tmp/check_mssql_health where the plugin drops files in-between runs, I have since made the `nagios` account owner of this folder, however, I'm still getting the original error outlined in my first post.
Thanks
Re: check_mssql_health doesn't run as nagios user
Posted: Mon Jun 15, 2015 12:02 pm
by ssax
How did you install DBD::Sybase? (through yum or through cpan?)
Which would install in these locations:
Code: Select all
ls -ld /usr/lib64/perl5/vendor_perl/DBD
ls -l /usr/lib64/perl5/vendor_perl/DBD/Sybase.pm
Just compile the plugin with the defaults:
I was able to make it run as root and as nagios without any issues.
Re: check_mssql_health doesn't run as nagios user
Posted: Mon Jun 15, 2015 3:20 pm
by Goodie
Hi ssax,
I installed DBD::sybase through cpan, I'll try what you suggested and report back.
Thanks