Designer local server

Pierre_Pierrot · November 8, 2017, 4:53pm

---- 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/ in this case). You MUST replace with your actual username.

Create the Download directory :

mkdir openremote_sources

cd /home//openremote_sources/

!!!

DOWNLOAD SOURCES

gwt-2.4.0 :

wget https://storage.googleapis.com/google-code-archive-downloads/v2/code.google.com/google-web-toolkit/gwt-2.4.0.zip

unzip gwt-2.4.0.zip

Beehive :

wget https://github.com/openremote/Beehive/archive/Beehive_OpenRemote_2_5_1_20160606.zip

unzip Beehive_OpenRemote_2_5_1_20160606.zip

Designer macfly:

svn co http: //svn.code.sf.net/p/openremote/code/tags/snapshot/Designer_2_14_0_SNAPSHOT-2014-01-31_MacFly

Designer 2.5 :

wget https://github.com/openremote/Designer/archive/Designer_2_5_4_20161123.zip

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//openremote_sources/Beehive-Beehive_OpenRemote_2_5_1_20160606/

PREPARE DATABASE

Create DB :

mysql -u root -p

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//openremote_sources/Designer_2_14_0_SNAPSHOT-2014-01-31_MacFly/

MODIFIED CONFIG FILES

nano ./build.properties

gwt.sdk = /home//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

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//openremote_sources/Designer-Designer_2_5_4_20161123/

MODIFIED CONFIG FILES

nano ./build.properties

gwt.sdk = /home//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

beehive.REST.Root.Url = http://yourIPserver:8080/beehive/rest/

deviceDiscoveryService.REST.Root.Url = http://yourIPserver:8080/dds/rest/