SSL connections not working

[imaginet]

Hi,

We are using Laravel 12 and spatie/laravel-multitenancy 4.0 on PHP 8.2

We have to use a MySQL database server with enforced SSL (require_secure_transport enabled) but this doesn't work with the multi-tenancy connections.

We have set the database SSL connection option which work in other frameworks e.g. in "config/database.php" add,

'options' = array(
PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => false,
PDO::MYSQL_ATTR_SSL_CA => null,
)

It appears to initiate the first connection as SSL/TLS and it runs "select * from tenants where identifier = site". But the second query appears to connect without SSL and fails to run "select * from sessions where id = 'xxx""

I also added the same SSL options to "app/Models/Tenant.php" but it didn't help

Any ideas on how we can resolve this?
thanks

[imaginet]

Just to note we solved this by adding the same SSL options to app/Tenant/CustomSwitchTenantDatabaseTask.php
and adding SESSION_CONNECTION=landlord to our .env file