• R
    Rodrigo

    Hi Jared!

    Thanks for the help!

    Rodrigo

    posted in User help read more
  • R
    Rodrigo

    Hi Guys,

    I've received a question from a client about Java, he's not able to buy licenses from Oracle (company related restrictions) and has asked me if we will be able to use Mango in this scenario. I have never bought a Java license for any installation, but I have seen in the Oracle website an update about their licenses.
    0_1573659145751_Screenshot_1.png

    Can someone please explain the implications of this update? Do we have to buy Java now?

    Thanks!
    Rodrigo

    posted in User help read more
  • R
    Rodrigo

    Thanks! @ThomasEinasto @CraigWeb
    Will check on this one!

    Best,
    Rodrigo

    posted in Hardware read more
  • R
    Rodrigo

    Thanks guys!

    @phildunlap Is there another way of remotely accessing Mango? in the intranet I understand it can just be accessed through an IP address (am I right?), but from the internet? a public IP? (I need to keep this low cost).

    @ThomasEinasto thanks! I will check on this.

    Regards,
    Rodrigo

    posted in Hardware read more
  • R
    Rodrigo

    Hi guys,

    I have a project for a small computing room (not even big enough to be called small data center) where I will like to use the Mango ES solution, never used this product and I will like to start, can you give me a hand?

    The room has two small ac units to control a rack temperature, the controlling logic is to be done with a controllers with I/Os (general functions like turning the ac on or off, rotating the equipment periodically, based on demand turn both ac units together, alarming)

    I have identified the following equipment for this project

    • Mango ES
    • Controller with I/Os and sensors to act on the ac equipment, with Modbus RTU communication (can Mango ES be used to do this? or is this external controller necessary?)
    • 3G router (the project requests the capability to send sms messages, can Mango do this without the 3G router?)
    • Is a Modbus RTU to IP gateway needed? or can the RS485 connection on the Mango ES be used to directly connect the RTU controller?
    • Remote access to Mango through the internet and intranet is required

    Can someone comment on this?

    Thanks all,
    Best regards,
    Rodrigo

    posted in Hardware read more
  • R
    Rodrigo

    Hi Phil,

    Thanks for replying!
    It's actually as you said, pointS x1, x2, x3 ,............,xn need to take a value at a given time, it doesn't have to be like the photo I included before. It's a group of something like 20 fan coils that need to be turned on in the morning and turned off in the afternoon.
    DGLux is running all the time (except when there's a power outage, but in this scenario they will have to check the state of everything after the power is reinstated), maybe something with the date picker from DGLux and the computer time will be enough.

    What do you think?
    Best,
    Rodrigo

    posted in DGLux Graphic Dashboards read more
  • R
    Rodrigo

    Hi Guys,

    I there someone here still using DGLux 2?
    I need to do a scheduler for an installation and have no idea how, attached there's an image of the scheduler I found on DGBox, does anyone knows how to create something like this?
    0_1533529162199_schedule_overview.jpg
    In this scheduler one can create, for example, a Occupancy schedule and assign this property to the points you want this schedule to act on.

    Thanks in advance,
    Best,
    Rodrigo

    posted in DGLux Graphic Dashboards read more
  • R
    Rodrigo

    @phildunlap

    Absolutely, It was my lack of patience :$

    Thanks again Phil,

    Regards

    posted in User help read more
  • R
    Rodrigo

    @phildunlap

    How do I know if the database has finished restoring?
    After hitting restore it just stays there.

    My mango version is 2.5.2

    "Using C:\Mango as MA_HOME
    C:\Mango\overrides\classes;C:\Mango\classes;C:\Mango\overrides\properties;C:\Man
    go\overrides\lib*;C:\Mango\lib*
    Using Java at java
    INFO 2017-05-26 14:51:16,416 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'asciiFile', v1.1.5 by Infinite Automation
    INFO 2017-05-26 14:51:16,423 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'BACnet', v2.1.3 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,427 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'controlcore', v1.0.5 by Infinite Automation
    INFO 2017-05-26 14:51:16,429 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'dashboards', v1.0.3 by Infinite Automation
    INFO 2017-05-26 14:51:16,430 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'dataFile', v1.0.8 by Infinite Automation
    INFO 2017-05-26 14:51:16,435 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'dataImport', v1.3.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,438 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'dglux', v1.2.0 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,440 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'dnp3', v1.5.0 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,443 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'galil', v1.4.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,445 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'graphicalViews', v1.5.2 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,463 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'http', v1.4.7 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,467 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'internal', v1.4.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,469 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'jmxds', v1.4.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,472 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'jspViews', v2.0.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,482 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'log4jDS', v1.0.2 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,485 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'log4JReset', v1.0.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,486 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'loggingConsole', v1.0.2 by Infinite Automation
    INFO 2017-05-26 14:51:16,487 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'maintenanceEvents', v1.4.8 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,490 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'mangoApi', v1.0.3 by Infinite Automation
    INFO 2017-05-26 14:51:16,491 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'mbus', v1.0.7 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,496 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'meta', v2.1.1 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,500 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'modbus', v1.5.4 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,509 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'onewire', v1.4.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,512 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'opcda', v1.5.7 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,513 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'openv4j', v1.0.5 by aploese
    INFO 2017-05-26 14:51:16,515 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'pachube', v1.4.8 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,517 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'persistent', v1.5.8 by Infinite Automation Systems Inc.
    INFO 2017-05-26 14:51:16,520 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'pointLinks', v1.4.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,522 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'pop3', v1.4.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,525 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'reports', v2.1.3 by Infinite Automation Systems Inc.
    INFO 2017-05-26 14:51:16,529 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'scheduledEvents', v1.4.7 by (unknown vendor)
    INFO 2017-05-26 14:51:16,531 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'scripting', v1.0.8 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,535 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'serial', v1.1.5 by Infinite Automation
    INFO 2017-05-26 14:51:16,537 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'snmp', v1.4.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,540 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'sqlConsole', v1.4.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,542 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'sqlds', v1.5.7 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,545 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'ssh', v1.0.5 by Infinite Automation Systems Inc.
    INFO 2017-05-26 14:51:16,548 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'sstGlobalScripts', v1.4.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,550 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'sstGraphics', v1.0.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,551 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'sstTheme', v1.0.6 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,551 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'TCPIP', v1.0.3 by Infinite Automation Systems Inc.
    INFO 2017-05-26 14:51:16,554 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'templateConfig', v1.0.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,556 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'twilio', v1.0.4 by (unknown vendor)
    INFO 2017-05-26 14:51:16,560 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'virtualDS', v1.4.5 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,563 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'vmstat', v1.4.7 by Infinite Automation Software
    INFO 2017-05-26 14:51:16,569 (com.serotonin.m2m2.Main.loadModules:402) - Loadin
    g module 'watchlists', v1.6.1 by Infinite Automation Systems Inc.
    INFO 2017-05-26 14:51:17,306 (com.serotonin.m2m2.Lifecycle.loadLic:411) - Check
    ing license...
    INFO 2017-05-26 14:51:17,373 (com.serotonin.m2m2.db.H2Proxy.initializeImpl:42)

    • Initializing H2 connection manager
      INFO 2017-05-26 14:51:22,014 (com.serotonin.m2m2.db.upgrade.DBUpgrade.checkUpgr
      ade:36) - Starting instance with core version 2.5.2, db 9
      Exception in thread "main" org.springframework.jdbc.BadSqlGrammarException: Prep
      aredStatementCallback; bad SQL grammar [select id, xid, alias, data from eventHa
      ndlers where eventTypeName=? and eventSubtypeName=? and (eventTypeRef1=? or ev
      entTypeRef1=0) and (eventTypeRef2=? or eventTypeRef2=0)]; nested exception is o
      rg.h2.jdbc.JdbcSQLException: Tabla "EVENTHANDLERS" no encontrada
      Table "EVENTHANDLERS" not found; SQL statement:
      select id, xid, alias, data from eventHandlers where eventTypeName=? and eventSu
      btypeName=? and (eventTypeRef1=? or eventTypeRef1=0) and (eventTypeRef2=? or
      eventTypeRef2=0) [42102-181]
      at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.d
      oTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
      or.translate(AbstractFallbackSQLExceptionTranslator.java:73)
      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
    1. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:69
    2.  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:72
      
    3.  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:73
      
    4.  at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:78
      
    5.  at com.serotonin.db.DaoUtils.query(DaoUtils.java:308)
       at com.serotonin.m2m2.db.dao.EventDao.getEventHandlers(EventDao.java:611
      

    )
    at com.serotonin.m2m2.db.dao.EventDao.getEventHandlers(EventDao.java:581
    )
    at com.serotonin.m2m2.rt.EventManager.setHandlers(EventManager.java:415)

        at com.serotonin.m2m2.rt.EventManager.raiseEvent(EventManager.java:94)
        at com.serotonin.m2m2.rt.event.type.SystemEventType.raiseEvent(SystemEve
    

    ntType.java:97)
    at com.serotonin.m2m2.Lifecycle.terminate(Lifecycle.java:321)
    at com.serotonin.m2m2.Main.main(Main.java:108)
    Caused by: org.h2.jdbc.JdbcSQLException: Tabla "EVENTHANDLERS" no encontrada
    Table "EVENTHANDLERS" not found; SQL statement:
    select id, xid, alias, data from eventHandlers where eventTypeName=? and eventSu
    btypeName=? and (eventTypeRef1=? or eventTypeRef1=0) and (eventTypeRef2=? or
    eventTypeRef2=0) [42102-181]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    at org.h2.message.DbException.get(DbException.java:179)
    at org.h2.message.DbException.get(DbException.java:155)
    at org.h2.command.Parser.readTableOrView(Parser.java:5227)
    at org.h2.command.Parser.readTableFilter(Parser.java:1221)
    at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1860)
    at org.h2.command.Parser.parseSelectSimple(Parser.java:1969)
    at org.h2.command.Parser.parseSelectSub(Parser.java:1854)
    at org.h2.command.Parser.parseSelectUnion(Parser.java:1675)
    at org.h2.command.Parser.parseSelect(Parser.java:1663)
    at org.h2.command.Parser.parsePrepared(Parser.java:433)
    at org.h2.command.Parser.parse(Parser.java:305)
    at org.h2.command.Parser.parse(Parser.java:277)
    at org.h2.command.Parser.prepareCommand(Parser.java:242)
    at org.h2.engine.Session.prepareLocal(Session.java:446)
    at org.h2.engine.Session.prepareCommand(Session.java:388)
    at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1189)
    at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:7

    1.  at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:277)
       at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCre
      

    ator.createPreparedStatement(JdbcTemplate.java:1557)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:

    1. ... 12 more
      "

    posted in User help read more
  • R
    Rodrigo

    Hi Phil,
    Thanks for answering so fast!

    I followed the point 2,

    • moved the mah2.h2.db somewhere else
    • started mango with ma-start.bat (it started and everything I had on Mango and DGLux dissapeared, including licenses)
    • went to system settings, Database Backup Settings, Get backups,
    • choosed one from a month ago and clicked restore database, here I closed the browser and the command prompt, I couldn't do anything else.
    • restarted from m-start.bat and now the loading lines goes to 100% and says "Running shutdown tasks", and keeps refreshing but it doesn't finish loading and mango doesn't starts.

    The point 1 you recommended, I don't have the h2-web-console.bat file in that folder, or any other folder.

    posted in User help read more
  • R
    Rodrigo

    Hi guys,

    I have a problem with my Mango Installation, described below, I've submitted a ticket for this, but I will also post this here, maybe someone knows the solution for this or maybe the developers would like to solve it through here so anyone can use this later. Let's keep our forum dynamic! :)

    Mango is installed on a windows 7 professional PC and I installed the service with the yajsw, it worked perfectly for most than a year.
    The computer was also (sadly) used to surf the web, so this is what may have caused the problems.
    The user says there was an electrical problem and the computer "blinked" twice and after that, Mango + DGLux stopped working.

    The symptoms:

    1. The service doesn't starts automatically.
    2. If I manually start the service, it stops automatically after a few minutes.
    3. If I manually start the service and launch Mango, I get the following error from the browser,
      "RequestError: Unable to load /status/mango.json?time=1495810520615 status 0"
      and the Mango Initialization stops at 55%, when
      Initializing Event Manager, and at the loading lines it states
      "INFO 2017-05-26 10:55:15,985 (com.serotonin.m2m2.dg.upgrade.DBUpgrade.checkUpgrade:36) - Starting instance with core version 2.5.2, db 9

    I tried the following:
    Tried to delete the service and the yajsw folders and reinstal, no luck.
    Recover the computer to an early date backup, no luck.

    Regards,
    Rodrigo

    posted in User help read more
  • R
    Rodrigo

    @JoelHaggar

    Thanks Joel, I'll try that, now I'm trying to use the json import export.
    I have 70 fan coils on a building an each fan coil controller has 10 points or so, I created all the points for one controller, exported this in json format and now I'm modifying that file and adding the points of the rest, let's see how it goes.

    Regards,
    Rodrigo

    posted in User help read more
  • R
    Rodrigo

    Hi Joel,
    In the video you recommended, you say that in a future video you are going to explain how to use CSV files to import lots of data points, you haven't made that video yet, right?
    In this video you explain how to use the property template, I found this tool to be extremely useful, but my lack of imagination :) doesn't let me understand how to use that to import lots of data points, are you trying to tell me that I should create the points one by one, and use the property template to assign the same properties to all of them?

    Hi Phil
    I thank you for your attempt to help me, but I know nothing about coding, so for me, what you wrote may well be chinese :$
    I really appreciate your message though.

    Regards,
    Rodrigo

    posted in User help read more
  • R
    Rodrigo

    I answer more than a month late, but thanks (better late, than never).

    I'll check on your sugestions now.

    Regards
    Rodrigo

    posted in User help read more
  • R
    Rodrigo

    Hi guys,

    In the past I've seen a video (or couple of them) around here explaining how to import lots of data points using an excel + word combination.
    I wanted to try that but I can't seem to find those videos anywhere anymore.

    Can someone give me a hand please?
    Regards
    Rodrigo

    posted in User help read more
  • R
    Rodrigo

    @JoelHaggar

    Got it, Thanks Joel, now, I can't login in that page, it uses the same username and password as the forum? or what's happening?

    Regards
    Rodrigo

    posted in User help read more
  • R
    Rodrigo

    What happened with the Wiki/documentation page?
    I'm having trouble finding the useful documentation that it used to contain.
    Is just me? Or the content has diminished?

    Thanks,
    Regards
    Rodrigo

    posted in User help read more
  • R
    Rodrigo

    Thanks guys! I will give it a try and let you know how it goes,

    Regards,
    Rodrigo

    posted in Scripting general Discussion read more