OHDSI Home | Forums | Wiki | Github

Arachne Data Node


(Ajit Bikram Mishra) #1

Hi All,

I dont see a lot of topics about Arachne , and very few documentation here and there.
I am struggling to setup the architecture.
I am almost done setting up the central node but when I register the data node api to my central node api , I can’t log in or register a new user on the data node UI (https://localhost:8880/)
Could you please help me registering the 1st user ?


(Alex Cumarav) #2

Hello @ajitbikram,
Your datanode should be configured to authenticate against your instance of the central. The first logged-in user will become data node admin.

For the localhost you may want to try to build the apps with the dev profile. In that case, you can reuse default settings.

If you have Postgres and Solr configured according to the:

Try this script - it should do the job:

#!/bin/bash

   mkdir arachne
   cd arachne

#BUILD
   git clone --branch develop git@github.com:OHDSI/ArachneCentralAPI.git
   git clone --branch develop git@github.com:OHDSI/ArachneNodeAPI.git
   mvn clean package -f ArachneCentralAPI/pom.xml -DskipTests -DskipDocker -DnoCheckstyle -Pdev,default
   mvn clean package -f ArachneNodeAPI/pom.xml -DskipTests -DskipDocker -DnoCheckstyle -Pdev,default

#RUN
#Given that Postgres databases created and accessible: ARN ARP on 127.0.0.1:5432 for the ohdsi/ohdsi

export JASYPT_ENCRYPTOR_PASSWORD=jasyptpass
export SPRING_DATASOURCE_PASSWORD='TCjtH8GQ958PrEGvURIRUA=='

java  -jar ArachneCentralAPI/target/portal-exec.jar "--spring.datasource.url=jdbc:postgresql://127.0.0.1:5432/arp" --office.home=/usr/lib/libreoffice/ --portal.urlWhiteList=https://localhost,https://127.0.0.1  "--spring.mail.password=eight_starts" &


java -jar ArachneNodeAPI/target/datanode-exec.jar "--datanode.arachneCentral.host=https://localhost"  --datanode.arachneCentral.port=8080  '--spring.datasource.url=jdbc:postgresql://127.0.0.1:5432/arn'  &

echo 'Both datanode and central are starting....'

# add admin to your user: INSERT INTO users_roles (user_id, role_id) VALUES ((SELECT id FROM users_data WHERE email = 'youruser@EXAMPLE.COM'), (SELECT id FROM roles WHERE name = 'ROLE_ADMIN'));

#enable account if necessary: select username, enabled, email_confirmed from users_data;

(Ajit Bikram Mishra) #3

Hi @acumarav , Thank you but for me the central node stands in another server , both datanode and centralnode are not running on same server. So when i register the datanode to the central node with below command :

java -jar target/datanode-exec.jar --datanode.arachneCentral.host=https://<this is an URL available on web, open to all> --datanode.arachneCentral.port=443 --jasypt.encryptor.password= “–spring.datasource.password=ENC(pass)” “–spring.mail.password=ENC(pass)” --spring.datasource.url=jdbc:postgresql://localhost:5432/datanode

I see below error with my first log on try :
An error has occurred. Please contact system administrator

org.springframework.web.client.ResourceAccessException: I/O error on POST request for “https://localhost:8080/api/v1/auth/login”: Unrecognized SSL message, plaintext connection?; nested exception is javax.net.ssl.SSLException: Unrecognized SSL message, plaintext connection?

Could you please help ?


t