• E
    eksantrik

    Hello all,

    I created a data source on Mango successfully using postgresql connection. The table I am collecting data from is used to collect data from a historical database every 10 minutes and 300 data points. My next goal is to graph some of this data over time for specific point names. Where can I find the details on creating the data points for my source? I tried to follow the steps on video tutorials and help menu but that did not help.

    Thanks,![0_1514389036978_postgresql database.png](Uploading 100%)

    posted in User help read more
  • E
    eksantrik

    Hello folks:

    I am new to Mango. I was wondering how I can connect it to our historical postgreSQL database. I just installed it and now looking for some guides.

    Thanks,

    posted in User help read more
  • E
    eksantrik

    I installed Mango on my Windows 10 laptop to start testing. Trying to build an MSSQL data source to database located on my laptop. Seeing the following error:
    INFO 2017-10-11T03:42:34,330 (com.serotonin.m2m2.sql.SqlDataSourceRT.initialize:510) - Error while initializing data source
    java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
    at java.net.URLClassLoader.findClass(URLClassLoader.java:381) ~[?:1.8.0_131]
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[?:1.8.0_131]
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[?:1.8.0_131]
    at java.lang.Class.forName0(Native Method) ~[?:1.8.0_131]
    at java.lang.Class.forName(Class.java:264) ~[?:1.8.0_131]
    at com.serotonin.m2m2.sql.SqlDataSourceRT.initialize(SqlDataSourceRT.java:498) [sql-ds-3.2.0.jar:?]
    at com.serotonin.m2m2.sql.SqlDataSourceRT.manageConnection(SqlDataSourceRT.java:281) [sql-ds-3.2.0.jar:?]
    at com.serotonin.m2m2.sql.SqlDataSourceRT.doPoll(SqlDataSourceRT.java:298) [sql-ds-3.2.0.jar:?]
    at com.serotonin.m2m2.rt.dataSource.PollingDataSource.doPollNoSync(PollingDataSource.java:196) [mango-3.2.1.jar:?]
    at com.serotonin.m2m2.rt.dataSource.PollingDataSource.scheduleTimeoutImpl(PollingDataSource.java:162) [mango-3.2.1.jar:?]
    at com.serotonin.m2m2.rt.dataSource.PollingDataSource$1.scheduleTimeout(PollingDataSource.java:70) [mango-3.2.1.jar:?]
    at com.serotonin.m2m2.util.timeout.TimeoutTask.run(TimeoutTask.java:59) [mango-3.2.1.jar:?]
    at com.serotonin.timer.Task.runTask(Task.java:179) [mango-3.2.1.jar:?]
    at com.serotonin.timer.TaskWrapper.run(TaskWrapper.java:23) [mango-3.2.1.jar:?]
    at com.serotonin.timer.OrderedThreadPoolExecutor$OrderedTaskCollection.run(OrderedThreadPoolExecutor.java:307) [mango-3.2.1.jar:?]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
    at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]

    My driver class setting is as follows: com.microsoft.sqlserver.jdbc.SQLServerDriver

    My connection string is as follows: jdbc:sqlserver://127.0.0.1:1433;database=Bisson;integratedSecurity=false;

    I am not sure what I am missing here.

    Please advise.

    Thanks,

    posted in Mango Automation general Discussion read more
  • E
    eksantrik

    Good day,

    We are trying to develop bacnet explorer using bacnet4j. the thing is that this explorer will not be in the same subnet as the bacnet controller most of the time. We can send who-is messages to the local broadcast address with destination network address 65535. We are trying to figure out how we can achieve the same when we are not in the same network as bacnet controller but we know the IP of the bacnet controller.

    Does bacnet4j support it?

    Thanks

    posted in BACnet4J general discussion read more
  • E
    eksantrik

    Good day,

    We are trying to develop bacnet explorer using bacnet4j. the thing is that this explorer will not be in the same subnet as the bacnet controller most of the time. We can send who-is messages to the local broadcast address with destination network address 65535. We are trying to figure out how we can achieve the same when we are not in the same network as bacnet controller but we know the IP of the bacnet controller.

    Does bacnet4j support it?

    Thanks

    posted in BACnet4J general discussion read more