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

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

@phildunlap said:

On my instance of Mango that chart is still rendered in server time as the default (i.e. my user preference is "use server time").

This can be manually set on a user by user basis to a specific timezone on the user details page, if you're certain the problem isn't the configuration of the timezone on the linux box.

where do you set the user preference "use server time" - i cant find this on my instance of mango (1.13.0)

@phildunlap said:

You are referring to which: charts in DGLux, reports, graphics views, mouse overs, data point page, etc?

the one on data_point_details.shtm

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)

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)

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

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

@phildunlap said:

values.push(sens.prev(MINUTE, 1).firstValue)

...
values.push(sens.prev(MINUTE, n).firstValue)

thanks, this seems exactly what i need.

one other request, where do i find documentation on what you have described above e.g. prev(MINUTE,1).firstvalue - what other functions etc are there which could be used ?

@phildunlap said:

The best way to do this is with a meta point. Write the code necessary to get all your points into an array, here's some code I stole:

values.push(sens1.value)
...
values.push(sensN.value)

Hope that helps.

Thanks for the quick response, a clarification please :-

sens1.value 
.... 
sensN.value 

wont this be value of n different points, i need to get the last n values of the same point into the array, how can i do that ?

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...

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...

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 ?

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 ?

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?

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?

@mlohbihler said:

Is there any pattern to when these errors occur, such as a specific time each day?

no not really. I got fed up with them and migrated to mysql, seems to have stopped after that. Overall system performance is also much better.

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 ?

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 ?

Joel, Bob - thanks for the deatils. the hw you have pointed to looks impressive, but is way too expensive for what i have in mind.

Let me elaborate, i am looking for something very simple like a 2 relay device which can be controlled over wireless directly by mango. someting < $30. Looking at the links you have posted and also my own googling, this seems highly unlikely.

this triggers an idea which i want to bounce off you. Using Arduino and the Rf modules which come for it, do you think it is a practical possibility to implement the MODBUS serial protocol over wireless using nRF24L01 modules and arduino MCU? I wanted your opinion on the praticality before i start investing some time in taking this forward.