Re: [Nagios-db-devel] abstraction and mysql support added to ui

[Ben <be...@si...>]

On Tue, 18 Jan 2005, Matthew Kent wrote:

> Well nagios allows for an undefined host check_command and considers
> them permanently up
> (http://nagios.sourceforge.net/docs/2_0/xodtemplate.html#host)

Hey, check that out. 

I'll change the stored proc to do the right thing.

> Also a few changes that I made for the mysql queries didn't make it back
> into postgres quite yet. Need to test them some more.

OK. Out of curiosity, what's in the pipeline?

> > 3. What are the inconsistancies between psql, mysql, and the cigs? Those
> > are likely bugs and should probably have a high priority of getting
> > squashed.
> > 
> 
> Well the most noticeable item for postgres is in the tac overview,
> pending passive checks are totalled properly but not displayed by
> serviceDetails.php when you click the link. 

If I recall, this is because service checks aren't made while a host is 
still pending, and the (postgres) neb module waits until a service check 
is made before writing it down. In other words, if a service is configured 
for a pending host, it will never be populated as "pending". This should 
probably be changed to be more correct, even though it will slow down 
startup time.

> The issue I see with how it currently works is that if you clear out the
> db and wipe the nagios retention.dat, when you go to start nagios up
> from this 'fresh' state the module doesn't insert all the host/services
> on startup. So instead of seeing '800 pending checks' after refreshing
> the mat view you see 5 hosts up/20 service ok/0 pending.

I suppose that is more correct, and doing this will also address the issue 
about serviceDetails.php not showing pending services.
 
> Lastly, I have a nice and simple caching template implementation that
> I'll send up today or tomorrow so I can work on some mockups of the gui
> over the weekend for comment.

I look forward to it. I think I have a good grasp on your database
abstraction layer - despite my post-lunch food coma - to my new php eyes,
it looks pretty clean. Late last week I had added the ability to sort 
serviceDetails.php columns.... I'll merge it in and check in the new files 
later today.