Laravel 11, PHP 8.3 mysql driver not enabled, also can't use postgress

[rogerio-pereira]

Description:
Hi i'm using Laravel 11, and PHP 8.3
Everything is being deployed to cloud, but i'm getting Illuminate\Database\QueryException could not find driver when opening the backend URL (this is being caused by mysql or postgress driver not being found to store session in database). I tried with mysql and pgsql.
Also i'm getting 419 Cors error on frontend (hosted in s3 as static website) when sending the login form. It works locally...

How to reproduce:
Create new project using Sail (laravel 11)
I run commands (inside docker container) to deploy to aws

php artisan optimize:clear
php artisan config:cache
serverless deploy

deploy using following serverless.yml

useDotenv: true
service: "bref"

plugins:
    # We need to include the Bref plugin
    - ./vendor/bref/bref
    - ./vendor/bref/extra-php-extensions
    - serverless-lift

resources:
    Resources:
        # Create our S3 storage bucket using CloudFormation
        S3:
            Type: AWS::S3::Bucket
            Properties:
                BucketName: ${env:AWS_BUCKET}
                PublicAccessBlockConfiguration:
                    BlockPublicAcls: false
                OwnershipControls:
                    Rules:
                        - ObjectOwnership: ObjectWriter

        S3BucketPolicy:
            Type: AWS::S3::BucketPolicy
            Properties:
                Bucket: 
                    Ref: S3
                PolicyDocument:
                    Statement:
                        -   Effect: Allow
                            Principal: "*"
                            Action:
                                - "s3:PutObject"
                                - "s3:GetObject"
                                - "s3:DeleteObject"
                            Resource: !Sub '${S3.Arn}/*'

        SQS:
            Type: AWS::SQS::Queue
            Properties:
                QueueName: ${env:SQS_QUEUE}

provider:
    name: aws
    # The AWS region in which to deploy (us-east-1 is the default)
    region: us-east-1
    iam:
        role:
            statements:
                -   Effect: Allow
                    Action:
                        - s3:PutObject
                        - s3:GetObject
                        - s3:DeleteObject
                    Resource:
                        - !Sub '${S3.Arn}' # the storage bucket
                        - !Sub '${S3.Arn}/*' # and everything inside
    # Environment variables
    environment:
        APP_ENV: local # Or use ${sls:stage} if you want the environment to match the stage
        FILESYSTEM_DISK: s3
        AWS_BUCKET: ${env:AWS_BUCKET}
        # QUEUE_CONNECTION: sqs
        # SQS_PREFIX: ${env:SQS_PREFIX} 
        # SQS_QUEUE: ${env:SQS_QUEUE}

package:
    # Files and directories to exclude from deployment
    patterns:
        - '!node_modules/**'
        - '!public/storage'
        - '!resources/assets/**'
        - '!storage/**'
        - '!tests/**'

functions:
    # This function runs the Laravel website/API
    web:
        handler: Bref\LaravelBridge\Http\OctaneHandler
        runtime: php-82
        timeout: 28 # in seconds (API Gateway has a timeout of 29 seconds)
        environment:
            BREF_LOOP_MAX: 250
        events:
            - httpApi: '*'
        layers:
            - ${bref-extra:pgsql-php-82}

    # This function lets us run artisan commands in Lambda
    artisan:
        handler: artisan
        runtime: php-82-console
        timeout: 720 # in seconds
        # Uncomment to also run the scheduler every minute
        # events:
        #     - schedule:
        #         rate: rate(1 minute)
        #         input: '"schedule:run"'
        layers:
            - ${bref-extra:pgsql-php-82}

constructs:
    bref-queue:
        type: queue
        worker:
            handler: Bref\LaravelBridge\Queue\QueueHandler
            runtime: php-82
            timeout: 60 # seconds
        layers:
            - ${bref-extra:pgsql-php-82}

My .env all sensitive information are inside < >

APP_NAME="Bref Lambda"
APP_ENV=local
APP_KEY=<my_key>
APP_DEBUG=true
APP_TIMEZONE=UTC
APP_URL=<my_url>
FRONTEND_URL=<my_frontend_url>
SANCTUM_STATEFUL_DOMAINS="<my_domain_without_http_or_https"  #do not include http:// or https://
APP_PORT=8080

APP_LOCALE=en
APP_FALLBACK_LOCALE=en
APP_FAKER_LOCALE=en_US

APP_MAINTENANCE_DRIVER=file
APP_MAINTENANCE_STORE=database

