Nagios Fusion unable to poll data from nagios server

[bosecorp]

Looks like I create a new dashboard, things get saved


but it wont let me delete the old dashboards

I get this error

There was an error deleting the specified dashboards.

[tgriep]

Can you run this command as root on the Fusion server.

Code: Select all

tail -f /var/log/httpd/*_log

Then try and delete the Dashboard.
If you see any errors in the shell running the tail command, post them here.

A few questions.
What user account are you are logged in as?
What "Auth Type" is that user, Local, Active Directory, LDAP?
You can find this on the Admin > Manage Users menu and editing the user account.

[bosecorp]

I tried with different accounts including nagiosadmin

here are the logs

10.20.2.118 - - [09/Aug/2018:10:02:21 -0400] "POST /nagiosfusion//dashboards/manage.php HTTP/1.1" 200 136 "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"
10.20.2.118 - - [09/Aug/2018:10:02:21 -0400] "GET /nagiosfusion//dashboards/?fusionwindow=manage.php HTTP/1.1" 200 20111 "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"
10.20.2.118 - - [09/Aug/2018:10:02:21 -0400] "GET /nagiosfusion//dashboards/manage.php HTTP/1.1" 200 26131 "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"
10.20.2.118 - - [09/Aug/2018:10:02:21 -0400] "POST /nagiosfusion/ajaxhelper.php HTTP/1.1" 200 - "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"
10.20.2.118 - - [09/Aug/2018:10:02:21 -0400] "POST /nagiosfusion/ajaxhelper.php HTTP/1.1" 200 - "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"
10.20.2.118 - - [09/Aug/2018:10:02:21 -0400] "POST /nagiosfusion/ajaxhelper.php HTTP/1.1" 200 5882 "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"
10.20.2.118 - - [09/Aug/2018:10:02:21 -0400] "POST /nagiosfusion/ajaxhelper.php HTTP/1.1" 200 20 "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"
10.20.2.118 - - [09/Aug/2018:10:02:21 -0400] "POST /nagiosfusion/ajaxhelper.php HTTP/1.1" 200 - "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"
10.20.2.118 - - [09/Aug/2018:10:02:21 -0400] "POST /nagiosfusion/ajaxhelper.php HTTP/1.1" 200 - "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"
10.20.2.118 - - [09/Aug/2018:10:02:21 -0400] "POST /nagiosfusion/ajaxhelper.php HTTP/1.1" 200 - "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"
10.20.2.118 - - [09/Aug/2018:10:02:21 -0400] "POST /nagiosfusion/ajaxhelper.php HTTP/1.1" 200 - "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"
10.20.2.118 - - [09/Aug/2018:10:02:21 -0400] "POST /nagiosfusion/ajaxhelper.php HTTP/1.1" 200 20 "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"
10.20.2.118 - - [09/Aug/2018:10:02:23 -0400] "POST /nagiosfusion/ajaxhelper.php HTTP/1.1" 200 5882 "http://usvanagiospfu2.bose.com/nagiosfu ... manage.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.84 Safari/537.36"

[tgriep]

Can you run the following commands as root and post the /tmp/info.txt file to the post so we can view the database entries for the dashboards?

Code: Select all

echo 'select * from dashboards;' |mysql -t -u fusion -pfusion fusion >/tmp/info.txt
echo 'desc dashboards;' |mysql -t -u fusion -pfusion fusion >>/tmp/info.txt
echo 'select * from dashlets;' |mysql -t -u fusion -pfusion fusion >>/tmp/info.txt
echo 'desc dashlets;' |mysql -t -u fusion -pfusion fusion >>/tmp/info.txt

We will need the name of the Dashboard you cannot delete.

[bosecorp]

anything but

98 | 8 | 02-Network AWS | 0 | 0 | 0 | 1 | ffffff | 90 | 90 |
| 108 | 1 | 02-Network AWS | 98 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 109 | 2 | 02-Network AWS | 98 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 110 | 4 | 02-Network AWS | 98 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 111 | 8 | 03-Internet-US-MA-Campus | 0 | 0 | 0 | 1 | ffffff | 40 | 40 |
| 112 | 1 | 03-Internet-US-MA-Campus | 111 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 113 | 2 | 03-Internet-US-MA-Campus | 111 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 114 | 4 | 03-Internet-US-MA-Campus | 111 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 115 | 8 | 04-Internet-US-DCE-CXs | 0 | 0 | 0 | 1 | ffffff | 50 | 50 |
| 116 | 1 | 04-Internet-US-DCE-CXs | 115 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 117 | 2 | 04-Internet-US-DCE-CXs | 115 | 0 | 0 | 1 | ffffff | 10 | 10 |
| 118 | 4 | 04-Internet-US-DCE-CXs | 115 | 0 | 0 | 1 | ffffff | 10 | 10 |

[scottwilkerson]

Are these the dashboards you want to delete or keep?

[bosecorp]

delete

[scottwilkerson]

The following command will remove them

Code: Select all

echo "delete from dashboards where dashboard_name IN ('02-Network AWS','03-Internet-US-MA-Campus','04-Internet-US-DCE-CXs');" |mysql -t -u fusion -pfusion fusion

[bosecorp]

Awesome. Thanks. I am all set

[scottwilkerson]

Awesome. Thanks. I am all set

Great

Locking