fuTelldus - PHP application for sensor-logging
Moderator: Telldus
Re: fuTelldus - PHP application for sensor-logging
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.
-
- Posts: 28
- Joined: Fri Mar 17, 2023 9:45 am
Re: fuTelldus - PHP application for sensor-logging
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
- 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
Re: fuTelldus - PHP application for sensor-logging
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
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
Re: fuTelldus - PHP application for sensor-logging
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.
-
- Posts: 2
- Joined: Fri Mar 17, 2023 9:45 am
Re: fuTelldus - PHP application for sensor-logging
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:/
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:/
Re: fuTelldus - PHP application for sensor-logging
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):
The only thing I'm not getting to work for now is the email schedule.
Edit: email works great! (was reported as spam.. )
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
Edit: email works great! (was reported as spam.. )
Re: fuTelldus - PHP application for sensor-logging
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..
Got everything up and running =)
Just wondering if its possible to get a update with temp+humidity combined on HighCharts like its for RGraph..
-
- Posts: 72
- Joined: Fri Mar 17, 2023 9:45 am
Cron not working
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.
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.
- Attachments
-
- Path is correct to the root of my files on my box
- 2.jpg (91.49 KiB) Viewed 21419 times
-
- Crontab is correctly set up
- 3.jpg (55.89 KiB) Viewed 21419 times
-
- No errors when checking /usr/bin/php /volume1/web/fuTelldus/cron_temp_log.php
- 1.jpg (59.46 KiB) Viewed 21419 times
TellStick Net v17 controller
COCO Technology & Proove switches/dimmers
Oregon THGN132N & Proove sensors
Software: Tasker, Remotestick, Telldus Live, DomoSpeak, TelLIVE Remote, Tellmon
COCO Technology & Proove switches/dimmers
Oregon THGN132N & Proove sensors
Software: Tasker, Remotestick, Telldus Live, DomoSpeak, TelLIVE Remote, Tellmon
Re: fuTelldus - PHP application for sensor-logging
Remember all paths in cron has to be absolute. Your second line is relative.
-
- Posts: 72
- Joined: Fri Mar 17, 2023 9:45 am
Re: fuTelldus - PHP application for sensor-logging
the second line is for another application. it has nothing to do with fuTelldusZapper wrote:Remember all paths in cron has to be absolute. Your second line is relative.
TellStick Net v17 controller
COCO Technology & Proove switches/dimmers
Oregon THGN132N & Proove sensors
Software: Tasker, Remotestick, Telldus Live, DomoSpeak, TelLIVE Remote, Tellmon
COCO Technology & Proove switches/dimmers
Oregon THGN132N & Proove sensors
Software: Tasker, Remotestick, Telldus Live, DomoSpeak, TelLIVE Remote, Tellmon
-
- Posts: 72
- Joined: Fri Mar 17, 2023 9:45 am
Re: fuTelldus - PHP application for sensor-logging
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?
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?
TellStick Net v17 controller
COCO Technology & Proove switches/dimmers
Oregon THGN132N & Proove sensors
Software: Tasker, Remotestick, Telldus Live, DomoSpeak, TelLIVE Remote, Tellmon
COCO Technology & Proove switches/dimmers
Oregon THGN132N & Proove sensors
Software: Tasker, Remotestick, Telldus Live, DomoSpeak, TelLIVE Remote, Tellmon
Re: fuTelldus - PHP application for sensor-logging
Any way to shedule turning On/Off lights at specified time? looks like you can only turn on/of things depending on temperature.
-
- Posts: 72
- Joined: Fri Mar 17, 2023 9:45 am
Re: fuTelldus - PHP application for sensor-logging
Only with Telldus Live Events Pro, starting November 4th... for now.GoffyOne wrote:Any way to shedule turning On/Off lights at specified time? looks like you can only turn on/of things depending on temperature.
TellStick Net v17 controller
COCO Technology & Proove switches/dimmers
Oregon THGN132N & Proove sensors
Software: Tasker, Remotestick, Telldus Live, DomoSpeak, TelLIVE Remote, Tellmon
COCO Technology & Proove switches/dimmers
Oregon THGN132N & Proove sensors
Software: Tasker, Remotestick, Telldus Live, DomoSpeak, TelLIVE Remote, Tellmon
Re: fuTelldus - PHP application for sensor-logging
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.
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.
-
- Posts: 6
- Joined: Fri Mar 17, 2023 9:45 am
Re: fuTelldus - PHP application for sensor-logging
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.
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.
Last edited by johanolzzon on Tue Nov 05, 2013 2:18 pm, edited 1 time in total.