BCRYPT_ROUNDS=12

LOG_CHANNEL=stderr
LOG_STACK=single
LOG_DEPRECATIONS_CHANNEL=null
LOG_LEVEL=debug

# DB_CONNECTION=pgsql
# DB_HOST=<my_postgress_host>
# DB_PORT=5432
DB_CONNECTION=mysql
DB_HOST=<my_mysql_host>
DB_PORT=3306
DB_DATABASE=<my_database>
DB_USERNAME=<my_username>
DB_PASSWORD=<my_db_password>

#PG_ADMIN_PORT=8888
#PG_ADMIN_EMAIL="[email protected]"
#PG_ADMIN_PASSWORD="123456"

SESSION_DRIVER=database
SESSION_LIFETIME=120
SESSION_ENCRYPT=false
SESSION_PATH=/
SESSION_DOMAIN=".<my-domain>" #make sure this has the first ., this will allow different subdomains

BROADCAST_CONNECTION=log
FILESYSTEM_DISK=s3
QUEUE_CONNECTION=sqs

#CACHE
CACHE_STORE=database
CACHE_PREFIX=

MEMCACHED_HOST=127.0.0.1

REDIS_CLIENT=phpredis
REDIS_HOST=redis
REDIS_PASSWORD=null
REDIS_PORT=6379

MAIL_MAILER=smtp
MAIL_HOST=mailpit
MAIL_PORT=1025
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
MAIL_FROM_ADDRESS="[email protected]"
MAIL_FROM_NAME="${APP_NAME}"

AWS_ACCESS_KEY_ID=<my_aws_key>
AWS_SECRET_ACCESS_KEY="<my_aws_secret>"
AWS_DEFAULT_REGION=us-east-1
AWS_BUCKET=<my_s3_bucket>

#QUEUE
SQS_PREFIX="https://sqs.us-east-1.amazonaws.com/<my_aws_id>"
SQS_QUEUE="<my_queue>"

#Minio
#AWS_ENDPOINT=http://minio:9000/
#AWS_URL=http://localhost:9000/profile
#AWS_USE_PATH_STYLE_ENDPOINT=true
#MINIO_USER=minio
#MINIO_PASSWORD=Minio@AWS

VITE_APP_NAME="${APP_NAME}"
VITE_PORT=5174

WWWGROUP=1000
WWWUSER=1000

Dockerfile using Laravel sail dockerfile, just added #Bref section at the end

FROM ubuntu:22.04

LABEL maintainer="Taylor Otwell"

ARG WWWGROUP
ARG NODE_VERSION=20
ARG POSTGRES_VERSION=15
ARG AWS_ACCESS_KEY_ID
ARG AWS_SECRET_ACCESS_KEY

WORKDIR /var/www/html

ENV DEBIAN_FRONTEND noninteractive
ENV TZ=UTC
ENV SUPERVISOR_PHP_COMMAND="/usr/bin/php -d variables_order=EGPCS /var/www/html/artisan serve --host=0.0.0.0 --port=80"
ENV SUPERVISOR_PHP_USER="sail"

RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime && echo $TZ > /etc/timezone

