fuTelldus - PHP application for sensor-logging

[stre]

Sorry, dont know the user since the service provider (www.binero.se) sets up the cron-job as a request for the page. The page works if I call it via my browser, but not as the service provider cron-job. The only thing that fails is the OAuth Verification... I sent mails with logging so I got down to the actual problem. I have the base-dir in the config.

[AcidSleeper]

A tip for future fuTelldus update:

- When you are looking at a sensor and showing temperatures my wish is to limit number of posts showing as a standard. But with a scoll-list you can adapt the number of temperature-posts showing on the page. This will reduce the loadingtime of the page if the database contains several thousends posts.

Mvh Niclas

[Baltta]

hey, I try install synology NAS. I get it all most right. But cron job don't work only manually.
When I try that "Setting up CRON on synology DSM" it stop over here. In error line 13

DiskStation> /usr/bin/php /volume1/web/futelldus/cron_temp_log.php
PHP Fatal error: Class 'Mysqli' not found in /volume1/web/futelldus/cron_temp_log.php on line 13

Fatal error: Class 'Mysqli' not found in /volume1/web/futelldus/cron_temp_log.php on line 13

Can sone one help me, please

Baltta

[rogerthn]

I do not have access to a synology NAS but Googles suggestion below might help?

I uncommented this line: "mysqli.allow_local_infile = On" and it worked. That line was the only one commented in the php.ini file.

[Heggholmen]

Hi,
Have installed fuTelldus on my WindowsHomeServer 2011 - and it looks to work half way. I can se my "devices" - and use them, but I don't have the sensor list. Anyone got an idee on how to solve it?

Have also notices that when I try to add a new user - the user table isn't updated. I also found out that sensors is not saved in the database - when "echo" the variables from sensors.php - it shows infoformation.

New observation - when I add a sensor manual in "futelldus_sensors" - the cron_temp_log.php inserts new data when it's runed... Soo - why isn't "sensors" list updated:/

[laban]

Thank you so much for this php-application!!

I installed it on Azure, just to test it. And it works great. The next step is to install it on a Raspberry Pi.

Here is my quick little howto for installing it on Linux (Debian/Ubuntu):

Code: Select all

#apt-get install apache2 php5 mysql-server phpmyadmin unzip
#cd /var/www/
#wget http://fosen-utvikling.no/public/futelldus/fuTelldus_v3.zip
#unzip fuTelldus_v3.zip
#nano/lib/config.inc.php  --> and add you're database credentials
Import the databases from    fuTelldus.sql   located inside /var/www. (I used phpmyadmin. http://domain/phpmyadmin, created a database and importet the sql file)

#apt-get install php-pear php5-dev make   	
#pear install --alldeps --force HTTP_OAuth channel://pear.php.net/HTTP_OAuth-0.2.3

#crontab -e

*/15 * * * * php -q /var/www/cron_temp_log.php
*/5 * * * * php -q /var/www/cron_schedule.php

The only thing I'm not getting to work for now is the email schedule.
Edit: email works great! (was reported as spam.. )

[Borgso]

Thanks for this nice php-app.
Got everything up and running =)

Just wondering if its possible to get a update with temp+humidity combined on HighCharts like its for RGraph..

[individual]

My cron does not work on my Saynology NAS, although everything seems to be set up ok and I receive no errors on verifications.

Only when I manually run schedule from settings, I get the emails, but no automated emails. Even so, it only works when I run schedule once. If I try again after several minutes, I get no mails.

[Zapper]

Remember all paths in cron has to be absolute. Your second line is relative.

[individual]

Remember all paths in cron has to be absolute. Your second line is relative.

the second line is for another application. it has nothing to do with fuTelldus

[individual]

Out of the blue, the cron is working! Maybe it was something in my NAS... but I didn't change anything, so... I don't know what is going on. Thankfully, it works now and emails are coming every 120 minutes.

However, I would like to ask: what is the minimum recommended cron pull time for temperature checking?

Because I have an idea: the receiver of my wireless thermostat just broke, and instead of buying a new one, I would rather modify a 433 MHz receiver to use it as wireless relay for my heater. I would use a temperature sensor as probe and set a schedule where my modified device will be turned on if the temperature is bellow / turned off if the temperature is above the scheduled threshold. And of course, no notification would be needed, unless I would like to know when the heating starts and stops.

Is this feasible?

[GoffyOne]

Any way to shedule turning On/Off lights at specified time? looks like you can only turn on/of things depending on temperature.

[individual]

Any way to shedule turning On/Off lights at specified time? looks like you can only turn on/of things depending on temperature.

Only with Telldus Live Events Pro, starting November 4th... for now.

[kringon]

Are there any live development going on regarding this app? (github-page etc)

I am a seasoned php / java / python developer and i would like to contribute to this project. I know my way arround the bootstrap 2.3 and 3.0 FW, and normal RESTfull services.

Any updates are appreciated.

[johanolzzon]

Wonderful application and also a wonderful tutorial!

However, my sensors (Clas Ohlson 36-1797) works perfectly in Telldus Live but they don't work in fuTelldus. On the sensors page the sensors are shown, but without any temperature or humidity. Also the last update is "43 years since" and no graphs are shown. But if I click on a sensor the average, max and min temperature is 0 but all the data is correct below. Anyone know how to fix this? I've been looking through the code but it's not easy when you're not a developer.

Avrage temperature 0 °
Max temperature 0 °
Min temperature 0 °

ID 1025012
Client name Hemma
Name Nere
Last update 15:09:29 18-10-13 (11 minutes since)
Ignored 0
Editable 1
Temperature 22.8
Humidity 56
Protocol mandolyn
Sensor ID 11
Timezone offset 7200

--------------

EDIT: My bad, I hadn't set up the chron job correctly - so I just followed the instructions and then it worked.