Changing Nagios xi IP address

This support forum board is for support questions relating to Nagios xi, our flagship commercial network monitoring solution.
User avatar
srrhd
Posts: 131
Joined: Thu May 19, 2011 6:15 am

Changing Nagios xi IP address

Post by srrhd »

Hi,

We had to change the IP address of one of our two Nagiosxi server. Since this change, it is unable to check the systems status and staistics as show on the image below. It was, when changing it's IP in 2011R1.9. I have read on the forum that you have implement on new licensing system which allow the change of IP, so i have upgraded the server to 2011R2.2. But the problem persists. Is there a way to reactivate the licence key with the new IP ?
Nagios xi - Administration_1332497069982.png
I also noticed that on the "check for update" page it keeps saying that the latest available version is 2011R1.9.
Nagios xi - Administration_1332497289385.png
Otherwise everything is working properly on the server, monitoring, notifications, graph performance, etc...

Thanks for your help,

Aurelien.

PS: By the way, it's impressive how the performance have increase with the latest version. The load has been divided by 2 ! Great job guys !!
You do not have the required permissions to view the files attached to this post.
Last edited by srrhd on Fri Mar 30, 2012 12:06 am, edited 1 time in total.
Configuration:
Nagios xi 2014R2.5
manually upgraded on 64bits CentOS 6
with nothing extra, no gnome, no proxy, no SSL
Add-ons: Hypermap, Minemap, Ping Action, Traceroute Action, Network Replay, Graph Explorer, Latest Alert
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises

Re: Changing Nagios xi IP address

Post by scottwilkerson »

srrhd wrote:I also noticed that on the "check for update" page it keeps saying that the latest available version is 2011R1.9.
This one looks like you haven't checked for updates since 2/2/2012, that wouls be why that is, Maybe you have automatic update checks disabled...

As for the other screen shot, you have a red ! on the top right, what does the "Could not read" link go to?

I don't think this looks like a licensing issue.
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
User avatar
srrhd
Posts: 131
Joined: Thu May 19, 2011 6:15 am

Re: Changing Nagios xi IP address

Post by srrhd »

OK forget about the "Automatic update check". It was enable but i guess i didn't press the "check now button". This morning it behaves properly.

Concerning the Red flag on top right, that why i provide you the screen shot. When i click on it i am redirect to the Server Status Information that gives no data:
Nagios xi - System Status_1332741827125.png
The wierd thing is that everything seems to work properly.
You do not have the required permissions to view the files attached to this post.
Configuration:
Nagios xi 2014R2.5
manually upgraded on 64bits CentOS 6
with nothing extra, no gnome, no proxy, no SSL
Add-ons: Hypermap, Minemap, Ping Action, Traceroute Action, Network Replay, Graph Explorer, Latest Alert
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises

Re: Changing Nagios xi IP address

Post by scottwilkerson »

Can you click on the Admin menu and tell me if all of the "xi System Component Status" are green.
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
User avatar
srrhd
Posts: 131
Joined: Thu May 19, 2011 6:15 am

Re: Changing Nagios xi IP address

Post by srrhd »

Yes but it says that there is no data:
Nagios xi - Administration_1332772064402.png
You do not have the required permissions to view the files attached to this post.
Configuration:
Nagios xi 2014R2.5
manually upgraded on 64bits CentOS 6
with nothing extra, no gnome, no proxy, no SSL
Add-ons: Hypermap, Minemap, Ping Action, Traceroute Action, Network Replay, Graph Explorer, Latest Alert
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises

Re: Changing Nagios xi IP address

Post by scottwilkerson »

I have a feeling that crond is not running or the nagiosxi cron jobs aren't processing correctly. Can you run

Code: Select all

service crond status
and

Code: Select all

ps aux |grep xi/cron
And report the output of both.

Thanks
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart
User avatar
srrhd
Posts: 131
Joined: Thu May 19, 2011 6:15 am

Re: Changing Nagios xi IP address

Post by srrhd »

Here are the outputs:

Code: Select all

[root@mNagiosxi ~]# service crond status
crond (pid  4303) is running...

Code: Select all