RUN apt-get update \
    && mkdir -p /etc/apt/keyrings \
    && apt-get install -y gnupg gosu curl ca-certificates zip unzip git supervisor sqlite3 libcap2-bin libpng-dev python2 dnsutils librsvg2-bin fswatch ffmpeg nano  \
    && curl -sS 'https://keyserver.ubuntu.com/pks/lookup?op=get&search=0x14aa40ec0831756756d7f66c4f4ea0aae5267a6c' | gpg --dearmor | tee /etc/apt/keyrings/ppa_ondrej_php.gpg > /dev/null \
    && echo "deb [signed-by=/etc/apt/keyrings/ppa_ondrej_php.gpg] https://ppa.launchpadcontent.net/ondrej/php/ubuntu jammy main" > /etc/apt/sources.list.d/ppa_ondrej_php.list \
    && apt-get update \
    && apt-get install -y php8.3-cli php8.3-dev \
       php8.3-pgsql php8.3-sqlite3 php8.3-gd \
       php8.3-curl \
       php8.3-imap php8.3-mysql php8.3-mbstring \
       php8.3-xml php8.3-zip php8.3-bcmath php8.3-soap \
       php8.3-intl php8.3-readline \
       php8.3-ldap \
       php8.3-msgpack php8.3-igbinary php8.3-redis php8.3-swoole \
       php8.3-memcached php8.3-pcov php8.3-imagick php8.3-xdebug \
    && curl -sLS https://getcomposer.org/installer | php -- --install-dir=/usr/bin/ --filename=composer \
    && curl -fsSL https://deb.nodesource.com/gpgkey/nodesource-repo.gpg.key | gpg --dearmor -o /etc/apt/keyrings/nodesource.gpg \
    && echo "deb [signed-by=/etc/apt/keyrings/nodesource.gpg] https://deb.nodesource.com/node_$NODE_VERSION.x nodistro main" > /etc/apt/sources.list.d/nodesource.list \
    && apt-get update \
    && apt-get install -y nodejs \
    && npm install -g npm \
    && npm install -g pnpm \
    && npm install -g bun \
    && curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | gpg --dearmor | tee /etc/apt/keyrings/yarn.gpg >/dev/null \
    && echo "deb [signed-by=/etc/apt/keyrings/yarn.gpg] https://dl.yarnpkg.com/debian/ stable main" > /etc/apt/sources.list.d/yarn.list \
    && curl -sS https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor | tee /etc/apt/keyrings/pgdg.gpg >/dev/null \
    && echo "deb [signed-by=/etc/apt/keyrings/pgdg.gpg] http://apt.postgresql.org/pub/repos/apt jammy-pgdg main" > /etc/apt/sources.list.d/pgdg.list \
    && apt-get update \
    && apt-get install -y yarn \
    && apt-get install -y mysql-client \
    && apt-get install -y postgresql-client-$POSTGRES_VERSION \
    && apt-get -y autoremove \
    && apt-get clean \
    && rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*

RUN setcap "cap_net_bind_service=+ep" /usr/bin/php8.3

RUN groupadd --force -g $WWWGROUP sail
RUN useradd -ms /bin/bash --no-user-group -g $WWWGROUP -u 1337 sail

COPY start-container /usr/local/bin/start-container
COPY supervisord.conf /etc/supervisor/conf.d/supervisord.conf
COPY php.ini /etc/php/8.3/cli/conf.d/99-sail.ini
RUN chmod +x /usr/local/bin/start-container

#Bref
RUN npm install -g serverless && \
    npm install -g serverless-lift
RUN serverless config credentials --provider aws --key $AWS_ACCESS_KEY_ID --secret $AWS_SECRET_ACCESS_KEY 

EXPOSE 8000

ENTRYPOINT ["start-container"]

docker-compose.yml

services:
    laravel.test:
        build:
            context: ./docker/8.3
            dockerfile: Dockerfile
            args:
                WWWGROUP: '${WWWGROUP}'
                AWS_ACCESS_KEY_ID: '${AWS_ACCESS_KEY_ID}'
                AWS_SECRET_ACCESS_KEY: '${AWS_SECRET_ACCESS_KEY}'
        image: sail-8.3/app
        extra_hosts:
            - 'host.docker.internal:host-gateway'
        ports:
            - '${APP_PORT:-80}:80'
            - '${VITE_PORT:-5173}:${VITE_PORT:-5173}'
        environment:
            WWWUSER: '${WWWUSER}'
            LARAVEL_SAIL: 1
            XDEBUG_MODE: '${SAIL_XDEBUG_MODE:-off}'
            XDEBUG_CONFIG: '${SAIL_XDEBUG_CONFIG:-client_host=host.docker.internal}'
            IGNITION_LOCAL_SITES_PATH: '${PWD}'
        volumes:
            - '.:/var/www/html'
        networks:
            - sail
        depends_on:
            - pgsql
            - redis
            - minio
            - mailpit

    pgsql:
        image: 'postgres:15'
        ports:
            - '${FORWARD_DB_PORT:-5432}:5432'
        environment:
            PGPASSWORD: '${DB_PASSWORD:-secret}'
            POSTGRES_DB: '${DB_DATABASE}'
            POSTGRES_USER: '${DB_USERNAME}'
            POSTGRES_PASSWORD: '${DB_PASSWORD:-secret}'
        volumes:
            - 'sail-pgsql:/var/lib/postgresql/data'
            - './docker/pgsql/create-testing-database.sql:/docker-entrypoint-initdb.d/10-create-testing-database.sql'
        networks:
            - sail
        healthcheck:
            test:
                - CMD
                - pg_isready
                - '-q'
                - '-d'
                - '${DB_DATABASE}'
                - '-U'
                - '${DB_USERNAME}'
            retries: 3
            timeout: 5s

    pgadmin:
        image: dpage/pgadmin4
        ports:
            - "${PG_ADMIN_PORT}:80"
        environment:
            PGADMIN_DEFAULT_EMAIL: ${PG_ADMIN_EMAIL}
            PGADMIN_DEFAULT_PASSWORD: ${PG_ADMIN_PASSWORD}
        depends_on:
            - pgsql
        volumes:
            - pgadmin-data:/var/lib/pgadmin
        networks:
            - sail

    redis:
        image: 'redis:alpine'
        ports:
            - '${FORWARD_REDIS_PORT:-6379}:6379'
        volumes:
            - 'sail-redis:/data'
        networks:
            - sail
        healthcheck:
            test:
                - CMD
                - redis-cli
                - ping
            retries: 3
            timeout: 5s

    minio:
        image: 'minio/minio:latest'
        ports:
            - '${FORWARD_MINIO_PORT:-9000}:9000'
            - '${FORWARD_MINIO_CONSOLE_PORT:-8900}:8900'
        environment:
            MINIO_ROOT_USER: ${MINIO_USER}
            MINIO_ROOT_PASSWORD: ${MINIO_PASSWORD}
        volumes:
            - 'sail-minio:/data/minio'
        networks:
            - sail
        command: 'minio server /data/minio --console-address ":8900"'
        healthcheck:
            test:
                - CMD
                - curl
                - '-f'
                - 'http://localhost:9000/minio/health/live'
            retries: 3
            timeout: 5s
            
    mailpit:
        image: 'axllent/mailpit:latest'
        ports:
            - '${FORWARD_MAILPIT_PORT:-1025}:1025'
            - '${FORWARD_MAILPIT_DASHBOARD_PORT:-8025}:8025'
        networks:
            - sail
