Re: [Nagios-users] Monitoring a Microsoft SQL Server

2011-11-17 Thread Kaplan, Andrew H.
Hi there -- I made some progress on my end. To start off, I confirmed the firewall is disabled on the SQL server. I then investigated the possibility that a named instance was being used on the server. It turns out that is the case. I then went to the SQL Server Configuration Manager utility/Netw

Re: [Nagios-users] I: R: R: configuration tool

2011-11-17 Thread Giorgio Zarrelli
So, you are not Connecting as root from nagiosql Please paste here The nagiosql install screenshot and The result of use mysql ; Select user,host,password from user; Ciao, Giorgio Il giorno 17/nov/2011, alle ore 16:45, "Marco Borsani" ha scritto: > Nothing happen, I still have same problem

Re: [Nagios-users] Monitoring a Microsoft SQL Server

2011-11-17 Thread Claudio Kuenzler
The other ports don't appear like typical MSSQL ports. Do you have by any chance the Windows firewall still active? Maybe the port is being blocked there? http://support.microsoft.com/kb/968872 Or do you use a named instance? I found this information on http://benchmarkitconsulting.com/colin-stasi

Re: [Nagios-users] Monitoring a Microsoft SQL Server

2011-11-17 Thread Kaplan, Andrew H.
Hi there -- I tried connecting to port 1433 of the SQL server, and the connection was refused. It appears that efforts to connect via the default port will not work in this case. I took the liberty of running the nestat -abn command syntax on the console of the SQL server, and searched for all re

Re: [Nagios-users] Monitoring a Microsoft SQL Server

2011-11-17 Thread Claudio Kuenzler
Please let us know if you get it working - I might have to add such a check soon as well. To answer your question: 1433 is the standard port of MSSQL so that should be ok. You can launch nmap or a simple telnet to double-check that. On Thu, Nov 17, 2011 at 4:34 PM, Jim Avery wrote: > On 17 Nove

Re: [Nagios-users] Oracle plugin

2011-11-17 Thread Dermot Duffy
I actually have oracle client installed: # rpm -qa | grep sqlplus oracle-instantclient11.2-sqlplus-11.2.0.3.0-1 I have now brought across the shared objects from the db server and symbolically linked them to /usr/lib. I now get the following when attempting to connect.. # /usr/local/instan

Re: [Nagios-users] Oracle plugin

2011-11-17 Thread Onotsky, Steve x55328
>From: Dermot Duffy [mailto:dermot.du...@brandtone.ie] >Sent: Thursday, November 17, 2011 11:49 AM >To: Nagios Users List >Subject: Re: [Nagios-users] Oracle plugin > >I brought the sqlplus binary across from the db server but I get the following error.. > ># ldd /usr/local/instantclient_10_2/sqlp

Re: [Nagios-users] Oracle plugin

2011-11-17 Thread Dermot Duffy
I brought the sqlplus binary across from the db server but I get the following error.. # ldd /usr/local/instantclient_10_2/sqlplus /usr/local/instantclient_10_2/sqlplus: error while loading shared libraries: /usr/lib/libclntsh.so.10.1: ELF file data encoding not little-endian Is there any way t

Re: [Nagios-users] Oracle plugin

2011-11-17 Thread Ismael Puerto
For your info: This is the library necessary for execute sqlplus [root@openbravo ~]# ldd /usr/oracle/product/11.2.0/bin/sqlplus linux-vdso.so.1 => (0x7fffe74b3000) libsqlplus.so => /usr/oracle/product/11.2.0/lib/libsqlplus.so (0x2b93dc626000) libclntsh.so.11.1 =>

Re: [Nagios-users] check_openmanage plugin: " Couldn't run command ..."

2011-11-17 Thread Trond Hasle Amundsen
Corcoran Smith writes: > First message, so please excuse any failures in format, etc! > > Got two issues with two boxes (out of 160!) using check_openmanage: > > 1) Couldn't run command 'c:\pro... ' etc > 2) U nrecognized character xA8: marked by <-- HERE after <-- HERE near column > 1 at /loade

Re: [Nagios-users] Oracle plugin

2011-11-17 Thread Dermot Duffy
No, oracle is not installed on this box. Am trying to connect from the nagios server to the oracle db server via sqlplus. From: Ismael Puerto [mailto:ismael.pue...@seres.es] Sent: 17 November 2011 15:57 To: nagios-users@lists.sourceforge.net Subject: Re: [Nagios-users] Oracle plugin Do yo have

Re: [Nagios-users] Oracle plugin

2011-11-17 Thread Ismael Puerto
Do yo have ORACLE_LIB? #echo $ORACLE_LIB On 11/17/2011 04:20 PM, Dermot Duffy wrote: > > Hi, > > > > Thanks for the feedback but it unfortunately makes no difference. > > > > # ln -s /usr/local/instantclient_10_2/libsqlplus.so /usr/lib/libsqlplus.so > > # > > # sqlplus username/passowrd@i

[Nagios-users] I: R: R: configuration tool

2011-11-17 Thread Marco Borsani
Nothing happen, I still have same problem. Marco -Messaggio originale- Da: Giorgio Zarrelli [mailto:zarre...@linux.it] Inviato: giovedì 17 novembre 2011 14:39 A: Marco Borsani Cc: 'Giorgio Zarrelli'; 'Nagios Users List' Oggetto: Re: R: R: [Nagios-users] configuration tool Hi, > MySQL> g

