COmanage Developers List

[Scott Koranda <>]

Hi,

> Maybe an easy question : I'm using comanage-registry-mariadb and I'd
> like to connect using a non-Docker app (PhpStorm), do you know if
> that's possible ?

It should be possible.
 
> I tried connecting to localhost/127.0.0.1:3306 and 192.168.0.1:3306
> (as that is the IP shown in 'docker network inspect
> comanage-registry-internal-network'), but no luck.

You need to expose the port outside of the container.

For example, if you are just using 'docker run' then you might do

docker run -d --name comanage-registry-database \
  --network comanage-registry-internal-network \
  -v /docker/var/lib/mysql:/var/lib/mysql \
  -e MYSQL_ROOT_PASSWORD=XXXXXXXX \
  -e MYSQL_DATABASE=registry \
  -e MYSQL_USER=registry_user \
  -e MYSQL_PASSWORD=xxxxxxxx \
  -p 3306:3306 \
  mariadb

You should then find that port 3306 on localhost is "connected to" port 3306
inside the container.

If you are using a compose file then you want something like this in it:

comanage-registry-database:
        image: comanage-registry-mariadb
        volumes:
            - /docker/var/lib/mysql:/var/lib/mysql
            - /docker/run/secrets:/run/secrets
        environment:
            - MYSQL_ROOT_PASSWORD_FILE=/run/secrets/mysql_root_password
            - MYSQL_DATABASE=registry
            - MYSQL_USER=registry_user
            - MYSQL_PASSWORD_FILE=/run/secrets/mysql_registry_user_password
        secrets:
            - mysql_root_password
            - mysql_registry_user_password
        networks:
            - default
        ports:
            - "3306:3306"
        deploy:
            replicas: 1

Thanks,

Scott