Re: [Nagios-users] Added Blame to availability reports

2009-03-17 Thread Alan Cooper
I've spent an unfathomable amount of time trying to achieve similar. In the end, I installed NDOUtils and built some rough scripts to interogate the database pulling stats based on (for my needs, but it could be altered) hostgroup and working out availability. For stuff that's not my fault, e.g.

[Nagios-users] Sub-views for customers

2009-02-14 Thread Alan Cooper
Hi folks, Is it possible to set up the web interface so that a user can only see certain hosts. I'd like to be able to give a customer a login so they can see information for their hosts, but I don't want them to be able to see any other customers servers - is this possible? Kind Regards

[Nagios-users] ndoutils Query optimisation

2008-08-20 Thread Alan Cooper
I am having problem scaling up a system we use to gather status data from the NDO db: The query I currently use is:- SELECT obj1.name1 AS host_name, nagios_hoststatus.problem_has_been_acknowledged, nagios_hoststatus.scheduled_downtime_depth, nagios_hosts.alias FROM `nagios_hoststatus` LEFT JOIN

Re: [Nagios-users] ndoutils Query optimisation

2008-08-20 Thread Alan Cooper
Thomas Guyot-Sionnest wrote: I'm not a SQL guru, but here's some thing I'd try... You may get better help from SQL/MySQL communities. * Make sure obj1.name1 is indexed (or is a PK) * Make sure every columns in the JOINs are indexed/PKs * Try removing the ORDER BY (i.e. sort it in the

Re: [Nagios-users] unable to connect to data sink

2008-07-14 Thread Alan Cooper
What version of nagios are you running? If you're running nagios 3.x you'll need ndo2db-3x Kaushal Shriyan wrote: Hi I get [1215630364] ndomod: Still unable to connect to data sink. 1019216 items lost, 5000 queued items to flush. in nagios.log file I can see the ndo2db has been started.

Re: [Nagios-users] Nagios 3.0 SLA Reporting

2008-05-27 Thread Alan Cooper
Hi, We had a similar requirement - the quick dirty way we managed to get reports out of Nagios NDO was to write our own DB interogation script in perl (once you have the schema from the docs and a copy of SQLyg, the DB is easy to navigate). To get round the downtime reports for events in

[Nagios-users] Problems starting nagios

2007-12-19 Thread Alan Cooper
Nagios 3.0rc1 on RHEL3 I've RPM'd up this release - I have it working fine on one RHEL3 box, and various other rhel4 boxes without issue, with the same configuration on all boxes. One (and only one) other RHEL3 box is causing me problems - nagios is quietly refusing to start, citing problems

[Nagios-users] Scheduling downtime in the past?

2007-12-01 Thread Alan Cooper
Is there anyway to make Nagios proicess scheduled downtime for times in the past - I'm upgrading from a very old (1.0b3) version to the current RC and also 2.9 with NDOutils and neither of these actually process the downtime - although there the logs show that the external command processed,

Re: [Nagios-users] If anyone is interested...

2007-11-28 Thread Alan Cooper
[EMAIL PROTECTED] wrote: I just whipped up a check for CLAM AV to report on the freshness of the clam-AV signature file. Be happy to post the code for people to improve upon. Hi Jim, That would be fantastic as we are currently relying on people remembering to check Cron output - happy

[Nagios-users] Availability reports Retrospective Scheduled Downtime

2007-10-09 Thread Alan Cooper
than a fault in our service) it doesn't change the report, it still appears as unscheduled downtime. Kind Regards, Alan -- Alan Cooper Lumison T: 0131 514 4033 F: 0845 119 9901 PS. Do you know that we have opened a new datacentre in Croydon? Click https://www.lumison.net/services/pdfs

[Nagios-users] Nagios availability outwith scheduled downtime reporting

2007-07-01 Thread Alan Cooper
I'd like to generate a report of all the hosts and services on my network with downtime that occurred outwith scheduled downtime. The availability report does not quite meet this requirement as, annoyingly, it only seems to exclude periods in downtime on the host detail, not for the hostgroup as