PHP interface for TellStick, HomeAutomation v2.0.2 released!

[tom_rosenback]

Hi all.
HomeAutomation v2.0.2 has been released.

For those of you that haven't been following the thread (http://telldus.se/forum/viewtopic.php?t=212) about HomeAutomation from its beginning, it is a web interface for controlling the Tellstick. HomeAutomation is built on PHP with MySQL as database engine and is licensed under GNU GPL.

If you want to see what HomeAutomation looks like in action, see my page at http://karpero.mine.nu/homeautomation (log in using demo/d3m0). So far HomeAutomation is working on Windows, Linux and Mac.

HomeAutomation v2.0.2 can be downloaded from here.

Latest source code can also be downloaded from our SVN server at
svn://karpero.mine.nu/homeautomation anonymously.

Mantis bugtracker: http://karpero.mine.nu/mantis

Changelog from our Mantis follows:

Code: Select all

v2.0.2 Released 2011-03-09
- [Houseplan] Houseplan shows icons in wrong place for portrait images
- [New functionality] Add possibility to login with parameters in URL
- [General] Add info to login form when incorrect credentials are given
- [Languages] After name should be Last name in english translation
- [Scheduler] Selecting All devices gives error message
- [Houseplan] Houseplan image is not uploaded

v2.0.1 Released 2011-02-28
- [Scheduler] Saving schedule with only a group selected (no devices) gives PHP-warning
- [Installer] Installer complains about database user not having enough privileges.
- [Scheduler] Invalid date formats for AT and SCHTASKS

v2.0 Released 2011-02-16
- [Scheduler] Add possibilty to configure dynamic activation interval
- [Mobile] Change slider back to dropdown
- [Mobile] Menu text needs to be bigger
- [General] Upcoming events displays tomorrow even if it is the day after tomorrow
- [Users guide] Description of different prerequisities needed
- [Users guide] Add Windows UAC notice
- [Scheduler] Add error messages under the activations list also if there is an error in the schedule
- [General] Refer to Users guide.php when config.php is missing

v2.0 RC Released 2011-02-02
- [Scheduler] Rebuilding of scheduler
 - [New functionality] Wakeup light
 - [Scheduler] Add possibility to configure dimlevel
 - [Scheduler] Add possibility to configure random on/off intervals
 - [Configuration] Add settings for dusk/dawn which can be used in scheduler
- [New functionality] Add better ways for users to search for errors
- [Scheduler] Add enable/disable toggler for schedules
- [General] Add configurable macros
 - [General] Changing scenario should affect devices aswell
- [Houseplan] Make the houseplan image the have dynamic width/height
- [New functionality] Grouping of devices
 - [General] All on/off for groups of devices
-  [Devices] Use slider instead of Dropdown box
- [Tellstick] Devices doesn't always react when they should
- [Configuration] Make houseplan configuration easier to lineup
- [Devices] Toggling abs dimmer doesn´t change the value in the dropdown
- [Configuration] Show the devices in groups in dropdown in dynamic scheduler activation
- [Log] Make logs folder non readable from web
- [Installer] Add optional info sharing in the end of installation procedure
- [Installer] Add pre-requisities check before starting installation
- [Installer] Add license agreement
- [General] Add grouping of devices, that can be used in tasks and in devices list
- [Configuration] Change sort order of latitude and longitude
- [Installer] Change the way read/write permissions are checked
- [General] Make read/write permissions configurable
- [Configuration] Custom icon for ON status not saved correctly
- [Scheduler] Add comment field to schedules
- [General] Code needs comments

v1.2.2 Released 2010-11-08
- [Mobile] Mobile GUI
- [General] Saving the first scenario gives the impression that it is selected
- [General] Remove root_url from config since this isn´t needed.
- [Tdtool] Add more debug messages when toggling devices
- [General] Move all.css to subfolder
- [Scheduler] Change sort order of schedules for better readability
- [General] Add config_default.php including default values for fallback
- [Mobile] Theme doesn´t seem to have affect on page
- [Languages] Wrong variable name in install_en.php
- [Help] Remove link Mobile to Full (and vice versa) from Help

v1.2.1 Released 2010-10-27
- [General] Move debug information to bottom of page.
- [Tdtool] Engineheater schedules are activated immidiately even if they shouldn´t.
- [Scheduler] Schema with both on and off and off on next day doesn´t work.
- [New functionality] Add link from full to mobile version and vice versa.

v1.2 Released 2010-10-19
- [Help] Show help in installer
- [General] Getting some warnings and notices from tdtool
- [General] Getting error when user session timed out or overtaken by another application
- [Readme] Add info about that user has to create the database first
- [Readme] Add permission info for tdtool
- [General] Add error messages in the top of the page if vital paths are not working
- [Tellstick] Log actions on stick to file.
- [Configuration] Add configuration page for temperature sensors
- [Devices] Allow users to have custom icons for all devices
- [General] Auto reload of page
- [Scheduler] Updatetasks.php doesn´t execute on certain operating systems
- [Houseplan] Show graph for temperatures when clicking on them in houseplan view
- [General] Infobox calculates sun dependant schedules wrong
- [Tdtool] Dongle lock doesn´t work after making tdtool to run in background
- [General] \\ becomes \ and \ is completely removed
- [Log] Log IP instead of text "local" / "Hemma"

