Wednesday, 1 March 2017

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