Hi again,
I guess I found the answer to my question.

I fiddled around with SQL and this query (for future reference):

select pt.name,r.title,r.restype,s.filename,r.line,h.name 
from puppet_tags as pt, resource_tags as rt,
        resources as r, hosts as h, source_files as s 
where s.id = r.source_file_id AND pt.id = rt.puppet_tag_id AND 
        rt.resource_id = r.id AND h.id = r.host_id AND 
        h.name like 'dvm01%' AND pt.name = "sge";

gives me all resources tagged with "sge" for hostnames that start with dvm01

This shows me that indeed my service check (for nagios) for exechosts is tagged 
with sge.
I have a class called 'sge', it seems that this adds the tag to the nagios 
definition.

Sorry for waking up the giants ;)

Have a nice day,
udo.

On 30.01.2011, at 10:17, Udo Waechter wrote:

> Hi all,
> I have a rather strange problem, and I can not really find out how to solve 
> it.
> 
> I have my nagios .cfg files exported to my nagios host.
> Most of the nagios-monitored hosts export these with tag=nagios, nagios-hsot 
> imports those with 
> File <<| tag == "nagios" |>>
> 
> On another host, the Sun GridEngine master, i import files with 
> configurations for the grid. These files are exported by my GridEngine 
> clients with tag = "sge", gridmaster does "File <<| tag == "sge" |>> to 
> import them.
> 
> The problem is now, that on the gridmaster also some of the nagios-check do 
> get imported. By only those from those clients who have the gridengine 
> execution host running. those have a nagios check for the open sge port.
> 
> I have double checked all classes involved in this problem, naturally one 
> might think that the nagios-check for the exec-port also has tag sge. But it 
> has not. At least not that I can see it ;)
> 
> My question: how can I debug this further. Does someone have a db-query to 
> check which resources are tagged with what?
> Is there another way to debug exported resources?
> 
> It is really annoying, cause now I have to either remove the service 
> dependency in my nagios checks or configuration of the computing grid won't 
> work.
> 
> Thank you very much,
> udo.
> 
> -- 
> ---[ Institute of Cognitive Science @ University of Osnabrueck
> ---[ Albrechtstrasse 28, D-49076 Osnabrueck, 969-3362
> ---[ Documentation: https://doc.ikw.uni-osnabrueck.de
> 
> 
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "Puppet Developers" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to 
> [email protected].
> For more options, visit this group at 
> http://groups.google.com/group/puppet-dev?hl=en.
> 

-- 
:: udo waechter - [email protected] :: N 52º16'30.5" E 8º3'10.1"
:: genuine input for your ears: http://auriculabovinari.de 
::                          your eyes: http://ezag.zoide.net
::                          your brain: http://zoide.net




-- 
You received this message because you are subscribed to the Google Groups 
"Puppet Developers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/puppet-dev?hl=en.

Reply via email to