View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
09379Bug reportsInstallationpublic2014-12-10 09:21
ReporterDenisChenu Assigned Toc_schmitz  
PrioritylowSeverityminor 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary09379: pgsql : user are not owner: throw 500 error
Description

If you try to use an existing DB, but user aren't owner (pgsl) : throw 500 error.

Steps To Reproduce

Create a pg sql db
Launch install
User an existing user with DB rigth, but not owner
Throw 500 at populate DB

Additional Information

Admin user have to know the problem and know how to fix it, but it's better (beautifull) if we show a better error page :)

Really low priority

TagsNo tags attached.
Attached Files
Internal Server Error.html (1,245 bytes)   
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Internal Server Error</title>

<style type="text/css">
/*<![CDATA[*/
body {font-family:"Verdana";font-weight:normal;color:black;background-color:white;}
h1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
h2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
h3 {font-family:"Verdana";font-weight:bold;font-size:11pt}
p {font-family:"Verdana";font-weight:normal;color:black;font-size:9pt;margin-top: -5px}
.version {color: gray;font-size:8pt;border-top:1px solid #aaaaaa;}
/*]]>*/
</style>
</head>

<body>
<h1>Internal Server Error</h1>
<h2>CDbCommand failed to execute the SQL statement: SQLSTATE[42501]: 
Insufficient privilege: 7 ERREUR:  doit être le propriétaire de la base 
de données testing</h2>
<p>
An internal error occurred while the Web server was processing your request.
Please contact the webmaster to report this problem.
</p>
<p>
Thank you.
</p>
<div class="version">
2014-12-01 12:24:15 </div>

</body></html>
Internal Server Error.html (1,245 bytes)   
Bug heat2
Complete LimeSurvey version number (& build)141126
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionPostgreSQL 9.1.14
Server OS (if known)debian/linux
Webserver software & version (if known)apache
PHP VersionPHP Version 5.4.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-12-05 09:33

administrator   ~31172

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

c_schmitz

c_schmitz

2014-12-05 09:35

administrator   ~31173

Fix committed to 2.06 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=14690

c_schmitz

c_schmitz

2014-12-10 09:21

administrator   ~31226

Version 2.05+ Build 141210 released

Related Changesets

LimeSurvey: master d9d4a740

2014-12-05 08:33:26

c_schmitz

Details Diff
Fixed issue 09379: DB error during installation when unsufficient permissions to create tables Affected Issues
09379
mod - application/controllers/InstallerController.php Diff File

LimeSurvey: 2.06 b8a397a5

2014-12-05 08:34:50

c_schmitz

Details Diff
Fixed issue 09379: DB error during installation when unsufficient permissions to create tables Affected Issues
09379
mod - application/controllers/InstallerController.php Diff File

Issue History

Date Modified Username Field Change
2014-12-01 12:29 DenisChenu New Issue
2014-12-01 12:29 DenisChenu File Added: Internal Server Error.html
2014-12-01 12:29 DenisChenu File Deleted: Internal Server Error.html
2014-12-01 12:30 DenisChenu File Added: Internal Server Error.html
2014-12-05 08:52 c_schmitz Summary pgsql : user are not proprietary : throw 500 error => pgsql : user are not owner: throw 500 error
2014-12-05 08:56 DenisChenu Description Updated
2014-12-05 08:56 DenisChenu Steps to Reproduce Updated
2014-12-05 09:32 c_schmitz Assigned To => c_schmitz
2014-12-05 09:32 c_schmitz Status new => assigned
2014-12-05 09:33 c_schmitz Changeset attached => LimeSurvey master d9d4a740
2014-12-05 09:33 c_schmitz Note Added: 31172
2014-12-05 09:33 c_schmitz Resolution open => fixed
2014-12-05 09:35 c_schmitz Changeset attached => LimeSurvey 2.06 b8a397a5
2014-12-05 09:35 c_schmitz Note Added: 31173
2014-12-05 09:52 c_schmitz Status assigned => resolved
2014-12-05 09:52 c_schmitz Fixed in Version => 2.05+
2014-12-10 09:21 c_schmitz Note Added: 31226
2014-12-10 09:21 c_schmitz Status resolved => closed