nagios with mysql

[Ton Voon]

On 21 Apr 2011, at 08:32, Marco Borsani wrote:

> I am using Nagios since 2004 with all the configuration in the text files.
>  
> Now, I’d like using mysql DB.
>  
> I do not need a migration procedure, I just need to understand how to configure a Nagios to start with mysql DB.

If you create your own DB to hold all the relationships and information to create the nagios configuration files, you'll end up with Opsview (http://opsview.com)

We model the data in the "proper" way (http://labs.opsview.com/2011/04/managing-security-permissions-for-large-teams-in-opsview/) and then we generate the nagios configuration files appropriately, with distributed monitoring thrown in for free.

NagiosQL is mapping the Nagios configuration files into a sql database, which is okay, but try running queries to tell you what you want to know and you'll end up replicating Nagios' configuration algorithms to get the data you need.

While our demo site doesn't give you access to the mysql db, I'd recommend you download our latest VM and poke around the DB structures. There's an import script so if you supply your Nagios object.dat file, we'll do a good job at importing your information into Opsview's DB.

We've got users that now run DB queries against opsview to give them asset lists. We've got other users that have asset lists external to Opsview, but use the REST API (http://docs.opsview.com/doku.php?id=opsview-community:restapi) to update Opsview. All this is much easier by abstracting the Nagios specific information away.

Ton

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20110421/a393be47/attachment.html>
-------------- next part --------------
------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload 
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve 
application availability and disaster protection. Learn more about boosting 
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
-------------- next part --------------
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null