unable to connect MSSQL when use php command in workspace

[minkbear]

Description:

When using php command in workspace, It's unable to connect MSSQL then show error

SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol]

Expected Behavior:

Context information:

Output of git rev-parse HEAD

5cf7449d4277f1eafdfb376afb902cd5494119bb

Output of docker version

Client:
 Cloud integration: 1.0.17
 Version:           20.10.7
 API version:       1.41
 Go version:        go1.16.4
 Git commit:        f0df350
 Built:             Wed Jun  2 11:56:22 2021
 OS/Arch:           darwin/amd64
 Context:           desktop-linux
 Experimental:      true

Server: Docker Engine - Community
 Engine:
  Version:          20.10.7
  API version:      1.41 (minimum version 1.12)
  Go version:       go1.13.15
  Git commit:       b0f5bc3
  Built:            Wed Jun  2 11:54:58 2021
  OS/Arch:          linux/amd64
  Experimental:     false
 containerd:
  Version:          1.4.6
  GitCommit:        d71fcd7d8303cbf684402823e425e9dd2e99285d
 runc:
  Version:          1.0.0-rc95
  GitCommit:        b9ee9c6314599f1b4a7f497e1f1f856fe433d3b7
 docker-init:
  Version:          0.19.0
  GitCommit:        de40ad0

Output of docker-compose version

Docker Compose version 2.0.0-beta.4

System info: Mac, Windows or Linux. Include which disto/version

Mac

Steps to reproduce the issue:

1. Enable

WORKSPACE_INSTALL_MSSQL=true
PHP_FPM_INSTALL_MSSQL=true

PHP_DOWNGRADE_OPENSSL_TLS_AND_SECLEVEL=true

2. Bash into workspace
3. run php artisan ....
4. Got error

SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol]

Stacktrace & Additional info:

Exception trace:

  1   Doctrine\DBAL\Driver\PDO\Exception::("SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol]")
      /var/www/u/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18

  2   Doctrine\DBAL\Driver\PDO\Exception::new()
      /var/www/u/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:41

[stale]

Hi 👋 this issue has been automatically marked as stale 📌 because it has not had recent activity 😴. It will be closed if no further activity occurs. Thank you for your contributions ❤️.

[stale]

Hi again 👋 we would like to inform you that this issue has been automatically closed 🔒 because it had not recent activity during the stale period. We really really appreciate your contributions, and looking forward for more in the future 🎈.

[pathros]

Description:

When using php command in workspace, It's unable to connect MSSQL then show error

SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol]

Expected Behavior:

Context information:

Output of git rev-parse HEAD

5cf7449d4277f1eafdfb376afb902cd5494119bb

Output of docker version

Client:
 Cloud integration: 1.0.17
 Version:           20.10.7
 API version:       1.41
 Go version:        go1.16.4
 Git commit:        f0df350
 Built:             Wed Jun  2 11:56:22 2021
 OS/Arch:           darwin/amd64
 Context:           desktop-linux
 Experimental:      true

Server: Docker Engine - Community
 Engine:
  Version:          20.10.7
  API version:      1.41 (minimum version 1.12)
  Go version:       go1.13.15
  Git commit:       b0f5bc3
  Built:            Wed Jun  2 11:54:58 2021
  OS/Arch:          linux/amd64
  Experimental:     false
 containerd:
  Version:          1.4.6
  GitCommit:        d71fcd7d8303cbf684402823e425e9dd2e99285d
 runc:
  Version:          1.0.0-rc95
  GitCommit:        b9ee9c6314599f1b4a7f497e1f1f856fe433d3b7
 docker-init:
  Version:          0.19.0
  GitCommit:        de40ad0

Output of docker-compose version

Docker Compose version 2.0.0-beta.4

System info: Mac, Windows or Linux. Include which disto/version

Mac

Steps to reproduce the issue:

1. Enable

WORKSPACE_INSTALL_MSSQL=true
PHP_FPM_INSTALL_MSSQL=true

PHP_DOWNGRADE_OPENSSL_TLS_AND_SECLEVEL=true

2. Bash into workspace

3. run php artisan ....

4. Got error

SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol]

Stacktrace & Additional info:

Exception trace:

  1   Doctrine\DBAL\Driver\PDO\Exception::("SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol]")
      /var/www/u/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18

  2   Doctrine\DBAL\Driver\PDO\Exception::new()
      /var/www/u/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:41

Once you enable or change values in the .env file, you need to rebuild the containers again, like so:

$ docker-compose up -d --build workspace

depending on what you have changed in that .env file. Check the Laradock documentation and search for the string "--build" in your browser.