Nagios Support Forum

Support for Nagios products and services
https://support.nagios.com/forum/

Some Dashboards disappeared?

https://support.nagios.com/forum/viewtopic.php?t=42742

Page 2 of 2

Re: Some Dashboards disappeared?

Posted: Tue Mar 07, 2017 5:12 pm
by ssax
Interesting, I've only seen the dashboards disappearing issue on systems that don't use postgresql, postgresql uses a text type field which is about 1GB (so not likely the issue).

Do you have any backup files in /store/backups/postgresql?

Code: Select all

ls -l /store/backups/postgresql/*/*

Re: Some Dashboards disappeared?

Posted: Wed Mar 08, 2017 7:51 am
by GhostRider2110
Yes there are a lot of them. Looks like Feb 28 is not there in the daily but weekly should be there...

Code: Select all

[root@iganagios ~]# ls -l /store/backups/postgresql/*/*
/store/backups/postgresql/daily/nagiosxi:
total 2020
-rw-r--r-- 1 root root 345309 Mar  2 07:00 nagiosxi_2017-03-02.Thursday.sql.gz
-rw-r--r-- 1 root root 338199 Mar  3 07:00 nagiosxi_2017-03-03.Friday.sql.gz
-rw-r--r-- 1 root root 340648 Mar  5 07:00 nagiosxi_2017-03-05.Sunday.sql.gz
-rw-r--r-- 1 root root 347035 Mar  6 07:00 nagiosxi_2017-03-06.Monday.sql.gz
-rw-r--r-- 1 root root 342085 Mar  7 07:00 nagiosxi_2017-03-07.Tuesday.sql.gz
-rw-r--r-- 1 root root 343241 Mar  8 07:00 nagiosxi_2017-03-08.Wednesday.sql.gz

/store/backups/postgresql/daily/postgres:
total 24
-rw-r--r-- 1 root root 416 Mar  2 07:00 postgres_2017-03-02.Thursday.sql.gz
-rw-r--r-- 1 root root 414 Mar  3 07:00 postgres_2017-03-03.Friday.sql.gz
-rw-r--r-- 1 root root 414 Mar  5 07:00 postgres_2017-03-05.Sunday.sql.gz
-rw-r--r-- 1 root root 414 Mar  6 07:00 postgres_2017-03-06.Monday.sql.gz
-rw-r--r-- 1 root root 415 Mar  7 07:00 postgres_2017-03-07.Tuesday.sql.gz
-rw-r--r-- 1 root root 417 Mar  8 07:00 postgres_2017-03-08.Wednesday.sql.gz

/store/backups/postgresql/daily/template1:
total 24
-rw-r--r-- 1 root root 452 Mar  2 07:00 template1_2017-03-02.Thursday.sql.gz
-rw-r--r-- 1 root root 450 Mar  3 07:00 template1_2017-03-03.Friday.sql.gz
-rw-r--r-- 1 root root 450 Mar  5 07:00 template1_2017-03-05.Sunday.sql.gz
-rw-r--r-- 1 root root 450 Mar  6 07:00 template1_2017-03-06.Monday.sql.gz
-rw-r--r-- 1 root root 451 Mar  7 07:00 template1_2017-03-07.Tuesday.sql.gz
-rw-r--r-- 1 root root 453 Mar  8 07:00 template1_2017-03-08.Wednesday.sql.gz

