Nagios Support Forum

I try install, the monitoring of the netflow.

in use this manual

http://beginlinux.com/server/nagios/cis ... -nagios-xi

but when try to open the url is not working

#/var/log/messages

Dec 27 05:39:40 nagiosxi ndo2db: mysql_error: 'Table 'nagios_systemcommands' is marked as crashed and should be repaired'
Dec 27 05:39:40 nagiosxi ndo2db: Error: mysql_query() failed for 'DELETE FROM nagios_hostchecks WHERE instance_id='1' AND start_time<FROM_UNIXTIME(1356003580)'
Dec 27 05:39:40 nagiosxi ndo2db: mysql_error: 'Table 'nagios_hostchecks' is marked as crashed and should be repaired'
Dec 27 05:40:10 nagiosxi nfcapd[29833]: Ident: 'upstream1' Flows: 0, Packets: 0, Bytes: 0, Sequence Errors: 0, Bad Packets: 0
Dec 27 05:40:10 nagiosxi nfcapd[29833]: Total ignored packets: 0
Dec 27 05:40:10 nagiosxi nfcapd[29836]: Ident: 'peer1' Flows: 0, Packets: 0, Bytes: 0, Sequence Errors: 0, Bad Packets: 0
Dec 27 05:40:10 nagiosxi nfcapd[29836]: Ident: 'peer2' Flows: 0, Packets: 0, Bytes: 0, Sequence Errors: 0, Bad Packets: 0
Dec 27 05:40:10 nagiosxi nfcapd[29836]: Total ignored packets: 0
Dec 27 05:40:15 nagiosxi nfsen[29842]: 0 channels/alerts to profile
Dec 27 05:40:15 nagiosxi nfsen[29842]: Update profile live in group .
Dec 27 05:40:15 nagiosxi nfsen[29842]: Channel info file missing for channel 'peer2' in './live'
Dec 27 05:40:15 nagiosxi nfsen[29842]: Channel info file missing for channel 'upstream1' in './live'
Dec 27 05:40:15 nagiosxi nfsen[29842]: Channel info file missing for channel 'peer1' in './live'
Dec 27 05:40:15 nagiosxi nfsen[29842]: Unable to create graph: No such file or directory
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error GenGraph: Profile: live, traffic-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 337.
Dec 27 05:40:15 nagiosxi nfsen[29842]: Unable to create graph: No such file or directory
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error GenGraph: Profile: live, traffic-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 346.
Dec 27 05:40:15 nagiosxi nfsen[29842]: Unable to create graph: No such file or directory
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error GenGraph: Profile: live, traffic-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 356.
Dec 27 05:40:15 nagiosxi nfsen[29842]: Unable to create graph: No such file or directory
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error GenGraph: Profile: live, traffic-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 366.
Dec 27 05:40:15 nagiosxi nfsen[29842]: Unable to create graph: No such file or directory
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error GenGraph: Profile: live, flows-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 337.
Dec 27 05:40:15 nagiosxi nfsen[29842]: Unable to create graph: No such file or directory
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error GenGraph: Profile: live, flows-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 346.
Dec 27 05:40:15 nagiosxi nfsen[29842]: Unable to create graph: No such file or directory
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error GenGraph: Profile: live, flows-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 356.
Dec 27 05:40:15 nagiosxi nfsen[29842]: Unable to create graph: No such file or directory
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error GenGraph: Profile: live, flows-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 366.
Dec 27 05:40:15 nagiosxi nfsen[29842]: Unable to create graph: No such file or directory
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error GenGraph: Profile: live, packets-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 337.
Dec 27 05:40:15 nagiosxi nfsen[29842]: Unable to create graph: No such file or directory
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error GenGraph: Profile: live, packets-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 346.
Dec 27 05:40:15 nagiosxi nfsen[29842]: Unable to create graph: No such file or directory
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error GenGraph: Profile: live, packets-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 356.
Dec 27 05:40:15 nagiosxi nfsen[29842]: Unable to create graph: No such file or directory
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error GenGraph: Profile: live, packets-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 366.
Dec 27 05:40:15 nagiosxi nfsen[29842]: Error graph update: Error GenGraph: Profile: live, packets-day: Legend set but no color: peer2
Dec 27 05:40:15 nagiosxi nfsen[29842]: Run expire at Thu Dec 27 05:40:00 2012
Dec 27 05:40:15 nagiosxi nfsen[29842]: End expire at Thu Dec 27 05:40:00 2012
Dec 27 05:40:41 nagiosxi ndo2db: Error: mysql_query() failed for 'DELETE FROM nagios_systemcommands WHERE instance_id='1' AND start_time<FROM_UNIXT

Looks like you need to repair your mysql database, as its marked as crashed. Refer to the documentation here on how to repair a mysql table:

http://dev.mysql.com/doc/refman/5.0/en/ ... epair.html

