Can't create a new host.

[dimsum]

Hi XI,

I've testing nagios xi on my environment but today i'd understand why when i creating a host and services finished but host and services are not show.

My steps to created host and services.
1. Monitoring Wizard
2. Select Printer
3. Add ip address
4. Add ping check and printer status
5. Finish

Before i face the issues i've 92 hosts in my nagios xi

My nagios xi version 2012R2.7 license trial version 60 Days and will now expire in 55 Days.

If you have any ideas please let me know.

Thanks in advance.

[slansing]

How did you shut down your nagios xi server, if you do not do it safely and properly then nagios and it's associated processes/services did not have time to exit and you may have corrupted the mysql DB. Please run through these steps here and see if your data comes back:

http://assets.nagios.com/downloads/nagi ... tabase.pdf

[dimsum]

Hi Support,

Today i've testing editing on the nagios config file from ssh remote. i was edit services in services folder then apply on nagios xi web portal but i just wondering my config is not change any new value stay same old config before i do it.

I think i can't edit any hosts and services. what is the problem. this's a limitation or not.

P.S. I've to POC on this company to purchase the system monitoring in next year on Q1-Q2. please let me know if you have any ideas ASAP.

Thanks in advance.

[tmcdonald]

Today i've testing editing on the nagios config file from ssh remote. i was edit services in services folder then apply on nagios xi web portal but i just wondering my config is not change any new value stay same old config before i do it..

Editing the files in your .../nagios/etc/services/ folder and then applying config in the web UI will not work. Configs are written to file when you apply config in the UI.

Have you tried adding the hosts you need in the static/ folder, then importing them?

[dimsum]

How did you shut down your nagios xi server, if you do not do it safely and properly then nagios and it's associated processes/services did not have time to exit and you may have corrupted the mysql DB. Please run through these steps here and see if your data comes back:

http://assets.nagios.com/downloads/nagi ... tabase.pdf

Hi Slansing,

Thanks for you reply.

I've follow in an instruction but it doesn't work. After repair i can't add any hosts and services in UI.

Have you any ideas.

Thanks in advance.

[slansing]

That may be another issue, can you now see your hosts/services in the Home > Hosts or Home > Services pages? Did you make sure to clear your browser's cache, and make sure you have no filters set for search terms?

[dimsum]

Hi Slansing,

Im very make sure. I testing on chrome and safari are same the issues. My this point, I can delete hosts or services but i can't add any hosts and services. For this make sure i'm access ssh remote to nagios xi and finding my new host added in the folder /usr/local/nagios/etc/hosts, /usr/local/nagios/etc/services but unfortunately im not see my new host adding file.

P.S Before i'm facing this issues i tries played the nagios xi version 2012R2.5 i found same issues and i try to upgrade that but it doesn't work any more.

Please help me.

Thanks in advance.

[scottwilkerson]

Can you show us the output of the following

Code: Select all

tail -200 /var/log/mysqld.log

Thanks

[dimsum]

Hi There,

Here's the log from mysqld.log

Code: Select all

131013 22:20:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131013 22:20:45  InnoDB: Initializing buffer pool, size = 8.0M
131013 22:20:45  InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
131013 22:20:45  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
131013 22:20:45  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
131013 22:20:45  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
131013 22:20:45  InnoDB: Started; log sequence number 0 0
131013 22:20:45 [Note] Event Scheduler: Loaded 0 events
131013 22:20:45 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
131013 22:27:17 [Note] /usr/libexec/mysqld: Normal shutdown

131013 22:27:17 [Note] Event Scheduler: Purging the queue. 0 events
131013 22:27:17  InnoDB: Starting shutdown...
131013 22:27:22  InnoDB: Shutdown completed; log sequence number 0 44233
131013 22:27:22 [Note] /usr/libexec/mysqld: Shutdown complete

