• S
sundeepgoel

I want to upgrade from ver 1.13.0 to the current 2.2.2.
What are the exact steps ?

• S
sundeepgoel

The timezone applied on the chart object is correct (uses local time), however watchlist or history seem to be GMT. How do i sort this ?

Note : my linux server timezone is correctly set to IST (local timezone)

• S
sundeepgoel

The pointValues table has grown huge on mysql. How can i partition it to improve overall performance ?

• S
sundeepgoel

how can i implement a filtering algorithm to give me the median value from a set of sensor readings. i need this for some digital sensors which sometime give false readings - basically want to put all readings of say the last one minute in an array, sort it and then pick the median (middle value).

is there an easy way to do this, any pointers will be appreciated...

• S
sundeepgoel

Hi, I am using the following to get the temp from an NTC

``````T = t1.past(MINUTE).average;

THERMISTORNOMINAL = 10000;

// temp. for nominal resistance (almost always 25 C)
TEMPERATURENOMINAL = 25;

// The beta coefficient of the thermistor (usually 3000-4000)
BCOEFFICIENT = 3435;

// the value of the 'other' resistor
SERIESRESISTOR = 14910;

average = 1023.00 / T  - 1.00;

average = SERIESRESISTOR / average;

steinhart = average / THERMISTORNOMINAL; // (R/Ro)
steinhart = Math.log(steinhart); // ln(R/Ro)
steinhart /= BCOEFFICIENT; // 1/B * ln(R/Ro)
steinhart += 1.0 / (TEMPERATURENOMINAL + 273.15); // + (1/To)
steinhart = 1.0 / steinhart; // Invert
steinhart -= 273.15; // convert to C

return steinhart ;
``````

Trouble is that when even for the past one hour where there is **NO **t1 value received, the average function still returns the average based on whatever was stored earlier. I was expecting that in case of no data, the average function based on time would return a NULL.

Any thoughts / suggestions ?

• S
sundeepgoel

Recently i have started getting graphs rendering only half in the** data_point_details.shtm?** page. I.e. only the top half is rendered, the bottom half in completely blank.

how do i troubleshoot this issue?

• S
sundeepgoel

Off late getting a lot of error like the one below

'calculated_data': Script error in point "Temp_Outside_5minAvg": sun.org.mozilla.javascript.WrappedException: Wrapped org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [select pv.dataType, pv.pointValue, pva.textPointValueShort, pva.textPointValueLong, pv.ts, pva.sourceType, pva.sourceId from pointValues pv left join pointValueAnnotations pva on pv.id = pva.pointValueId where pv.dataPointId=? and pv.ts >= ? and pv.ts#1) in at line number 1 in at line number 1

They go away after bouncing tomcat, but again reoccur after some time. please advise on resolution ?

• S
sundeepgoel

Please guide on what would be required to make DIY module for home automation. Based on a variety of sensor inputs like temperature, humidity, i want to be able to control a number of fans, exhaust fans and air conditioners directly from the mango software.

I guess my question has three parts :-

1. How can mango be used to control mains (220V) hardware
2. How to mango communicate with such hardware.
3. What are the basic protocols which the hardware device needs to implement, are there any chips on the market which readily implement the communication stack / required protocols

Any guidance will be appreciated ...