Hi,

Some time back I wrote a question about the ability to call custom
variables in the xml extensions. I was able to call standard ones like
host_name but not any custom variables that had been configured. I was
advised that Icinga-Web 1.7 would introduce this functionality which was
great news.

So now 1.7 is out and I have finally had the chance to run up a
Core/Web/PNP4Nagios install on a Ubuntu x64 12.04LTS VM. I have migrated my
Icinga, and Web db's to the new machine and all appears to be ok. Now I
have returned to the task of getting normal variables and custom variables
to be returned by my extensions in the xml/extensions folder. I have added
a datasource and fields to provide a escalation information button in the
grid which is all good. When clicked it opens a new tab within web and
builds the built URL eg:

<parameter name="url"><![CDATA[
http://kwok/kwok/kb/article-detail.dll?articleId={host_notes_url}]
]></parameter>

The issue I have is that I can only get just a few variables to be returned
in the URL such as host_name and host_alias. Other standard variables such
as host_notes and host_notes_url do not return anything. The strange this
is that on my previous server running 1.6, this works ok. Of course using
custom variables isn't working either. I have looked at the dev
documentation regarding writing grid views and it says that Web is
interfacing with DQL-View.

How can I go about seeing what variables are available to icinga-web from
DQL? Would this help me determine where the issue is any why just a few
standard variables are being returned, but nothing else?

Any help greatly appreciated.

Thanks
Adam


On Thu, Aug 23, 2012 at 5:32 PM, <icinga-users-requ...@lists.sourceforge.net
> wrote:

> Send icinga-users mailing list submissions to
>         icinga-users@lists.sourceforge.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.sourceforge.net/lists/listinfo/icinga-users
> or, via email, send a message with subject or body 'help' to
>         icinga-users-requ...@lists.sourceforge.net
>
> You can reach the person managing the list at
>         icinga-users-ow...@lists.sourceforge.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of icinga-users digest..."
>
>
> Today's Topics:
>
>    1. Re: High icinga server load - why? (Tomas Macek)
>    2. Hidden icinga-web 1.7.2 bugfix release (Michael Friedrich)
>    3. XenServer (Domnick Eger)
>    4. Re: XenServer (Michael Friedrich)
>    5. IcingaApiModel error after Icinga-web installation (Tal Bar-Or)
>    6. Authorization Error in Icinga (john meyer)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Mon, 20 Aug 2012 12:26:57 +0200 (CEST)
> From: Tomas Macek <ma...@fortech.cz>
> Subject: Re: [icinga-users] High icinga server load - why?
> To: icinga-users@lists.sourceforge.net
> Message-ID: <alpine.lfd.2.02.1208201225230.3...@maca.fortech.cz>
> Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
>
> One more question:
> What Icinga stores on the disk and where? This could be a problem, when
> something
> writes into some file and the file is not rotated, grows up and slows down
> the system.
>
> Tomas
>
>
> On Mon, 20 Aug 2012, Tomas Macek wrote:
>
> > Hello, this (see attachment) is the daily graph made from server, which
> runs
> > the Icinga process only. And this server is other one, than it was in my
> > previous posts - it's some other testing server. The big jump in load at
> 8:00
> > this morning was the Icinga process reload. The next jump at about 10:00
> is
> > the Icinga downgrade from 1.7.1 to 1.6.1 - the difference between 1.6.1
> and
> > 1.7.1 is about 5% in performance.
> > I will see (and let you know) if the server load will grow up.
> >
> > I used absolutely the same configuration files.
> >
> > Hints, comments, ideas are welcome, but now I'm thinking about Icinga
> > downgrade to 1.4.x (I made upgrade to 1.7 due to bugs in notifications.c
> in
> > 1.6.1).
> >
> > Regards, Tomas
> >
> >
> > On Fri, 13 Jul 2012, Tomas Macek wrote:
> >
> >> Hello, my server with Icinga installed has high load. See daily graf in
> >> attachment for details. The lower load from 9:00 today is caused by
> restart
> >> of the Icinga process. It never happened when I used 1.6.1 and from the
> >> update date (18/05/2012) I experience these problems. This problem
> always
> >> disappeares when I restart the Icinga.
> >>
> >> Any ideas?
> >>
> >> These are the steps to restart, but I don't know if this helps... But
> the
> >> strange thing for me is, that there were two icinga processes stopeed
> >>
> >>
> >> [root@server mt_check]# /etc/init.d/icinga stop
> >> icinga (pid 13386 3749) is running...
> >> Stopping icinga:                                           [  OK  ]
> >> [root@server mt_check]# /etc/init.d/icinga start
> >> icinga is stopped
> >> Starting icinga:                                           [  OK  ]
> >> [root@server mt_check]# ps auxw | grep icinga
> >> icinga   13432  1.4  0.0  95316  7552 ?        Ssl  08:43   0:25
> >> /usr/bin/icinga -d /etc/icinga/icinga.cfg
> >> root     19145  0.0  0.0  61216   764 pts/0    S+   09:12   0:00 grep
> >> icinga
> >> icinga   19159  0.0  0.0  95320  6952 ?        S    09:12   0:00
> >> /usr/bin/icinga -d /etc/icinga/icinga.cfg
> >> icinga   19160  0.0  0.0  67504   688 ?        S    09:12   0:00
> >> /usr/lib64/nagios/plugins//check_icmp -w 45.0 19  -c 70.0 25  -p 5
> >> 10.253.1.41
> >> icinga   19162  0.0  0.0  95320  6952 ?        S    09:12   0:00
> >> /usr/bin/icinga -d /etc/icinga/icinga.cfg
> >> icinga   19163  0.0  0.0  67504   684 ?        S    09:12   0:00
> >> /usr/lib64/nagios/plugins//check_icmp -w 45.0 19  -c 70.0 25  -p 5
> >> 10.101.5.9
> >>
> >>
> >> Regards, Tomas
>
>
>
> ------------------------------
>
> Message: 2
> Date: Mon, 20 Aug 2012 16:12:42 +0200
> From: Michael Friedrich <michael.friedr...@gmail.com>
> Subject: [icinga-users] Hidden icinga-web 1.7.2 bugfix release
> To: icinga-users@lists.sourceforge.net
> Message-ID: <503245da.3020...@gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> https://www.icinga.org/2012/08/20/hidden-icinga-web-1-7-2-bugfix-release/
>
> core 1.7.2 will have to wait a bit longer, but you can help test the
> current snapshots here
> http://build.icinga.org/snapshots/icinga-core-r1.7-CURRENT.tar.gz
>
>
> --
> DI (FH) Michael Friedrich
>
> https://twitter.com/dnsmichi
>
> Lead Icinga Core Developer
> https://www.icinga.org
>
>
>
>
> ------------------------------
>
> Message: 3
> Date: Mon, 20 Aug 2012 22:08:18 +0000
> From: Domnick Eger <de...@cobercafe.net>
> Subject: [icinga-users] XenServer
> To: "icinga-users@lists.sourceforge.net"
>         <icinga-users@lists.sourceforge.net>
> Message-ID:
>         <
> 41c166832ce6a341bd1a2d6c6ecd8d954c651...@bl2prd0811mb399.namprd08.prod.outlook.com
> >
>
> Content-Type: text/plain; charset="us-ascii"
>
> Does anyone out there use XenServer and monitor it via Icinga ?, I been
> looking for some basic scripts, but nothing really out there publically.
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 4
> Date: Tue, 21 Aug 2012 00:35:10 +0200
> From: Michael Friedrich <michael.friedr...@gmail.com>
> Subject: Re: [icinga-users] XenServer
> To: icinga-users@lists.sourceforge.net
> Message-ID: <5032bb9e.2030...@gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 21.08.2012 00:08, Domnick Eger wrote:
> >
> > Does anyone out there use XenServer and monitor it via Icinga ?, I
> > been looking for some basic scripts, but nothing really out there
> > publically.
> >
>
> i'm monitoring some xen instances with a variety of plugins found on the
> net. mostly from opsview.
> https://wiki.icinga.org/display/howtos/opsview+plugins
> https://wiki.icinga.org/display/howtos/op5+plugins
>
> other than that, google unveils some check plugins as well. look for
> "check_xen".
>
> >
> >
> >
> ------------------------------------------------------------------------------
> > Live Security Virtual Conference
> > Exclusive live event will cover all the ways today's security and
> > threat landscape has changed and how IT managers can respond. Discussions
> > will include endpoint security, mobile security and the latest in malware
> > threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> >
> >
> > _______________________________________________
> > icinga-users mailing list
> > icinga-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/icinga-users
>
>
> --
> DI (FH) Michael Friedrich
>
> Lead Icinga Core Developer
> https://www.icinga.org
>
>
>
>
> ------------------------------
>
> Message: 5
> Date: Tue, 21 Aug 2012 15:52:27 +0300
> From: Tal Bar-Or <tba...@gmail.com>
> Subject: [icinga-users] IcingaApiModel error after Icinga-web
>         installation
> To: icinga-users@lists.sourceforge.net
> Message-ID:
>         <CAM0M=j0V58E+rQ_fDxhxZ--B9FT-3pjino-uiY=
> jnbhtcfk...@mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi All ,
>
> I just finished Icinga-web(1.7.2)  installation set all setting in
> database.xml according doc , icinga +IdoUtils work OK  i have local machine
> and everything is green
> The issue is when i get into Icinga-Web i get error for evry section i
> choosing and top dashboard is missing, looking into /var/log/icinga-web
> logs i get following error below:
> i don't have such db icinga@localhost user and i don't know where i missed
> configuration
> Please advice.
>
> Thanks
>
> Debug log
>
>
>  [Tue Aug 21 09:39:15 2012] [error] Fetch failed with message PDO
> Connection Error: SQLSTATE[28000] [1045] Access denied for user
> 'icinga'@'localhost'
> (using password: YES)
>  Query: SELECT DISTINCT i2.current_state AS i2__current_state,
> i2.current_state AS i2__0, COUNT(DISTINCT i.host_object_id) AS i__1,
> i2.current_state AS i2__2, (i2.has_been_checked-1)*-1 AS i__3,
> (i2.has_been_checked-1)*-1 AS i__4, COUNT(i2.current_state) AS i2__5,
> COUNT(i2.current_state) AS i2__6 FROM icinga_hosts i INNER JOIN
> icinga_hoststatus i2 ON i.host_object_id = i2.host_object_id INNER JOIN
> icinga_objects i3 ON i.host_object_id = i3.object_id AND (i3.is_active = 1)
> WHERE (i.config_type = ?) GROUP BY i2.current_state, i2.has_been_checked
> TargetStore info (IcingaApiModel):
>                     - Store target: IcingaHosts
>                     - Searchtype:
>
>
> ICINGA-WEB LOG
>
>
>  [Tue Aug 21 09:39:15 2012] [error] Fetch failed with message PDO
> Connection Error: SQLSTATE[28000] [1045] Access denied for user
> 'icinga'@'localhost'
> (using password: YES)
>  Query: SELECT DISTINCT i2.current_state AS i2__current_state,
> i2.current_state AS i2__0, COUNT(DISTINCT i.host_object_id) AS i__1,
> i2.current_state AS i2__2, (i2.has_been_checked-1)*-1 AS i__3,
> (i2.has_been_checked-1)*-1 AS i__4, COUNT(i2.current_state) AS i2__5,
> COUNT(i2.current_state) AS i2__6 FROM icinga_hosts i INNER JOIN
> icinga_hoststatus i2 ON i.host_object_id = i2.host_object_id INNER JOIN
> icinga_objects i3 ON i.host_object_id = i3.object_id AND (i3.is_active = 1)
> WHERE (i.config_type = ?) GROUP BY i2.current_state, i2.has_been_checked
> TargetStore info (IcingaApiModel):
>                     - Store target: IcingaHosts
>                     - Searchtype:
>
>
>
>
>
> --
> Tal Bar-or
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 6
> Date: Thu, 23 Aug 2012 09:33:36 +0200
> From: "john meyer" <firesk...@emailn.de>
> Subject: [icinga-users] Authorization Error in Icinga
> To: icinga-users@lists.sourceforge.net
> Message-ID: <5a45e45fce006d79379b918957e46...@server1.emailn.de>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hello guys
>
> Evironment:
> Ubuntu: 10.04 LTS
> Icinga :Icinga 1.7.1 with omd 0.55
>
>
> I've  set up an Test Icinga System
>
> If i try to got to the Host Detail or Server Detail Menue there comes the
> folowing error:
>
>
> It appears as though you do not have permission to view information for
> any of the services you requested...
> If you believe this is an error, check the HTTP server authentication
> requirements for accessing this CGI and check the authorization options in
> your CGI configuration file.
>
>
> My apache settings are:
>
> # Apache configuration for access to Icinga Classic web GUI:
>
>
> Alias /omd055/icinga/local /omd/sites/omd055/local/share/icinga/htdocs
> <Directory /omd/sites/omd055/local/share/icinga/htdocs>
>       Order deny,allow
>       allow from all
> </Directory>
>
> ScriptAlias /omd055/icinga/cgi-bin /omd/sites/omd055/lib/icinga/cgi-bin
> <Directory /omd/sites/omd055/lib/icinga/cgi-bin>
>   Order allow,deny
>   Allow from all
>   SetEnv ICINGA_CGI_CONFIG "/omd/sites/omd055/etc/icinga/cgi.cfg"
> </Directory>
>
> Alias /omd055/icinga /omd/sites/omd055/share/icinga/htdocs
> <Directory /omd/sites/omd055/share/icinga/htdocs>
>   Order allow,deny
>   Allow from all
>   # Rewrite rules for handling the local-hierarchy. All URI to static
>   # files are redirected, if those exist in local/. Thus the user
>   # even can override shipped static files.
>   RewriteEngine on
>   RewriteCond "/omd/sites/omd055/local/share/icinga/htdocs/$1" "-f"
>   RewriteRule "(.*)" "/omd055/icinga/local/$1"
>
> </Directory>
>
> the apache log doesn't show an error which belongs to this problem.
>
> and the authorization is temporaily disabled
>
>
> regards john s.
>
>
>
>
>
>
>
>
>
>
>
> ------------------------------
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>
> ------------------------------
>
> _______________________________________________
> icinga-users mailing list
> icinga-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/icinga-users
>
>
> End of icinga-users Digest, Vol 40, Issue 9
> *******************************************
>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users

Reply via email to