Designer local server

276 views
Skip to first unread message

Pierre Pierrot

unread,
Oct 31, 2017, 1:17:10 PM10/31/17
to openremot...@googlegroups.com
---- Openremote Setup on a Linux Server ----


It was tested on Ubuntu 12.04 LTS, Ubuntu 13.10, Ubuntu 14.04 LTS, Ubuntu 16.04 LTS and Debian 7 Wheezy


sudo apt-get install subversion openjdk-6-jdk ant tomcat7 mysql-server


!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


sudo service tomcat7 stop


This document assume that you're starting in your user home directory (/home/<user> in this case). You MUST replace <user> with your actual username.



Create the Download directory :


mkdir openremote_sources

cd /home/<user>/openremote_sources/


!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

DOWNLOAD SOURCES


gwt-2.4.0 :


unzip gwt-2.4.0.zip



Beehive :


unzip Beehive_OpenRemote_2_5_1_20160606.zip



Designer macfly:




Designer 2.5 :


unzip Designer_2_5_4_20161123.zip


!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Create Logs directories and set permissions :


sudo mkdir -p /var/log/openremote/beehive

sudo mkdir -p /var/log/openremote/designer

sudo chown -R tomcat7:tomcat7 /var/log/openremote



!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

--- BEEHIVE 2.5 ---


cd /home/<user>/openremote_sources/Beehive-Beehive_OpenRemote_2_5_1_20160606/ 




PREPARE DATABASE

Create DB :

 mysql -u root -p 
 mysql> CREATE DATABASE beehive DEFAULT CHARACTER SET utf8;
 exit


Import sql template into the db :

mysql -u root -p beehive < ./sql/import.sql



MODIFIED CONFIG FILES

Here is the lines froms configs file you must modify with your text editor (nano in this case):


 nano ./build.properties

 tomcatconfig.dir=/var/lib/tomcat7/conf
 tomcatlog.dir=/var/lib/tomcat7/logs
 tomcat.home=/var/lib/tomcat7
 # deploy.dir=/var/lib/tomcat7/webapps
 


nano ./config/config.properties

jdbc.url=jdbc:mysql://localhost:3306/beehive?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8
 jdbc.username = root
 jdbc.password = yourDBpassword
 work.dir = /var/lib/tomcat7/webapps/beehive
 icons.dir = http://yourIPserver:8080/beehive/icons/         
 


nano ./config/log4j.properties

 log4j.appender.errors.File = /var/log/openremote/beehive/errors.log
 log4j.appender.errorshtml.File = /var/log/openremote/beehive/errors.html
 log4j.appender.beehive.File = /var/log/openremote/beehive/beehive.log
 log4j.appender.beehivehtml.File = /var/log/openremote/beehive/beehive.html
 log4j.appender.hibernate.File = /var/log/openremote/beehive/hibernate.log
 log4j.appender.hibernatehtml.File = /var/log/openremote/beehive/hibernate.html
 log4j.appender.spring.File = /var/log/openremote/beehive/spring.log
 log4j.appender.springhtml.File = /var/log/openremote/beehive/spring.html



--- COMPILLING ---

  ant war 



Copying the output .war file to Tomcat directory :


sudo cp ./output/beehive.war /var/lib/tomcat7/webapps/

sudo service tomcat7 start




 You can test now with your web browser :  http://yourIPserver:8080/beehive



!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

--- DESIGNER macfly---


cd /home/<user>/openremote_sources/Designer_2_14_0_SNAPSHOT-2014-01-31_MacFly/



MODIFIED CONFIG FILES


 nano ./build.properties 

gwt.sdk = /home/<user>/openremote_sources/gwt-2.4.0
version = 2.14.0 build.date = 2014-01-16
version.name = macfly
# deploy.dir = /designer 




 nano ./config/config.properties