/store/backups/postgresql/monthly/nagiosxi:
total 7800
-rw-r--r-- 1 root root  18711 Nov  1  2014 nagiosxi_2014-11-01.November.nagiosxi.sql.gz
-rw-r--r-- 1 root root  44075 Dec  1  2014 nagiosxi_2014-12-01.December.nagiosxi.sql.gz
-rw-r--r-- 1 root root  94691 Jan  1  2015 nagiosxi_2015-01-01.January.nagiosxi.sql.gz
-rw-r--r-- 1 root root 191096 Feb  1  2015 nagiosxi_2015-02-01.February.nagiosxi.sql.gz
-rw-r--r-- 1 root root 176023 Mar  1  2015 nagiosxi_2015-03-01.March.nagiosxi.sql.gz
-rw-r--r-- 1 root root 291345 Apr  1  2015 nagiosxi_2015-04-01.April.nagiosxi.sql.gz
-rw-r--r-- 1 root root 265528 May  1  2015 nagiosxi_2015-05-01.May.nagiosxi.sql.gz
-rw-r--r-- 1 root root 239582 Jun  1  2015 nagiosxi_2015-06-01.June.nagiosxi.sql.gz
-rw-r--r-- 1 root root 240302 Jul  1  2015 nagiosxi_2015-07-01.July.nagiosxi.sql.gz
-rw-r--r-- 1 root root 234476 Aug  1  2015 nagiosxi_2015-08-01.August.nagiosxi.sql.gz
-rw-r--r-- 1 root root 374674 Sep  1  2015 nagiosxi_2015-09-01.September.nagiosxi.sql.gz
-rw-r--r-- 1 root root 214758 Oct  1  2015 nagiosxi_2015-10-01.October.nagiosxi.sql.gz
-rw-r--r-- 1 root root 266042 Nov  1  2015 nagiosxi_2015-11-01.November.nagiosxi.sql.gz
-rw-r--r-- 1 root root 234322 Dec  1  2015 nagiosxi_2015-12-01.December.nagiosxi.sql.gz
-rw-r--r-- 1 root root 328028 Jan  1  2016 nagiosxi_2016-01-01.January.nagiosxi.sql.gz
-rw-r--r-- 1 root root 296472 Feb  1  2016 nagiosxi_2016-02-01.February.nagiosxi.sql.gz
-rw-r--r-- 1 root root 339168 Mar  1  2016 nagiosxi_2016-03-01.March.nagiosxi.sql.gz
-rw-r--r-- 1 root root 312985 Apr  1  2016 nagiosxi_2016-04-01.April.nagiosxi.sql.gz
-rw-r--r-- 1 root root 330087 May  1  2016 nagiosxi_2016-05-01.May.nagiosxi.sql.gz
-rw-r--r-- 1 root root 421085 Jun  1  2016 nagiosxi_2016-06-01.June.nagiosxi.sql.gz
-rw-r--r-- 1 root root 321984 Jul  1  2016 nagiosxi_2016-07-01.July.nagiosxi.sql.gz
-rw-r--r-- 1 root root 311840 Aug  1  2016 nagiosxi_2016-08-01.August.nagiosxi.sql.gz
-rw-r--r-- 1 root root 325296 Sep  1  2016 nagiosxi_2016-09-01.September.nagiosxi.sql.gz
-rw-r--r-- 1 root root 320140 Oct  1 08:00 nagiosxi_2016-10-01.October.nagiosxi.sql.gz
-rw-r--r-- 1 root root 337783 Nov  1 08:00 nagiosxi_2016-11-01.November.nagiosxi.sql.gz
-rw-r--r-- 1 root root 344945 Dec  1 08:00 nagiosxi_2016-12-01.December.nagiosxi.sql.gz
-rw-r--r-- 1 root root 331124 Jan  1 07:00 nagiosxi_2017-01-01.January.nagiosxi.sql.gz
-rw-r--r-- 1 root root 356839 Feb  1 07:00 nagiosxi_2017-02-01.February.nagiosxi.sql.gz
-rw-r--r-- 1 root root 360610 Mar  1 07:00 nagiosxi_2017-03-01.March.nagiosxi.sql.gz

