perfSONAR User Q&A and Other Discussion

[Andrew Lake <>]

Hi,

You should be able to disable http in apache and listen only on https.

When you click on a box does it load everything except the graph? My best guess is because the graph is using an http URL and the browser doesn't like it when you mix http and https. By default it should be using a relative URL of /perfsonar-graphs/ which should keep things consistent. Have you by chance set graph_url any place (it may be multiple places) in /etc/perfsonar/meshconfig-guiagent.conf? If so, you can delete it or comment it out. You may have to wait for the checks to run again for the change to take effect, so it might not happen right away. If you have not set graph_url, I am not quite sure why it won’t load.

Thanks,

Andy

On April 25, 2017 at 2:59:13 PM, Liu, Dengfeng (NIH/CIT) [C] () wrote:

Thank you Andrew; You are right, the skipTableBuild is set to 1 and after change to 0, working fine.

Another problem is how to disble http and use https exclusively? when I use https, mouse click on the dashboard not working, while working fine when using http.

Dengfeng

---

From: Andrew Lake <>
Sent: Tuesday, April 25, 2017 2:24 PM
To: Liu, Dengfeng (NIH/CIT) [C]; perfsonar-user
Subject: Re: [perfsonar-user] maddash erros

 

Hi,

In, your /etc/maddash/maddash-server/maddash.yaml file do you have “skipTableBuild” set to 0? If so set it to 1 and restart maddash-server. It looks like your database did not get upgraded.

Thanks,

Andy

On April 25, 2017 at 1:39:09 PM, Liu, Dengfeng (NIH/CIT) [C] () wrote:

After upgrade, maddash can not boot with this error, any suggestion?

#######################################################

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
MLog initialization issue: slf4j found no binding or threatened to use its (dangerously silent) NOPLogger. We consider the slf4j library not found.
java.sql.SQLDataException: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Clob'.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.ConnectionChild.newSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.dataTypeConversion(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.checkClobConditions(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setClob(Unknown Source)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setClob(NewProxyPreparedStatement.java:1164)
    at net.es.maddash.ConfigLoader.load(ConfigLoader.java:214)
    at net.es.maddash.MaDDashGlobals.load(MaDDashGlobals.java:297)
    at net.es.maddash.MaDDashGlobals.<init>(MaDDashGlobals.java:188)
    at net.es.maddash.MaDDashGlobals.getInstance(MaDDashGlobals.java:506)
    at net.es.maddash.Invoker.main(Invoker.java:55)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.simontuffs.onejar.Boot.run(Boot.java:340)
    at com.simontuffs.onejar.Boot.main(Boot.java:166)
Caused by: ERROR 22005: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Clob'.
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
    ... 21 more
Initialization error: Error loading database: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Clob'.
java.lang.RuntimeException: Error loading database: An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'java.sql.Clob'.
    at net.es.maddash.ConfigLoader.load(ConfigLoader.java:482)
    at net.es.maddash.MaDDashGlobals.load(MaDDashGlobals.java:297)
    at net.es.maddash.MaDDashGlobals.<init>(MaDDashGlobals.java:188)
    at net.es.maddash.MaDDashGlobals.getInstance(MaDDashGlobals.java:506)
    at net.es.maddash.Invoker.main(Invoker.java:55)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at com.simontuffs.onejar.Boot.run(Boot.java:340)
    at com.simontuffs.onejar.Boot.main(Boot.java:166)