jdbc.url=jdbc:mysql://localhost:3306/beehive?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8
 jdbc.username = root
 jdbc.password = yourDBpassword

 beehive.REST.Root.Url = http://yourIPserver:8080/beehive/rest/ 
 webapp.server.root = http://yourIPserver:8080/designer 




 nano ./config/log4j.properties 

 log4j.appender.user-log.File = /var/log/openremote/designer/users.log
 log4j.appender.cache-log.File = /var/log/openremote/designer/cache.log
 log4j.appender.cache-debug-log.File = /var/log/openremote/designer/cache-debug.log
 log4j.appender.state-log.File = /var/log/openremote/designer/state.log
 log4j.appender.state-debug-log.File = /var/log/openremote/designer/state-debug.log
 log4j.appender.save-log.File = /var/log/openremote/designer/save.log
 log4j.appender.save-debug-log.File = /var/log/openremote/designer/save-debug.log
 log4j.appender.restore-log.File = /var/log/openremote/designer/restore.log
 log4j.appender.restore-debug-log.File = /var/log/openremote/designer/restore-debug.log
 log4j.appender.mail-log.File = /var/log/openremote/designer/mail.log
 log4j.appender.resourceservice-log.File = /var/log/openremote/designer/resourceservice.log
 log4j.appender.resourceservice-debug-log.File = /var/log/openremote/designer/resourceservice-debug.log
 log4j.appender.beehive-log.File = /var/log/openremote/designer/beehive.log
 log4j.appender.beehive-debug-log.File = /var/log/openremote/designer/beehive-debug.log
 log4j.appender.errors.File = /var/log/openremote/designer/errors.log
 log4j.appender.designer.File = /var/log/openremote/designer/designer.log
 log4j.appender.hibernate.File = /var/log/openremote/designer/hibernate.log
 log4j.appender.spring.File = /var/log/openremote/designer/spring.log



TOMCAT CONFIG

You must modifying Tomcat7 config to prevent JasperException (backward compatibility with Tomcat6), append this at the end of the file :


nano /etc/tomcat7/catalina.properties    


 org.apache.jasper.compiler.Parser.STRICT_WHITESPACE= false


sudo service tomcat7 restart



COMPILLING

 ant war


Copy & rename :

sudo cp ./output/Designer-2.14.0-2014-01-16-macfly.war /var/lib/tomcat7/webapps/designer.war



You can test now with your web browser :  http://yourIPserver:8080/designer



Validate A NEW ACCOUNT

If you set the mail server : Create an account and just check your mailbox to click on the link to validate the user.
If not, it will say that the username is not available, but in fact, it was created but not validated. To validate it, modify into beehive database, table user and set "valid" to 1 onto your user line.

 mysql -u root -p beehive 
 mysql> UPDATE `user` SET `valid` = 1 WHERE `username` = 'yourUsername';
 exit



WARNING -----

Designer-macfly serves us only to create accounts, you should not especially use him to design dashboards.

Thus with designer 2.5 I did not find the solution to create accounts we shall use designer-macfly for it!!

Once the accounts created with designer-macfly and validated, it is necessary to move :

Var/lib/tomcat7/webapps/designer.war and/Var/lib/tomcat7/webapps/designer in a new file "designer_old" 

May proceed to the installation of designer 2.5    ------ WARNING



!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

--- Designer 2.5 ---



cd /home/<user>/openremote_sources/Designer-Designer_2_5_4_20161123/



MODIFIED CONFIG FILES


 nano ./build.properties 

gwt.sdk = /home/<user>/openremote_sources/gwt-2.4.0
deploy.dir=/var/lib/tomcat7/webapps 




 nano ./config/config.properties

jdbc.url=jdbc:mysql://localhost:3306/beehive?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8
jdbc.username = root
jdbc.password = yourDBpassword