/store/backups/postgresql/monthly/postgres:
total 116
-rw-r--r-- 1 root root 425 Nov  1  2014 postgres_2014-11-01.November.postgres.sql.gz
-rw-r--r-- 1 root root 425 Dec  1  2014 postgres_2014-12-01.December.postgres.sql.gz
-rw-r--r-- 1 root root 424 Jan  1  2015 postgres_2015-01-01.January.postgres.sql.gz
-rw-r--r-- 1 root root 425 Feb  1  2015 postgres_2015-02-01.February.postgres.sql.gz
-rw-r--r-- 1 root root 422 Mar  1  2015 postgres_2015-03-01.March.postgres.sql.gz
-rw-r--r-- 1 root root 422 Apr  1  2015 postgres_2015-04-01.April.postgres.sql.gz
-rw-r--r-- 1 root root 420 May  1  2015 postgres_2015-05-01.May.postgres.sql.gz
-rw-r--r-- 1 root root 421 Jun  1  2015 postgres_2015-06-01.June.postgres.sql.gz
-rw-r--r-- 1 root root 421 Jul  1  2015 postgres_2015-07-01.July.postgres.sql.gz
-rw-r--r-- 1 root root 423 Aug  1  2015 postgres_2015-08-01.August.postgres.sql.gz
-rw-r--r-- 1 root root 426 Sep  1  2015 postgres_2015-09-01.September.postgres.sql.gz
-rw-r--r-- 1 root root 424 Oct  1  2015 postgres_2015-10-01.October.postgres.sql.gz
-rw-r--r-- 1 root root 425 Nov  1  2015 postgres_2015-11-01.November.postgres.sql.gz
-rw-r--r-- 1 root root 425 Dec  1  2015 postgres_2015-12-01.December.postgres.sql.gz
-rw-r--r-- 1 root root 424 Jan  1  2016 postgres_2016-01-01.January.postgres.sql.gz
-rw-r--r-- 1 root root 425 Feb  1  2016 postgres_2016-02-01.February.postgres.sql.gz
-rw-r--r-- 1 root root 422 Mar  1  2016 postgres_2016-03-01.March.postgres.sql.gz
-rw-r--r-- 1 root root 422 Apr  1  2016 postgres_2016-04-01.April.postgres.sql.gz
-rw-r--r-- 1 root root 420 May  1  2016 postgres_2016-05-01.May.postgres.sql.gz
-rw-r--r-- 1 root root 421 Jun  1  2016 postgres_2016-06-01.June.postgres.sql.gz
-rw-r--r-- 1 root root 421 Jul  1  2016 postgres_2016-07-01.July.postgres.sql.gz
-rw-r--r-- 1 root root 423 Aug  1  2016 postgres_2016-08-01.August.postgres.sql.gz
-rw-r--r-- 1 root root 426 Sep  1  2016 postgres_2016-09-01.September.postgres.sql.gz
-rw-r--r-- 1 root root 424 Oct  1 08:00 postgres_2016-10-01.October.postgres.sql.gz
-rw-r--r-- 1 root root 425 Nov  1 08:00 postgres_2016-11-01.November.postgres.sql.gz
-rw-r--r-- 1 root root 425 Dec  1 08:00 postgres_2016-12-01.December.postgres.sql.gz
-rw-r--r-- 1 root root 424 Jan  1 07:00 postgres_2017-01-01.January.postgres.sql.gz
-rw-r--r-- 1 root root 425 Feb  1 07:00 postgres_2017-02-01.February.postgres.sql.gz
-rw-r--r-- 1 root root 422 Mar  1 07:00 postgres_2017-03-01.March.postgres.sql.gz

