Dalichecklist.yaml

name: LAMP Stack

on:
  schedule:
  - cron:  '00 19 * * *'
  push:
    branches: [ master ]
  pull_request:
    branches: [ master ]

jobs:
  LAMP-AMD64:
    strategy:
      matrix:
        pv: ["8.2", "8.1", "8.0", "7.4", "7.3", "7.2"]
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v2
      - name: Build the Docker image Apache php ${{ matrix.pv }}
        run: docker-compose -f "docker-compose.yml" up -d --build
        env:
            PHP_VERSION: "${{ matrix.pv }}"
            XDEBUG: true
            DISPLAY_PHPERROR: true
            SERVER_ROOT:  /var/www/
            APP_CODE_PATH_HOST: /tmp/app
            DB_NAME: test
            DB_USER:  admin
            DB_PASSWORD:  password
            DB_ROOT_PASSWORD: password
            DATA_PATH_HOST: /tmp/lamp
            MARIADB_VERSION:  10.7
      - name: PHP version check
        run : docker exec lamp-stack_apache_1 php -v
      - name: Mongodb driver check
        run:  docker exec lamp-stack_apache_1 php -m | grep mongo
      - name: Mysql Driver check
        run: docker exec lamp-stack_apache_1 php -m | grep mysqli
      - name: Composer test
        run: docker exec lamp-stack_apache_1 composer
      - name: Web site Test
        run: |
          docker exec lamp-stack_apache_1 sudo wget -O /var/www/index.php https://raw.githubusercontent.com/deck-app/stack-preview-screen/main/install/index.html
          sudo curl -I --http2 http://localhost:5590/
      - name: Verify MariaDB running from host, create Database and show Database
        run: |
          while ! docker exec lamp-stack_mariadb_1 mysqladmin --user=root --password=password --host "mariadb" ping --silent &> /dev/null ; do
              echo "Waiting for database connection..."
              sleep 2
          done
      - name: Check MariaDB version
        run:  docker exec lamp-stack_mariadb_1 mysql -uroot -ppassword -e "SHOW VARIABLES LIKE '%version%';"
      - name: Verify MariaDB database from user
        run:  docker exec lamp-stack_mariadb_1 mysql -uadmin -ppassword -e "SHOW DATABASES"
      - name: Create a Database
        run:  docker exec lamp-stack_mariadb_1 mysql -uroot -ppassword -e "CREATE DATABASE deckapp"
      - name: Verify Database create or not
        run:  docker exec lamp-stack_mariadb_1 mysql -uroot -ppassword -e "SHOW DATABASES"
      - name: Database connection check
        run: |
          docker exec lamp-stack_apache_1 sudo wget -O /var/www/db.php https://raw.githubusercontent.com/nabad600/apache_php/master/connection.php
          docker exec lamp-stack_apache_1 sudo php /var/www/db.php
      - name: Destroy Container and file
        run:  |
          docker-compose down
          sudo rm -rf /tmp/app
          sudo rm -rf /tmp/lamp
          echo "y" | docker image prune -a
          echo "y" | docker volume prune
      - name: Slack Notification
        uses: rtCamp/action-slack-notify@v2
        env:
          SLACK_CHANNEL: github_action_status
          SLACK_COLOR: ${{ job.status }} # or a specific color like 'good' or '#ff00ff'
          SLACK_ICON: https://github.com/rtCamp.png?size=48
          SLACK_MESSAGE: 'Post Content LAMP ${{ matrix.pv }} AMD64 :rocket:'
          SLACK_TITLE: Post Title
          SLACK_USERNAME: rtCamp
          SLACK_WEBHOOK: ${{ secrets.SLACK_WEBHOOK_URL }}
          SLACK_WEBHOOK_URL: ${{ secrets.SLACK_WEBHOOK_URL }}
  LAMP-ARM64:
    strategy:
      matrix:
        pv: ["8.2", "8.1", "8.0", "7.4", "7.3", "7.2"]
    runs-on: ubuntu-22.04
    name: LAMP-ARM64
    steps:
      - uses: actions/checkout@v4
      - uses: uraimo/run-on-arch-action@v2
        name: Run commands
        id: runcmd
        with:
          arch: aarch64
          distro: ubuntu22.04
          run: |
            uname -a
            echo ::set-output name=uname::$(uname -a)
      - name: Get the output
        run: |
          echo "The uname output was ${{ steps.runcmd.outputs.uname }}"
      - name: Build the Docker image Apache php ${{ matrix.pv }}
        run: docker-compose -f "docker-compose.yml" up -d --build
        env:
            PHP_VERSION: "${{ matrix.pv }}"
            XDEBUG: true
            DISPLAY_PHPERROR: true
            SERVER_ROOT:  /var/www/
            APP_CODE_PATH_HOST: /tmp/app
            DB_NAME: test
            DB_USER:  admin
            DB_PASSWORD:  password
            DB_ROOT_PASSWORD: password
            DATA_PATH_HOST: /tmp/lamp
            MARIADB_VERSION:  10.7
      - name: PHP version check
        run : docker exec lamp-stack_apache_1 php -v
      - name: Mongodb driver check
        run:  docker exec lamp-stack_apache_1 php -m | grep mongo
      - name: Mysql Driver check
        run: docker exec lamp-stack_apache_1 php -m | grep mysqli
      - name: Composer test
        run: docker exec lamp-stack_apache_1 composer
      - name: Web site Test
        run: |
          docker exec lamp-stack_apache_1 sudo wget -O /var/www/index.php https://raw.githubusercontent.com/deck-app/stack-preview-screen/main/install/index.html
          sudo curl -I --http2 http://localhost:5590/
      - name: Verify MariaDB running from host, create Database and show Database
        run: |
          while ! docker exec lamp-stack_mariadb_1 mysqladmin --user=root --password=password --host "mariadb" ping --silent &> /dev/null ; do
              echo "Waiting for database connection..."
              sleep 2
          done
      - name: Check MariaDB version
        run:  docker exec lamp-stack_mariadb_1 mysql -uroot -ppassword -e "SHOW VARIABLES LIKE '%version%';"
      - name: Verify MariaDB database from user
        run:  docker exec lamp-stack_mariadb_1 mysql -uadmin -ppassword -e "SHOW DATABASES"
      - name: Create a Database
        run:  docker exec lamp-stack_mariadb_1 mysql -uroot -ppassword -e "CREATE DATABASE deckapp"
      - name: Verify Database create or not
        run:  docker exec lamp-stack_mariadb_1 mysql -uroot -ppassword -e "SHOW DATABASES"
      - name: Database connection check
        run: |
          docker exec lamp-stack_apache_1 sudo wget -O /var/www/db.php https://raw.githubusercontent.com/nabad600/apache_php/master/connection.php
          docker exec lamp-stack_apache_1 sudo php /var/www/db.php
      - name: Destroy Container and file
        run:  |
          docker-compose down
          sudo rm -rf /tmp/app
          sudo rm -rf /tmp/lamp
          echo "y" | docker image prune -a
          echo "y" | docker volume prune
      - name: Slack Notification
        uses: rtCamp/action-slack-notify@v2
        env:
          SLACK_CHANNEL: github_action_status
          SLACK_COLOR: ${{ job.status }}
          SLACK_ICON: https://github.com/rtCamp.png?size=48
          SLACK_MESSAGE: 'Post Content LAMP ${{ matrix.pv }} ARM64 :rocket:'
          SLACK_TITLE: Post Title
          SLACK_USERNAME: rtCamp
          SLACK_WEBHOOK: ${{ secrets.SLACK_WEBHOOK_URL }}
          SLACK_WEBHOOK_URL: ${{ secrets.SLACK_WEBHOOK_URL }}
  
  LAMP75-AMD64:
    strategy:
      matrix:
        pv: ["7.1", "5.6"]
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v2
      - name: Build the Docker image Apache php ${{ matrix.pv }}
        run: docker-compose -f "docker-compose.yml" up -d --build
        env:
            PHP_VERSION: "${{ matrix.pv }}"
            XDEBUG: true
            DISPLAY_PHPERROR: true
            SERVER_ROOT:  /var/www/
            APP_CODE_PATH_HOST: /tmp/app
            DB_NAME: test
            DB_USER:  admin
            DB_PASSWORD:  password
            DB_ROOT_PASSWORD: password
            DATA_PATH_HOST: /tmp/lamp
            MARIADB_VERSION:  10.7
      - name: PHP version check
        run : docker exec lamp-stack_apache_1 php -v
      - name: Mysql Driver check
        run: docker exec lamp-stack_apache_1 php -m | grep mysqli
      - name: Composer test
        run: docker exec lamp-stack_apache_1 composer
      - name: Web site Test
        run: |
          docker exec lamp-stack_apache_1 sudo wget -O /var/www/index.php https://raw.githubusercontent.com/deck-app/stack-preview-screen/main/install/index.html
          sudo curl -I --http2 http://localhost:5590/
      - name: Verify MariaDB running from host, create Database and show Database
        run: |
          while ! docker exec lamp-stack_mariadb_1 mysqladmin --user=root --password=password --host "mariadb" ping --silent &> /dev/null ; do
              echo "Waiting for database connection..."
              sleep 2
          done
      - name: Check MariaDB version
        run:  docker exec lamp-stack_mariadb_1 mysql -uroot -ppassword -e "SHOW VARIABLES LIKE '%version%';"
      - name: Verify MariaDB database from user
        run:  docker exec lamp-stack_mariadb_1 mysql -uadmin -ppassword -e "SHOW DATABASES"
      - name: Create a Database
        run:  docker exec lamp-stack_mariadb_1 mysql -uroot -ppassword -e "CREATE DATABASE deckapp"
      - name: Verify Database create or not
        run:  docker exec lamp-stack_mariadb_1 mysql -uroot -ppassword -e "SHOW DATABASES"
      - name: Database connection check
        run: |
          docker exec lamp-stack_apache_1 sudo wget -O /var/www/db.php https://raw.githubusercontent.com/nabad600/apache_php/master/connection.php
          docker exec lamp-stack_apache_1 sudo php /var/www/db.php
      - name: Destroy Container and file
        run:  |
          docker-compose down
          sudo rm -rf /tmp/app
          sudo rm -rf /tmp/lamp
          echo "y" | docker image prune -a
          echo "y" | docker volume prune
      - name: Slack Notification
        uses: rtCamp/action-slack-notify@v2
        env:
          SLACK_CHANNEL: github_action_status
          SLACK_COLOR: ${{ job.status }} # or a specific color like 'good' or '#ff00ff'
          SLACK_ICON: https://github.com/rtCamp.png?size=48
          SLACK_MESSAGE: 'Post Content LAMP ${{ matrix.pv }} AMD64 :rocket:'
          SLACK_TITLE: Post Title
          SLACK_USERNAME: rtCamp
          SLACK_WEBHOOK: ${{ secrets.SLACK_WEBHOOK_URL }}
          SLACK_WEBHOOK_URL: ${{ secrets.SLACK_WEBHOOK_URL }}
  LAMP75-ARM64:
    strategy:
      matrix:
        pv: ["7.1", "5.6"]
    runs-on: ubuntu-22.04
    name: LAMP75-ARM64
    steps:
      - uses: actions/checkout@v4
      - uses: uraimo/run-on-arch-action@v2
        name: Run commands
        id: runcmd
        with:
          arch: aarch64
          distro: ubuntu22.04
          run: |
            uname -a
            echo ::set-output name=uname::$(uname -a)
      - name: Get the output
        run: |
          echo "The uname output was ${{ steps.runcmd.outputs.uname }}"
      - name: Build the Docker image Apache php ${{ matrix.pv }}
        run: docker-compose -f "docker-compose.yml" up -d --build
        env:
            PHP_VERSION: "${{ matrix.pv }}"
            XDEBUG: true
            DISPLAY_PHPERROR: true
            SERVER_ROOT:  /var/www/
            APP_CODE_PATH_HOST: /tmp/app
            DB_NAME: test
            DB_USER:  admin
            DB_PASSWORD:  password
            DB_ROOT_PASSWORD: password
            DATA_PATH_HOST: /tmp/lamp
            MARIADB_VERSION:  10.7
      - name: PHP version check
        run : docker exec lamp-stack_apache_1 php -v
      - name: Mysql Driver check
        run: docker exec lamp-stack_apache_1 php -m | grep mysqli
      - name: Composer test
        run: docker exec lamp-stack_apache_1 composer
      - name: Web site Test
        run: |
          docker exec lamp-stack_apache_1 sudo wget -O /var/www/index.php https://raw.githubusercontent.com/deck-app/stack-preview-screen/main/install/index.html
          sudo curl -I --http2 http://localhost:5590/
      - name: Verify MariaDB running from host, create Database and show Database
        run: |
          while ! docker exec lamp-stack_mariadb_1 mysqladmin --user=root --password=password --host "mariadb" ping --silent &> /dev/null ; do
              echo "Waiting for database connection..."
              sleep 2
          done
      - name: Check MariaDB version
        run:  docker exec lamp-stack_mariadb_1 mysql -uroot -ppassword -e "SHOW VARIABLES LIKE '%version%';"
      - name: Verify MariaDB database from user
        run:  docker exec lamp-stack_mariadb_1 mysql -uadmin -ppassword -e "SHOW DATABASES"
      - name: Create a Database
        run:  docker exec lamp-stack_mariadb_1 mysql -uroot -ppassword -e "CREATE DATABASE deckapp"
      - name: Verify Database create or not
        run:  docker exec lamp-stack_mariadb_1 mysql -uroot -ppassword -e "SHOW DATABASES"
      - name: Database connection check
        run: |
          docker exec lamp-stack_apache_1 sudo wget -O /var/www/db.php https://raw.githubusercontent.com/nabad600/apache_php/master/connection.php
          docker exec lamp-stack_apache_1 sudo php /var/www/db.php
      - name: Destroy Container and file
        run:  |
          docker-compose down
          sudo rm -rf /tmp/app
          sudo rm -rf /tmp/lamp
          echo "y" | docker image prune -a
          echo "y" | docker volume prune
      - name: Slack Notification
        uses: rtCamp/action-slack-notify@v2
        env:
          SLACK_CHANNEL: github_action_status
          SLACK_COLOR: ${{ job.status }}
          SLACK_ICON: https://github.com/rtCamp.png?size=48
          SLACK_MESSAGE: 'Post Content LAMP ${{ matrix.pv }} ARM64 :rocket:'
          SLACK_TITLE: Post Title
          SLACK_USERNAME: rtCamp
          SLACK_WEBHOOK: ${{ secrets.SLACK_WEBHOOK_URL }}
          SLACK_WEBHOOK_URL: ${{ secrets.SLACK_WEBHOOK_URL }}