Re: [Nagios-users] Monitoring a Microsoft SQL Server

2011-11-17 Thread Jim Avery
On 17 November 2011 15:17, Kaplan, Andrew H. wrote: > Hi there -- > > Thanks for your reply. I tried your suggestion on the two plugins, and here > are > the results. > > When the command syntax for check_mssql was the following: > > ./check_mssql -H -U \\ -P > > or > > ./check_mssql -H -U '\\

Re: [Nagios-users] Oracle plugin

2011-11-17 Thread Dermot Duffy
I now get the following: # ldd /usr/bin/sqlplus /usr/bin/sqlplus: error while loading shared libraries: /usr/lib/libclntsh.so.10.1: ELF file data encoding not little-endian -Original Message- From: Onotsky, Steve x55328 [mailto:steve.onot...@broadridge.com] Sent: 17 November 2011 14:58

Re: [Nagios-users] Oracle plugin

2011-11-17 Thread Dermot Duffy
Yes the check_oracle_instance file sets the path as follows: $ENV{"LD_LIBRARY_PATH"} = "/usr/local/instantclient_10_2/"; R, D. -Original Message- From: Onotsky, Steve x55328 [mailto:steve.onot...@broadridge.com] Sent: 17 November 2011 14:58 To: Nagios Users List Subject: Re: [Nagios-use

Re: [Nagios-users] Oracle plugin

2011-11-17 Thread Onotsky, Steve x55328
>From: Dermot Duffy [mailto:dermot.du...@brandtone.ie] >Sent: Thursday, November 17, 2011 9:16 AM >To: nagios-users@lists.sourceforge.net >Subject: [Nagios-users] Oracle plugin ># sqlplus username/passowrd@ip_address:port/SSID       >#substituted with my own credentials >sqlplus: err

Re: [Nagios-users] Oracle plugin

2011-11-17 Thread Dermot Duffy
Hi, Thanks for the feedback but it unfortunately makes no difference. # ln -s /usr/local/instantclient_10_2/libsqlplus.so /usr/lib/libsqlplus.so # # sqlplus username/passowrd@ip_address:port/SSID sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file

Re: [Nagios-users] Monitoring a Microsoft SQL Server

2011-11-17 Thread Kaplan, Andrew H.
Hi there -- Thanks for your reply. I tried your suggestion on the two plugins, and here are the results. When the command syntax for check_mssql was the following: ./check_mssql -H -U \\ -P or ./check_mssql -H -U '\\' -P The error message displayed on-screen was: UNKNOWN: Invalid charact

Re: [Nagios-users] Oracle plugin

2011-11-17 Thread Ismael Puerto
ln -s/usr/local/instantclient_10_2/libsqlplus.so/usr/lib/libsqlplus.so On 11/17/2011 03:16 PM, Dermot Duffy wrote: > > Hi, > > > > I have installed the "check_oracle_instance" plugin but I am having > some issues with sqlplus. > > > > http://exchange.nagios.org/directory/Plugins/Databases/Orac

[Nagios-users] Oracle plugin

2011-11-17 Thread Dermot Duffy
Hi, I have installed the "check_oracle_instance" plugin but I am having some issues with sqlplus. http://exchange.nagios.org/directory/Plugins/Databases/Oracle/Check-Oracle-status-%26-health-without-install-Oracle-client/details The nagios compiles correctly so the config is good however when I

Re: [Nagios-users] R: R: configuration tool

2011-11-17 Thread Giorgio Zarrelli
Hi, > MySQL> grant all on mysql.* to root@’' identified by > 'password'; Try MySQL> grant all on *.* to root@% identified by 'password'; It will allow connection as root from ANY host/hostname and will give ALL privileges on ALL databases. As I told before: REMOVE this user as soon as you co

Re: [Nagios-users] R: configuration tool

2011-11-17 Thread Giorgio Zarrelli
It's just a MySQL right access problem. Please, describe what you are doing, step by step, so we can debug and help you. As a first hint I suggest you to create on mysql db a user ''root'@'yournagiosqlwebserverip' Würth a GRANT ALL ON *.* Then on mysql server issue a 'flush privileges' Then

[Nagios-users] R: configuration tool

2011-11-17 Thread Marco Borsani
Now , web pages are ok. Have anybody installed nagiosql and MySQL in different hosts ? I think to install nagiosql in the same server than Nagios and keeping MySQL DB in the other … but I have some grant problem (“Access denied for user root@ip-address” during the creation of NagiosQL My

[Nagios-users] Need plugin to retrieve a variable status of snmp trap using passive service

2011-11-17 Thread Mohammed EL KOURCHALI
Hi all, I'm looking for a plugin or script to retrieve variable value from snmp trap using passive service. My remote device send snmp traps with many variables, so i wont too assign each variable to one passive service. I try duplicating snmp traps on snmptt-XX.conf and use snmptt MATCH express

Re: [Nagios-users] Presumed service dependencies?

2011-11-17 Thread mail
On Wed, Nov 16, 2011 at 9:33 PM, Mike Chesnut wrote: > Is there a way to tell Nagios that I want all services on a host to be > dependent on that host without having to write a separate > servicedependency for every single service? I can't even conceive of a > situation where, when a host is down