stretch install

get bitbucket repo:

git clone https://rosszfej@bitbucket.org/rosszfej/smarthome.git

mosquitto:

sudo wget http://repo.mosquitto.org/debian/mosquitto-repo.gpg.key
sudo apt-key add mosquitto-repo.gpg.key
cd /etc/apt/sources.list.d/
sudo wget http://repo.mosquitto.org/debian/mosquitto-stretch.list
sudo apt-get update
sudo apt-get install mosquitto mosquitto-clients

test mosquitto:

mosquitto_sub -v -t '#'

mysql install:

sudo apt-get --assume-yes install mysql-server

mysql setup:

sudo mysql -u root -p
CREATE DATABASE OpenHAB;
CREATE USER 'openhab'@'localhost' IDENTIFIED BY '[mysql-password]';
GRANT ALL PRIVILEGES ON OpenHAB.* TO 'openhab'@'localhost';
quit

nodejs: 
http://thisdavej.com/beginners-guide-to-installing-node-js-on-a-raspberry-pi/

curl -sL https://deb.nodesource.com/setup_10.x | sudo -E bash -
sudo apt install -y nodejs

sudo apt-get install npm

npm install nodejs-websocket
npm install mysql
npm install mqtt
npm install mime-types

test nodejs:
node -v

java, openhab:
https://www.admin-enclave.com/en/articles/linux/462-install-openhab-2-x-on-raspberry-pi-on-debian-9-stretch-2.html


sudo usermod -a -G dialout openhab

sudo update-rc.d openhab2 defaults sudo /bin/systemctl start openhab2.service

openhab binding install:

feature:install openhab-persistence-jdbc-mysql
feature:install openhab-persistence-mysql
feature:install openhab-binding-mqtt1
feature:install openhab-action-mqtt
feature:install openhab-binding-mihome

myopenhab

http://docs.openhab.org/addons/io/openhabcloud/readme.html
1. install openHAB cloud connector via Paper UI

2. configuration
uuid
secret key

autostart

sudo npm install forever -g

sudo crontab -e 

add:

@reboot sudo /usr/local/bin/forever start -l /home/pi/smarthome/raspberry/forever.log -a /home/pi/smarthome/raspberry/node/http.js

oh2 securtiy

http://docs.openhab.org/installation/security.html

sudo apt-get update && sudo apt-get install nginx
sudo mv /etc/nginx/sites-enabled/default /etc/nginx/sites-enabled/openhab

sudo nano /etc/nginx/sites-enabled/openhab

server {
listen                          [LISTEN_PORT];
server_name                     [mydomain_or_myip];

location / {
proxy_pass                            http://localhost:[LOCAL_PORT]/;
proxy_set_header Host                 $http_host;
proxy_set_header X-Real-IP            $remote_addr;
proxy_set_header X-Forwarded-For      $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto    $scheme;
}
}


sudo nginx -t
sudo service nginx restart


add securiry:

sudo apt-get install apache2-utils

add the following to the previous file:

auth_basic                            "Username and Password Required";
auth_basic_user_file                  /etc/nginx/.htpasswd;


sudo htpasswd /etc/nginx/.htpasswd [USERNAME]

setup raspberry pi

ftp:
sudo apt-get install -y vsftpd
sudo sed -i 's/#write_enable=YES/write_enable=YES/g' /etc/vsftpd.conf
sudo service vsftpd restart

git:
no need, already installed: sudo apt-get install git
git clone https://rosszfej@bitbucket.org/rosszfej/smarthome.git

install:

cd smarthome/raspberry
sudo chmod +x install
./install
during install enter [mysql-password]

install is different!!!
- java8 !
- mosquitto: sudo apt-get --assume-yes  update is inportant
- sudo sometimes is not enough: sudo su

export /inport mysql database: 
mysqldump -u username -p databasename > filename.sql
mysql -u username -p -h localhost DATA-BASE-NAME < data.sql

mysql setup:
sudo mysql -u root -p
CREATE DATABASE OpenHAB;
CREATE USER 'openhab'@'localhost' IDENTIFIED BY '[mysql-password]';
GRANT ALL PRIVILEGES ON OpenHAB.* TO 'openhab'@'localhost';
quit

Start OpenHab in browser:
select DEMO mode!!!

On paper UI install:
"JDBC Persistence MySQL"
"MySQL Persistence"
"MQQTBinding"
"eBus Binding"
"MQTT Action"

----> Transformations : RegEx Transformation!!!!
----> configuration / system / persitence: JDBC!!!

start oh2 console:
ssh -p 8101 openhab@localhost
pass: habopen

feature:install openhab-transport-serial
feature:list | grep transport-serial

check for passwords:
cd _buda/oh2/services
cat mysql.cfg
cat jdbc.cfg

deploy:
cd
cd smarthome/raspberry
sudo chmod +x deploy
sudo ./deploy _[name]

restart OH2:
sudo systemctl restart openhab2.service

install openhab on Win10

install openhab2:
- download openhab zip
- download JDK 32 bit
- set JAVA_HOME user variable to c:\Program Files\Java\jdk1.8.0_121 or similar

compile xiaomi binding:
- download Openhab1 addons source openhab1-addons-master.zip
- download xiaomi binding source https://github.com/octa22/org.openhab.binding.xiaomigateway org.openhab.binding.xiaomigateway-master.zip
- download apache-maven-3.3.9-bin.zip (set some JAVA_ROOT )
- modify pom.xml in root: add new modeule
- modify pom.xml in binding: add parent
- mvn clean install

there is a bug in xiaomi binding:

 private Float formatValue(String value) {
        if (value.length() == 4)
            return Float.parseFloat(value.substring(0, 2) + "." + value.substring(2));
else if (value.length() == 3)
   return Float.parseFloat(value.substring(0, 1) + "." + value.substring(2));
else if (value.length() == 2)
   return Float.parseFloat("0." + value);
        else
            return Float.parseFloat(value);
    }

mqtt names

heater states: OPEN, CLOSED
heater/house 


pump states: OPEN, CLOSED
pump/ground
pump/upstairs


thermostat states: OPEN, CLOSED
thermostat commands: FORCED_ON, FORCED_OFF, RELEASE
thermostat/livingroom
thermostat/guestroom
thermostat/bedroom
thermostat/room1
thermostat/room2
thermostat/room3


valve states: OPEN, CLOSED, OPENING, CLOSING
valve/livingroom
valve/guestroom
valve/bedroom
valve/room1
valve/room2
valve/room3
valve/towel1
valve/towel2


towel_dryer: WARM_UP, PAUSE, COOLING, OPEN, CLOSED
towel_dryer/towel1
towel_dryer/towel2



heating: OPEN, CLOSED
heating/livingroom
heating/guestroom
heating/bedroom
heating/room1
heating/room2
heating/room3
heating/towel1
heating/towel2


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


shutter states: STOP, UP, DOWN
shutter commands: STOP, UP, DOWN
shutter/livingroom/kitchen
shutter/livingroom/window
shutter/livingroom/big
shutter/livingroom/door
shutter/bedroom/window
shutter/bedroom/door
shutter/bedroom/room1
shutter/bedroom/room2
shutter/bedroom/room3