nagios with mysql

[Giorgio Zarrelli]

Hi,

it seems a bit beyond his needs :-)

Then, from your words it seems that in Opsview you attached a CMDB to
Nagios. Is it so? Could be interesting, lots.


Giorgio

<quota chi="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
>
> ------------------------------------------------------------------------------
> 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_______________________________________________
> 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



------------------------------------------------------------------------------
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
_______________________________________________
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