chore: update installer script #131
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Release Draft | |
| # This workflow is triggered on creating tags | |
| on: | |
| push: | |
| tags: | |
| - "*.*.*" | |
| env: | |
| BUILD_TYPE: Release | |
| jobs: | |
| build-mac: | |
| name: macOS | |
| runs-on: macos-13 | |
| env: | |
| CMAKE_GENERATOR: Unix Makefiles | |
| ODBC_DM_INCLUDES: /usr/local/include | |
| steps: | |
| - name: Checkout source code | |
| uses: actions/checkout@v4 | |
| # Configure build environment/dependencies | |
| # Removing some /usr/local/bin files to avoid symlink issues wih brew update | |
| - name: Install MySQL client libs & other dependencies | |
| run: | | |
| rm '/usr/local/bin/2to3' | |
| rm '/usr/local/bin/2to3-3.11' | |
| rm '/usr/local/bin/idle3' | |
| rm '/usr/local/bin/idle3.11' | |
| rm '/usr/local/bin/pydoc3' | |
| rm '/usr/local/bin/pydoc3.11' | |
| rm '/usr/local/bin/python3' | |
| rm '/usr/local/bin/python3-config' | |
| rm '/usr/local/bin/python3.11' | |
| rm '/usr/local/bin/python3.11-config' | |
| brew update | |
| brew unlink unixodbc | |
| brew install libiodbc mysql-client | |
| brew link --overwrite --force libiodbc | |
| brew install openssl@3 | |
| rm -f /usr/local/lib/libssl.3.dylib | |
| rm -f /usr/local/lib/libcrypto.3.dylib | |
| ln -s /usr/local/opt/openssl@3/lib/libssl.3.dylib /usr/local/lib/ | |
| ln -s /usr/local/opt/openssl@3/lib/libcrypto.3.dylib /usr/local/lib/ | |
| curl -L https://dev.mysql.com/get/Downloads/MySQL-8.3/mysql-${{ vars.MYSQL_VERSION }}-macos14-x86_64.tar.gz -o mysql.tar.gz | |
| tar -xzvf mysql.tar.gz | |
| - name: Build and install AWS SDK C++ | |
| working-directory: ./scripts | |
| run: | | |
| ./build_aws_sdk_unix.sh $BUILD_TYPE | |
| - name: Create build environment | |
| run: cmake -E make_directory ${{ github.workspace }}/build | |
| - name: Configure CMake | |
| run: cmake -S . -B build | |
| -G "$CMAKE_GENERATOR" | |
| -DCMAKE_BUILD_TYPE=$BUILD_TYPE | |
| -DMYSQLCLIENT_STATIC_LINKING=true | |
| -DODBC_INCLUDES=$ODBC_DM_INCLUDES | |
| -DCONNECTOR_PLATFORM=macos | |
| -DBUNDLE_DEPENDENCIES=true | |
| -DMYSQL_DIR=./mysql-${{ vars.MYSQL_VERSION }}-macos14-x86_64 | |
| - name: Build driver | |
| working-directory: ${{ github.workspace }}/build | |
| run: | | |
| export LIBRARY_PATH=$LIBRARY_PATH:$(brew --prefix zstd)/lib/ | |
| cmake --build . | |
| - name: Build installer | |
| working-directory: ${{ github.workspace }}/build | |
| if: success() | |
| run: cpack . | |
| - name: Upload macOS installer as artifact | |
| if: success() | |
| uses: actions/upload-artifact@v3 | |
| with: | |
| name: installers | |
| path: ${{ github.workspace }}/build/aws-mysql-odbc-*.pkg | |
| if-no-files-found: error | |
| build-linux: | |
| name: Linux | |
| runs-on: ubuntu-latest | |
| env: | |
| CMAKE_GENERATOR: Unix Makefiles | |
| CXX: g++-11 | |
| steps: | |
| - name: Checkout source code | |
| uses: actions/checkout@v4 | |
| # Configure build environment/dependencies | |
| - name: Install build dependencies | |
| run: sudo apt-get update && sudo apt-get install | |
| g++-11 | |
| build-essential | |
| libgtk-3-dev | |
| unixodbc | |
| unixodbc-dev | |
| libcurl4-openssl-dev libssl-dev uuid-dev zlib1g-dev # AWS SDK dependencies | |
| - name: Install MySQL client libs and include files | |
| run: | | |
| curl -L https://dev.mysql.com/get/Downloads/MySQL-8.3/mysql-${{ vars.MYSQL_VERSION }}-linux-glibc2.28-x86_64.tar.xz -o mysql.tar.gz | |
| tar xf mysql.tar.gz | |
| - name: Build and install AWS SDK C++ | |
| working-directory: ./scripts | |
| run: | | |
| ./build_aws_sdk_unix.sh $BUILD_TYPE | |
| - name: Create build environment | |
| shell: bash | |
| run: cmake -E make_directory ${{ github.workspace }}/build | |
| - name: Configure CMake | |
| shell: bash | |
| run: cmake -S . -B build | |
| -G "$CMAKE_GENERATOR" | |
| -DCMAKE_BUILD_TYPE=$BUILD_TYPE | |
| -DMYSQLCLIENT_STATIC_LINKING=true | |
| -DWITH_UNIXODBC=1 | |
| -DCONNECTOR_PLATFORM=linux | |
| -DMYSQL_DIR=./mysql-${{ vars.MYSQL_VERSION }}-linux-glibc2.28-x86_64/ | |
| -DBUNDLE_DEPENDENCIES=true | |
| # Build driver | |
| - name: Build driver | |
| working-directory: ${{ github.workspace }}/build | |
| shell: bash | |
| run: cmake --build . --config $BUILD_TYPE | |
| - name: Build installer | |
| working-directory: ${{ github.workspace }}/build | |
| if: success() | |
| run: cpack . | |
| - name: Upload Linux installer as artifact | |
| if: success() | |
| uses: actions/upload-artifact@v3 | |
| with: | |
| name: installers | |
| path: ${{ github.workspace }}/build/aws-mysql-odbc-*.tar.gz | |
| if-no-files-found: error | |
| build-windows: | |
| name: Windows | |
| runs-on: windows-latest | |
| env: | |
| CMAKE_GENERATOR: Visual Studio 17 2022 | |
| WIX_DIR: "C:/Program Files (x86)/WiX Toolset v3.14/bin" | |
| steps: | |
| - name: Checkout source code | |
| uses: actions/checkout@v4 | |
| # Configure build environment/dependencies | |
| - name: Install MySQL client libs | |
| run: | | |
| curl -L https://dev.mysql.com/get/Downloads/MySQL-8.3/mysql-${{ vars.MYSQL_VERSION }}-winx64.zip -o mysql.zip | |
| unzip -d C:/ mysql.zip | |
| - name: Install OpenSSL 3 | |
| run: | | |
| curl -L https://download.firedaemon.com/FireDaemon-OpenSSL/openssl-3.3.1.zip -o openssl3.zip | |
| unzip -d C:/ openssl3.zip | |
| cp -r C:/openssl-3/x64/bin/libssl-3-x64.dll C:/Windows/System32/ | |
| cp -r C:/openssl-3/x64/bin/libcrypto-3-x64.dll C:/Windows/System32/ | |
| - name: Add msbuild to PATH | |
| uses: microsoft/setup-msbuild@v2 | |
| - name: Build and install AWS SDK C++ | |
| working-directory: ./scripts | |
| run: | | |
| .\build_aws_sdk_win.ps1 x64 ${{ env.BUILD_TYPE}} ON "${{env.CMAKE_GENERATOR}}" | |
| - name: Setup nmake | |
| uses: ilammy/msvc-dev-cmd@v1 | |
| - name: Run build installer script | |
| run: | | |
| .\build_installer.ps1 x64 ${{ env.BUILD_TYPE}} "${{env.CMAKE_GENERATOR}}" C:/mysql-${{ vars.MYSQL_VERSION }}-winx64 "${{env.WIX_DIR}}" C:/openssl-3/x64/include/ | |
| - name: Configure AWS credentials | |
| uses: aws-actions/configure-aws-credentials@v4.0.2 | |
| with: | |
| role-skip-session-tagging: true | |
| aws-access-key-id: ${{ secrets.AWS_BUILD_KEY }} | |
| aws-secret-access-key: ${{ secrets.AWS_BUILD_SECRET_KEY }} | |
| aws-region: us-west-2 | |
| role-to-assume: ${{ secrets.AWS_ROLE_TO_ASSUME }} | |
| role-external-id: ${{ secrets.AWS_ROLE_EXTERNAL_ID }} | |
| role-duration-seconds: 3600 | |
| - name: Run signer script | |
| shell: pwsh | |
| working-directory: ./scripts | |
| run: | | |
| choco upgrade jq -y | |
| . ".\sign_installer.ps1" | |
| Invoke-SignInstaller ${{ github.workspace }}\wix winx64a ${{github.ref_name}} ${{ secrets.AWS_UNSIGNED_BUCKET }} ${{ secrets.AWS_SIGNED_BUCKET }} ${{ secrets.AWS_S3_KEY }}aws-mysql-odbc-${{github.ref_name}}-winx64a.msi | |
| - name: Upload Windows installer as artifact | |
| if: success() | |
| uses: actions/upload-artifact@v3 | |
| with: | |
| name: installers | |
| path: ${{ github.workspace }}/wix/*.msi | |
| if-no-files-found: error | |
| draft-release: | |
| name: Create Draft Release | |
| runs-on: ubuntu-latest | |
| needs: [build-mac, build-linux, build-windows] | |
| steps: | |
| - name: Download all installers | |
| uses: actions/download-artifact@v4.1.7 | |
| with: | |
| name: installers | |
| # Get tag version for release | |
| - name: Set Version Env Variable | |
| run: echo "RELEASE_VERSION=${GITHUB_REF#refs/*/}" >> $GITHUB_ENV | |
| - name: 'Get Release Details' | |
| run: | | |
| export RELEASE_DETAILS="$(awk -vN=2 'n<N;/^## /{++n}' CHANGELOG.md)" | |
| export RELEASE_DETAILS="$(sed '${/^# /d;}' <<< "$RELEASE_DETAILS")" | |
| export RELEASE_DETAILS="$(sed '$d' <<< "$RELEASE_DETAILS")" | |
| touch RELEASE_DETAILS.md | |
| echo "$RELEASE_DETAILS" > RELEASE_DETAILS.md | |
| - name: Upload to Draft Release | |
| uses: ncipollo/release-action@v1 | |
| with: | |
| draft: true | |
| name: "AWS ODBC Driver for MySQL - v${{ env.RELEASE_VERSION }}" | |
| bodyFile: RELEASE_DETAILS.md | |
| artifacts: "./*.pkg, ./*.tar.gz, ./*.msi" | |
| token: ${{ secrets.GITHUB_TOKEN }} |