Connecting to RDS from Laravel+Docker via bastion server(EC2)

brunt@jp — Wed, 08 Dec 2021 04:09:29 +0000

RDS is configured to connect only from EC2, so if you want to connect to RDS from your local environment, you need to do some work.

In this article, I will briefly show you how to connect to RDS from a Laravel application running in a Docker container in the local environment via a bastion server(EC2).

Original Post

cyublog | Connecting to RDS from Laravel+Docker via bastion server(EC2)

Local Environment

macOS:10.15.7
A docker container running a Laravel application.

$ docker --version
Docker version 20.10.2, build 2291f61

$ docker-compose --version
docker-compose version 1.27.4, build 40524192

Pre-conditions

A bastion server(EC2) which can be accessed from your local environment.
An AWS RDS which can be accessed from the bastion server.

Workflow

Create a SSH tunnel.
Check the connection from the local machine (Mac) and from the Docker container.
Modify the .env file so that the Laravel app can connect to the RDS.

SSH tunnel

First, create a SSH tunnel.

ssh -N -L 3333:[RDS endpoint]:[RDS port] -i [pem file of bastion server] -p 22 [EC2 user]@[bastion ip]

This time, set the port number of 3333 with RDS.

Once it is created, check it with a command.

Check the connection from the local machine

Run the following command in a terminal on your local machine to confirm.

mysql -h 127.0.0.1 -u [USER NAME] -p -D [DATABASE NAME] -P 3333

Check the connection from Docker container

Enter thr Docker container, then run the following command to check the connection.

Note that the host must be host.docker.internal.

mysql -h host.docker.internal -u [USER NAME] -p -D [DATABASE NAME] -P 3333

Modify DB settings of Laravel application

Next, modify the .env file of your Laravel application.

DB_HOST=host.docker.internal
DB_PORT=3333
DB_DATABASE=[DATABASE NAME]
DB_USERNAME=[USER NAME]
DB_PASSWORD=[PASSWAORD]

Finally, check it in your Laravel application.

Send A Slack Notification Automatically When A Release Is Published On Github

brunt@jp — Tue, 07 Dec 2021 03:12:05 +0000

This article will show you a way how to send a notification automatically after you published a release on github.

This way will include Github Actions and Slack Incoming Webhook.

Original Source

cyublog | Send A Slack Notification Automatically When A Release Is Published On Github

Purpose

Create github release.
　　↓
Publish the github release.
　　↓
Automatically send a message which contains tag_name, author, release body, github url of the release to slack.

Process

Prepare Slack Incoming Webhook Url

Follow this article Incoming webhooks for slack, and we will get a url that can be use in Github Actions to send messages.

Github

Here are two things has to do.

set the slack incoming webhook url to the Actions secrets.
Create a Github Actions workflow.

Actions secrets

Go to the github repository,
click Settings tab -> Secrets -> New repository secret.
-> Name: SLACK_WEBHOOK_URL, Value: The slack incoming webhook url.

Workflow

1. Go to the github repository, click the actions tab to open the github actions page.

(The page link maybe https://github.com/{user_name}/{repository_name}/actions.user_name, repository_name must be changed to yours.)

2. Create a New workflow.

I will create my workflow, so click set up a workflow yourself link to open a basic workflow.

Enter the workflow file name and edit the contents.

Here is the contents of workflow file.

name: ReleaseNotice
on:
  release:
    types: [published]
  workflow_dispatch:
jobs:
  build:
    runs-on: ubuntu-latest
    steps:
      # To check the github context
      - name: Dump Github context
        env:
          GITHUB_CONTEXT: ${{ toJSON(github) }}
        run: echo "$GITHUB_CONTEXT"
      - name: Slack Notification on SUCCESS
        if: success()
        uses: tokorom/action-slack-incoming-webhook@main
        env:
          INCOMING_WEBHOOK_URL: ${{ secrets.SLACK_WEBHOOK_URL }}
        with:
          text: A release is published.
          blocks: |
            [
              {
                "type": "header",
                "text": {
                  "type": "plain_text",
                  "text": "${{ github.event.release.tag_name}} is published!"
                }
              },
              {
                "type": "section",
                "text": {
                  "type": "mrkdwn",
                  "text": "*Author:*\n${{ github.actor }}"
                }
              },
               {
                "type": "section",
                "text": {
                  "type": "mrkdwn",
                  "text": "*Information:*"
                }
              },
              {
                "type": "section",
                "text": {
                  "type": "mrkdwn",
                  "text": ${{ toJSON(github.event.release.body) }}
                }
              },
              {
                "type": "section",
                "text": {
                  "type": "mrkdwn",
                  "text": "${{ github.event.release.html_url }}"
                }
              }
            ]

3. Start Commit

You can commit it to main branch or other branch to let the workflow be launch.

Test

The workflow will be launched when you publish a release from the branch that the workflow is committed.

Now, create a new release and published it. You will see the message is send to your slack channel.

That’s all. I hope this will help you.

DEV Community: brunt@jp

Connecting to RDS from Laravel+Docker via bastion server(EC2)

Original Post

Local Environment

Pre-conditions

Workflow

SSH tunnel

Check the connection from the local machine

Check the connection from Docker container

Modify DB settings of Laravel application

Send A Slack Notification Automatically When A Release Is Published On Github

Original Source

Purpose

Process

Prepare Slack Incoming Webhook Url

Github

Actions secrets

Workflow

1. Go to the github repository, click the actions tab to open the github actions page.

2. Create a New workflow.

3. Start Commit

Test