Consulta Nagvis

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Consulta Nagvis

Post by scottwilkerson »

ok, lets trim it down to just this

Code: Select all

grep ndomod /usr/local/nagios/var/nagios.log|tail -50
Former Nagios employee
Creator:
ahumandesign.com
enneagrams.com
alex3105
Posts: 103
Joined: Sat Jul 28, 2018 10:54 am

Re: Consulta Nagvis

Post by alex3105 »

I attached it .. thanks for the support.
Attachments
ll5.txt
(2.96 KiB) Downloaded 197 times
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Consulta Nagvis

Post by scottwilkerson »

ok, so it is copnnected

What do you get when running the following?

Code: Select all

echo 'select * from nagios_objects;' | mysql -u ndoutils -p'ndoutils_password' nagios
Former Nagios employee
Creator:
ahumandesign.com
enneagrams.com
alex3105
Posts: 103
Joined: Sat Jul 28, 2018 10:54 am

Re: Consulta Nagvis

Post by alex3105 »

You do not get results from this last command.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Consulta Nagvis

Post by scottwilkerson »

Are you sure the database user has the correct rights on the mysql server?
Former Nagios employee
Creator:
ahumandesign.com
enneagrams.com
alex3105
Posts: 103
Joined: Sat Jul 28, 2018 10:54 am

Re: Consulta Nagvis

Post by alex3105 »

I've verified it like this .. will it be fine ..?

[root@localhost Documentos]# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 86
Server version: 5.5.56-MariaDB MariaDB Server

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SHOW GRANTS FOR 'ndoutils'@'localhost';
+-----------------------------------------------------------------------------------------------------------------+
| Grants for ndoutils@localhost |
+-----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'ndoutils'@'localhost' IDENTIFIED BY PASSWORD '*59CEA604D47257BE41050920CF424B4ADAEE5120' |
| GRANT ALL PRIVILEGES ON `nagios`.* TO 'ndoutils'@'localhost' WITH GRANT OPTION |
+-----------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| nagios |
| performance_schema |
| test |
+--------------------+
5 rows in set (0.00 sec)

Greetings.
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Consulta Nagvis

Post by scottwilkerson »

at this point I would edit the ndo2db.cfg and turn on debugging

Code: Select all

debug_level=-1
then restart ndo2db and nagios

Code: Select all

service ndo2db restart
service nagios restart
wait about 5 minutes, and grab this file and attach
/usr/local/nagios/var/ndo2db.debug
Former Nagios employee
Creator:
ahumandesign.com
enneagrams.com
alex3105
Posts: 103
Joined: Sat Jul 28, 2018 10:54 am

Re: Consulta Nagvis

Post by alex3105 »

The debug file has not been generated .. I will try again ..
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises
Contact:

Re: Consulta Nagvis

Post by scottwilkerson »

alex3105 wrote:The debug file has not been generated .. I will try again ..
Let us know when it gets generated.
Former Nagios employee
Creator:
ahumandesign.com
enneagrams.com
alex3105
Posts: 103
Joined: Sat Jul 28, 2018 10:54 am

Re: Consulta Nagvis

Post by alex3105 »

Estimado Scott,

Editing the ndo2db.cfg file, enabling debul_level=-1 and restarting ndo2 services and nagios does not generate the file /usr/local/nagios/var/ndo2db.debug.

Could you please indicate the correct sequence to generate the log, I'm sorry, I'm not very expert in Centos.

Greetings.
Locked