Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Admin Password Help

Admin Password Help 2 years 8 months ago #101666

  • rschroeder
  • rschroeder's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
Is there a way you can reset the "admin" password if it's been lost after installation and set-up? Personnel changes have resulted in a loss of the password and we can no longer log in through the server. Thanks in advance for your assistance.
The administrator has disabled public write access.

Admin Password Help 2 years 8 months ago #101674

  • Ben_V
  • Ben_V's Avatar
  • Offline
  • Platinum Lime
  • Posts: 1798
  • Thank you received: 440
  • Karma: 110
Hi,
You may have a look here ;)
Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
All LS releases => bit.ly/1VMuTDu | 2.06lts => bit.ly/1Qv44A1
Demo surveys => bit.ly/20NW9V8 (already included in /docs/demosurveys)
The administrator has disabled public write access.

Admin Password Help 2 years 8 months ago #101675

  • rschroeder
  • rschroeder's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
Thanks Ben for the information. Does the SQL script remove all users or can it just reset the admin password? I don't want to remove all of the accounts listed in the application.
The administrator has disabled public write access.

Admin Password Help 2 years 8 months ago #101687

  • Ben_V
  • Ben_V's Avatar
  • Offline
  • Platinum Lime
  • Posts: 1798
  • Thank you received: 440
  • Karma: 110
Yes it will overwrite all the `lime_users` table and delete users (due to the "DROP TABLE IF EXISTS" statement)

If you only have 1 admin account just this query to only update the password value. Admin username won't be affected (only the passw will be updated to "password").

Be careful if other users are sharing admin rights because their passwords will be updated too. In this case edit the query changing 'superadmin=1' by another field and value present into your `lime_users` table
UPDATE lime_users SET password=0x64666332353762396662343161396663333138666131313034303063343461333136653863616661303066356230356536396264623466646438656665616664 WHERE superadmin=1
Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
All LS releases => bit.ly/1VMuTDu | 2.06lts => bit.ly/1Qv44A1
Demo surveys => bit.ly/20NW9V8 (already included in /docs/demosurveys)
The administrator has disabled public write access.

Admin Password Help 2 years 8 months ago #101756

  • rschroeder
  • rschroeder's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
Thanks again Ben for all of your assistance.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.217 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form