[root@mNagiosxi ~]# ps -aux | grep xi/cron
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.7/FAQ
nagios   23776  0.0  0.0   2500   976 ?        Ss   10:21   0:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/reportengine.php > /usr/local/nagiosxi/var/reportengine.log 2>&1
nagios   23778  3.7  0.4  30088 15092 ?        S    10:21   0:00 /usr/bin/php -q /usr/local/nagiosxi/cron/reportengine.php
nagios   23779  0.0  0.0   2500   972 ?        Ss   10:21   0:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php > /usr/local/nagiosxi/var/feedproc.log 2>&1
nagios   23780  0.0  0.0   2500   972 ?        Ss   10:21   0:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php > /usr/local/nagiosxi/var/sysstat.log 2>&1
nagios   23781  0.0  0.0   2500   968 ?        Ss   10:21   0:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php > /usr/local/nagiosxi/var/perfdataproc.log 2>&1
nagios   23782  3.6  0.4  30088 15056 ?        S    10:21   0:00 /usr/bin/php -q /usr/local/nagiosxi/cron/feedproc.php
nagios   23783  0.0  0.0   2500   976 ?        Ss   10:21   0:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php > /usr/local/nagiosxi/var/eventman.log 2>&1
nagios   23784  0.0  0.0   2500   968 ?        Ss   10:21   0:00 /bin/sh -c /usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php > /usr/local/nagiosxi/var/cmdsubsys.log 2>&1
nagios   23785  3.8  0.4  30184 15228 ?        S    10:21   0:00 /usr/bin/php -q /usr/local/nagiosxi/cron/cmdsubsys.php
nagios   23786  4.7  0.6  33676 18740 ?        S    10:21   0:00 /usr/bin/php -q /usr/local/nagiosxi/cron/eventman.php
nagios   23787  3.6  0.4  30160 15192 ?        S    10:21   0:00 /usr/bin/php -q /usr/local/nagiosxi/cron/perfdataproc.php
nagios   23788  4.1  0.5  30164 15612 ?        S    10:21   0:00 /usr/bin/php -q /usr/local/nagiosxi/cron/sysstat.php
root     23892  0.0  0.0   4020   720 pts/0    S+   10:21   0:00 grep xi/cron
Configuration:
Nagios xi 2014R2.5
manually upgraded on 64bits CentOS 6
with nothing extra, no gnome, no proxy, no SSL
Add-ons: Hypermap, Minemap, Ping Action, Traceroute Action, Network Replay, Graph Explorer, Latest Alert
mguthrie
Posts: 4380
Joined: Mon Jun 14, 2010 10:21 am

Re: Changing Nagios xi IP address

Post by mguthrie »

Run:

Code: Select all

tail -f /usr/local/nagiosxi/var/sysstat.log
There should be some error output in that. I'm wondering if there's some corruption in one of your MySQL tables.
http://assets.nagios.com/downloads/nagi ... tabase.pdf
User avatar
srrhd
Posts: 131
Joined: Thu May 19, 2011 6:15 am

Re: Changing Nagios xi IP address

Post by srrhd »

Here are the logs that effectively shows some SQL errors, always about the same block:

Code: Select all

        SQL:    SQL Error [nagiosxi] :</b> ERROR:  invalid page header in block 60 of relation "xi_sysstat"CMDLINE=/etc/init.d/nagios status
nagios (pid 9011) is running...
OUTPUT=nagios (pid 9011) is running...
RETURNCODE=0
CMDLINE=/etc/init.d/npcd status
NPCD running (pid 4355).
OUTPUT=NPCD running (pid 4355).
RETURNCODE=0
CMDLINE=/etc/init.d/ndo2db status
ndo2db (pid 4346) is running...
OUTPUT=ndo2db (pid 4346) is running...
RETURNCODE=0
DAEMONS:
Array
(
    [nagioscore] => Array
        (
            [daemon] => nagios
            [output] => nagios (pid 9011) is running...
            [return_code] => 0
            [status] => 0
        )

    [pnp] => Array
        (
            [daemon] => npcd
            [output] => NPCD running (pid 4355).
            [return_code] => 0
            [status] => 0
        )

    [ndoutils] => Array
        (
            [daemon] => ndo2db
            [output] => ndo2db (pid 4346) is running...
            [return_code] => 0
            [status] => 0
        )

)
        SQL:    SQL Error [nagiosxi] :</b> ERROR:  invalid page header in block 60 of relation "xi_sysstat"HOSTCHECKPERF:
