ArcadeData / arcadeanalytics

Arcade Analytics is the first Open Source Graph Analytics platform. Connect your Graph Database (Neo4j, OrientDB, Amazon Neptune, Microsoft CosmosDB, etc) and RDBMS (Oracle, MySQL, Postgres, Microsoft SQLServer, MariaDB) to create powerful dashboards.
https://arcadeanalytics.com
Apache License 2.0
190 stars 30 forks source link

connect to local JanusGraph 0.3.2 #162

Open MayJV opened 5 years ago

MayJV commented 5 years ago

Hey! I'm trying to connect my janusgraph DB as a datasource, but this did not work.

version: '2'
services:
  arcadeanalytics-app:
    image: arcadeanalytics/arcadeanalytics:1.0.3
    environment:
      - SPRING_PROFILES_ACTIVE=prod,swagger
      - SPRING_DATASOURCE_URL=jdbc:postgresql://arcadeanalytics-postgresql:5432/arcadeanalytics
      - SPRING_DATA_ELASTICSEARCH_CLUSTER_NODES=arcadeanalytics-elasticsearch:9300
      - SPRING_EMAIL_HOST=smtp.gmail.com
      - SPRING_EMAIL_PORT=587
      - SPRING_EMAIL_USERNAME=
      - SPRING_EMAIL_PASSWORD=
      - JHIPSTER_SLEEP=10 # gives time for the database to boot before the application
      - JHIPSTER_MAIL_FROM=
      - JHIPSTER_MAIL_BASE-URL=
      - APPLICATION_PATH=/arcade
      - APPLICATION_MEDIAPATH=/content/media/
      - APPLICATION_STORAGE_PATH=/arcade/storage
      - APPLICATION_CONNECTORSPATH=/arcade-connectors
      - JAVA_OPTS=-DSSH_PRIV_KEY=/arcade/.ssh/id_rsa -DSSH_PUB_KEY=/arcade/.ssh/id_rsa.pub
    ports:
      - 8098:8080
    volumes:
      - ~/.arcade/:/arcade/
  arcadeanalytics-postgresql:
    image: postgres:9
    ports:
      - 5452:5432
    volumes:
      - ~/.arcade/arcadeanalytics/postgresql/:/var/lib/postgresql/data/
    environment:
      - POSTGRES_USER=arcadeanalytics
      - POSTGRES_PASSWORD=
  arcadeanalytics-elasticsearch:
    image: elasticsearch:2.4.6
    volumes:
      - ~/.arcade/arcadeanalytics/elasticsearch/:/usr/share/elasticsearch/data/
    environment:
      - "ES_JAVA_OPTS=-Xms4g -Xmx4g"
    ports:
      - 19200:9200
      - 19300:9300
  arcadeanalytics-janusgraph:
    extends:
      file: janusgraph.yml
      service: arcadeanalytics-janusgraph

Any suggestions? Thanks for the help!

MayJV commented 5 years ago

image

arcade-player commented 5 years ago

is the docker container of janus running? what's the output of docker ps?

MayJV commented 5 years ago

yes , janus is running. image

MayJV commented 5 years ago

is the docker container of janus running? what's the output of docker ps

janus is ok. can you help me check the config is true ? Thanks

arcade-player commented 5 years ago

Our mistake. The JanusGraph docker image doesn't have any data inside. We use that image in our tests loading one of the dataset provided with janus distributuon:

https://github.com/ArcadeAnalytics/arcade-connectors/blob/c95890b391fdfa9b9d4238864b1adf5b8ab5d727/gremlin/src/test/kotlin/com/arcadeanalytics/provider/gremlin/janusgraph/JanusgraphTestHelper.kt#L58

We are working toimprove our docker image with dataset preloaded.

MayJV commented 5 years ago

Oh,I've solved the problem. because of my janus config . scripts/empty-sample.groovy is not g

Arcade Analytics is a good tool , Thank you for your contribution. 👍

theZiki commented 4 years ago

Oh,I've solved the problem. because of my janus config . scripts/empty-sample.groovy is not g

Arcade Analytics is a good tool , Thank you for your contribution. 👍

Hi what was your problem? I also have the same problem, but I can't connect to my locally runing JanusGrapsh server, not as docker image.