Problem with Ingres Plugin

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Bone8Head
Posts: 106
Joined: Tue Nov 10, 2015 2:39 am

Re: Problem with Ingres Plugin

Post by Bone8Head »

rkennedy wrote:From your Nagios server, can you run the following commands and post the output?

Code: Select all

netstat -an|grep :5667
ifconfig|grep 'inet addr'
Image
Bone8Head
Posts: 106
Joined: Tue Nov 10, 2015 2:39 am

Re: Problem with Ingres Plugin

Post by Bone8Head »

If i try to netstat ncsa is the same, the system don't say anything...maybe the service is down?
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Problem with Ingres Plugin

Post by rkennedy »

Yeah, take a look to make sure your NSCA configuration. Can you post the contents of your /etc/xinetd.d/nsca file for us to take a look at?
Former Nagios Employee
Bone8Head
Posts: 106
Joined: Tue Nov 10, 2015 2:39 am

Re: Problem with Ingres Plugin

Post by Bone8Head »

rkennedy wrote:Yeah, take a look to make sure your NSCA configuration. Can you post the contents of your /etc/xinetd.d/nsca file for us to take a look at?
Here the file for you:

Image
Bone8Head
Posts: 106
Joined: Tue Nov 10, 2015 2:39 am

Re: Problem with Ingres Plugin

Post by Bone8Head »

Maybe are the user: nagios and group: nagios wrong...?
In the Nagios XI web I use nagiosadmin, and for Nagios on Putty i use "root" (is the default user)...
rkennedy
Posts: 6579
Joined: Mon Oct 05, 2015 11:45 am

Re: Problem with Ingres Plugin

Post by rkennedy »

Can you also post your /usr/local/nagios/etc/nsca.cfg config file?
Former Nagios Employee
Bone8Head
Posts: 106
Joined: Tue Nov 10, 2015 2:39 am

Re: Problem with Ingres Plugin

Post by Bone8Head »

rkennedy wrote:Can you also post your /usr/local/nagios/etc/nsca.cfg config file?
Here we go, I didn't copy the Comments (#) (can't screenshot it, is too long):

Code: Select all

pid_file=/var/run/nsca.pid

server_port=5667

#server_address=192.168.1.1 (I should copy the Nagios Server here and remove the #)?

nsca_user=nagios

nsca_group=nagios

debug=0

command_file=/usr/local/nagios/var/rw/nagios.cmd

alternate_dump_file=/usr/local/nagios/var/rw/nsca.dump

aggregate_writes=0

append_to_file=0

max_packet_age=30

password=finance

decryption_method=0

Bone8Head
Posts: 106
Joined: Tue Nov 10, 2015 2:39 am

Re: Problem with Ingres Plugin

Post by Bone8Head »

Yeah the problem was that.
I removed the # and added my Server IP and now is Working properly.

I have another question: do you know how the Event Log Plugin Works? When I get a critical Alert because i have a Error Event on a Server, when Nagios XI will stop to show me this Critical Error?
bwallace
Posts: 1145
Joined: Tue Nov 17, 2015 1:57 pm

Re: Problem with Ingres Plugin

Post by bwallace »

Glad to hear the previous issue is resolved. Refer to the doc below on Windows Event Log monitoring.

https://www.nagios.com/solutions/window ... onitoring/
Be sure to check out the Knowledgebase for helpful articles and solutions!
Bone8Head
Posts: 106
Joined: Tue Nov 10, 2015 2:39 am

Re: Problem with Ingres Plugin

Post by Bone8Head »

Hello guys.
Today I got another problem.
With no reason, Nagios XI on web now gives this error:

Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.

Run the following from the CLI as root to attempt to repair the DB

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh
Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.

Run the following from the CLI as root to attempt to repair the DB

/usr/local/nagiosxi/scripts/repair_databases.sh
Message: A database connection error has been detected, we are attempting to repair the server, if the repair does not resolve the issue, please contact Nagios support.

Run the following from the CLI as root to attempt to repair the DB

/usr/local/nagiosxi/scripts/repair_databases.sh
I tried the command but nothing changed...

Code: Select all

mysqld is stopped
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld:                                           [FAILED]
mysqld is stopped
DATABASE: nagios
TABLE:
/var/lib/mysql/nagios /
Stopping mysqld:                                           [  OK  ]
- recovering (with sort) MyISAM-table 'nagios_acknowledgements.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_commands.MYI'
Data records: 135
- Fixing index 1
/usr/local/nagiosxi/scripts/repairmysql.sh: line 59:  9672 Segmentation fault      $cmd $t --sort_buffer_size=256M
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld:                                           [FAILED]
/

===============
REPAIR COMPLETE
===============
mysqld dead but pid file exists
DATABASE: nagiosql
TABLE:
/var/lib/mysql/nagiosql /
Stopping mysqld:                                           [  OK  ]
- recovering (with sort) MyISAM-table 'tbl_command.MYI'
Data records: 139
- Fixing index 1
/usr/local/nagiosxi/scripts/repairmysql.sh: line 59: 10345 Segmentation fault      $cmd $t --sort_buffer_size=256M
Timeout error occurred trying to start MySQL Daemon.
Starting mysqld:                                           [FAILED]
/

===============
REPAIR COMPLETE
===============
ndo2db was not running... could not stop
Starting ndo2db: done.
Running configuration check...
Locked