Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Login Admin Fails Fresh Install 2.56.1 Build 161118

  • katcher01
  • katcher01's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
7 years 3 months ago #145316 by katcher01
I have a new install of limesurvey
Version 2.56.1 Build 161118
Windows 7
Apache 2.2.25
PHP 5.4.38
Postgresql 9.1.13

The install ran as expected and as I had seen in previous posts I did not adjust the admin username, or password and accepted the default.
When I tried to login for the first time using the default password for admin, it failed. I accessed the user record and added my email address. I reset the admin password. Still no luck. I noticed on many posts that upgrading PHP solved the problem. I do not believe it is a valid solution. Does anyone have any idea why it fails? I have other application on my server which may or may not work with a php upgrade.


Any infrmation would be appreciated.

Thanks
Eric Katchan
The topic has been locked.
  • katcher01
  • katcher01's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
7 years 3 months ago #145325 by katcher01
I have some further debug information:

I believe the issue may be in the hashing or storing of the passwords in general.

When I retrieve the password from the db in postgres resource i get
a 130 character string with one letter at the from followed by 129 numeric characters
for example:
x31303834346635373935363763523639636661353438613162616539656337613733313063626539873864333661393765633236666438336432353536656534
hash('sha256', $password) = 10844f579567c269cfa548a1bae9ec7a7310cbe978d36a97ec26fd83d2556ee4

This string is being compared to a
Authdb.php line 170
if ($sStoredPassword !== hash('sha256', $password))

They will never be the same. The lenght alone causes the comparison to fail.

Just debugging...
The topic has been locked.
  • katcher01
  • katcher01's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
7 years 3 months ago #145337 by katcher01
Solved

Postgres output_bytea needs to be modified:

ALTER DATABASE limesurvey SET bytea_output = 'escape';

www.limesurvey.org/forum/installation-a-...-installation#110736
Thanks KMC13 much appreciated
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 3 months ago #145349 by DenisChenu
Maybe : best to report the issue.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose