perfSONAR User Q&A and Other Discussion

[Phil Reese <>]

Hi Andy,

That pointer did clear up the spinning wheel problem but I'm still stuck 
with three systems showing appropriate dashboards, but no results, all 
orange.

Here are links to the pages:
http://srcf-ps.stanford.edu/maddash-webui/index.cgi
http://rcf-ps.stanford.edu/maddash-webui/index.cgi?dashboard=Stanford%20PS%20Sites
http://float10g.stanford.edu/maddash-webui/index.cgi

I'm not sure why that one host, psych-ps, does show values on a single host.

Further thoughts or suggestions?

Phil

On 4/23/14, 6:47 AM, Andrew Lake wrote:
> Hi,
>
> The FAQ here should have the steps you need: 
> http://psps.perfsonar.net/toolkit/FAQs.html#Q71
>
> Thanks,
> Andy
>
>
> On Apr 22, 2014, at 2:34 PM, Phil Reese 
> <>
>  wrote:
>
> > Hi,
> >
> > I'd been using the Dashboard for quite awhile then a disk crash had me 
> > starting from scratch again.
> >
> > Just got back to it and decided I'd just install it on a different, newer 
> > system.
> >
> > I did a yum update for all the perfsonar stuff and then did the yum install 
> > maddash
> >
> > I edited the maddash-server.yaml file as suggested and as I had done in the 
> > past (didn't have a copy of the old file, of course).
> >
> > Started up the process and the Dashboard shows up just fine but all the boxes 
> > are orange and don't seem to change over a couple of hours of time.
> >
> > Thought I must have fat fingered something so went back to the original 
> > system and went through the same steps.  This time the banner appears but 
> > only a spinning wheel showed, for a long time. Looked in the logs and it said:
> > level=INFO ts=2014-02-05T03:56:25.844168Z event=maddash.init.start 
> > guid=775ea81a-7665-4590-b159-00612b5a5b6e
> > level=ERROR ts=2014-02-05T03:56:54.189207Z event=maddash.init.end 
> > guid=775ea81a-7665-4590-b159-00612b5a5b6e status=-1 msg="Error loading database: 
> > Column 'TEMPLATENAME' is either not in any table in the FROM list or appears within a 
> > join specification and is outside the scope of the join specification or appears in a 
> > HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  
> > statement then 'TEMPLATENAME' is not a column in the target table."
> >
> > Is there a way to clean out things and start over?
> >
> > Stilling thinking fat finger issue, I went to my last production PS box and 
> > did the same steps as the first system and got the same results.  The grids 
> > show nicely but all have orange boxes that don't change over time.
> >
> > Suggestions?
> >
> > Phil