connecting to the nagios databases with 3rd party tools

[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.

[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...