Analytics Workbench Setup with netbeans using postgresSQL
After cloning the project please make sure that you put the “Components” and “UI” in the same address and parent folder otherwise you need to change the addresses for output_results in TableViewerAgent.java and MetaAnalysisAgent.java file in their components. Other solution could edit the result configuration in “sisob.config” file which is not recommended.
Components
Requirements:
- Current JDK
- PostgreSQL
- R Project
Current JDK
find the current version according to your operation system JDK
PostgreSQL
-
create database “workbench” and a corresponding user with all rights granted for the DB.
- initialization on MacOs
- Setting Up PostgreSQL on MacOs
Start manualy postgrade, you can observe the connections.
postgres -D /usr/local/var/postgres
Stop manually postgrade
pg_ctl -D /usr/local/var/postgres stop -s -m fast
if you got the “Too many clients issue” please check the guide on the WIKI folder: https://github.com/AnalyticsWorkbench/Components/wiki/Bugs-and-errors
R Project
-
R (https://cran.r-project.org/)
- install necessary R packages (Runiversal, igraph, blockmodeling, fpc, Matrix, dplyr)
Open the cmd of the R enviroment and write the command:
- install.packages(c(Runiversal”,”igraph”,”blockmodeling”,”fpc”,"Matrix", "dplyr"))
to de bug easier the requirements we can try them seperatly :
install.packages(c(pkgs="dplyr"))
to install with the R user interface please check this video
Workbench UI
Requirements:
- Redis is requierd to run the workbench.js on the frontend:
Redis
download the project and follow the readme.md for make and run.https://redis.io/download or directly from AnalyticsWorkbench/Redis
https://redis.io/download or on Windows https://github.com/dmajkic/redis/downloads or you can clone from Github directly from: (recommanded) extra package: https://github.com/antirez/redis To run Redis with the default configuration just type in terminal or cmd:
% cd src
% ./redis-server
To shut down the redis server Either connect to node instance and use shutdown command or if you are on ubuntu you can try to restart redis server through init.d:
/etc/init.d/redis-server restart
or stop/start it:
/etc/init.d/redis-server stop
/etc/init.d/redis-server start
On Mac systems
redis-cli shutdown
-
NodeJS (https://nodejs.org)
- install necessary module by executing node, navigationg into “webworkbench” and executing „npm install“ (in the terminal/comand line) in the „webworkbench“ directory
npm install
Create folders and files (if they are not already there):
-
Folder “results”: the folder which is used to server analysis results
-
Folder “security”: the folder containing certificates for https/wss
- nodeworkbench.key - private key file
- nodeworkbench.crt - certificate file (filename is an example, may be configured)
Installation
1. Change sisob.config to local settings:
## hostname for message connection
server.message.name=localhost
## internalname for message connection (e.g. database for PSQL)
server.message.internalname=workbench
## internalname for data connection (e.g. database for PSQL)
server.data.internalname=workbench
## port for message connection
server.message.port=5432
## main could be 1883 2525 or 5432
## internalname for message connection (e.g. database for PSQL)
server.message.internalname=workbench
## username for message connection
server.message.username=workbench
## password for message connection
server.message.password=workbench
## location of the Rscript executable
rwrapper.executable=/usr/lib/R/bin/Rscript or on Windows usually C:\\Program Files\\R\\R-3.x.x\\bin\\Rscript.exe
## directory for the created output
slideshow.serverdir=path_to_project/webworkbench/results/
## directory from which the uploader offers files
upload.directory=path_to_project/webworkbench/upload files
## directory in which the resultcollector searches for created results
results.filelocation=path_to_project/webworkbench/results/
## -----------------------EXTRA ----------------------------------------------
## ----- set data connection here -----
## which backend for data communication (currently ftp, postgresql)
server.data=postgresql
## hostname for data connection
server.data.name=localhost
## port for data connection
server.data.port=5432
## username for databackend if needed
server.data.username=workbench
## password for databackend if needed
server.data.password=workbench
##md5906943237b36364eeacc1ff6ea3c0ae0
##server.data.password=workbench
## ----- set message connection here -----
## which backend for message communication (currently mqtt, postgresql)
connection.type=SINGLE
server.message=mqtt
server.message=postgresql
2. Initialise DB
In UI folder: - Run usercreator.js (Initial admin user (user:admin, pwd:admin-pw) and regular user (user:user, pwd:user-pw) will be created - Run postgresinitializer.js (node postgresinitializer.js)
In components folder
- Run Maven build
mvn clean install - Run postgresinit.java in executer folder with your IDE
3. Startup
– Start the UI – Start redis-server – Start postsql-server – Run node server (node workbench.js) in webworkbench folder (Server listens at localhost:3081) – Start the components framework: – Run components/components-executor/Executor.java (All analytics components listed in executor.xml will be started)
Kick off workbench run local server video
PROBABLE ERRORS
### Package does not exist
After execution if you got error import java.time.format.DateTimeFormatter; import java.time.temporal.TemporalAccessor;
Package does not exist, it might be the IDE change your defult java version because of other projects. e.g. from JAVA 8 to JAVA 10. accepteble version for current Workbench is 1.8 according to this figure:
JDK Version problem
Error:java: javacTask: source release 7 requires target release 1.7
need to surf on server to know more about Sisob Workbench ? https://descartes.inf.uni-due.de:3081/workbench
New interface with react: https://descartes.inf.uni-due.de:3081/ClientV2
contact us for more information: https://www.collide.info/en/mitarbeiter