The LimeSurvey Fund-Raiser 2012 is complete. Thank you for donating a total of 25,000 USD!     List of donors »
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username?
  • Page:
  • 1

TOPIC: Reset admin password

Reset admin password 4 months 19 hours ago #91701

  • damien
  • damien's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 7
  • Karma: 1
Hi,

Since 2.0, there is no /admin/install directory and so no resetadminpwd.php, so, how to reset the admin password now?

Here is the wiki solution wich doesn't work with 2.0+ installs
The administrator has disabled public write access.

Re: Reset admin password 4 months 19 hours ago #91707

  • Ben_V
  • Ben_V's Avatar
  • OFFLINE
  • Platinum Lime
  • Posts: 735
  • Thank you received: 136
  • Karma: 44
Hi,
You can do it easily if you are abble to manage SQL queries...

I attached a dump with the `lime_users` original table
User:admin
Password: password

File Attachment:

File Name: reset_admin_v2.txt
File Size: 2 KB


Note:the version is Version 2.00+ Build 121017..It's not the last build but I suppose that's `lime_users` table structure is the same. In case of doubt make a dump of this table or of the entire database.
Benoît

goo.gl/Bw5iM => Recherche GG dans le forum français (remplacer "exemple" dans la barre de recherche)
goo.gl/WX8PH => GG search for english forum (Replace "example" in the search bar)
goo.gl/IxiGu => Búsqueda en el foro en español (Cambiar "ejemplo" en la barra de...
The administrator has disabled public write access.
The following user(s) said Thank You: damien

Re: Reset admin password 4 months 18 hours ago #91708

  • damien
  • damien's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 7
  • Karma: 1
Thanks, I just erased my install and re-installed it so I can't test your solution but thanks.
The administrator has disabled public write access.

Re: Reset admin password 3 months 1 week ago #92571

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 1975
  • Thank you received: 156
  • Karma: 80
I have a similar case:
Local installation that can't send emails, haven't configured smtp.

I think actually that I remember my login/pw combination, but somehow the login screen always shows the message:
Incorrect username and/or password!

You have exceeded the number of maximum login attempts. Please wait 10 minutes before trying again.

And the 10 minutes are over quite a bit.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds
If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re: Reset admin password 3 months 1 week ago #92578

  • Ben_V
  • Ben_V's Avatar
  • OFFLINE
  • Platinum Lime
  • Posts: 735
  • Thank you received: 136
  • Karma: 44
10 minutes is pretty good delay for having a beer ;) but in case you need less time you may look at:

application/config/config-defaults.php
(around L 60)
// If the user enters password incorrectly
$config['maxLoginAttempt']    =   3;                // Lock them out after 3 attempts
$config['timeOutTime']        =   60 * 10;          // Lock them out for 10 minutes.
Benoît

goo.gl/Bw5iM => Recherche GG dans le forum français (remplacer "exemple" dans la barre de recherche)
goo.gl/WX8PH => GG search for english forum (Replace "example" in the search bar)
goo.gl/IxiGu => Búsqueda en el foro en español (Cambiar "ejemplo" en la barra de...
Last Edit: 3 months 1 week ago by Ben_V. Reason: _
The administrator has disabled public write access.
  • Page:
  • 1
Moderators: DenisChenu, ITEd
Time to create page: 0.250 seconds
Donation Image