Page 1 of 1

Error: Could not find any host matching

Posted: Thu Sep 13, 2018 1:10 pm
by jeffersjw
Hi,

I am getting the following error when trying to apply my config:

Error: Could not find any host matching 'drexchvm01.corp.globetax.com' (config file '/usr/local/nagios/etc/services/drexch02.corp.globetax.com.cfg', starting on line 93)

Error: Could not expand hostgroups and/or hosts specified in service (config file '/usr/local/nagios/etc/services/drexch02.corp.globetax.com.cfg', starting on line 93)

I tried following the steps in https://support.nagios.com/forum/viewto ... =7&t=44126 but it did not resolve the issue.
Also, I have none idea what is being referred to in line 93 as these .cfg files do not contain that many.

Any assistance greatly appreciated!

Re: Error: Could not find any host matching

Posted: Thu Sep 13, 2018 1:47 pm
by syang
You need to correct the object definition error that nagios is complaining about. Try these two possible solutions:
1. Add a host object called 'drexchvm01.corp.globetax.com'
2. Remove 'drexchvm01.corp.globetax.com' from the service definition

After making the change(s), what is the output when you enter this command in the CLI?

Code: Select all

/usr/local/nagios/bin/nagios -v /usr/local/nagios/etc/nagios.cfg
If the problem persists, could you include your host/service definitions onto this post?

Re: Error: Could not find any host matching

Posted: Thu Sep 13, 2018 4:01 pm
by jeffersjw
There were no services bound to it as I had removed them already but I had added and removed the host many times. SHould I add the host bind a service then remove it?

Output is as follows and am still having the issue:

Nagios Core 4.2.4
Copyright (c) 2009-present Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 12-07-2016
License: GPL

Website: https://www.nagios.org
Reading configuration data...
Read main config file okay...
Warning: Duplicate definition found for service 'HTTP' on host 'www.globetax.com' (config file '/usr/local/nagios/etc/services/www.globetax.com.cfg', starting on line 57)
Read object config files okay...

Running pre-flight check on configuration data...

Checking objects...
Checked 1247 services.
Checked 199 hosts.
Checked 27 host groups.
Checked 22 service groups.
Checked 20 contacts.
Checked 2 contact groups.
Checked 126 commands.
Checked 26 time periods.
Checked 0 host escalations.
Checked 0 service escalations.
Checking for circular paths...
Checked 199 hosts
Checked 0 service dependencies
Checked 0 host dependencies
Checked 26 timeperiods
Checking global event handlers...
Checking obsessive compulsive processor commands...
Checking misc settings...

Total Warnings: 0
Total Errors: 0

Things look okay - No serious problems were detected during the pre-flight check
You have mail in /var/spool/mail/root

Re: Error: Could not find any host matching

Posted: Thu Sep 13, 2018 4:20 pm
by syang
There may something wrong with your database. Before repairing it, be sure to make a backup of your files. You can follow the instructions here: https://assets.nagios.com/downloads/nag ... ios-XI.pdf

After the backup is done, repair the database with this script as root user:

Code: Select all

/usr/local/nagiosxi/scripts/repair_databases.sh
Then sign into the terminal as the Nagios User and run this script and show us the output:

Code: Select all

/usr/local/nagiosxi/scripts/reconfigure_nagios.sh

Re: Error: Could not find any host matching

Posted: Thu Sep 13, 2018 4:23 pm
by tgriep
What version of MYSQL are you running?
To get that, run this as root.

Code: Select all

mysql -V
Has the MYSQL database been offloaded to a remote server?
Were there any updates done to the server?

Can you run the following and post the output to the ticket?

Code: Select all

echo 'show global status;' |mysql -t -u root -pnagiosxi

It looks like the objects in the Core Config Manager are not in sync with the running config and that is causing the error..

To fix that, login to the XI GUI and go to the Core Config Manager
Under "Tools", click "Write Config Files" or if you are running a newer versions of XI, The menu is called "Config File Management"
Click the click the "Write" button, then the "Delete" button then click the "Write" button and then the "Verify" button
If you get any errors, resolve them and click on the "Delete" button, "Write", "Verify" until all of the errors are resolved.
Click the Apply Configuration link and click the "Apply Configuration" button after ALL of the errors are resolved.

