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.

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.

P.S. thanks again for contributing. You rock.

After years of using prepared statements in many databases, i have to admin i have no idea. It never came up.

:) Thanks. Re linking, there's a bit of an icon clash that has been a small thorn in the paw for a while now, but there's still no good solution.

A system event would probably be simpler.

I ended up using net-snmp locally on the box, and passing an exec command. Then via mango, use SNMP data source to query the values. An expensive hack, but works fine on a small scale. -Dan

Hi Matthew, I happens only for a few pages. I don't have admin rights to install the software on my pc. I will be able to do this soon and post the results.

Thanks! this seemed like one of those problems where there is a lot more to it than appears on first glance, so I asked before diving in.

I meant create a "meta" data source, create a point in it, and give it any old script to give the point a value. The only thing potentially wrong that i could see in the code is possible failure to create the Javascript engine, which would be an environmental thing, probably to do with the JVM. Of course, if you're not using the most current Mango version (1.6.4) that could be an issue too.

Sure, that works. :)

I wonder if any user manual (http also OK) would be available before installing full software. This time Google did not help me :shock: This would be very helpfull for me as I have existing (other) system running in measurement-PC and I would like to make swap as short as possible Thanks

This post has been superseded by this one: http://mango.serotoninsoftware.com/forum/posts/list/185.page.

Hi Nik, I've personally had some issues with Ubuntu, but i'm far from being able to say for sure that's the problem. Still, i suggest trying Fedora or a Windows host for Mango to see if your serial ports stick around longer. Also, make sure data sources and testers aren't competing for the port in the case that you have multiple data sources running. Only one running data source can own a serial port at a time. Note also that the node scanner owns the port while it is scanning.

Thanks I'll do that tomorrow :-)

Hi Dusky, It's hard to say without knowing more about the queries you are doing. (If, however, you are asking if there are connection pooling facilities available, the answer currently is no.) It sounds like you are doing row-bases querying. If so, it may be possible for you to use "union" clauses to combine your queries into one. This should work if your data types are all the same. For example, you might do something like this: select id, value from table1 union select id, value from table2 union...