Page 1 of 1
Exporting Dashboards
Posted: Wed Jan 17, 2018 10:03 am
by blariv
Hi,
built a latest version nagiosXI server. I have exported everything over but cant figure out if I can export the custom dashboards we created, any ideas?
Thanks!
Re: Exporting Dashboards
Posted: Wed Jan 17, 2018 10:34 am
by npolovenko
Hello,
@blariv. Did you use a backup-restore to transfer everything over to the new server? Or did you manually export the configuration files?
https://assets.nagios.com/downloads/nag ... ios-XI.pdf
Re: Exporting Dashboards
Posted: Thu Jan 18, 2018 8:12 am
by blariv
I had to do it manually since I went from 2012 to the latest version
Re: Exporting Dashboards
Posted: Thu Jan 18, 2018 12:41 pm
by npolovenko
@blariv, There's no easy way to do this since all dashboards information is stored in the database. So, technically you could dump the database tables and entries from the old system and then reinsert them into the new one. But there's no guarantee that the table structure stayed the same in the new XI. So you risk damaging your new XI database. Here's the MYSQL query to extract the dashboard information from the database:
Code: Select all
echo "select * from xi_usermeta where keyname = 'dashboards';" | mysql -uroot -pnagiosxi nagiosxi
Re: Exporting Dashboards
Posted: Mon Jan 22, 2018 4:35 pm
by blariv
that is not working on the old system.
what are people doing other than recreating all their dashboards?
[root@nagiosxi ~]# echo "select * from xi_usermeta where keyname = 'dashboards';" | mysql -uroot -pnagiosxi nagiosxi
ERROR 1049 (42000): Unknown database 'nagiosxi'
Re: Exporting Dashboards
Posted: Tue Jan 23, 2018 10:20 am
by tgriep
The old system is probably using the Postgress database so you would have to use this command instead.
Code: Select all
echo "select * from xi_usermeta where keyname = 'dashboards';" | psql nagiosxi nagiosxi
Re: Exporting Dashboards
Posted: Thu Jan 25, 2018 12:36 pm
by blariv
thanks for all the help, you can close this