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

[Ben <be...@si...>]

On Mon, 24 Jan 2005, Tim Verhoeven wrote:

> 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.

Well, I'm glad to hear that it's useful to more than just me.

> 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]

So, I tried to run this in psql and had no problem. I haven't had a 
problem with the page generation, either. I assume you get the same error 
if you copy that SQL and run it in psql?

> 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 ?

Yeah, this was an ugly hack because I'm lazy. It sounds like Matthew 
already has a fix up his sleeve.