131013 22:27:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131126 20:51:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131126 20:51:44  InnoDB: Initializing buffer pool, size = 8.0M
131126 20:51:44  InnoDB: Completed initialization of buffer pool
131126 20:51:44  InnoDB: Started; log sequence number 0 44233
131126 20:51:44 [Note] Event Scheduler: Loaded 0 events
131126 20:51:44 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
131126 22:15:49 [Note] /usr/libexec/mysqld: Normal shutdown

131126 22:15:49 [Note] Event Scheduler: Purging the queue. 0 events
131126 22:15:51  InnoDB: Starting shutdown...
131126 22:15:53  InnoDB: Shutdown completed; log sequence number 0 44233
131126 22:15:53 [Note] /usr/libexec/mysqld: Shutdown complete

131126 22:15:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131126 22:16:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131126 22:16:14  InnoDB: Initializing buffer pool, size = 8.0M
131126 22:16:14  InnoDB: Completed initialization of buffer pool
131126 22:16:14  InnoDB: Started; log sequence number 0 44233
131126 22:16:14 [Note] Event Scheduler: Loaded 0 events
131126 22:16:14 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
131127 20:09:09 [Note] /usr/libexec/mysqld: Normal shutdown

131127 20:09:09 [Note] Event Scheduler: Purging the queue. 0 events
131127 20:09:09  InnoDB: Starting shutdown...
131127 20:09:11  InnoDB: Shutdown completed; log sequence number 0 44233
131127 20:09:11 [Note] /usr/libexec/mysqld: Shutdown complete

131128 08:09:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131128 08:09:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131128  8:09:33  InnoDB: Initializing buffer pool, size = 8.0M
131128  8:09:33  InnoDB: Completed initialization of buffer pool
131128  8:09:33  InnoDB: Started; log sequence number 0 44233
131128  8:09:33 [Note] Event Scheduler: Loaded 0 events
131128  8:09:33 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
131128 10:56:15 [Note] /usr/libexec/mysqld: Normal shutdown

131128 10:56:15 [Note] Event Scheduler: Purging the queue. 0 events
131128 10:56:17  InnoDB: Starting shutdown...
131128 10:56:18  InnoDB: Shutdown completed; log sequence number 0 44233
131128 10:56:18 [Note] /usr/libexec/mysqld: Shutdown complete

131128 10:56:18 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131128 10:56:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131128 10:56:41  InnoDB: Initializing buffer pool, size = 8.0M
131128 10:56:41  InnoDB: Completed initialization of buffer pool
131128 10:56:41  InnoDB: Started; log sequence number 0 44233
131128 10:56:41 [Note] Event Scheduler: Loaded 0 events
131128 10:56:41 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
131202  8:34:16 [Note] /usr/libexec/mysqld: Normal shutdown

131202  8:34:16 [Note] Event Scheduler: Purging the queue. 0 events
131202  8:34:16  InnoDB: Starting shutdown...
131202  8:34:20  InnoDB: Shutdown completed; log sequence number 0 44233
131202  8:34:20 [Note] /usr/libexec/mysqld: Shutdown complete

131202 08:34:20 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131202 08:34:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131202  8:34:44  InnoDB: Initializing buffer pool, size = 8.0M
131202  8:34:44  InnoDB: Completed initialization of buffer pool
131202  8:34:44  InnoDB: Started; log sequence number 0 44233
131202  8:34:44 [Note] Event Scheduler: Loaded 0 events
131202  8:34:44 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
131202 22:26:50 [Note] /usr/libexec/mysqld: Normal shutdown

131202 22:26:50 [Note] Event Scheduler: Purging the queue. 0 events
131202 22:26:50  InnoDB: Starting shutdown...
131202 22:26:55  InnoDB: Shutdown completed; log sequence number 0 44233
131202 22:26:55 [Note] /usr/libexec/mysqld: Shutdown complete

131202 22:26:55 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131202 22:32:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131202 22:32:19  InnoDB: Initializing buffer pool, size = 8.0M
131202 22:32:19  InnoDB: Completed initialization of buffer pool
131202 22:32:19  InnoDB: Started; log sequence number 0 44233
131202 22:32:19 [Note] Event Scheduler: Loaded 0 events
131202 22:32:19 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
131206  8:03:19 [Note] /usr/libexec/mysqld: Normal shutdown

