Skip to content
This repository was archived by the owner on Oct 8, 2020. It is now read-only.

elyobelyob/boiler-scheduler-php

Repository files navigation

boiler-control-php

The frontend to the boiler control program forked from (https://github.com/james-jaynne/boiler-control-php).

This requires the Zend Framework (http://framework.zend.com/) installed to run.

For support please use this Raspberry Pi forum thread http://www.raspberrypi.org/phpBB3/viewtopic.php?f=37&t=22244

Install Instructions

These install instructions are being updated and were more applicable to the original author's README file ... mainly should be ok though.

Update your Pi and install apache, mysql and phpmyadmin

Enter a mysql root password and choose apache2 for phpmyadmin

sudo apt-get update
sudo apt-get install screen apache2 mysql-client mysql-server phpmyadmin

Login to mysql - replace password with your password from above

mysql --user=root --pass=password

Here we create a mysql user (pi) and password for the program. Replace 'password' with the password you would like for the normal pi user - ideally this should be different to the root password

CREATE USER 'pi'@'localhost' IDENTIFIED BY  'password';
GRANT USAGE ON * . * TO  'pi'@'localhost' IDENTIFIED BY  'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE IF NOT EXISTS  `pi` ;
GRANT ALL PRIVILEGES ON  `pi` . * TO  'pi'@'localhost';
exit;

Download the source from github and copy it to the right directories

wget https://github.com/james-jaynne/boiler-control-php/archive/master.zip
unzip master.zip

mysql --user=pi --pass=password pi < boiler-control-php-master/sql/structure.sql
mysql --user=pi --pass=password pi < boiler-control-php-master/sql/data.sql

sudo rm -R /var/www/*
sudo mv boiler-control-php-master/* /var/www
sudo a2enmod rewrite

Here we need to modify the apache setup - ctrl-x exits

sudo nano /etc/apache2/sites-available/default

Change DocumentRoot /var/www to DocumentRoot /var/www/public <Directory /var/www/> to <Directory /var/www/public/> Changes the first two instances of AllowOverride None to AllowOverride All

sudo /etc/init.d/apache2 restart

Edit the config file to enter the mysql password

sudo nano /var/www/application/config/config.ini

Change resources.db.params.password = "raspberry" to reflect your password

Download the zend framework 1 minimal from http://framework.zend.com/ and transfer it to your Pis home directory - you have to do this from your PC using a program like winscp. Change the filenames below to reflect the version you have downloaded

tar -xzvf ZendFramework-1.12.0-minimal.tar.gz
sudo mv ZendFramework-1.12.0-minimal/library/* /var/www/library/
rm -R boiler-control-php-master/
rm master.zip

You're done - you should be able to visit your Pis web page and load up the web frontend

THINGS I WANT TO DO

Keep record of .1 increase decrease whilst heating on. Also heating on off calls in same table. how fast a house heats and cools.Build a target temp option. Should be a learning system with option in schedule. Ignore times extra heating on eg lounge fire, eg move to second node for x hours or ignore unusual heating bursts, eg direct sunshine effect. Work out temp difference for other nodes in case primary node battery/comms dies. Maintain temp setting. Put hearing on early if outside dropping fast and internal ok?

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published