One thing to note is that column names are a little wonky (missing labels). There are blank entries where things like the icon goes, etc. In case that was the issue, I narrowed it down to 'just' the host name...but alas still no luck. :(
[cid:[email protected]] From: Jason Copeland Sent: Tuesday, July 19, 2011 7:51 PM To: '[email protected]' Subject: RE: [icinga-users] Icinga-web blank result window I turned the icigna-api logging on full, and I see: 2011-07-20T02:39:42+00:00 - [DEBUG] Creating new interface IcingaApiSearchIdoMysql 2011-07-20T02:39:42+00:00 - [DEBUG] Requesting target: host 2011-07-20T02:39:42+00:00 - [DEBUG] Retrieved filter appendix : 2011-07-20T02:39:42+00:00 - [DEBUG] QUERY (IcingaApiSearchIdoMysql) : select distinct h.icon_image AS HOST_ICON_IMAGE,i.instance_name AS INSTANCE_NAME,oh.object_id AS HOST_OBJECT_ID,oh.name1 AS HOST_NAME,h.alias AS HOST_ALIAS,h.display_name AS HOST_DISPLAY_NAME,hs.current_state AS HOST_CURRENT_STATE,hs.last_check AS HOST_LAST_CHECK,hs.last_state_change AS HOST_LAST_STATE_CHANGE,hs.current_check_attempt AS HOST_CURRENT_CHECK_ATTEMPT,hs.output AS HOST_OUTPUT,hs.max_check_attempts AS HOST_MAX_CHECK_ATTEMPTS,h.instance_id AS HOST_INSTANCE_ID,(hs.has_been_checked-hs.should_be_scheduled)*-1>0 AS HOST_IS_PENDING from icinga_objects oh inner join icinga_hosts h on h.host_object_id = oh.object_id inner join icinga_hoststatus hs on hs.host_object_id = oh.object_id inner join icinga_instances i on i.instance_id = h.instance_id where oh.objecttype_id = 1 and h.config_type=1 order by oh.name1 ASC,hs.last_check DESC limit 0,30 So that looks okay, I don't really see any unusual characters which would result in an escaping bug. Also note that: http://localhost/icinga-web/web/api/host_status_summary/filter[AND(HOST_NAME|=|localhost)]/columns[HOST_STATE|HOST_NAME|HOST_LAST_CHECK]/json<http://localhost/icinga-web/web/api/host_status_summary/filter%5bAND(HOST_NAME|=|localhost)%5d/columns%5bHOST_STATE|HOST_NAME|HOST_LAST_CHECK%5d/json> When putting in a valid hostname on my system results in actual real data. Putting in the same filter in the HostStatus Cronk didn't help though. :(
<<inline: image001.jpg>>
------------------------------------------------------------------------------ 10 Tips for Better Web Security Learn 10 ways to better secure your business today. Topics covered include: Web security, SSL, hacker attacks & Denial of Service (DoS), private keys, security Microsoft Exchange, secure Instant Messaging, and much more. http://www.accelacomm.com/jaw/sfnl/114/51426210/
_______________________________________________ icinga-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/icinga-users
