Changing Nagios XI IP address

[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 !!

[scottwilkerson]

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.

[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.

[scottwilkerson]

Can you click on the Admin menu and tell me if all of the "XI System Component Status" are green.

[srrhd]

Yes but it says that there is no data:

Nagios XI - Administration_1332772064402.png

[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

[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

[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

[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 ?

[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