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.

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

@mlohbihler said:

Shouldn't be necessary, except for one file. If you've already set up MySQL you'll be familiar with the WEB-INF/classes/env.properties file. Just make sure it is pointing at your MySQL instance and you should be good.
That's what I thought, just wanted to make sure.

Thank you!

Create a meta point that calculates the difference between the two points Add a high limit detector on to the meta point Add an event handler to the high limit detector that turns on your pump.

Check out point event detectors, scheduled events, and event handlers.

However you want.