Page 2 of 2

Re: Nagios Fusion unable to poll data from nagios server

Posted: Wed Aug 08, 2018 2:20 pm
by 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.

Re: Nagios Fusion unable to poll data from nagios server

Posted: Thu Aug 09, 2018 8:29 am
by 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.

Re: Nagios Fusion unable to poll data from nagios server

Posted: Thu Aug 09, 2018 9:02 am
by 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"

Re: Nagios Fusion unable to poll data from nagios server

Posted: Thu Aug 09, 2018 12:30 pm
by 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.

Re: Nagios Fusion unable to poll data from nagios server

Posted: Fri Aug 10, 2018 10:36 am
by 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 |

Re: Nagios Fusion unable to poll data from nagios server

Posted: Fri Aug 10, 2018 4:03 pm
by scottwilkerson
Are these the dashboards you want to delete or keep?

Re: Nagios Fusion unable to poll data from nagios server

Posted: Sat Aug 11, 2018 6:09 pm
by bosecorp
delete

Re: Nagios Fusion unable to poll data from nagios server

Posted: Mon Aug 13, 2018 7:03 am
by 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

Re: Nagios Fusion unable to poll data from nagios server

Posted: Tue Aug 14, 2018 7:43 am
by bosecorp
Awesome. Thanks. I am all set

Re: Nagios Fusion unable to poll data from nagios server

Posted: Tue Aug 14, 2018 7:53 am
by scottwilkerson
bosecorp wrote:Awesome. Thanks. I am all set
Great

Locking