Deploy server and database using docker

[scriptingislife]

@congto @MinhKMA

I made Dockerfile-server and Dockerfile-db. I'd recommend updating your repos.

The server uses the python container built on top of Alpine. The database uses the MariaDB container.

After cloning this repo I ran these commands to get it up and running. Next I want to link them so the server can communicate with the database.

docker build -f Dockerfile-server .
docker run -d --name mapperserver -p 5000:5000 <build server image>

docker build -f Dockerfile-db .
docker run -d --name mapperdb -p 3306:3306 -e MYSQL_ROOT_PASSWORD=secret <built db image>

Let me know if this works for you. The sensor setup is so simple I'm not sure it needs a container. Also it needs access to the auth.log file.

[congto]

@becksteadn

Sorry, this week I am busy, I am not testing your guide. But I see your missing guide

This docker build -f Dockerfile-server. I think, it is correct docker build -f Dockerfile-server . You are missing dot in comand.

I will test your script over the weekend.
Thanks

[congto]

@becksteadn

I reviewed your docker-compose file (1) . What do you think if the docker-compose using option depends_on ?. Example:

 mapperserver:
    depends_on:
      - mapperdb

Thanks

Ref

(1) https://github.com/becksteadn/Mapper-Server/blob/master/docker-compose.yml#L12-L13

[congto]

Hi @becksteadn

I am trying your guide (1), but I have got error in picture (2). I think, container DB have a problem permission user in picture (3). Please, can you check sql script createdb.sql

Thanks

REF:

(1) #3 (comment)

(2) http://prntscr.com/jmlalo

(3) http://prntscr.com/jmldtl

[scriptingislife]

Yeah the mapperserver user was originally only allowed to access the DB on localhost when I planned on using one container. Now it needs to come from the mapperserver host.

[scriptingislife]

docker-compose up should work properly now. The only thing I'm struggling with is getting the server to delay running draw_map.py until the database is reachable.

Thanks for your suggestions. Docker is a really great platform.