Nagios with MySQL

[Marc Powell]

Nagios only maintains current data in the database. All historical data
is kept in nagios.log and the archives of nagios.log.

I don't know if mysql supports triggers but you could write a procedure
to copy the data to a history table on insert or update (we've done this
with postgresql).

--
Marc

> -----Original Message-----
> From: crsurf [mailto:crsurf at terra.com.br]
> Sent: Monday, September 29, 2003 10:33 AM
> To: nagios-users
> 
>  Hello All
> 
> I'm using nagios with mysql to store status on database for create
> custom reports, the problem is that I only found in my database the
> latest data. I have 84 services registered at my nagios server and
> when i make a select * from servicestatus; or select * from
> serviceretention; this return only 84 rows.
> How can I obtain the historical data from my services in MySQL?
> It's possible? Or nagios only register the latest status on MySQL?
> 
> Tks
> 
> Cristiano
> 
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> 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


-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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