Array
(
    [min_latency] => 0.008
    [max_latency] => 13.12
    [avg_latency] => 1.4290944055944
    [min_execution_time] => 0.00465
    [max_execution_time] => 11.37856
    [avg_execution_time] => 1.4863102447552
)
SERVICECHECKPERF:
Array
(
    [min_latency] => 0.008
    [max_latency] => 12.131
    [avg_latency] => 1.2951844262295
    [min_execution_time] => 0.0038
    [max_execution_time] => 10.91872
    [avg_execution_time] => 1.0450163114754
)
CORE STATS:
Array
(
    [hostcheckevents] => Array
        (
            [1min] => 0
            [5min] => 0
            [15min] => 0
        )

    [servicecheckevents] => Array
        (
            [1min] => 0
            [5min] => 0
            [15min] => 0
        )

    [timedevents] => Array
        (
            [1min] => 0
            [5min] => 0
            [15min] => 0
        )

    [activehostchecks] => Array
        (
            [1min] => 1
            [5min] => 286
            [15min] => 466
        )

    [passivehostchecks] => Array
        (
            [1min] => 0
            [5min] => 0
            [15min] => 0
        )

    [activeservicechecks] => Array
        (
            [1min] => 123
            [5min] => 588
            [15min] => 918
        )

    [passiveservicechecks] => Array
        (
            [1min] => 0
            [5min] => 0
            [15min] => 0
        )

    [activehostcheckperf] => Array
        (
            [min_latency] => 0.008
            [max_latency] => 13.12
            [avg_latency] => 1.4290944055944
            [min_execution_time] => 0.00465
            [max_execution_time] => 11.37856
            [avg_execution_time] => 1.4863102447552
        )

    [activeservicecheckperf] => Array
        (
            [min_latency] => 0.008
            [max_latency] => 12.131
            [avg_latency] => 1.2951844262295
            [min_execution_time] => 0.0038
            [max_execution_time] => 10.91872
            [avg_execution_time] => 1.0450163114754
        )

)
        SQL:    SQL Error [nagiosxi] :</b> ERROR:  invalid page header in block 60 of relation "xi_sysstat"LOAD:
Array
(
    [load1] => 1.75
    [load5] => 4.07
    [load15] => 4.26
)
        SQL:    SQL Error [nagiosxi] :</b> ERROR:  invalid page header in block 60 of relation "xi_sysstat"MEMORY:
Array
(
    [total] => 3034
    [used] => 2487
    [free] => 546
    [shared] => 0
    [buffers] => 252
    [cached] => 1404
)
        SQL:    SQL Error [nagiosxi] :</b> ERROR:  invalid page header in block 60 of relation "xi_sysstat"SWAP:
Array
(
    [total] => 1023
    [used] => 0
    [free] => 1023
)
        SQL:    SQL Error [nagiosxi] :</b> ERROR:  invalid page header in block 60 of relation "xi_sysstat"IOSTAT:
Array
(
    [user] => 5.55
    [nice] => 0.00
    [system] => 1.00
    [iowait] => 7.49
    [steal] => 0.00
    [idle] => 85.96
)
        SQL:    SQL Error [nagiosxi] :</b> ERROR:  invalid page header in block 60 of relation "xi_sysstat" SQL:     SQL Error [nagiosxi] :</b> ERROR:  invalid page header in block 60 of relation "xi_sysstat".
I asked Google about the SQL error appearing in sysstat.log and it seems to be linked to the PostgreSQL database. Whatever i ran the repairmysql.sh script and it prompted any error except the four warnings at the begining:

Code: Select all

[root@mNagiosxi ~]# /usr/local/nagiosxi/scripts/repairmysql.sh nagios *
DATABASE: nagios
TABLE:
/var/lib/mysql/nagios ~
Stopping MySQL:                                            [  OK  ]
Warning: option 'key_buffer_size': unsigned value 18446744073709551615 adjusted to 4294963200
Warning: option 'read_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'write_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295
Warning: option 'sort_buffer_size': unsigned value 18446744073709551615 adjusted to 4294967295
- recovering (with sort) MyISAM-table 'nagios_acknowledgements.MYI'
Data records: 27
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_commands.MYI'
Data records: 88
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_commenthistory.MYI'
Data records: 1011
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_comments.MYI'
Data records: 4
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_configfiles.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_configfilevariables.MYI'
Data records: 137
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_conninfo.MYI'
Data records: 281
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_contact_addresses.MYI'
Data records: 8
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactgroup_members.MYI'
Data records: 23
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactgroups.MYI'
Data records: 5
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contact_notificationcommands.MYI'
Data records: 180
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotificationmethods.MYI'
Data records: 13265
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_contactnotifications.MYI'
Data records: 13265
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_contacts.MYI'
Data records: 15
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_contactstatus.MYI'
Data records: 15
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_customvariables.MYI'
Data records: 690
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_customvariablestatus.MYI'
Data records: 690
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with keycache) MyISAM-table 'nagios_dbversion.MYI'
Data records: 1