/store/backups/postgresql/monthly/template1:
total 116
-rw-r--r-- 1 root root 462 Nov  1  2014 template1_2014-11-01.November.template1.sql.gz
-rw-r--r-- 1 root root 462 Dec  1  2014 template1_2014-12-01.December.template1.sql.gz
-rw-r--r-- 1 root root 461 Jan  1  2015 template1_2015-01-01.January.template1.sql.gz
-rw-r--r-- 1 root root 462 Feb  1  2015 template1_2015-02-01.February.template1.sql.gz
-rw-r--r-- 1 root root 459 Mar  1  2015 template1_2015-03-01.March.template1.sql.gz
-rw-r--r-- 1 root root 459 Apr  1  2015 template1_2015-04-01.April.template1.sql.gz
-rw-r--r-- 1 root root 457 May  1  2015 template1_2015-05-01.May.template1.sql.gz
-rw-r--r-- 1 root root 458 Jun  1  2015 template1_2015-06-01.June.template1.sql.gz
-rw-r--r-- 1 root root 458 Jul  1  2015 template1_2015-07-01.July.template1.sql.gz
-rw-r--r-- 1 root root 460 Aug  1  2015 template1_2015-08-01.August.template1.sql.gz
-rw-r--r-- 1 root root 463 Sep  1  2015 template1_2015-09-01.September.template1.sql.gz
-rw-r--r-- 1 root root 461 Oct  1  2015 template1_2015-10-01.October.template1.sql.gz
-rw-r--r-- 1 root root 462 Nov  1  2015 template1_2015-11-01.November.template1.sql.gz
-rw-r--r-- 1 root root 462 Dec  1  2015 template1_2015-12-01.December.template1.sql.gz
-rw-r--r-- 1 root root 461 Jan  1  2016 template1_2016-01-01.January.template1.sql.gz
-rw-r--r-- 1 root root 462 Feb  1  2016 template1_2016-02-01.February.template1.sql.gz
-rw-r--r-- 1 root root 459 Mar  1  2016 template1_2016-03-01.March.template1.sql.gz
-rw-r--r-- 1 root root 459 Apr  1  2016 template1_2016-04-01.April.template1.sql.gz
-rw-r--r-- 1 root root 457 May  1  2016 template1_2016-05-01.May.template1.sql.gz
-rw-r--r-- 1 root root 458 Jun  1  2016 template1_2016-06-01.June.template1.sql.gz
-rw-r--r-- 1 root root 458 Jul  1  2016 template1_2016-07-01.July.template1.sql.gz
-rw-r--r-- 1 root root 460 Aug  1  2016 template1_2016-08-01.August.template1.sql.gz
-rw-r--r-- 1 root root 463 Sep  1  2016 template1_2016-09-01.September.template1.sql.gz
-rw-r--r-- 1 root root 461 Oct  1 08:00 template1_2016-10-01.October.template1.sql.gz
-rw-r--r-- 1 root root 462 Nov  1 08:00 template1_2016-11-01.November.template1.sql.gz
-rw-r--r-- 1 root root 462 Dec  1 08:00 template1_2016-12-01.December.template1.sql.gz
-rw-r--r-- 1 root root 461 Jan  1 07:00 template1_2017-01-01.January.template1.sql.gz
-rw-r--r-- 1 root root 462 Feb  1 07:00 template1_2017-02-01.February.template1.sql.gz
-rw-r--r-- 1 root root 459 Mar  1 07:00 template1_2017-03-01.March.template1.sql.gz

/store/backups/postgresql/weekly/nagiosxi:
total 3344
-rw-r--r-- 1 root root 1369132 Feb  4 07:00 nagiosxi_week.05.2017-02-04.sql.gz
-rw-r--r-- 1 root root  341763 Feb 11 07:00 nagiosxi_week.06.2017-02-11.sql.gz
-rw-r--r-- 1 root root  351638 Feb 18 07:00 nagiosxi_week.07.2017-02-18.sql.gz
-rw-r--r-- 1 root root  338345 Feb 25 07:00 nagiosxi_week.08.2017-02-25.sql.gz
-rw-r--r-- 1 root root  368425 Mar  4 07:00 nagiosxi_week.09.2017-03-04.sql.gz
-rw-r--r-- 1 root root  312094 Sep  3  2016 nagiosxi_week.35.2016-09-03.sql.gz
-rw-r--r-- 1 root root  330365 Dec  3 08:00 nagiosxi_week.48.2016-12-03.sql.gz