networks:
    sail:
        driver: bridge
volumes:
    sail-pgsql:
        driver: local
    sail-redis:
        driver: local
    sail-minio:
        driver: local
    pgadmin-data:

I have a folder php/conf.d/ in laravel project having a single file called extensions.ini, having

extension=pdo_pgsql
extension=pdo_mysql

[mnapoli]

MySQL is included and enabled by default in the Bref runtime. Could you try with MySQL and post the entire error?

[rogerio-pereira]

With Mysql is working, also the cors error was because my frontend didn't had a ssl certificate.
I'm testing with postgress, to check if the error was solved

[rogerio-pereira]

The problem was that i was using PHP_INI_SCAN_DIR
and it wasn't recognizing the path /var/task/<path/to/my/ini>
i simply removed that from provider environment and add the php/conf.d folder to root of the project

[rogerio-pereira]

Not really. I'm not able to upload files to S3, also queue is not working (probably because the upload failed).

the files are being sent to lambda, but when i do
Storage::putFileAs('profiles', $file, $fileName);
It returns false, tried to add a try/catch, but it doesn't trigger any exception, just fails to upload file

[rogerio-pereira]

I also tried saving a file using aws sdk, (both works locally, but not from lambda)
i made some changes in serverless.yml (it's updated above)

$bucket = env('AWS_BUCKET');
    $key = 'test_upload.txt';
    $content = 'Hello, S3 from Lambda!';

    $s3 = new S3Client([
        'region'  => env('AWS_DEFAULT_REGION', 'us-east-1'),
        'version' => 'latest',
        'credentials' => [
            'key'    => env('AWS_ACCESS_KEY_ID'),
            'secret' => env('AWS_SECRET_ACCESS_KEY'),
        ],
    ]);

    try {
        $result = $s3->putObject([
            'Bucket' => $bucket,
            'Key'    => $key,
            'Body'   => $content,
        ]);
        echo "File uploaded successfully. ETag: " . $result['ETag'];
    } catch (AwsException $e) {
        echo "Error uploading file: " . $e->getMessage();
    }

[rogerio-pereira]

@mnapoli do you have any idea why can't i upload files to s3, and post messages to queues?
i'm sorry to tag you, but you marked this conversation as closed yesterday...
please take your time, i know you might be busy

[mnapoli]

I marked as answered because the topic was about Mysql and PostgreSQL.

I think your credentials are wrong, you should not supply them.

Try

    $s3 = new S3Client([
        'region'  => env('AWS_DEFAULT_REGION', 'us-east-1'),
        'version' => 'latest',
    ]);

[rogerio-pereira]

Will open a new discussion related to s3 and sqs error