MySQL connection from Docker action?

[Guite]

Hello,

can I somehow pass a service (specifically a database connection) to a Docker action?

When I try to pass options like this:

with:
    database_user: myUser
    ...
    database_port: "${{ job.services.mysql.ports['3306'] }}"

and use this information inside my entrypoint.sh file

I get the following error:

mysql -h 127.0.0.1 --port 32768 -u myUser -pxy -e "CREATE DATABASE IF NOT EXISTS myDB;"

ERROR 2002 (HY000): Can't connect to MySQL server on '127.0.0.1' (115)

Is there any possibility to map the connection? Or do I need to setup MySQL inside my Docker container?

Thanks for your advice,

Axel

[BrightRan]

There are some of the possible causes of this error:

1) Network failure especially if mysql database server is running on remote host.

2) No mysql server is running on the mentioned host.

3) Firewall blocking TCP-IP connection or other related reasons.

You can try using ping command to test the client-server connectivity, such as “ping 127.0.0.1”.

The following are two Docker container actions for MySQL and docs for MySQL image, maybe you can reference them:

Setup MySQL

Start MySQL

https://hub.docker.com/_/mysql

[Guite]

I already have a MySQL server setup like this:

    services:
      mysql:
        image: mysql:5.7
        env:
          MYSQL_USER: myUser
          MYSQL_PASSWORD: myPass
          MYSQL_DATABASE: myDB
          MYSQL_ROOT_PASSWORD: myPass
        ports:
          - 3306
        options: --health-cmd="mysqladmin ping" --health-interval=10s --health-timeout=5s --health-retries=3

But my special use case is that I do not want to use it directly in the workflow, but within a docker action used by the workflow. I will try to use the default mysql available in virtual environments instead.

[Guite]

This thread at stack overflow contains several possible solutions:

https://stackoverflow.com/questions/24319662/from-inside-of-a-docker-container-how-do-i-connect-to-t...

Is it possible with GitHub actions to call a docker image in host mode by setting/appending

--network=host or --net=host

?

[dakale · Accepted solution]

All containers (job, service, actions) get attached to the same user defined bridge network on the host, meaning all the containers can reach each other over that network, not via the host's localhost networking. From inside your action, you should be able to connect to mysql with hostname mysql (comes from the name of your service) and the default port 

[Guite]

Thank you very much! I'd never found this by myself.

[Nosferican]

If I wanted to connect to a remote webdriver from inside a GitHub Action,

after running

docker run -d -p 4444:4444 --name selenium selenium/standalone-chrome

what address should I use rather than 

localhost:4444

[dakale]

You could run the webdriver as a service container, in which case youd do something like:

services:
  selenium:
    image: selenium/standalone-chrome

 (see https://help.github.com/en/actions/automating-your-workflow-with-github-actions/workflow-syntax-for-...)

That way a docker network will be created, and from inside a container action, you can connect to it via the hostname "selenium" (comes from the service name). So youd just use hostname=selenium, port=4444

Note that in the above example, no port mapping were specified, thats because for user defined bridge networks in docker, all ports are accesible by default, so the application inside the container only needs to actually be listening on 4444

...

We dont currently support adding docker-specific options, like "network", when running container actions so unfortunately you wouldnt be able to create a network, and run your action attached to that network specifically (something like docker run --network ....)

Of course if you are using a javascript action that would be running on the host, so you could connect via localhost (if you ran the selenium container with --network host)

Hope that helps

[zachguo]

What if we have a custom docker container and cannot run it as a service? How can we connect to it?

docker run -d -p 8378:8378 customcontainer:$GITHUB_SHA
curl --retry 10 --retry-delay 5 --retry-connrefused -v http://localhost:8378