View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
11973 | Bug reports | Installation | public | 2016-12-01 15:19 | 2018-02-14 17:13 |
Reporter | katcher01 | Assigned To | c_schmitz | ||
Priority | none | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.56.x | ||||
Fixed in Version | 3.3.x | ||||
Summary | 11973: Admin Login Fails on new installation Postgresql Databse Backend | ||||
Description | Install fresh as per installation instructions. Do not modify default admin information. Login as admin may fail with postgres backend | ||||
Steps To Reproduce | Typical install and attempt to login with default admin/password | ||||
Additional Information | I have seen this with Postgresql 9.1.13 on windows Solution in DB creation script ensure that ALTER DATABASE limesurvey SET bytea_output = 'escape'; It appears as if default may be hex which causes invalid comparison string | ||||
Tags | No tags attached. | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | Version 2.56.1+161118 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Unimportant | ||||
Database type & version | Postgresql 9.1.13 DB Version 260 | ||||
Server OS (if known) | Windows 7 | ||||
Webserver software & version (if known) | Apache 2.2.25 | ||||
PHP Version | 5.4.38 | ||||
I cannot reproduce that on Postgres 9.6. No matter what I set for bytea_output (hex or escaped) I can always log in successfully. |
|
This is resolved in Version 3 because the password hash is now stored in a normal text field, not a binary field. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2016-12-01 15:19 | katcher01 | New Issue | |
2016-12-06 17:12 |
|
Assigned To | => ollehar |
2016-12-06 17:12 |
|
Status | new => assigned |
2017-06-13 12:25 | c_schmitz | Assigned To | ollehar => c_schmitz |
2017-06-13 12:26 | c_schmitz | Product Version | => 2.56.x |
2017-06-13 12:32 | c_schmitz | Status | assigned => feedback |
2017-06-13 12:32 | c_schmitz | Note Added: 43890 | |
2018-02-14 17:13 | c_schmitz | Status | feedback => closed |
2018-02-14 17:13 | c_schmitz | Resolution | open => fixed |
2018-02-14 17:13 | c_schmitz | Fixed in Version | => 3.3.x |
2018-02-14 17:13 | c_schmitz | Note Added: 46474 |