Re: Error: Could not find any host matching

Posted: Fri Sep 14, 2018 11:05 am
by jeffersjw
I get this when running the first commands (DB repair):

===============
REPAIR COMPLETE
===============
Stopping ndo2db: done.
Starting ndo2db: done.
Running configuration check...

Nagios Core 4.2.4
Copyright (c) 2009-present Nagios Core Development Team and Community Contributors
Copyright (c) 1999-2009 Ethan Galstad
Last Modified: 12-07-2016
License: GPL

Website: https://www.nagios.org
Reading configuration data...
Read main config file okay...
Error: Unexpected token or statement in file '/usr/local/nagios/etc/hosts/tmp_xi_vars.cfg' on line 1.
Error processing object config files!


***> One or more problems was encountered while processing the config files...

Check your configuration file(s) to ensure that they contain valid
directives and data defintions. If you are upgrading from a previous
version of Nagios, you should be aware that some variables/definitions
may have been removed or modified in this version. Make sure to read
the HTML documentation regarding the config files, as well as the
'Whats New' section to find out what has changed.


=======================
nagios database repair succeeded
nagiosql database repair succeeded

You have mail in /var/spool/mail/root
[root@nagios hosts]# /usr/local/nagiosxi/scripts/reconfigure_nagios.sh
URL: http://localhost/nagiosxi/includes/components/ccm/
CMDLINE
/usr/bin/wget --save-cookies nagiosql.cookies --keep-session-cookies http://localhost/nagiosxi/includes/components/ccm/ --no-check-certificate --post-data 'submit=Login&hidelog=true&loginSubmitted=true&backend=1&username=nagiosxi&password=Gts9100' -O nagiosql.login--2018-09-14 10:07:04-- http://localhost/nagiosxi/includes/components/ccm/
Resolving localhost... ::1, 127.0.0.1
Connecting to localhost|::1|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
Saving to: “nagiosql.login”

[ <=> ] 38,097 --.-K/s in 0.02s

2018-09-14 10:07:04 (2.37 MB/s) - “nagiosql.login” saved [38097]

LOGIN SUCCESSFUL!
IMPORTING CONFIG FILES...URL: http://localhost/nagiosxi/includes/components/ccm/
Array
(
)
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
Another reconfigure process is still running, sleeping...
^C

Re: Error: Could not find any host matching

Posted: Fri Sep 14, 2018 11:07 am
by jeffersjw
For the second one I followed the steps and saw no errors but when applying any new config still get the same message.

Here is the output from the SQL commands:

Code: Select all

[root@nagios hosts]# mysql -V
mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
You have mail in /var/spool/mail/root

Code: Select all

