ERROR 2026 (HY000): SSL connection error: SSL_CTX_set_default_verify_paths failed

[Brenneisen]

Discussed in #41299

^{Originally posted by Brenneisen March 2, 2022}

• Laravel Version: 9.3.0
• PHP Version: 8.1.1
• Database Driver & Version: MySQL Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

Description:

I get an error when running php artisan migrate. With version 9.2.0 the migrations still work. With 9.3.0 our integration tests throw an error when migrating because of an SSL connection error. For me it seems to be due to the new config --ssl-ca="${:LARAVEL_LOAD_SSL_CA}".

The command "mysql  --user="${:LARAVEL_LOAD_USER}" --password="${:LARAVEL_LOAD_PASSWORD}" --host="${:LARAVEL_LOAD_HOST}" --port="${:LARAVEL_LOAD_PORT}" --ssl-ca="${:LARAVEL_LOAD_SSL_CA}" --database="${:LARAVEL_LOAD_DATABASE}" < "${:LARAVEL_LOAD_PATH}"" failed.

Error Output:

mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2026 (HY000): SSL connection error: SSL_CTX_set_default_verify_paths failed

Steps To Reproduce:

Run php artisan migrate.

[Brenneisen]

I believe it is due to the fact that an empty string is passed: #40931

[DeepDiver1975]

What is the MySQL client version?

[Brenneisen]

@DeepDiver1975

[DeepDiver1975]

I will provide a PR later today.
Using the mariadb client this was not observed. Sorry for the trouble.

[Bouhnosaure]

Indeed i just updated to 9.3 and got the same error when my tests runs the migrations:

Symfony\Component\Process\Exception\ProcessFailedException : The command "mysql  --user="${:LARAVEL_LOAD_USER}" --password="${:LARAVEL_LOAD_PASSWORD}" --host="${:LARAVEL_LOAD_HOST}" --port="${:LARAVEL_LOAD_PORT}" --ssl-ca="${:LARAVEL_LOAD_SSL_CA}" --database="${:LARAVEL_LOAD_DATABASE}" < "${:LARAVEL_LOAD_PATH}"" failed.

Exit Code: 1(General error)

Working directory: /app

Output:
================

Error Output:
================
ERROR 2026 (HY000): SSL connection error: Error while reading file.

/app/vendor/symfony/process/Process.php:267
/app/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlSchemaState.php:77
/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:145
...

My environment is using mysql Ver 15.1 Distrib 10.5.12-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper as client and no configuration on SSL certificates on databases for testing.

I hope it helps !

[CraigMonva]

Spotted this yesterday while running github action tests that require mysql connection.

Glad its being looked at already.

[driesvints]

@DeepDiver1975 when will you have time to send in a PR? Otherwise we'll probably revert this for now to unblock people.

[DeepDiver1975]

Within the next hour