View Issue Details

IDProjectCategoryView StatusLast Update
14125Bug reports[All Projects] Installationpublic2018-10-03 08:19
ReporterDenisChenuAssigned ToDenisChenu 
PrioritynoneSeverityminor 
Status resolvedResolutionfixed 
Product Version3.14.x 
Target VersionFixed in Version3.14.x 
Summary14125: DB user with insufficient right can show white page when installing
Description

With IIS + SQL server : if user have insufficient right (READ/WRITE role, not db_owner) : this broke with a 500 error without any information.

Steps To Reproduce

With mysql/apache : it's better show a 500 with the DB error. Need hacking index.php for IIS

Then with mysql
create "test" DB
create "read' user
GRANT SELECT , INSERT , UPDATE , DELETE , ALTER ON test . * TO 'read'@'localhost';

Launch new install

TagsNo tags attached.
Complete LimeSurvey version number (& build)3.14.11 github
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database & DB-Versionmysql + mssql (+ surely pgsql with invalid rights)
Operating System (Server)windows (and linux)
Webserver software & versionIIS (but reproductible in apache)
PHP Versionnot releavant (tested in 7.2, reproduce in 5.6)

Activities

DenisChenu

DenisChenu

2018-10-02 17:31

developer  

index.php.html (1,661 bytes)

user70560

2018-10-03 08:18

  ~49223

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=28212

Related Changesets

LimeSurvey: master 91a5cef6

2018-10-03 08:18:48

user70560


Committer: GitHub Details Diff
Fixed issue 14125: DB user with insufficient right can show white page when installing (#1133)

Dev: fix double encoding of arrays of errors
Dev: trace is really not needed (Yii part)
Dev: didn't test with command install : create-database throw CHttpException (didn't update it)
mod - application/controllers/InstallerController.php Diff File
mod - application/views/installer/dbconfig_view.php Diff File
mod - installer/create-database.php Diff File

Issue History

Date Modified Username Field Change
2018-10-02 17:31 DenisChenu New Issue
2018-10-02 17:31 DenisChenu Status new => assigned
2018-10-02 17:31 DenisChenu Assigned To => DenisChenu
2018-10-02 17:31 DenisChenu File Added: index.php.html
2018-10-03 08:18 user70560 Changeset attached => LimeSurvey master 91a5cef6
2018-10-03 08:18 user70560 Note Added: 49223
2018-10-03 08:18 user70560 Assigned To DenisChenu => user70560
2018-10-03 08:18 user70560 Resolution open => fixed
2018-10-03 08:19 DenisChenu Assigned To user70560 => DenisChenu
2018-10-03 08:19 DenisChenu Status assigned => resolved
2018-10-03 08:19 DenisChenu Fixed in Version => 3.14.x