View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
19387Bug reportsInstallationpublic2024-01-31 17:062024-01-31 17:11
ReporterDenisChenu Assigned To 
PrioritynoneSeverityminor 
Status newResolutionopen 
Product Version5.6.x 
Summary19387: Unable to install on some specific server (SQL extra parameters)
Description

New MSSQL server need SSL connexion. But locally : ssl is not OK, a way to use such DB is to add ;TrustServerCertificate=1 at connectionString
It's OK when LimeSurvey is already installed, or to install via console.
But not to install via web a new instance.

Steps To Reproduce

Steps to reproduce

Try to add ;TrustServerCertificate=1 at end of connectionString

Expected result

Have a way to add extra parameters

Actual result

No way

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)5.6.52 and 6.4.4
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionmssql for the example
Server OS (if known)windows
Webserver software & version (if known)iis here
PHP Version8.0

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2024-01-31 17:07

developer   ~79380

Last edited: 2024-01-31 17:11

'connectionString' => "sqlsrv:Server={$DBserver};Database={$DBdatabase};TrustServerCertificate=1",

I think it can just be interesting to have 'extraParameters' on the installer for all DB.

https://stackoverflow.com/questions/70399243/how-to-fix-sql-server-2019-connection-error-due-to-certificate-issue

Issue History

Date Modified Username Field Change
2024-01-31 17:06 DenisChenu New Issue
2024-01-31 17:07 DenisChenu Note Added: 79380
2024-01-31 17:07 DenisChenu Bug heat 0 => 2
2024-01-31 17:11 DenisChenu Note Edited: 79380