[root@nagios hosts]# echo 'show global status;' |mysql -t -u root -pnagiosxi
+-----------------------------------+-----------+
| Variable_name                     | Value     |
+-----------------------------------+-----------+
| Aborted_clients                   | 1         |
| Aborted_connects                  | 0         |
| Binlog_cache_disk_use             | 0         |
| Binlog_cache_use                  | 0         |
| Bytes_received                    | 448795540 |
| Bytes_sent                        | 203604390 |
| Com_admin_commands                | 32657     |
| Com_assign_to_keycache            | 0         |
| Com_alter_db                      | 0         |
| Com_alter_db_upgrade              | 0         |
| Com_alter_event                   | 0         |
| Com_alter_function                | 0         |
| Com_alter_procedure               | 0         |
| Com_alter_server                  | 0         |
| Com_alter_table                   | 0         |
| Com_alter_tablespace              | 0         |
| Com_analyze                       | 0         |
| Com_backup_table                  | 0         |
| Com_begin                         | 0         |
| Com_binlog                        | 0         |
| Com_call_procedure                | 0         |
| Com_change_db                     | 35850     |
| Com_change_master                 | 0         |
| Com_check                         | 0         |
| Com_checksum                      | 0         |
| Com_commit                        | 0         |
| Com_create_db                     | 0         |
| Com_create_event                  | 0         |
| Com_create_function               | 0         |
| Com_create_index                  | 0         |
| Com_create_procedure              | 0         |
| Com_create_server                 | 0         |
| Com_create_table                  | 0         |
| Com_create_trigger                | 0         |
| Com_create_udf                    | 0         |
| Com_create_user                   | 0         |
| Com_create_view                   | 0         |
| Com_dealloc_sql                   | 0         |
| Com_delete                        | 1023      |
| Com_delete_multi                  | 0         |
| Com_do                            | 0         |
| Com_drop_db                       | 0         |
| Com_drop_event                    | 0         |
| Com_drop_function                 | 0         |
| Com_drop_index                    | 0         |
| Com_drop_procedure                | 0         |
| Com_drop_server                   | 0         |
| Com_drop_table                    | 0         |
| Com_drop_trigger                  | 0         |
| Com_drop_user                     | 0         |
| Com_drop_view                     | 0         |
| Com_empty_query                   | 0         |
| Com_execute_sql                   | 0         |
| Com_flush                         | 0         |
| Com_grant                         | 0         |
| Com_ha_close                      | 0         |
| Com_ha_open                       | 0         |
| Com_ha_read                       | 0         |
| Com_help                          | 0         |
| Com_insert                        | 239552    |
| Com_insert_select                 | 0         |
| Com_install_plugin                | 0         |
| Com_kill                          | 0         |
| Com_load                          | 0         |
| Com_load_master_data              | 0         |
| Com_load_master_table             | 0         |
| Com_lock_tables                   | 0         |
| Com_optimize                      | 156       |
| Com_preload_keys                  | 0         |
| Com_prepare_sql                   | 0         |
| Com_purge                         | 0         |
| Com_purge_before_date             | 0         |
| Com_release_savepoint             | 0         |
| Com_rename_table                  | 0         |
| Com_rename_user                   | 0         |
| Com_repair                        | 0         |
| Com_replace                       | 115       |
| Com_replace_select                | 0         |
| Com_reset                         | 0         |
| Com_restore_table                 | 0         |
| Com_revoke                        | 0         |
| Com_revoke_all                    | 0         |
| Com_rollback                      | 0         |
| Com_rollback_to_savepoint         | 0         |
| Com_savepoint                     | 0         |
| Com_select                        | 139583    |
| Com_set_option                    | 17960     |
| Com_show_authors                  | 0         |
| Com_show_binlog_events            | 0         |
| Com_show_binlogs                  | 0         |
| Com_show_charsets                 | 0         |
| Com_show_collations               | 0         |
| Com_show_column_types             | 0         |
| Com_show_contributors             | 0         |
| Com_show_create_db                | 0         |
| Com_show_create_event             | 0         |
| Com_show_create_func              | 0         |
| Com_show_create_proc              | 0         |
| Com_show_create_table             | 0         |
| Com_show_create_trigger           | 0         |
| Com_show_databases                | 0         |
| Com_show_engine_logs              | 0         |
| Com_show_engine_mutex             | 0         |
| Com_show_engine_status            | 0         |
| Com_show_events                   | 0         |
| Com_show_errors                   | 0         |
| Com_show_fields                   | 0         |
| Com_show_function_status          | 0         |
| Com_show_grants                   | 0         |
| Com_show_keys                     | 0         |
| Com_show_master_status            | 0         |
| Com_show_new_master               | 0         |
| Com_show_open_tables              | 0         |
| Com_show_plugins                  | 0         |
| Com_show_privileges               | 0         |
| Com_show_procedure_status         | 0         |
| Com_show_processlist              | 0         |
| Com_show_profile                  | 0         |
| Com_show_profiles                 | 0         |
| Com_show_slave_hosts              | 0         |
| Com_show_slave_status             | 0         |
| Com_show_status                   | 1         |
| Com_show_storage_engines          | 0         |
| Com_show_table_status             | 0         |
| Com_show_tables                   | 0         |
| Com_show_triggers                 | 0         |
| Com_show_variables                | 0         |
| Com_show_warnings                 | 0         |
| Com_slave_start                   | 0         |
| Com_slave_stop                    | 0         |
| Com_stmt_close                    | 0         |
| Com_stmt_execute                  | 0         |
| Com_stmt_fetch                    | 0         |
| Com_stmt_prepare                  | 0         |
| Com_stmt_reprepare                | 0         |
| Com_stmt_reset                    | 0         |
| Com_stmt_send_long_data           | 0         |
| Com_truncate                      | 23        |
| Com_uninstall_plugin              | 0         |
| Com_unlock_tables                 | 0         |
| Com_update                        | 233       |
| Com_update_multi                  | 0         |
| Com_xa_commit                     | 0         |
| Com_xa_end                        | 0         |
| Com_xa_prepare                    | 0         |
| Com_xa_recover                    | 0         |
| Com_xa_rollback                   | 0         |
| Com_xa_start                      | 0         |
| Compression                       | OFF       |
| Connections                       | 3229      |
| Created_tmp_disk_tables           | 6         |
| Created_tmp_files                 | 15        |
| Created_tmp_tables                | 4558      |
| Delayed_errors                    | 0         |
| Delayed_insert_threads            | 0         |
| Delayed_writes                    | 0         |
| Flush_commands                    | 1         |
| Handler_commit                    | 0         |
| Handler_delete                    | 2352      |
| Handler_discover                  | 0         |
| Handler_prepare                   | 0         |
| Handler_read_first                | 79265     |
| Handler_read_key                  | 3377650   |
| Handler_read_next                 | 2635749   |
| Handler_read_prev                 | 0         |
| Handler_read_rnd                  | 283703    |
| Handler_read_rnd_next             | 4982407   |
| Handler_rollback                  | 0         |
| Handler_savepoint                 | 0         |
| Handler_savepoint_rollback        | 0         |
| Handler_update                    | 163304    |
| Handler_write                     | 770857    |
| Innodb_buffer_pool_pages_data     | 19        |
| Innodb_buffer_pool_pages_dirty    | 0         |
| Innodb_buffer_pool_pages_flushed  | 0         |
| Innodb_buffer_pool_pages_free     | 493       |
| Innodb_buffer_pool_pages_misc     | 0         |
| Innodb_buffer_pool_pages_total    | 512       |
| Innodb_buffer_pool_read_ahead_rnd | 1         |
| Innodb_buffer_pool_read_ahead_seq | 0         |
| Innodb_buffer_pool_read_requests  | 77        |
| Innodb_buffer_pool_reads          | 12        |
| Innodb_buffer_pool_wait_free      | 0         |
| Innodb_buffer_pool_write_requests | 0         |
| Innodb_data_fsyncs                | 3         |
| Innodb_data_pending_fsyncs        | 0         |
| Innodb_data_pending_reads         | 0         |
| Innodb_data_pending_writes        | 0         |
| Innodb_data_read                  | 2494464   |
| Innodb_data_reads                 | 25        |
| Innodb_data_writes                | 3         |
| Innodb_data_written               | 1536      |
| Innodb_dblwr_pages_written        | 0         |
| Innodb_dblwr_writes               | 0         |
| Innodb_log_waits                  | 0         |
| Innodb_log_write_requests         | 0         |
| Innodb_log_writes                 | 1         |
| Innodb_os_log_fsyncs              | 3         |
| Innodb_os_log_pending_fsyncs      | 0         |
| Innodb_os_log_pending_writes      | 0         |
| Innodb_os_log_written             | 512       |
| Innodb_page_size                  | 16384     |
| Innodb_pages_created              | 0         |
| Innodb_pages_read                 | 19        |
| Innodb_pages_written              | 0         |
| Innodb_row_lock_current_waits     | 0         |
| Innodb_row_lock_time              | 0         |
| Innodb_row_lock_time_avg          | 0         |
| Innodb_row_lock_time_max          | 0         |
| Innodb_row_lock_waits             | 0         |
| Innodb_rows_deleted               | 0         |
| Innodb_rows_inserted              | 0         |
| Innodb_rows_read                  | 0         |
| Innodb_rows_updated               | 0         |
| Key_blocks_not_flushed            | 0         |
| Key_blocks_unused                 | 5415      |
| Key_blocks_used                   | 6694      |
| Key_read_requests                 | 10063245  |
| Key_reads                         | 525108    |
| Key_write_requests                | 752350    |
| Key_writes                        | 482915    |
| Last_query_cost                   | 0.000000  |
| Max_used_connections              | 62        |
| Not_flushed_delayed_rows          | 0         |
| Open_files                        | 98        |
| Open_streams                      | 0         |
| Open_table_definitions            | 89        |
| Open_tables                       | 56        |
| Opened_files                      | 1379      |
| Opened_table_definitions          | 291       |
| Opened_tables                     | 388       |
| Prepared_stmt_count               | 0         |
| Qcache_free_blocks                | 0         |
| Qcache_free_memory                | 0         |
| Qcache_hits                       | 0         |
| Qcache_inserts                    | 0         |
| Qcache_lowmem_prunes              | 0         |
| Qcache_not_cached                 | 0         |
| Qcache_queries_in_cache           | 0         |
| Qcache_total_blocks               | 0         |
| Queries                           | 470338    |
| Questions                         | 470338    |
| Rpl_status                        | NULL      |
| Select_full_join                  | 0         |
| Select_full_range_join            | 0         |
| Select_range                      | 2571      |
| Select_range_check                | 0         |
| Select_scan                       | 5552      |
| Slave_open_temp_tables            | 0         |
| Slave_retried_transactions        | 0         |
| Slave_running                     | OFF       |
| Slow_launch_threads               | 0         |
| Slow_queries                      | 0         |
| Sort_merge_passes                 | 0         |
| Sort_range                        | 1119      |
| Sort_rows                         | 53985     |
| Sort_scan                         | 1732      |
| Ssl_accept_renegotiates           | 0         |
| Ssl_accepts                       | 0         |
| Ssl_callback_cache_hits           | 0         |
| Ssl_cipher                        |           |
| Ssl_cipher_list                   |           |
| Ssl_client_connects               | 0         |
| Ssl_connect_renegotiates          | 0         |
| Ssl_ctx_verify_depth              | 0         |
| Ssl_ctx_verify_mode               | 0         |
| Ssl_default_timeout               | 0         |
| Ssl_finished_accepts              | 0         |
| Ssl_finished_connects             | 0         |
| Ssl_session_cache_hits            | 0         |
| Ssl_session_cache_misses          | 0         |
| Ssl_session_cache_mode            | NONE      |
| Ssl_session_cache_overflows       | 0         |
| Ssl_session_cache_size            | 0         |
| Ssl_session_cache_timeouts        | 0         |
| Ssl_sessions_reused               | 0         |
| Ssl_used_session_cache_entries    | 0         |
| Ssl_verify_depth                  | 0         |
| Ssl_verify_mode                   | 0         |
| Ssl_version                       |           |
| Table_locks_immediate             | 543059    |
| Table_locks_waited                | 362       |
| Tc_log_max_pages_used             | 0         |
| Tc_log_page_size                  | 0         |
| Tc_log_page_waits                 | 0         |
| Threads_cached                    | 0         |
| Threads_connected                 | 41        |
| Threads_created                   | 3228      |
| Threads_running                   | 1         |
| Uptime                            | 7032      |
| Uptime_since_flush_status         | 7032      |
+----------------------------------

Re: Error: Could not find any host matching

Posted: Fri Sep 14, 2018 11:21 am
by npolovenko
@jeffersjw, I would like to schedule a remote session and take a closer look at your config files. Please open a support ticket here so we can arrange a remote session.
https://support.nagios.com/tickets

Re: Error: Could not find any host matching

Posted: Fri Sep 14, 2018 12:54 pm
by jeffersjw
Opened. I am available for the next hour.

Re: Error: Could not find any host matching

Posted: Fri Sep 14, 2018 1:12 pm
by npolovenko
@jeffersjw, Great. I responded in the ticket. I will be closing this thread so we can focus our efforts.