v1.1.1 Released 2010-04-15
- [Installer] Configured devicetype is not selected.
- [Scheduler] JT.exe causes unhandled exception.
- [Scheduler] Combination of different devicetypes in schedules doesn´t work as expected.
- [Houseplan] Removed devices aren't removed from houseplan.
- [Configuration] Unable to edit or delete created scenarios.
- [Configuration] Need to take summer/winter time into account when calculating sunrise/sunset.

v1.1
- [Database] Eventlogging with dimlevel true/false is not handled as numeric 1/0 by some database engine versions.
- [Installer] Fix the install script to handle updates as well.
- [General] Verify Mac compatibility.
- [Tdtool] Commandline reports "You are not allowed here" for some OS.
- [Languages] Translate to finnish.
- [General] Add licensing to pages.
- [Tellstick] Verify absolute dimmer function.
- [General] Mobile version.
- [Configuration] Need possibility to clear houseplan configuration.
- [Installer] Install doesn´t seem to understand åäö on some computers.
- [General] Add setting to hide/show the infobox.
- [Scheduler] Add ability to force next event to run now.
- [Log] Add sort, limit, clean.
- [Database] Make queries injection proof.
- [Languages] Add translation support.
- [Database] Make queries support single backslash.
- [Tellstick] Make PHP execute exec in background.
- [Tellstick] Make schedules use last dimlevel.
- [General] Add index.php to links and forms.
- [General] Add configuration for default page.
- [Scheduler] Implement new scenario model.
- [Configuration] Manage scenarios.
- [Languages] Fix languages for settings in database.
- [Languages] Add fallback to english.
- [General] Theming.
- [Languages] Translate to english.
- [General] Add help pages.
- [General] Add info box showing sun rise, sunset, next event.
- [Configuration] Possibility to configure what IP addresses are considered "local".
- [General] Show Scenario setting on houseplan page, eg. Home, Away... 

Screenshots on v1.1.1



All comments, suggesstions and questions are welcome!

HomeAutomation now have a homepage of it own, check it out: http://karpero.mine.nu/ha

Enjoy!

[coldpenguin]

In case anyone else tries, I could not get the SVN copy to work at all.
Going to the web-page http://127.0.0.1/homeautomation/ came up with a white page (tried to download /.css which didn't exist), asking for username and password.

Downloading the zip file, the page correctly comes up blue, and starts installation (no username and password).

[tom_rosenback]

In case anyone else tries, I could not get the SVN copy to work at all.
Going to the web-page http://127.0.0.1/homeautomation/ came up with a white page (tried to download /.css which didn't exist), asking for username and password.

Downloading the zip file, the page correctly comes up blue, and starts installation (no username and password).

Reason to why SVN version doesn´t go to the installer is that in index.php the call to checkInstallation is commented out. If you aren´t a developer, stick to the zip, otherwise you are welcome to use the SVN version.

How did you download from SVN? Checkout complete homeautomation folder is the right way.

[tom_rosenback]

Here comes a bugfix release, v1.1.1.

Changelog:

Code: Select all

v1.1.1 Released 2010-04-15
- [Installer] Configured devicetype is not selected.
- [Scheduler] JT.exe causes unhandled exception.
- [Scheduler] Combination of different devicetypes in schedules doesn´t work as expected.
- [Houseplan] Removed devices aren't removed from houseplan.
- [Configuration] Unable to edit or delete created scenarios.
- [Configuration] Need to take summer/winter time into account when calculating sunrise/sunset.

Download HomeAutomation v1.1.1 here and install.

[coldpenguin]

I did a full check-out via:

svn co svn://karpero.mine.nu/homeautomation/ ./homeautomation/

I would like to do some dev work, but I am very short on time at the moment. I was going to write my own scheduler working off of an excel/csv as a backend, but as I saw yours already done, I thought it was preferable! Might be worthwhile modifying the install text to state which items have been disabled from SVN.

[tom_rosenback]

I did a full check-out via:

svn co svn://karpero.mine.nu/homeautomation/ ./homeautomation/

I would like to do some dev work, but I am very short on time at the moment. I was going to write my own scheduler working off of an excel/csv as a backend, but as I saw yours already done, I thought it was preferable! Might be worthwhile modifying the install text to state which items have been disabled from SVN.

Seems like you have checked out the source code ok. What is it that you are missing from HomeAutomation? We have a pretty large todo list, and maybe the things you want to be in are already on our todo.

[svenlind]

Hello Tom,

Nice work

I have done a just a little PHP coding, and I have a question regarding the scheduler.

How is PHP functions runnned on timming ?
Is your homeautomation server working standalone ? Or must there be a logged in user active (a browser (HTTP client) polling your server) ?