/store/backups/postgresql/weekly/postgres:
total 28
-rw-r--r-- 1 root root 415 Feb  4 07:00 postgres_week.05.2017-02-04.sql.gz
-rw-r--r-- 1 root root 415 Feb 11 07:00 postgres_week.06.2017-02-11.sql.gz
-rw-r--r-- 1 root root 415 Feb 18 07:00 postgres_week.07.2017-02-18.sql.gz
-rw-r--r-- 1 root root 415 Feb 25 07:00 postgres_week.08.2017-02-25.sql.gz
-rw-r--r-- 1 root root 415 Mar  4 07:00 postgres_week.09.2017-03-04.sql.gz
-rw-r--r-- 1 root root 415 Sep  3  2016 postgres_week.35.2016-09-03.sql.gz
-rw-r--r-- 1 root root 415 Dec  3 08:00 postgres_week.48.2016-12-03.sql.gz

/store/backups/postgresql/weekly/template1:
total 28
-rw-r--r-- 1 root root 451 Feb  4 07:00 template1_week.05.2017-02-04.sql.gz
-rw-r--r-- 1 root root 451 Feb 11 07:00 template1_week.06.2017-02-11.sql.gz
-rw-r--r-- 1 root root 451 Feb 18 07:00 template1_week.07.2017-02-18.sql.gz
-rw-r--r-- 1 root root 451 Feb 25 07:00 template1_week.08.2017-02-25.sql.gz
-rw-r--r-- 1 root root 451 Mar  4 07:00 template1_week.09.2017-03-04.sql.gz
-rw-r--r-- 1 root root 451 Sep  3  2016 template1_week.35.2016-09-03.sql.gz
-rw-r--r-- 1 root root 451 Dec  3 08:00 template1_week.48.2016-12-03.sql.gz

Re: Some Dashboards disappeared?

Posted: Wed Mar 08, 2017 3:38 pm
by ssax
We should be able to pull the old dashboards from one of these files from a day that you know it was working:

