SUPPORT FOR CONFIGURING NAGIOS WITH MYSQL DATABASETO STORE LOGAND DATA IN MYSQL

[Edgar Matzinger]

Hi Sanjeeb,

you wrote:
> Thanks for the response.Let me Describe what is my 
> requirement  we have Nagios configured in one server with 
> apache where it is not able to store all datas(Means if we 
> want to gather last 1 year's data for KPI  we are not able to 
> do same).

You can do this with ndo2db. With this tool data can be stored
on a different server than the one nagios is running on.

> So my management decided to configure Nagios with 
> Mysql to store all information and can retrive all 
> information from url when ever they require it.

If you need it for reporting purposes only, use ndo2db. There
are probably some reporting tools available which can translate
the contents of the NDO database into a report. Otherwise you could
use a generic BI tool to generate such reports. Start with checking
the tables nagios_checkhosts and nagios_checkservices. A short
search didn't reveal any out-of-the-box solutions.... :-(

> So please advice what steps and what I will follow to 
> implement the same .Do you have any specific document for 
> same then please help me .

I don't have any experience with reporting from nagios. I do use
ndo2db for nagvis.

Sorry, cu l8r, Edgar.
-- 
    |\  /| :                                : Addr: Valid Eindhoven B.V.
 /  | \/ | :     Edgar R. Matzinger         :       t.a.v. E.R.
Matzinger
/   |    | :                                :       Paradijslaan 36
\  /|  /\| :                                :       5611 KN Eindhoven
 \/   /  \ :     Valid Eindhoven BV         :
  \  /\  / :                                :
   \/ |\/  :                                :
      |    :                                :
Disclaimer: Any comments, opinions made are mine, etc ... 

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
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