Questions about authentication and storage

[Max von Tettenborn]

Hi,

I got two qustions:

1. I am trying to run the Wisemapping Docker container and I would like to persist data. The docs at Docker Hub seem to be missing someting. Under the section "Option 1: Running HSQL within the image storage" there is no mount option in the command. How would that option have to look like?

2. Does Wisemapping have a Proxy Auth feature? I mean a setting (e.g. via environment variable) where you can instruct the app to read the logged-in user from a given http header (which should be configurable). This is useful for hosting app behind a reverse proxy like Traefik. How would I configure it?

Thanks!

[Jean-Marc Chiappa]

Hi Max,

Regarding the option 2 for wisemapping docker : you should add a mount point : --mount type=volume,source=wisemappingdb,target=/var/lib/wisemapping/db

as wisemappingdb is a host directory (automatically created if it doesn't exist)

It works for me.

Regards

jm

[Laurent Goussard]

I also try to run wisemapping with docker behind traefik.

Here is the files I use, but even if wisemapping web ui is running, I can't do anything as  everything I try results with a

org.hibernate.exception.SQLGrammarException: could not prepare statement exception.

.env file:

APP_PROJECT=wisemapping
APP_DOMAIN=map.docker

docker-compose.yml:

version: '3'
services:
  wisemapping:
    image: wisemapping/wisemapping:latest
    container_name: ${APP_PROJECT}-wisemapping
    volumes:
      - ./data:/var/lib/wisemapping/db
    labels:
      - "traefik.http.routers.${APP_PROJECT}-wisemapping.rule=Host(`${APP_DOMAIN}`)"
      - "traefik.http.services.${APP_PROJECT}-wisemapping-service.loadbalancer.server.port=8080"

networks:
  default:
      name: web

I just created an issue regarding this missing volume mounting point, but maybe someone already succeeded ?

[Paulo Veiga]

Hi Le!

I've just updated the docker image documentation. It was not capturing the DB mounting outside the container. 

https://hub.docker.com/repository/docker/wisemapping/wisemapping

Please, let me know if you have any questions,

Paulo

--
You received this message because you are subscribed to the Google Groups "wisemapping-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wisemapping-sup...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/wisemapping-support/aeced65f-4eab-40f2-9be2-3c8770174c9fn%40googlegroups.com.

--

WiseMapping Founder

Paulo Gustavo Veiga

[Laurent Goussard]

Awesome ! Thank you Paulo !

I did adapt a little bit for my docker-compose setup and it now works, thanks

[Mohamed Razeed]

I am also getting above error if try to follow option 2. and I can see below log:
15:24:54.988 [http-nio-8080-exec-9] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - user lacks privilege or object not found: USER in statement [select user0_.colaborator_id as id1_3_, user0_1_.creation_date as creation2_3_, user0_1_.email as email3_3_, user0_.activation_code as activati1_8_, user0_.activation_date as activati2_8_, user0_.allow_send_email as allow_se3_8_, user0_.authentication_type as authenti4_8_, user0_.authenticator_uri as authenti5_8_, user0_.firstname as firstnam6_8_, user0_.google_sync as google_s7_8_, user0_.google_token as google_t8_8_, user0_.lastname as lastname9_8_, user0_.locale as locale10_8_, user0_.password as passwor11_8_, user0_.sync_code as sync_co12_8_ from USER user0_ inner join COLLABORATOR user0_1_ on user0_.colaborator_id=user0_1_.id where user0_1_.email=?]

Help me on this.
Following below step:

Option 2: Running HSQL with a mounted directory.

Only one time, copy the empty default out of the container:

$ mkdir your- db-dir-store-path

$ docker run --name wiseapp -d --mount type=bind,source=your-db-dir-store-path,target=/var/lib/wise-db wisemapping/wisemapping:latest

$ docker cp wiseapp:/var/lib/wisemapping/db your-db-dir-store-path

$ docker stop wiseapp;docker rm wiseapp

Then, execute the container mounting tbe directory:

$ docker run --mount type=bind,source=your-db-dir-store-path/db,target=/var/lib/wisemapping/db -it --rm -p 8080:8080 wisemapping/wisemapping:latest