View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
19387Bug reportsInstallationpublic2024-01-31 17:062024-09-04 08:13
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 heat4
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
c_schmitz

c_schmitz

2024-09-03 17:17

administrator   ~80885

I am using SQL Server 19 and do not have that problem.
DenisChenu

DenisChenu

2024-09-04 08:13

developer   ~80889

I am using SQL Server 19 and do not have that problem.

Depend on the certificate, maybe.

  1. PHP on windows are complex with certificate …
  2. We disallow here specific installation

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
2024-09-03 17:17 c_schmitz Note Added: 80885
2024-09-03 17:17 c_schmitz Bug heat 2 => 4
2024-09-04 08:13 DenisChenu Note Added: 80889