Code: Select all

    /store/backups/postgresql/daily/nagiosxi:
    total 2020
    -rw-r--r-- 1 root root 345309 Mar  2 07:00 nagiosxi_2017-03-02.Thursday.sql.gz
    -rw-r--r-- 1 root root 338199 Mar  3 07:00 nagiosxi_2017-03-03.Friday.sql.gz
    -rw-r--r-- 1 root root 340648 Mar  5 07:00 nagiosxi_2017-03-05.Sunday.sql.gz
    -rw-r--r-- 1 root root 347035 Mar  6 07:00 nagiosxi_2017-03-06.Monday.sql.gz
    -rw-r--r-- 1 root root 342085 Mar  7 07:00 nagiosxi_2017-03-07.Tuesday.sql.gz
    -rw-r--r-- 1 root root 343241 Mar  8 07:00 nagiosxi_2017-03-08.Wednesday.sql.gz

    /store/backups/postgresql/monthly/nagiosxi:
    total 7800
    -rw-r--r-- 1 root root  18711 Nov  1  2014 nagiosxi_2014-11-01.November.nagiosxi.sql.gz
    -rw-r--r-- 1 root root  44075 Dec  1  2014 nagiosxi_2014-12-01.December.nagiosxi.sql.gz
    -rw-r--r-- 1 root root  94691 Jan  1  2015 nagiosxi_2015-01-01.January.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 191096 Feb  1  2015 nagiosxi_2015-02-01.February.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 176023 Mar  1  2015 nagiosxi_2015-03-01.March.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 291345 Apr  1  2015 nagiosxi_2015-04-01.April.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 265528 May  1  2015 nagiosxi_2015-05-01.May.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 239582 Jun  1  2015 nagiosxi_2015-06-01.June.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 240302 Jul  1  2015 nagiosxi_2015-07-01.July.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 234476 Aug  1  2015 nagiosxi_2015-08-01.August.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 374674 Sep  1  2015 nagiosxi_2015-09-01.September.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 214758 Oct  1  2015 nagiosxi_2015-10-01.October.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 266042 Nov  1  2015 nagiosxi_2015-11-01.November.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 234322 Dec  1  2015 nagiosxi_2015-12-01.December.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 328028 Jan  1  2016 nagiosxi_2016-01-01.January.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 296472 Feb  1  2016 nagiosxi_2016-02-01.February.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 339168 Mar  1  2016 nagiosxi_2016-03-01.March.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 312985 Apr  1  2016 nagiosxi_2016-04-01.April.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 330087 May  1  2016 nagiosxi_2016-05-01.May.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 421085 Jun  1  2016 nagiosxi_2016-06-01.June.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 321984 Jul  1  2016 nagiosxi_2016-07-01.July.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 311840 Aug  1  2016 nagiosxi_2016-08-01.August.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 325296 Sep  1  2016 nagiosxi_2016-09-01.September.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 320140 Oct  1 08:00 nagiosxi_2016-10-01.October.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 337783 Nov  1 08:00 nagiosxi_2016-11-01.November.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 344945 Dec  1 08:00 nagiosxi_2016-12-01.December.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 331124 Jan  1 07:00 nagiosxi_2017-01-01.January.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 356839 Feb  1 07:00 nagiosxi_2017-02-01.February.nagiosxi.sql.gz
    -rw-r--r-- 1 root root 360610 Mar  1 07:00 nagiosxi_2017-03-01.March.nagiosxi.sql.gz

    /store/backups/postgresql/weekly/nagiosxi:
    total 3344
    -rw-r--r-- 1 root root 1369132 Feb  4 07:00 nagiosxi_week.05.2017-02-04.sql.gz
    -rw-r--r-- 1 root root  341763 Feb 11 07:00 nagiosxi_week.06.2017-02-11.sql.gz
    -rw-r--r-- 1 root root  351638 Feb 18 07:00 nagiosxi_week.07.2017-02-18.sql.gz
    -rw-r--r-- 1 root root  338345 Feb 25 07:00 nagiosxi_week.08.2017-02-25.sql.gz
    -rw-r--r-- 1 root root  368425 Mar  4 07:00 nagiosxi_week.09.2017-03-04.sql.gz
    -rw-r--r-- 1 root root  312094 Sep  3  2016 nagiosxi_week.35.2016-09-03.sql.gz
    -rw-r--r-- 1 root root  330365 Dec  3 08:00 nagiosxi_week.48.2016-12-03.sql.gz
We'd need to replace the current data with what the user current had from the backup files though, so it would erase what he's done since (or we can create a different user and then just change the data to attach it to the new user so you could deploy from them, etc).

What would you like to do?

Re: Some Dashboards disappeared?

Posted: Thu Mar 09, 2017 11:35 am
by GhostRider2110
I would not mind reloading to a different user.

Re: Some Dashboards disappeared?

Posted: Thu Mar 09, 2017 2:48 pm
by mcapra
Can you send over one of those monthly postgresql backups that you think has the dashboards? I would imagine the February or January one should be good.

If the files are particularly big, you could open a support ticket with [email protected] and email them as an attachment.

Re: Some Dashboards disappeared?

Posted: Thu Mar 09, 2017 3:20 pm
by GhostRider2110
I'm attaching two of the weekly. One from Feb 4 and one from Feb 25. I would think that the Feb 25 one would have that in there. The reason I am sending in two of them is the fact that the one from Feb 4 is much bigger than any since. I'm not sure why that would be.

Re: Some Dashboards disappeared?

Posted: Fri Mar 10, 2017 1:54 pm
by mcapra
Here's what you can try: create a dummy user via the Nagios XI interface called dummy.user. After that, download the SQL attached to this post and run it like so:

Code: Select all

psql -U postgres -d nagiosxi -a -f /path/to/42742_recover_dash.sql
That's probably your best bet at recovering the dashboards to dummy.user. Then you should be able to redeploy them via dummy.user.
All times are UTC-05:00
Page 2 of 2

Powered by phpBB® Forum Software © phpBB Limited