[Nagios-db-devel] UI SQL error & path issue
Status: Beta
Brought to you by:
bench23
|
From: Tim V. <dj...@ro...> - 2005-01-24 21:42:58
|
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
|