---------

- recovering (with sort) MyISAM-table 'nagios_downtimehistory.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_eventhandlers.MYI'
Data records: 14
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_externalcommands.MYI'
Data records: 1334
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_flappinghistory.MYI'
Data records: 1952
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_hostchecks.MYI'
Data records: 577
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_contactgroups.MYI'
Data records: 53
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_contacts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostdependencies.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalation_contactgroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalation_contacts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostescalations.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostgroup_members.MYI'
Data records: 472
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hostgroups.MYI'
Data records: 168
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_host_parenthosts.MYI'
Data records: 289
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_hosts.MYI'
Data records: 286
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_hoststatus.MYI'
Data records: 286
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19

---------

- recovering (with sort) MyISAM-table 'nagios_instances.MYI'
Data records: 1
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_logentries.MYI'
Data records: 317553
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7

---------

- recovering (with sort) MyISAM-table 'nagios_notifications.MYI'
Data records: 102015
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7

---------

- recovering (with sort) MyISAM-table 'nagios_objects.MYI'
Data records: 1383
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5

---------

- recovering (with sort) MyISAM-table 'nagios_processevents.MYI'
Data records: 1100
- Fixing index 1

---------

- recovering (with sort) MyISAM-table 'nagios_programstatus.MYI'
Data records: 1
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_runtimevariables.MYI'
Data records: 18
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_scheduleddowntime.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicechecks.MYI'
Data records: 1321
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4

---------

- recovering (with sort) MyISAM-table 'nagios_service_contactgroups.MYI'
Data records: 516
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_service_contacts.MYI'
Data records: 3
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicedependencies.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contactgroups.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalation_contacts.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_serviceescalations.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicegroup_members.MYI'
Data records: 9
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_servicegroups.MYI'
Data records: 6
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_services.MYI'
Data records: 749
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_servicestatus.MYI'
Data records: 749
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
- Fixing index 9
- Fixing index 10
- Fixing index 11
- Fixing index 12
- Fixing index 13
- Fixing index 14
- Fixing index 15
- Fixing index 16
- Fixing index 17
- Fixing index 18
- Fixing index 19

---------

- recovering (with sort) MyISAM-table 'nagios_statehistory.MYI'
Data records: 135733
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5

---------

- recovering (with sort) MyISAM-table 'nagios_systemcommands.MYI'
Data records: 160
- Fixing index 1
- Fixing index 2
- Fixing index 3

---------

- recovering (with sort) MyISAM-table 'nagios_timedeventqueue.MYI'
Data records: 1013
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_timedevents.MYI'
Data records: 0
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiods.MYI'
Data records: 13
- Fixing index 1
- Fixing index 2

---------

- recovering (with sort) MyISAM-table 'nagios_timeperiod_timeranges.MYI'
Data records: 59
- Fixing index 1
- Fixing index 2
Starting MySQL:                                            [  OK  ]
~

===============
REPAIR COMPLETE
===============
Is there a way to fix the Postgre database ?
Configuration:
Nagios xi 2014R2.5
manually upgraded on 64bits CentOS 6
with nothing extra, no gnome, no proxy, no SSL
Add-ons: Hypermap, Minemap, Ping Action, Traceroute Action, Network Replay, Graph Explorer, Latest Alert
scottwilkerson
DevOps Engineer
Posts: 19396
Joined: Tue Nov 15, 2011 3:11 pm
Location: Nagios Enterprises

Re: Changing Nagios xi IP address

Post by scottwilkerson »

Lets run the following:

Code: Select all

psql nagiosxi nagiosxi
vacuum;
vacuum analyze;
vacuum full;
\q

cd /usr/local/nagiosxi/cron
rm -f ../var/dbmaint.lock
./dbmaint.php
Former Nagios employee
Creator:
Human Design Website
Get Your Human Design Chart