131206  8:03:19 [Note] Event Scheduler: Purging the queue. 0 events
131206  8:03:21  InnoDB: Starting shutdown...
131206  8:03:22  InnoDB: Shutdown completed; log sequence number 0 44233
131206  8:03:22 [Note] /usr/libexec/mysqld: Shutdown complete

131206 08:03:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131206 08:03:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131206  8:03:42  InnoDB: Initializing buffer pool, size = 8.0M
131206  8:03:42  InnoDB: Completed initialization of buffer pool
131206  8:03:42  InnoDB: Started; log sequence number 0 44233
131206  8:03:42 [Note] Event Scheduler: Loaded 0 events
131206  8:03:42 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
131206  8:09:19 [Note] /usr/libexec/mysqld: Normal shutdown

131206  8:09:19 [Note] Event Scheduler: Purging the queue. 0 events
131206  8:09:21  InnoDB: Starting shutdown...
131206  8:09:23  InnoDB: Shutdown completed; log sequence number 0 44233
131206  8:09:23 [Note] /usr/libexec/mysqld: Shutdown complete

131206 08:09:23 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131206 08:09:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131206  8:09:28  InnoDB: Initializing buffer pool, size = 8.0M
131206  8:09:28  InnoDB: Completed initialization of buffer pool
131206  8:09:28  InnoDB: Started; log sequence number 0 44233
131206  8:09:28 [Note] Event Scheduler: Loaded 0 events
131206  8:09:28 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
131206  8:09:49 [Note] /usr/libexec/mysqld: Normal shutdown

131206  8:09:49 [Note] Event Scheduler: Purging the queue. 0 events
131206  8:09:51  InnoDB: Starting shutdown...
131206  8:09:53  InnoDB: Shutdown completed; log sequence number 0 44233
131206  8:09:53 [Note] /usr/libexec/mysqld: Shutdown complete

131206 08:09:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131206 08:10:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131206  8:10:16  InnoDB: Initializing buffer pool, size = 8.0M
131206  8:10:16  InnoDB: Completed initialization of buffer pool
131206  8:10:16  InnoDB: Started; log sequence number 0 44233
131206  8:10:16 [Note] Event Scheduler: Loaded 0 events
131206  8:10:16 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
131209  9:18:36 [Note] /usr/libexec/mysqld: Normal shutdown

131209  9:18:36 [Note] Event Scheduler: Purging the queue. 0 events
131209  9:18:38  InnoDB: Starting shutdown...
131209  9:18:42  InnoDB: Shutdown completed; log sequence number 0 44233
131209  9:18:42 [Note] /usr/libexec/mysqld: Shutdown complete

131209 09:18:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131209 09:29:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131209  9:29:29  InnoDB: Initializing buffer pool, size = 8.0M
131209  9:29:29  InnoDB: Completed initialization of buffer pool
131209  9:29:29  InnoDB: Started; log sequence number 0 44233
131209  9:29:30 [Note] Event Scheduler: Loaded 0 events
131209  9:29:30 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
131209  9:36:08 [Note] /usr/libexec/mysqld: Normal shutdown

131209  9:36:08 [Note] Event Scheduler: Purging the queue. 0 events
131209  9:36:10  InnoDB: Starting shutdown...
131209  9:36:12  InnoDB: Shutdown completed; log sequence number 0 44233
131209  9:36:12 [Note] /usr/libexec/mysqld: Shutdown complete

131209 09:36:12 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
131209 09:36:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131209  9:36:38  InnoDB: Initializing buffer pool, size = 8.0M
131209  9:36:38  InnoDB: Completed initialization of buffer pool
131209  9:36:38  InnoDB: Started; log sequence number 0 44233
131209  9:36:38 [Note] Event Scheduler: Loaded 0 events
131209  9:36:38 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

Thanks.

[lmiltchev]

Go to Admin->System Profile->Download Profile, save the "profile.zip" and PM it to any of us (Nagios tech support).