Nagios Support Forum

Code: Select all

su nagios
mysql -u nagios -p'<PASSWORD>' -h <IP_ADDRESS_OF_MYSQL_SERVER>

Code: Select all

root@NagiosCoreServer:/usr/local/nagios/var# mysql -u nagios  -h 172.20.81.135 -pnagios
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 91
Server version: 5.5.31-0ubuntu0.12.04.2-log (Ubuntu)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> 

Code: Select all

[1386959714] Nagios 3.5.0 starting... (PID=22090)
[1386959714] Local time is Fri Dec 13 18:35:14 UTC 2013
[1386959714] LOG VERSION: 2.0
[1386959714] Error: Unable to open file '/usr/local/nagios/bin/ndomod.o' for reading: No such file or directory
[1386959714] Error: Failed to safely copy module '/usr/local/nagios/bin/ndomod.o'. The module will not be loaded

Code: Select all

mysql> SELECT * FROM nagios_objects;
+-----------+-------------+---------------+----------------------+-----------------+-----------+
| object_id | instance_id | objecttype_id | name1                | name2           | is_active |
+-----------+-------------+---------------+----------------------+-----------------+-----------+
|         1 |           1 |             1 | ITEN-SRVCARTMSCORE01 | NULL            |         0 |
|         2 |           1 |             9 | 24x7                 | NULL            |         0 |
|         3 |           1 |            12 | check-host-alive     | NULL            |         0 |
|         4 |           1 |             2 | ITEN-SRVCARTMSCORE01 | Current Users   |         0 |
|         5 |           1 |            12 | check_local_users    | NULL            |         0 |
|         6 |           1 |             2 | ITEN-SRVCARTMSCORE01 | Total Processes |         0 |
|         7 |           1 |            12 | check_local_procs    | NULL            |         0 |
|         8 |           1 |             2 | ITEN-SRVCARTMSCORE01 | Current Load    |         0 |
|         9 |           1 |            12 | check_local_load     | NULL            |         0 |
|        10 |           1 |             1 | ITEN-SRVCAREZV01     | NULL            |         0 |
|        11 |           1 |             2 | ITEN-SRVCARTMSCORE01 | PING            |         0 |
|        12 |           1 |            12 | check_ping           | NULL            |         0 |
|        13 |           1 |             2 | ITEN-SRVCARTMSCORE01 | SSH             |         0 |
|        14 |           1 |            12 | check_ssh            | NULL            |         0 |
+-----------+-------------+---------------+----------------------+-----------------+-----------+
14 rows in set (0.00 sec)

mysql> SELECT * FROM nagios_hosts;
Empty set (0.00 sec)

mysql> SELECT * FROM nagios_services;
Empty set (0.00 sec)

Code: Select all

ls -la /usr/local/nagios/bin/
grep "ndomod" /usr/local/nagios/etc/nagios.cfg