[Nagios-db-devel] UI SQL error & path issue

[Tim V. <dj...@ro...>]

Gents,

I've finaly got my NEB module working, so I had a chance to play with the 
UI. It looks very nice and seems to be a good base to add things I need 
for our environment. So once again thanks for great work you already have 
done.

But ofcourse being me I had to run into some sort of trouble :-) The first 
thing is this SQL error with the availability reports. (I'm using pgsql)

Critical error follows:
select coalesce(hostgroup.alias,'[no group]') as 
hostgroup,shgs.hostname,soft_state,round((duration::float/totaltime)::numeric,5) 
as percent from hostgroup,summarize_grouped_host_states_by_hostgroup(
null,null,'{18}') shgs where shgs.groupid = hostgroup.id and 
shgs.configured = TRUE order by name,hostname [nativecode=ERROR: missing 
.. at end of SQL expression]

The error (between the [] brackets) is always the same but ofcourse the 
actual select statement changes a bit for the 4 different availability 
reports.

Since I'm not a hero with SQL and don't know pgsql at all I'm a bit lost 
here. Any ideas ?

The second issue are the paths used by the html code. They seems to start 
with /neb/. Since I just made a alias in my httpd.conf to what comes out 
of CVS this doesn't really work. So my I offer 2 suggestions to fix this ?

First is to make the prefix a config option. This addes some more php code 
inbetween the html code but keeps the absolute paths.
Second is to change all path to the relative system. (That is what I did 
as a quick fix to get it working) The problem is ofcourse that it is not a 
clear system when you have many levels.

I'm more than happy to implement either solution, or let me know if I mist 
another solution.

Kind regards,
Tim

--
Tim Verhoeven - dj...@ro... - 0479 / 88 11 83

/* This is total bullshit: */
         linux-2.6.6/drivers/video/sis/init301.c