How does scheduler work ?

Keep up the good work

-Sven

[tom_rosenback]

Hello Tom,

Nice work

I have done a just a little PHP coding, and I have a question regarding the scheduler.

How is PHP functions runnned on timming ?
Is your homeautomation server working standalone ? Or must there be a logged in user active (a browser (HTTP client) polling your server) ?

How does scheduler work ?

Keep up the good work

-Sven

Thank you Sven! I, or more correct, We will try our best to keep up the pace of this project.

I´m not sure if I understood what you were looking for as an answer but I will try my best to sort out your questions.

HomeAutomation uses OS schedulers. On Windows it uses Windows Scheduler which is found in the Control Panel and on Linux/Mac it uses Crontab and AT. On Windows it requires that the user is logged in but nothing else. On Linux/Mac the user which Apache uses need to have the correct privileges to run Crontab/AT.

So, Yes it is standalone only using inbuilt application in the OS, no polling needed, it manages all by itself.

[ungedanielsen]

I have to say.. This is great work. Had a hard time getting everything up and running, but that had nothing to do with your code

The issues I had was all about getting apache,php and mySQL to work. (Yes, I'm "new" to ubuntu,php,apache and mySQL)

The last issue was setting permission on /dev/tellstick, but it is all solved now, and I can start playing with it. (I'm at work now, and I was smart to turn off the router through your fantastic software, so it DOES work )

To bad I hadn't implemented the cron-job to check network-status. (It would have turned the modem on again)

Guess I'll have to wait until I get home

[tom_rosenback]

I have to say.. This is great work. Had a hard time getting everything up and running, but that had nothing to do with your code

The issues I had was all about getting apache,php and mySQL to work. (Yes, I'm "new" to ubuntu,php,apache and mySQL)

The last issue was setting permission on /dev/tellstick, but it is all solved now, and I can start playing with it. (I'm at work now, and I was smart to turn off the router through your fantastic software, so it DOES work )

To bad I hadn't implemented the cron-job to check network-status. (It would have turned the modem on again)

Guess I'll have to wait until I get home

Great! Yes there are a few things that needs to be solved regarding configuration of the OS and the apps installed but other than that HomeAutomation should work without any problems.

Hehe nice with turning of the router...

Welcome back in the evening if you have any questions!

[ungedanielsen]

Up and running again!

I have now a job running every minute (debug) that checks if my connection is up. If not, it turn off the router, wait 10 sek, and then turn it back on.

Now I have to figure out how to actually get schedules to work, Any quick tip that can save me "minutes" of googling?

And one more question: I was wanting a random thing for when I'm not home. Like: Turn on the TV at some time between 20:00 and 01:30 ++

Have you thought about this?

~Unge Danielsen

[tom_rosenback]

Up and running again!

I have now a job running every minute (debug) that checks if my connection is up. If not, it turn off the router, wait 10 sek, and then turn it back on.

Now I have to figure out how to actually get schedules to work, Any quick tip that can save me "minutes" of googling?

And one more question: I was wanting a random thing for when I'm not home. Like: Turn on the TV at some time between 20:00 and 01:30 ++

Have you thought about this?

~Unge Danielsen

Good job! If you still need help with the schedules, just ask!

As of the random thing, yes we have it on our TODO list and it will most probably be in the next release.

HomeAutomation now have got a homepage of its own, check it out here http://karpero.mine.nu/ha

[tom_rosenback]

I opened up the bugtracker for anonymous reading today. The bugtracker can be found here http://karpero.mine.nu/mantis

If you find anything you in Mantis that could improve HomeAutomation in some way, please post it here or send us an email or contact us through the homepage http://karpero.mine.nu/ha

[tom_rosenback]

Happy news for you!

HomeAutomation v1.2 is now released and can be downloaded from http://karpero.mine.nu/ha/index.php?page=download.

So what has happened from previous release?

The biggest change in v1.2 is that the page does no longer need to be reloaded everytime you click on something that is related to a device, eg. activation of a device, running a schedule from the infobox, etc. For those who have 1-wire configured with HomeAutomation can now enjoy the graphs (latest 24h) that show when clicking on a temperature on the houseplan view. The status icons and temperatures are now updated without needing to reload the page, that is if a schedule is run in the background the device statuses will automatically updated and you are always up-to-date, also the infobox is updated. Custom icons for all devices is now also supported, look in Configuration => Handle devices => Edit a device. + a lot of small fixes.

The reason for the significant growth of the ZIP-file is that jpgraph and fancybox is now included in the package, that´s why.

In a nutshell that should be it, look in the Mantis changelog for more details.

Download and enjoy in the dark autumn!

best regards, Daniel and Tom

[tom_rosenback]

A bugfix release v1.2.1 has now been released, the major change in this version is that the engineheater function now works as expected again. Otherwise there is just small fixes, check Mantis changelog for further details.

Download from here: http://karpero.mine.nu/ha/index.php?pag ... d&hl=en_US