Page 1 of 1
connecting to the nagios databases with 3rd party tools
Posted: Wed Jan 25, 2012 1:43 pm
by jon.bilderback
I am looking to run reports in Crystal Reports, or possibly Access, and need to get to the nagios databases.
Is there a guide for this? If not, could someone please let me know the steps required?
Thanks.
Re: connecting to the nagios databases with 3rd party tools
Posted: Wed Jan 25, 2012 2:16 pm
by scottwilkerson
Nagios XI uses three different databases, as well as performance data being written to text files, it really depends on what data you need....
1 Postgresql DB (doubt you need info from here, but maybe)
------------------
DB Name = nagiosxi
2 MySQL DB's
----------------------
nagios
nagiosql
Default root password for all 3 would have been nagiosxi
As for accessing this remotely from Crystal Reports, I know for sure you would need to add/modify a mysql user account to allow access from something other than localhost.
*********************
* BETTER OPTION
*********************
Depending on what data you need, have you looked at the
backendapi component? This will give you a ton of data in XML, without opening the database permissions...