Sources not running

[Miguel]

Hi all,
I have just installed the Netwrok Analyzer VMware demo version but I am not able to run any source that I have set in the menu. The error appears in the report tab of each source UI menu:
There was an error running nfdump command: /usr/local/bin/nfdump -M '/usr/local/nagiosna/var/test/flows/' -R . -t '2014/02/02.11:12:57-2014/02/03.11:12:56' -N -n '5' -s 'srcip/bytes' -o 'csv' 2> /dev/null

Does anybody know how can I solve this problem?

Thanks in advance

[sreinhardt]

Well, let's start with, what version of NNA are you running, and is this via the cli or web interface?

You might also try:

Code: Select all

/usr/local/nagiosna/bin/nagiosna restart

[Miguel]

Ok, the current version I am using is nagiosna-2014r1.3. I've restarted the VM and it appears another error now:
"A Database Error Occurred

Unable to connect to your database server using the provided settings.

Filename: core/Loader.php

Line Number: 346"


Thanks again

[lmiltchev]

Run the following commands and show us the output:

Code: Select all

sestatus
iptables -L -n
which rrdtool
cat /etc/sudoers.d/nna_conf

[Miguel]

I attach two screenshots with the output

[sreinhardt]

Let's verify that mysql is running and not causing errors.

Code: Select all

service mysql status
tail -n 25 /var/log/mysqld.log

Also if you could post text instead of screenshots, it would be appreciated. Thanks!

[Miguel]

It seems that mysql is not running.
[root@localhost ~]# service mysql status
mysql: unrecognized service

[root@localhost ~]# tail -n 25 /var/log/mysqld.log
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
140205 18:13:26 InnoDB: Started; log sequence number 0 0
140205 18:13:27 [Note] Event Scheduler: Loaded 0 events
140205 18:13:27 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
140205 18:13:29 [Note] /usr/libexec/mysqld: Normal shutdown

140205 18:13:29 [Note] Event Scheduler: Purging the queue. 0 events
140205 18:13:29 InnoDB: Starting shutdown...
140205 18:13:32 InnoDB: Shutdown completed; log sequence number 0 119617
140205 18:13:32 [Note] /usr/libexec/mysqld: Shutdown complete

140205 18:13:32 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140205 18:13:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140205 18:13:33 InnoDB: Initializing buffer pool, size = 8.0M
140205 18:13:33 InnoDB: Completed initialization of buffer pool
140205 18:13:33 InnoDB: Started; log sequence number 0 119617
140205 18:13:33 [Note] Event Scheduler: Loaded 0 events
140205 18:13:33 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.71' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

[Miguel]

I can't neither restart the service
[root@localhost ~]# service mysqld restart
Stopping mysqld: [ OK ]
Another MySQL daemon already running with the same unix socket.
Starting mysqld: [FAILED]

[slansing]

Please run:

Code: Select all

service mysqld stop

rm -rf /var/lib/mysql/mysql.sock

service mysqld start

[Miguel]

Ok, this fixes the problem with mysql. Now I can access to nagios menu via browser in http://localhost/nagiosna/index.php. The only problem now is that I can not see data for the sources. The message that appears is: "No Data Available. There is not data available for the currently selected time period". I have already open the port of the source (2055 in my case) like this:
iptables -I INPUT 1 -i eth0 -p tcp --dport 2055 -j ACCEPT

But it seems is not enough. Is it necessary to do something else to be able to see data information in the sources?

Thanks again