• D
    Dominic.Irl

    Is it possible to read and log data in smaller intervals than 1 second?

    posted in How-To read more
  • D
    Dominic.Irl

    Hi Joel,

    It's more trial and error shifting Mango onto cloud based server at the moment. The two different errors were coming up when trying two different ports for comms. I have port forwarding set up on my router for two devices. I was just wondering why one port got one error and the other port the other error. I have yet to establish communication with the Modbus devices but this is a network issue - nothing to do with Mango as I have found out.

    Rgds,
    Dominic

    posted in User help read more
  • D
    Dominic.Irl

    Could someone enlighten me as to what the following two error messages may mean when polling a modbus TCP/IP data register?

    1.Gateway path unavailable
    2.com.serotonin.modbus4j.exception.ModbusTransportException: java.net.SocketTimeoutException: connect timed out

    Thanks in advance,
    Dominic.IRL

    posted in User help read more
  • D
    Dominic.Irl

    I seem to have overcome this issue by going to
    (start>run>services.msc) and starting the MYSQL instance.

    All seems to be going fine now.

    posted in User help read more
  • D
    Dominic.Irl

    I am encountering an issue with SQL upon initializing Mango. It seems that there is an issue with my " MySQLd.exe and it needs to close". After Mango "initializes " it gives me the following message.

    "System exception!

    The server has experienced an exception processing your last request. The exception has been logged, and system administrators will be notified of this problem. You may continue to use the site. We apologize for the inconvenience"

    Here is an example of the report generated from Mango:::

    
    org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:973)
    	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:769)
    	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1667)
    	at com.serotonin.web.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:37)
    	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
    	at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:83)
    	at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:300)
    	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
    	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
    	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
    	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
    	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
    	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
    	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
    	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
    	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
    	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
    	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
    	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
    	at org.eclipse.jetty.server.Server.handle(Server.java:485)
    	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:290)
    	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
    	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
    	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:606)
    	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:535)
    	at java.lang.Thread.run(Unknown Source)
    Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
    	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:630)
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:727)
    	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:737)
    	at com.serotonin.db.spring.ExtendedJdbcTemplate.queryForObject(ExtendedJdbcTemplate.java:39)
    	at com.serotonin.db.DaoUtils.queryForObject(DaoUtils.java:332)
    	at com.serotonin.m2m2.db.dao.UserDao.getUser(UserDao.java:42)
    	at com.serotonin.m2m2.web.mvc.controller.LoginController.onSubmit(LoginController.java:88)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    	at java.lang.reflect.Method.invoke(Unknown Source)
    	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
    	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
    	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
    	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
    	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
    	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
    	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
    	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
    	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
    	... 29 more
    Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    	at sun.reflect.GeneratedConstructorAccessor33.newInstance(Unknown Source)
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    	at java.lang.reflect.Constructor.newInstance(Unknown Source)
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1121)
    	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:357)
    	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2482)
    	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2519)
    	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2304)
    	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
    	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    	at sun.reflect.GeneratedConstructorAccessor35.newInstance(Unknown Source)
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    	at java.lang.reflect.Constructor.newInstance(Unknown Source)
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)
    	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
    	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
    	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
    	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188)
    	at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
    	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
    	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
    	... 50 more
    Caused by: java.net.ConnectException: Connection refused: connect
    	at java.net.TwoStacksPlainSocketImpl.socketConnect(Native Method)
    	at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
    	at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
    	at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
    	at java.net.PlainSocketImpl.connect(Unknown Source)
    	at java.net.SocksSocketImpl.connect(Unknown Source)
    	at java.net.Socket.connect(Unknown Source)
    	at java.net.Socket.connect(Unknown Source)
    	at java.net.Socket.<init>(Unknown Source)
    	at java.net.Socket.<init>(Unknown Source)
    	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:259)
    	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:307)
    	... 68 more
    
    REQUEST URL
    http://localhost:8080/exception/error.jsp
    
    
    

    There have been no changes made to the Mango instance and am curious as to what may be the cause of all this.

    Any help is muchly appreciated.

    Regards,

    DominicIrl

    posted in User help read more
  • D
    Dominic.Irl

    Hi Jeremy,

    I intend trying to get this up and running in the following weeks. I will keep you posted on how it goes.

    Regards,
    Dominic

    posted in How-To read more
  • D
    Dominic.Irl

    That sounds very promising Joel.
    I will be keeping my eye out for that module as it sounds pretty much exactly what I am after.

    posted in How-To read more
  • D
    Dominic.Irl

    Does anybody know if it is possible to alter the layout of the CSV file that is e-mailed in the reports?

    Specifically I wish to include graphs in the CSV file.

    Thanks in advance,

    Dominic

    posted in How-To read more
  • D
    Dominic.Irl

    All up and running,

    Thanks for the input Joel!

    P.S. How do I mark post as SOLVED?

    posted in Dashboard Designer & Custom AngularJS Pages read more
  • D
    Dominic.Irl

    Perfect. We will give this a shot and let you know how we get on.

    Thanks for the quick replies.

    Dominic

    posted in Dashboard Designer & Custom AngularJS Pages read more