Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

  • Logging.... interval... quantize

    3
    0 Votes
    3 Posts
    2k Views
    S
    i've decided to make 2 data sources... a/. source with 1 sec polling for realtime data b/. source with 15min polling and quantize checked source b is set for logging on time stamp so achieves the desired result. however, i'm also publishing this data (potentially both sources) with another scada instance retrieving the data. currently the publising data source is set for updates by changes. since the source is quantize, it would be nice if i could select 'timestamp' change for the update. presently i only see option to select 'all changes' which see's the client scada have per second updates, or 'changes only' which fails since the data value might not have changed. i'm using 1.12.0, has the publishing facility been changed to send updates based on timestamp? thanks skiv
  • Interactive graphical view

    3
    0 Votes
    3 Posts
    3k Views
    F
    I think you may create a custom page, you should start look at CustomViewExample.jsp.
  • OPC connection

    3
    0 Votes
    3 Posts
    5k Views
    F
    It seems that Mango M2M and Mango M2M2 are already retired and with no stable version and also no sources, so You'd better using Scadabr, it is a fork from Mango. Scadabr's forum is only in portuguese but you can post english messages there. Their suport is not good as the Mango used to be but there are sources available and it seems to work fine. There are lot of bugs also but the team is still active. http://sourceforge.net/projects/scadabr Also take a look at this: http://sourceforge.net/projects/scadabr/files/Software/Docs/OPC Configuration ScadaBR.pdf/download and this http://mango.serotoninsoftware.com/forum/posts/list/15/599.page
  • Examples on Mango

    3
    0 Votes
    3 Posts
    3k Views
    M
    There are many good examples in this forum. Look under the"stories"or "how to" sections. Your questions is very generic and would be best answered by spending some time reading. Pretty much everything you need to know is here.
  • Meta point and cron trigger

    3
    0 Votes
    3 Posts
    2k Views
    S
    i cannot use event triggers based on time because i need them to be dynamic... but an alternative would to have access the elapsed time of a trigger to i could see where its got to... can i do that?
  • Error in getting graphics from watchlist

    2
    0 Votes
    2 Posts
    2k Views
    G
    Hi all, When I try to get a graphic from watchlist points, I get the following error (on console). Going for logs, does not helps much. Any idea what might have happened here? ERROR 2011-07-26 10:21:45,448 (org.directwebremoting.util.CommonsLoggingOutput.error:75) - Missing : in conversion data (2011) WARN 2011-07-26 10:21:45,452 (org.directwebremoting.util.CommonsLoggingOutput.warn:67) - Marshalling exception org.directwebremoting.extend.MarshallException: Error marshalling int: Format error converting false. See the logs for more details. at org.directwebremoting.convert.PrimitiveConverter.convertInbound(PrimitiveConverter.java:49) at org.directwebremoting.dwrp.DefaultConverterManager.convertInbound(DefaultConverterManager.java:159) at org.directwebremoting.dwrp.BaseCallMarshaller.marshallInbound(BaseCallMarshaller.java:155) at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:44) at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101) at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) WARN 2011-07-26 10:21:45,475 (org.directwebremoting.util.CommonsLoggingOutput.warn:59) - --Erroring: batchId[8] message[org.directwebremoting.extend.MarshallException: Error marshalling int: Format error converting false. See the logs for more details.] Thanks in advance! Gustavo
  • Clear the Event DB

    2
    0 Votes
    2 Posts
    2k Views
    N
    Hi guys, I would like to clean my event database, since it gives too much old Urgent messages and currently I have changed my alerting policies. How can this be done? I am using Ubuntu and I have tried to connect to the MangoDB directory by means of the "JavaDB/Derby embedded" driver of DBVisualizer, but I have not successed in it. My MangoM2M version is 1.12.4. Thanks in advance Bye
  • Derby->MySQL: ERROR 42X05: Table/View 'SYSTEMSETTINGS' does not exist.

    5
    0 Votes
    5 Posts
    5k Views
    A
    Use mango 1.12.3 ther are nop sources for versions > 1.12.3, or ask serotonin directly. Arne
  • Here are some view component examples

    8
    0 Votes
    8 Posts
    11k Views
    F
    Very useful examples, I would like to set an RTC clock using two select combobox: Hours 0-23 and Minutes 0-59. The datapoint must be set in seconds, so I need two combos performing some scripting like get the value of hours3600 plus minutes60. I am trying but could not do it yet. Here is my code, it works outside mango, but could not set the datapoint from this, anyone could help? <script language="JavaScript"> function checar() { campo1 = document.form.select1; campo2 = document.form.select2; if(campo1.value!="") { valor1=campo1.value; } else { valor1=""; } if(campo2.value!="") { valor2=campo2.value; } else { valor2=""; } um = valor1*3600; // hour to seconds dois = valor2*60; // minutes to seconds totalSec = um+dois; if(um=="" && dois=="") { document.form.total.value=""; } else { document.form.total.value=totalSec; //mango.view.setPoint("+ point.id +", \""+ pointComponent.id +"\", "+totalSec+" )'>"; } } </script> <form name="form"> <select name="select1" onChange="checar()"> <option></option> <option value="1">1</option> <option value="0">...</option> <option value="23">23</option> </select> <select name="select2" onChange="checar()"> <option></option> <option value="1">1</option> <option value="0">...</option> <option value="59">59</option> </select> <input type="text" name="total" value=""> </form>
  • SQL Data Source and temporary tables

    2
    0 Votes
    2 Posts
    3k Views
    G
    Hi, My sensors send SMS messages which are stored into a MySQL table (received_messages_t). Each message has basically: two fields (device_id+slave_id) for sensor identification, one field is timestamp, then I have "N" measurement fields (eg current, voltage etc). My approach was to define in Mango M2M one Data Source for each sensor, and then N Data Points (one for each measurement field). I guess a column based query is not suitable (only the first row of the result is used), so I would need a row-based query which extracts the messages sent from a sensor within a certain timeframe (eg during the last day), and puts data in 3 columns: Data Point Name, Data Point Value, Timestamp. Thus, each message will be splitted into N rows. I have successfully tested such a script (eg with MySQL Query Browser), which uses MySQL temporary tables: DROP TABLE if exists Dummy; DROP TABLE if exists dum_datasource_t; CREATE TEMPORARY TABLE Dummy ENGINE=MEMORY SELECT * FROM received_messages_t WHERE device_id=2 AND slave_id=2 AND DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= message_timestamp; CREATE TEMPORARY TABLE dum_datasource_t(Name VARCHAR(255) NOT NULL , Value VARCHAR(255) NOT NULL, Timestamp DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00')ENGINE=MEMORY; insert into dum_datasource_t(Name, Value, Timestamp) select 'Voltage_1', Dummy.Voltage_1, Dummy.message_timestamp from Dummy; ...(other Data Points)... insert into dum_datasource_t(Name, Value, Timestamp) select 'Voltage_N', Dummy.Voltage_N, Dummy.message_timestamp from Dummy; select * from dum_datasource_t; Now, if I use this as Select statement in my Mango Data Source, the Statement test execution gives: "class java.sql.SQLException: Can not issue data manipulation statements with executeQuery()." Any suggestion before trying to change Statement.executeQuery() into Statement.executeUpdate() in the source code? Any better way to handle this SQL Data Source? My Mango installation is using Derby, while Data Source is on a separate MySQL server, btw I do not think this is the point. Thank you in advance. Giorgio
  • Overlay text values onto dynamic graphic

    4
    0 Votes
    4 Posts
    3k Views
    J
    Well, I figured it out. I case anyone else would like to do this, I just changed this.cont.appendChild(this.cnv); to this.cont.insertBefore(this.cnv,this.cont.firstChild); in ROOT\resources\wz_jsgraphics.js
  • Error "getElement(mango.share.users, data.userId) is null"

    4
    0 Votes
    4 Posts
    4k Views
    P
    Thanks for the link. I had searched for the other error message before posting, so I had not seen your helpful link. I backed up MangoDB when troubleshooting, and got the same error when running the backed up database under older Mango versions. For some reason, lately I could no longer get Mango to initialize when using the originally backed up MangoDB, so I had to start Mango with an empty database and import the json files to recreate my setup, and re-upload the graphical background images. Consequently, I lost all my historical data points. Actually, they're still in the backup MangoDB, but since Mango won't load when that database is used, I don't know how to retrieve that historical data, let alone import it into the new database. That data is not critical at the moment, but when historical data becomes important, it concerns me that I may not be able to retrieve it. I created new usernames and set their home pages, and this time I was able to update passwords of users with homepages and save without seeing the null error. However, I just got that error again when updating the admin password: ERROR 2011-06-01 20:57:54,121 (com.serotonin.mango.web.filter.ExceptionDetectionFilter.doFilter:52) - DWR invocation exception java.lang.NullPointerException at com.serotonin.mango.web.dwr.DataPointDetailsDwr.getPointData(DataPointDetailsDwr.java:66) at com.serotonin.mango.web.dwr.MiscDwr.doLongPoll(MiscDwr.java:343) at sun.reflect.GeneratedMethodAccessor1306.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34) at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428) at com.serotonin.mango.web.dwr.util.LoggedInAjaxMethodFilter.doFilter(LoggedInAjaxMethodFilter.java:52) at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428) at com.serotonin.web.dwr.LocalizationFilter.doFilter(LocalizationFilter.java:42) at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428) at com.serotonin.mango.web.filter.ExceptionDetectionFilter.doFilter(ExceptionDetectionFilter.java:40) at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428) at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431) at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283) at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52) at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101) at org.directwebremoting.servlet.DwrServlet.doPost(DwrServlet.java:146) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:636) This error occurred even though I had previously set a homepage for user admin.
  • Chart and Thumbnail generation on Fedora Server (no x-server) not working

    3
    0 Votes
    3 Posts
    3k Views
    S
    Some may wonder what exactly I am trying to accomplish. The answer is to develop the leanest possible tomcat/mango server. I am trying to use a minimal install of Fedora 14 without x-server. OpenJDK 1.6.0 is being used along with Tomcat 7.0.14 to run Mango 1.12.4. There aren't any permission issues, that I know of, for absolutely everything else works in Mango M2M except the chart generation. I know there has to be a library that is missing that I don't have installed. If anyone has a clue what it could be...well, it would be so very MUCH appreciated.
  • Calculate Standard Deviation, Normal Distribution?

    4
    0 Votes
    4 Posts
    4k Views
    R
    Great, thanks!
  • Complete simulation setup (all the Links are given)

    2
    0 Votes
    2 Posts
    3k Views
    N
    In this tutorial (below link), you can find free tools ,to simulate PLC with Mango M2M http://scadaforplcs.blogspot.com/
  • Modbus rtu source via tcp gateway, polling trouble

    4
    0 Votes
    4 Posts
    4k Views
    S
    hi joohwan, sorry i'll try and break it down mango (since 1.8.1 i think) modbus I/O, RTU via a TCP gateway. all i know is it appears mango's polling mechanism is not geared towards multiple sources, i.e. there is no staggering of devices... and i've seen on site where this has risen to unrecoverable comms downtime. resetting the data source or restarting the instance is required. 2 other modbus masters I have at my disposal, seem to polling 'one at a time' and this works much better
  • Char encoding trouble ? ... Maybe not

    4
    0 Votes
    4 Posts
    4k Views
    V
    hello Patriator, another user from france is willing to help with the translation. post in french: http://www.scadabr.org.br/?q=node/127 (we use the same translation files from mango) would you be interested in joining efforts? this could be put into mango´s main release. best regards
  • Graphic View

    3
    0 Votes
    3 Posts
    2k Views
    M
    Not currently in M2M, but this would be possible in M2M2.
  • Event handler, process trigger

    3
    0 Votes
    3 Posts
    4k Views
    M
    Can you use some kind of O/S-level semaphore? lockfile() maybe?
  • 0 Votes
    3 Posts
    4k Views
    P
    Solution: In Debian/Ubuntu the serial ports are in group 'dialout.' However, user tomcat6 is not a member of group dialout, and consequently could not see the ports. $ ls -l /dev/ttyS* crw-rw---- 1 root dialout 4, 64 2011-03-23 20:42 /dev/ttyS0 crw-rw---- 1 root dialout 4, 65 2011-03-03 10:28 /dev/ttyS1 crw-rw---- 1 root dialout 4, 66 2011-03-03 10:28 /dev/ttyS2 crw-rw---- 1 root dialout 4, 67 2011-03-03 10:28 /dev/ttyS3 To fix the problem, user tomcat6 must be added to group dialout: root@ubuntuserver# usermod -G dialout tomcat6 Now Tomcat6 can see the serial ports, but Mango will not report them until it is restarted. To restart Mango: root@ubuntuserver# /etc/init.d/tomcat6 restart Stopping Tomcat servlet engine tomcat6 [ OK ] Starting Tomcat servlet engine tomcat6 Now Mango shows the serial ports in the pulldown menu When I searched for this in the forum, I had searched for 'NMEA.' Once I noticed the same 'missing ports' problem was also on the 'Modbus serial' data source page, I narrowed it to a serial port problem, and searched the forum for 'rxtx' and found out that [url=http://mango.serotoninsoftware.com/forum/posts/list/0/189.page#1362]'a reboot was mandatory,' so I restarted Tomcat. [solved] It would be useful to have a Mango wiki so that these issues can be organized and updated in a more structured manner than what a forum can support.