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.

The display of the code (at least on my browser) leaves a few things out. Check the page source. This appears to be a more complete rendition.

Antsu, are you still using the updated build that i sent you? If so, there is a version conflict between the source and the old JSPs that you still have. The next version of Mango will fix that for you.

Hi Antsu, I think the 0.5C resolution of the temp sensor is a 1-wire restriction. The documentation on the units that i have say so - not sure about yours. Re the blue curve, i suspect those drops at midnight and 6:30 are due to your function momentarily returning "false". I suggest doing an analysis on the data to find out for sure.

what kind of devices are used to read the state of an input ? I want to display if a pump is running. what do i need and how do i connect it to mango.

It's just a warning. You'll also see an exception event raised within Mango. It means that your equipment did not respond to the request within the timeout period.

You can get it here: http://www.tucsni.nl/mango/mango-i18n-nl.zip

2010-2-22 15:53:21 org.apache.catalina.core.ApplicationContext log ??: Initializing Spring root WebApplicationContext 2010-2-22 15:53:23 org.apache.catalina.core.StandardContext listenerStart ??: Exception sending context initialized event to listener instance of class com.serotonin.mango.MangoContextListener com.serotonin.ShouldNeverHappenException: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select ds.id, ds.name, ds.dataSourceType, ds.enabled, vrt.updateSeconds, mbs.updateSeconds, mbs.commPortId, mbs.baudRate, mbs.flowControlIn, mbs.flowControlOut, mbs.dataBits, mbs.stopBits, mbs.parity, mbs.encoding, mbs.echo, mbi.updateSeconds, mbi.transportType, mbi.host, mbi.port from dataSources ds left join dataSourceVrt vrt on vrt.dataSourceId = ds.id left join dataSourceMbs mbs on mbs.dataSourceId = ds.id left join dataSourceMbi mbi on mbi.dataSourceId = ds.id]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.datasourcevrt' doesn't exist at com.serotonin.mango.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:87) at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:135) at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:248) at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:85) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:556) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardHost.start(StandardHost.java:722) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443) at org.apache.catalina.core.StandardService.start(StandardService.java:516) at org.apache.catalina.core.StandardServer.start(StandardServer.java:710) at org.apache.catalina.startup.Catalina.start(Catalina.java:583) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413) Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select ds.id, ds.name, ds.dataSourceType, ds.enabled, vrt.updateSeconds, mbs.updateSeconds, mbs.commPortId, mbs.baudRate, mbs.flowControlIn, mbs.flowControlOut, mbs.dataBits, mbs.stopBits, mbs.parity, mbs.encoding, mbs.echo, mbi.updateSeconds, mbi.transportType, mbi.host, mbi.port from dataSources ds left join dataSourceVrt vrt on vrt.dataSourceId = ds.id left join dataSourceMbs mbs on mbs.dataSourceId = ds.id left join dataSourceMbi mbi on mbi.dataSourceId = ds.id]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.datasourcevrt' doesn't exist at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.translate(SQLExceptionSubclassTranslator.java:78) at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:237) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:457) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:465) at com.serotonin.db.DaoUtils.query(DaoUtils.java:167) at com.serotonin.mango.db.upgrade.Upgrade0_7_0.upgrade(Upgrade0_7_0.java:68) at com.serotonin.mango.db.upgrade.DBUpgrade.checkUpgrade(DBUpgrade.java:82) ... 27 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'mango.datasourcevrt' doesn't exist at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1422) at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:210) at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:442) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395) ... 32 more 2010-2-22 15:53:23 org.apache.catalina.core.ApplicationContext log ??: Closing Spring root WebApplicationContext 2010-2-22 15:53:24 org.apache.catalina.core.ApplicationContext log ??: ContextListener: contextInitialized() 2010-2-22 15:53:24 org.apache.catalina.core.ApplicationContext log ??: SessionListener: contextInitialized()

Text renderers are assigned to points. Editing is found in the page with a "brick" icon that has a pencil on it. Anyway, i'm glad that you were able to do this with a custom view. I had a feeling that users were more than willing to do their own scripting.

