artisan migrate gives error "sh: mysql: command not found"

[eAvio]

Hi,

We are trying to deploy or laravel nova app with bref.
Deployment goes well, but when trying to run artisan migrate we get strange error:
sh: mysql: command not found

We run migration with:
vendor/bin/bref cli --region eu-central-1 radioPool-dev-artisan -- migrate --force

We are using Laravel v8.27.0 (PHP v8.0.1).

Any help would be appreciated.

serverless.yml

service: radiopoll

provider:
    name: aws
    # The AWS region in which to deploy (us-east-1 is the default)
    region: eu-central-1
    # The stage of the application, e.g. dev, production, staging… ('dev' is the default)
    stage: dev
    runtime: provided.al2

package:
    # Directories to exclude from deployment
    exclude:
        - node_modules/**
        - public/storage
        - resources/assets/**
        - storage/**
        - tests/**

functions:
    # This function runs the Laravel website/API
    web:
        handler: public/index.php
        timeout: 28 # in seconds (API Gateway has a timeout of 29 seconds)
        layers:
            - ${bref:layer.php-80-fpm}
        events:
            -   httpApi: '*'
        vpc:
          securityGroupIds:
            - sg-xxxx
          subnetIds:
            - subnet-xxxx
            - subnet-xxxx
            - subnet-xxxx
    # This function lets us run artisan commands in Lambda
    artisan:
        handler: artisan
        timeout: 120 # in seconds
        layers:
            - ${bref:layer.php-80} # PHP
            - ${bref:layer.console} # The "console" layer
        vpc:
          securityGroupIds:
            - sg-xxxx
          subnetIds:
            - subnet-xxxx
            - subnet-xxxx
            - subnet-xxxx

plugins:
    # We need to include the Bref plugin
    - ./vendor/bref/bref

[deleugpn]

Are you making use of Laravel Snapshot migration? mysql is not installed inside AWS Lambda. You'd need to figure out a way to install it with a custom layer, but I'm guessing it could lead to a too large Lambda Function.
I'd recommend looking into what's trying to use a local MySQL installation and replace that with code that don't assume a local MySQL installed

[eAvio]

@deleugpn thank you for very fast reply.

We actually have very basic Laravel installation - no exotic packages.
We are using regular Laravel artisan migrate command.

Database is AWS Aurora Serverless (with VPN security groups as suggested in Bref documentation)

From Bref documentation I assume this should work out of the box with out installing any additional mysql layer. Is that correct?

Shall we avoid using artisan migrate for serverless installation?

Regards,
Gregor