Thank achieve and fix errors in the database.

But still failed to resolve the following errors.
I get to see, the url without problems, but it seems there is a problem creating the graphics and another with the profile live.

siguiete besides the path "/ var / cache / nfdump /" no record

and permitted the following ports in iptables.


# IPFLOW
-A INPUT-m state - state NEW-m tcp-p tcp - dport 9995-j ACCEPT

# IPFLOW
-A INPUT-m state - state NEW-m tcp-p tcp - dport 9996-j ACCEPT

and this is the log

#/var/log/messages

Dec 30 12:45:15 nagiosxi nfsen[16625]: Run expire at Sun Dec 30 12:45:00 2012
Dec 30 12:45:15 nagiosxi nfsen[16625]: End expire at Sun Dec 30 12:45:00 2012
Dec 30 12:47:51 nagiosxi nfsen[24981]: Error generating details graph: Legend set but no color: peer2 : Arg: 'live', 'peer1:upstream1:peer2', 'any', 'flows', '1356607800', '1356806400', '1356892800', '1356849600', '1356849600', '576', '200', '0', '0', '0'
Dec 30 12:48:38 nagiosxi nagios: Auto-save of retention data completed successfully.
Dec 30 12:50:10 nagiosxi nfcapd[16592]: Ident: 'peer1' Flows: 0, Packets: 0, Bytes: 0, Sequence Errors: 0, Bad Packets: 0
Dec 30 12:50:10 nagiosxi nfcapd[16592]: Ident: 'peer2' Flows: 0, Packets: 0, Bytes: 0, Sequence Errors: 0, Bad Packets: 0
Dec 30 12:50:10 nagiosxi nfcapd[16592]: Total ignored packets: 0
Dec 30 12:50:10 nagiosxi nfcapd[16587]: Ident: 'upstream1' Flows: 0, Packets: 0, Bytes: 0, Sequence Errors: 0, Bad Packets: 0
Dec 30 12:50:10 nagiosxi nfcapd[16587]: Total ignored packets: 0
Dec 30 12:50:15 nagiosxi nfsen[16625]: 0 channels/alerts to profile
Dec 30 12:50:15 nagiosxi nfsen[16625]: Update profile live in group .
Dec 30 12:50:15 nagiosxi nfsen[16625]: Unable to create graph: No such file or directory
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error GenGraph: Profile: live, traffic-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 337.
Dec 30 12:50:15 nagiosxi nfsen[16625]: Unable to create graph: No such file or directory
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error GenGraph: Profile: live, traffic-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 346.
Dec 30 12:50:15 nagiosxi nfsen[16625]: Unable to create graph: No such file or directory
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error GenGraph: Profile: live, traffic-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 356.
Dec 30 12:50:15 nagiosxi nfsen[16625]: Unable to create graph: No such file or directory
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error GenGraph: Profile: live, traffic-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 366.
Dec 30 12:50:15 nagiosxi nfsen[16625]: Unable to create graph: No such file or directory
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error GenGraph: Profile: live, flows-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 337.
Dec 30 12:50:15 nagiosxi nfsen[16625]: Unable to create graph: No such file or directory
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error GenGraph: Profile: live, flows-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 346.
Dec 30 12:50:15 nagiosxi nfsen[16625]: Unable to create graph: No such file or directory
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error GenGraph: Profile: live, flows-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 356.
Dec 30 12:50:15 nagiosxi nfsen[16625]: Unable to create graph: No such file or directory
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error GenGraph: Profile: live, flows-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 366.
Dec 30 12:50:15 nagiosxi nfsen[16625]: Unable to create graph: No such file or directory
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error GenGraph: Profile: live, packets-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 337.
Dec 30 12:50:15 nagiosxi nfsen[16625]: Unable to create graph: No such file or directory
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error GenGraph: Profile: live, packets-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 346.
Dec 30 12:50:15 nagiosxi nfsen[16625]: Unable to create graph: No such file or directory
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error GenGraph: Profile: live, packets-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 356.
Dec 30 12:50:15 nagiosxi nfsen[16625]: Unable to create graph: No such file or directory
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error GenGraph: Profile: live, packets-day: Legend set but no color: peer2 at /data/nfsen/libexec/NfSenRRD.pm line 366.
Dec 30 12:50:15 nagiosxi nfsen[16625]: Error graph update: Error GenGraph: Profile: live, packets-day: Legend set but no color: peer2
Dec 30 12:50:15 nagiosxi nfsen[16625]: Run expire at Sun Dec 30 12:50:00 2012
Dec 30 12:50:15 nagiosxi nfsen[16625]: End expire at Sun Dec 30 12:50:00 2012

I did find this post by Peter, the creator of nfsen and nfdump.

http://www.mail-archive.com/nfsen-discu ... 01989.html

It seems as though the color is very important when running nfsen and it will nosedive if you haven't set it in the config.