<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>On 21 Apr 2011, at 08:32, Marco Borsani wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div lang="IT" link="blue" vlink="purple"><div class="WordSection1" style="page: WordSection1; "><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; ">I am using Nagios since 2004 with all the configuration in the text files.</div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB">Now, I’d like using mysql DB.<o:p></o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB"><o:p> </o:p></span></div><div style="margin-top: 0cm; margin-right: 0cm; margin-bottom: 0.0001pt; margin-left: 0cm; font-size: 11pt; font-family: Calibri, sans-serif; "><span lang="EN-GB">I do not need a migration procedure, I just need to understand how to configure a Nagios to start with mysql DB.</span></div></div></div></span></blockquote><div><br></div>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 (<a href="http://opsview.com">http://opsview.com</a>)</div><div><br></div><div>We model the data in the "proper" way (<a href="http://labs.opsview.com/2011/04/managing-security-permissions-for-large-teams-in-opsview/">http://labs.opsview.com/2011/04/managing-security-permissions-for-large-teams-in-opsview/</a>) and then we generate the nagios configuration files appropriately, with distributed monitoring thrown in for free.</div><div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>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 (<a href="http://docs.opsview.com/doku.php?id=opsview-community:restapi">http://docs.opsview.com/doku.php?id=opsview-community:restapi</a>) to update Opsview. All this is much easier by abstracting the Nagios specific information away.</div><div><br></div><div>Ton</div><div><br></div></body></html>