@apl said: goto war/WEB-INF/classes/ there you will see messages.properties, messages_de.properties and messages_en.properties for your language you maust create a messages_nl.properties for dutch (? sorry if I am wrong) and add the proper entry to i18n.properties. Or choose English/Deutsch from the world (top/right). Arne English is ok for me. There is a messages_en and messages_de file In the i8n.properties both enlish and german are in the file. There is no world in publicview see mango.de1103.nl

@craig said: Hi Sprokkie, Maybe you should run mango on the webserver (in addition to your home server). You could set up a publisher to publish the data from your home mango instance to the remote webserver mango instance. Alternatively, you could create a 'custom view' .jsp file on your home server mango instance, and download that to your remote webserver with a program like wget. From the 1.8 changelog: "Custom view pages A new approach to creating views has been added to Mango. Now you can create your own custom view pages using simple JSP tags. Simply create a JSP page in the Mango file system, and within your HTML specify the points that you want displayed where you want them. You can also display compound charts with custom plot colours. And, using javascript you can write simple scripts to set point values as well." i copied my file costumview.jsp to the webserver when i acces the file, i got a page where i could read the file. the page did not work. when i look in the file there are some other files neccesary here is the url http://mango.de1103.nl/costumview.jsp

Ok, good. Just a general note that XIDs for data sources only start with "DS" by default (and the same with "DP" and data points). They can otherwise have any value as long as it is unique.

You need to look in a file in Tomcat's logs directory usually called "localhost.yyyy-mm-dd.log" for the stack trace.

@sprokkie said: @craig said: click the brick icon for the point, go to the point properties edit page and near the bottom you can set up a chart renderer. this will give you the mouse over chart I have made a sipmle point, the point properties does not show chart. I found out what you mentioned. I have a chart now with mouse over. Now i have the problem that is to big, where can i resize it

Good to hear. Thanks for following up.

Thanks now is perfect with URL = http://65.5.172.234/axis-cgi/jpg/image.cgi WEBCAM ... = <img src="http://65.5.172.234/axis-cgi/mjpg/video.cgi?camera=&showlength=1&resolution=704x240" id="liveimage" /> It works perfectly

Thanks. Re Javascript, just ask Google. There's a ton of resources around.

Ciao I have a datasource with 2 point that return a CURRENTvalue and a MAXvalue (and/or MINvalue). I have associated to this datasource a dinamic graphich, in particular the CURRENTvalue point. Is it possible to set the max value of dinamic graphic with the MAXvalue of datasource? Ciao everyone!!!

sorry, wrong message

i've got this working, I'll send it along in a few months when it is properly tested.

hi mlohbihler I don't want to convert derby to postgreSQL,because I want to use postgreSQL directly,I modify the code about database,now I run the program and find the following log(the tables in postgreSQL have been created Automatically): org.springframework.dao.InvalidDataAccessApiUsageException: The getKey method should only be used when a single key is returned. The current key entry contains multiple keys: [{id=1, username=admin, password=0DPiKuNIrrVmD8IUCuw1hQxNqZc=, email=admin@yourMangoDomain.com, phone=, admin=Y, disabled=N, lastlogin=null, selectedwatchlist=null, homeurl=null, receivealarmemails=0, receiveownauditevents=N}] at org.springframework.jdbc.support.GeneratedKeyHolder.getKey(GeneratedKeyHolder.java:65) at com.serotonin.db.DaoUtils.doInsert(DaoUtils.java:151) at com.serotonin.mango.db.dao.UserDao.insertUser(UserDao.java:134) at com.serotonin.mango.db.dao.UserDao.access$000(UserDao.java:38) at com.serotonin.mango.db.dao.UserDao$2.doInTransactionWithoutResult(UserDao.java:122) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at com.serotonin.mango.db.dao.UserDao.saveUser(UserDao.java:118) at com.serotonin.mango.db.DatabaseAccess.initialize(DatabaseAccess.java:138) at com.serotonin.mango.MangoContextListener.databaseInitialize(MangoContextListener.java:248) at com.serotonin.mango.MangoContextListener.contextInitialized(MangoContextListener.java:85) best wishes Susan