deviceDiscoveryService.REST.Root.Url = http://yourIPserver:8080/dds/rest/ 
webapp.server.root = http://yourIPserver:8080/designer 




  nano ./config/log4j.properties 

 log4j.appender.user-log.File = /var/log/openremote/designer/users.log
 log4j.appender.cache-log.File = /var/log/openremote/designer/cache.log
 log4j.appender.cache-debug-log.File = /var/log/openremote/designer/cache-debug.log
 log4j.appender.state-log.File = /var/log/openremote/designer/state.log
 log4j.appender.state-debug-log.File = /var/log/openremote/designer/state-debug.log
 log4j.appender.save-log.File = /var/log/openremote/designer/save.log
 log4j.appender.save-debug-log.File = /var/log/openremote/designer/save-debug.log
 log4j.appender.restore-log.File = /var/log/openremote/designer/restore.log
 log4j.appender.restore-debug-log.File = /var/log/openremote/designer/restore-debug.log
 log4j.appender.mail-log.File = /var/log/openremote/designer/mail.log
 log4j.appender.resourceservice-log.File = /var/log/openremote/designer/resourceservice.log
 log4j.appender.resourceservice-debug-log.File = /var/log/openremote/designer/resourceservice-debug.log
 log4j.appender.beehive-log.File = /var/log/openremote/designer/beehive.log
 log4j.appender.beehive-debug-log.File = /var/log/openremote/designer/beehive-debug.log
 log4j.appender.errors.File = /var/log/openremote/designer/errors.log
 log4j.appender.designer.File = /var/log/openremote/designer/designer.log
 log4j.appender.hibernate.File = /var/log/openremote/designer/hibernate.log
 log4j.appender.spring.File = /var/log/openremote/designer/spring.log



COMPILLING

 ant war



Copy & rename :

sudo cp ./output/Designer-2.5.4-2016-11-23-Designer.war /var/lib/tomcat7/webapps/designer.war


You can test now with your web browser :  http://yourIPserver:8080/designer




!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


 
EDIT  OpenRemote-Controller/webapps/controller/WEB-INF/classes/config.properties  ----- FOR SYNCHRONIZED WITH LOCAL DESIGNER ------


#Beehive REST URL to perform online design downloads
beehive.REST.Root.Url = http://yourIPserver:8080/beehive/rest/  



controller.performBeehiveSyncing=false

Pierre Pierrot

unread,
Nov 3, 2017, 6:50:33 AM11/3/17
to OpenRemote
I also recommend you to add in crontab -e ,  these scripts to be able to make regularly a saving of the database and the dashboards.

That will avoid you having to redo everything in case of problem or of restorationof the server.


backup_bdd.sh

#!/bin/bash
#
## on se place dans le repertoire ou l'on veut sauvegarder les bases
#
cd /home/<user>/scripts/backups/

for i in beehive; do

## Sauvegarde des bases de donnees en fichiers .sql
mysqldump --user=root --password=yourDBpassword $i > ${i}_`date +"%Y-%m-%d"`.sql

## Compression des exports en tar.bz2 (le meilleur taux de compression)
tar jcf ${i}_`date +"%Y-%m-%d"`.sql.tar.bz2 ${i}_`date +"%Y-%m-%d"`.sql

## Suppression des exports non compresses
rm ${i}_`date +"%Y-%m-%d"`.sql

done




backup_folder.sh

#!/bin/sh

# Enregistrez ce script sous le nom de backup.sh. Prennez note de son emplacement.

echo "------------------------------------------------------";
echo "- Sauvegarde complète du système";
echo "------------------------------------------------------";
echo "";

echo "Création de l'archive";

# On crée l'archive .tar en précisant entre guillemets les chemins absolus des dossiers à sauvegarder.
tar -cvzf /home/<user>/scripts/backups/backup_`date +"%Y-%m-%d"`.tar.gz "/var/lib/tomcat7/webapps/beehive/resources/" "/var/lib/tomcat7/webapps/designer/modeler_tmp/"
echo "------------------------------------------------------";
echo "";

echo "Vérification de l'existence de l'archive";
# On teste si l'archive a bien été créée
if [ -e /home/<user>/scripts/backups/backup_`date +"%Y-%m-%d"`.tar.gz ]
then
echo ""
echo "Votre archive a bien été créée.";
echo ""
else
echo ""
echo "Il y a eu un problème lors de la création de l'archive.";
echo ""
fi

echo "### Fin de la sauvegarde.  ###";





clean_backups.sh

#!/bin/bash
#
## Supprime les sauvegardes vieilles de plus de 180 jours
#
find /home/<user>/scripts/backups/ -type f -mtime +180 -delete


Reply all
Reply to author
Forward
0 new messages