perfSONAR User Q&A and Other Discussion

[Casey Russell <>]

Also,  

I see repeated instances of this in the logs (both when the problem existed, and also now, that the graphs are working normally.  Don't know if it's related or not.

[Wed Sep 04 14:37:42 2013] [error] [client 2001:470:7c:1a2:fcba:46b4:102e:fe38] [Wed Sep  4 14:37:42 2013] owamp.cgi: DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /opt/perfsonar_ps/toolkit/web/root/gui/owamp_jitter/owamp.cgi line 244., referer: http://ps-data.kanren.net/toolkit/

Casey Russell

Network Engineer

Kansas Research and Education Network

1405 Wakarusa Dr., Ste B
Lawrence, KS 66049

(785)856-9820  ext 9809

On Wed, Sep 4, 2013 at 2:44 PM, Casey Russell <> wrote:

Andy, 

Well, as has happened far too often in my 15 year IT career, as soon as I publicly announce a problem, the machine makes me a liar and begins to behave normally.  

This problem existed every time I've tried to load the pages for the last 6 days, but just now when I tried it (to get you log files) the graphs loaded normally.

So here are the logs from earlier this morning when it was failing.  Perhaps if I know why it was failing before, I can fix it myself next time.  

[Wed Sep 04 12:20:09 2013] [error] [client 2001:470:7c:1a2:fcba:46b4:102e:fe38] [Wed Sep  4 12:20:09 2013] owampplot_histogram.cgi: Couldn't run gnuplot at /opt/perfsonar_ps/toolkit/web/root/gui/owamp_jitter/owampplot_histogram.cgi line 408., referer: http://ps-data.kanren.net/toolkit/gui/owamp_jitter/owamp.cgi?name=KANREN_OWAMP_TCP4

[Wed Sep 04 12:20:12 2013] [error] [client 2001:470:7c:1a2:fcba:46b4:102e:fe38] [Wed Sep  4 12:20:12 2013] owampplot_histogram.cgi: Can't exec "gnuplot": No such file or directory at /opt/perfsonar_ps/toolkit/web/root/gui/owamp_jitter/owampplot_histogram.cgi line 408., referer: http://ps-data.kanren.net/toolkit/gui/owamp_jitter/owamp.cgi?name=KANREN_OWAMP_TCP4

[Wed Sep 04 12:20:12 2013] [error] [client 2001:470:7c:1a2:fcba:46b4:102e:fe38] [Wed Sep  4 12:20:12 2013] owampplot_histogram.cgi: Couldn't run gnuplot at /opt/perfsonar_ps/toolkit/web/root/gui/owamp_jitter/owampplot_histogram.cgi line 408., referer: http://ps-data.kanren.net/toolkit/gui/owamp_jitter/owamp.cgi?name=KANREN_OWAMP_TCP4

[Wed Sep 04 12:25:44 2013] [error] [client 2001:470:7c:1a2:fcba:46b4:102e:fe38] [Wed Sep  4 12:25:44 2013] owampplot_histogram.cgi: Can't exec "gnuplot": No such file or directory at /opt/perfsonar_ps/toolkit/web/root/gui/owamp_jitter/owampplot_histogram.cgi line 408., referer: http://ps-data.kanren.net/toolkit/gui/owamp_jitter/owamp.cgi?name=KANREN_OWAMP_TCP4

[Wed Sep 04 12:25:44 2013] [error] [client 2001:470:7c:1a2:fcba:46b4:102e:fe38] [Wed Sep  4 12:25:44 2013] owampplot_histogram.cgi: Couldn't run gnuplot at /opt/perfsonar_ps/toolkit/web/root/gui/owamp_jitter/owampplot_histogram.cgi line 408., referer: http://ps-data.kanren.net/toolkit/gui/owamp_jitter/owamp.cgi?name=KANREN_OWAMP_TCP4

[Wed Sep 04 12:26:18 2013] [error] [client 2001:470:7c:1a2:fcba:46b4:102e:fe38] [Wed Sep  4 12:26:18 2013] owampplot_histogram.cgi: Can't exec "gnuplot": No such file or directory at /opt/perfsonar_ps/toolkit/web/root/gui/owamp_jitter/owampplot_histogram.cgi line 408., referer: http://ps-data.kanren.net/toolkit/gui/owamp_jitter/owamp.cgi?name=KANREN_OWAMP_TCP4

Casey Russell

Network Engineer

Kansas Research and Education Network

1405 Wakarusa Dr., Ste B
Lawrence, KS 66049

(785)856-9820  ext 9809

On Wed, Sep 4, 2013 at 1:43 PM, Andy Lake <> wrote:

Hi Casey,

Could you open the page in question in your browser then then send us /var/log/httpd/error_log? It looks like your host is collecting OWAMP data from browsing the various pages, looks like maybe the CGI script is hitting some type of error. 

Thanks,

Andy