Page 2 of 3

Re: Problem with Ingres Plugin

Posted: Wed Dec 23, 2015 2:36 am
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

Re: Problem with Ingres Plugin

Posted: Wed Dec 23, 2015 5:23 am
by Bone8Head
If i try to netstat ncsa is the same, the system don't say anything...maybe the service is down?

Re: Problem with Ingres Plugin

Posted: Wed Dec 23, 2015 10:36 am
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?

Re: Problem with Ingres Plugin

Posted: Tue Dec 29, 2015 2:59 am
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

Re: Problem with Ingres Plugin

Posted: Tue Dec 29, 2015 3:02 am
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)...

Re: Problem with Ingres Plugin

Posted: Tue Dec 29, 2015 10:44 am
by rkennedy
Can you also post your /usr/local/nagios/etc/nsca.cfg config file?

Re: Problem with Ingres Plugin

Posted: Mon Jan 04, 2016 3:28 am
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


Re: Problem with Ingres Plugin

Posted: Mon Jan 04, 2016 4:19 am
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?

Re: Problem with Ingres Plugin

Posted: Mon Jan 04, 2016 1:42 pm
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/

Re: Problem with Ingres Plugin

Posted: Fri Jan 08, 2016 4:49 am
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...