Re: [Nagios-db-devel] mysql module added

[Matthew K. <mk...@ma...>]

On Thu, 2005-01-06 at 14:56, Ben wrote:
> Cool. I'll see if maybe I can't find a better hack than inserting a 
> timed event. Quite frankly, even doing the work twice doesn't bother me 
> so much, though maybe I'm just saying that because my database fits in 
> ram and it only takes 30 seconds or so to start up. :)
> 

Well I'm not inserting a timed event so much as registering for a
callback from the first one to be added. 

> Maybe I'm blind, but when I pulled new files from CVS I didn't see 
> anything for the UI. I also don't see any views in the schema that 
> would support the current UI. Did you forget to check something in?
> 

No you didn't. I haven't begun work on the UI since it's going to
require some pretty lengthy changes to abstract between the two
databases properly. I'll start in on it tonight. 

Of course it wouldn't be so bad if MySQL 4.1 wasn't lacking so many
features compared to postgres, but I can't do much about that.

Since the changes are pretty long I'll wait until I'm finished and go
over the changes with you before I bother checking anything in.

- Matt

> On Jan 5, 2005, at 6:02 PM, Matthew Kent wrote:
> 
> > I've sent up my initial attempt at a mysql version of the postgres
> > module. It's reasonably complete, meaning it does all the things the
> > postgres module does (although in a far less pretty way) with an
> > identical table structure.
> >
> > Also regarding the issue with retention data, it turns out I was wrong,
> > NEBCALLBACK_PROCESS_DATA is called before the data is loaded from the
> > rentention file into memory resulting in that 'loading the data twice
> > problem' I mentioned.
> >
> > The solution I found was to register NEBCALLBACK_TIMED_EVENT_DATA for a
> > one off call to 'loadconfig' (formerly processStart). Timed events
> > aren't scheduled until after the retention file is loaded. It's kinda
> > hackish but works. Once loadconfig is hit I loop through the host and
> > service lists sending the data to processStatus.
> >
> > Excuse me if I didn't explain this well, hopefully my code will.
> > -- 
> > Matthew Kent <mk...@ma...>
> > http://magoazul.com
> >
> >
> >
> > -------------------------------------------------------
> > The SF.Net email is sponsored by: Beat the post-holiday blues
> > Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
> > It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
> > _______________________________________________
> > Nagios-db-devel mailing list
> > Nag...@li...
> > https://lists.sourceforge.net/lists/listinfo/nagios-db-devel
> 
> 
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by: Beat the post-holiday blues
> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
> _______________________________________________
> Nagios-db-devel mailing list
> Nag...@li...
> https://lists.sourceforge.net/lists/listinfo/nagios-db-devel