Page 4 of 7
Re: Consulta Nagvis
Posted: Thu Aug 16, 2018 4:52 pm
by scottwilkerson
ok, lets trim it down to just this
Code: Select all
grep ndomod /usr/local/nagios/var/nagios.log|tail -50
Re: Consulta Nagvis
Posted: Thu Aug 16, 2018 6:23 pm
by alex3105
I attached it .. thanks for the support.
Re: Consulta Nagvis
Posted: Fri Aug 17, 2018 2:21 pm
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
Re: Consulta Nagvis
Posted: Fri Aug 17, 2018 2:58 pm
by alex3105
You do not get results from this last command.
Re: Consulta Nagvis
Posted: Fri Aug 17, 2018 3:02 pm
by scottwilkerson
Are you sure the database user has the correct rights on the mysql server?
Re: Consulta Nagvis
Posted: Fri Aug 17, 2018 3:59 pm
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.
Re: Consulta Nagvis
Posted: Fri Aug 17, 2018 4:42 pm
by scottwilkerson
at this point I would edit the ndo2db.cfg and turn on debugging
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
Re: Consulta Nagvis
Posted: Fri Aug 17, 2018 5:21 pm
by alex3105
The debug file has not been generated .. I will try again ..
Re: Consulta Nagvis
Posted: Mon Aug 20, 2018 9:54 am
by scottwilkerson
alex3105 wrote:The debug file has not been generated .. I will try again ..
Let us know when it gets generated.
Re: Consulta Nagvis
Posted: Mon Aug 20, 2018 3:45 pm
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.