You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If you want to Connect to an unencrpyted MsSQL Server with the following connection array, a connection could not be established, because the encryption could not be set.
Joomla 4.1.4
PHP 7.4.28
Linux Ubuntu Webserver
sql_srv extension 5.10.0
Additional comments
In the file libraries\vendor\joomla\database\src\Sqlsrv\SqlsrvDriver.php at line 117 to 124 the config array needs the option encrypt, so the array must be change from this:
I think the suggested code change alone will not be sufficient because it requires $this->options['encrypt'] to be set. The code should also work if the option is not set, either by using a default value in that case or by only adding it to the $config array only if it is set.
As we don't seem to support encrypted connections with the MS SQL driver (if I remember right), we could also just set the encrypt value to false in general in the $config array instead of having an option for it.
Steps to reproduce the issue
If you want to Connect to an unencrpyted MsSQL Server with the following connection array, a connection could not be established, because the encryption could not be set.
Expected result
In the config array there is an option "encrypt" to set the state.
Actual result
System information (as much as possible)
Joomla 4.1.4
PHP 7.4.28
Linux Ubuntu Webserver
sql_srv extension 5.10.0
Additional comments
In the file libraries\vendor\joomla\database\src\Sqlsrv\SqlsrvDriver.php at line 117 to 124 the config array needs the option encrypt, so the array must be change from this:
to this:
The text was updated successfully, but these errors were encountered: