- Posts: 7
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Reset admin password
- damien01
- Topic Author
- Offline
- New Member
Less
More
11 years 2 months ago #91701
by damien01
Reset admin password was created by damien01
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
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 topic has been locked.
- Ben_V
- Offline
- Platinum Member
Less
More
- Posts: 1128
- Thank you received: 329
11 years 2 months ago #91707
by Ben_V
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Replied by Ben_V on topic Reset admin password
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
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.
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
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
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Attachments:
The following user(s) said Thank You: damien01
The topic has been locked.
- damien01
- Topic Author
- Offline
- New Member
Less
More
- Posts: 7
- Thank you received: 0
11 years 2 months ago #91708
by damien01
Replied by damien01 on topic Reset admin password
Thanks, I just erased my install and re-installed it so I can't test your solution but thanks.
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11645
- Thank you received: 2739
11 years 2 months ago #92571
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Reset admin password
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.
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.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- Ben_V
- Offline
- Platinum Member
Less
More
- Posts: 1128
- Thank you received: 329
11 years 2 months ago - 11 years 2 months ago #92578
by Ben_V
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Replied by Ben_V on topic Reset admin password
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)
application/config/config-defaults.php
(around L 60)
Code:
// 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
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Last edit: 11 years 2 months ago by Ben_V. Reason: _
The topic has been locked.
- ElJuez
- Offline
- New Member
Less
More
- Posts: 2
- Thank you received: 0
10 years 2 months ago #105327
by ElJuez
Replied by ElJuez on topic Reset admin password
Hi Ben
I saw lot of post from you searching how to reset the password for admin.
But you are always sending us to the same file giving the admin password "password" default one.
But how to change the password with the one we want to update ? Or will the system ask us a for new password as it is the default one ?
If not, do you already have a script allowing to generate a new string for the password with the one we want ?
Thanks
I saw lot of post from you searching how to reset the password for admin.
But you are always sending us to the same file giving the admin password "password" default one.
But how to change the password with the one we want to update ? Or will the system ask us a for new password as it is the default one ?
If not, do you already have a script allowing to generate a new string for the password with the one we want ?
Thanks
The topic has been locked.
- Ben_V
- Offline
- Platinum Member
Less
More
- Posts: 1128
- Thank you received: 329
10 years 2 months ago - 10 years 2 months ago #105330
by Ben_V
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Replied by Ben_V on topic Reset admin password
Hi,
those indications is a recovery process to access the admin if you can't log in.
The normal way is to edit your (admin) account editing your password:
Go to " manage users " tab in the main menu
those indications is a recovery process to access the admin if you can't log in.
The normal way is to edit your (admin) account editing your password:
Go to " manage users " tab in the main menu
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Attachments:
Last edit: 10 years 2 months ago by Ben_V.
The topic has been locked.
- ElJuez
- Offline
- New Member
Less
More
- Posts: 2
- Thank you received: 0
10 years 2 months ago #105332
by ElJuez
Replied by ElJuez on topic Reset admin password
Thanks Ben
The thing is that I was not seeing the admin account from that page. I do not understand why, it was not listed.
I am reinstalling the tool.
I'll infor you after if I can see my user into.
The thing is that I was not seeing the admin account from that page. I do not understand why, it was not listed.
I am reinstalling the tool.
I'll infor you after if I can see my user into.
The topic has been locked.
- Mazi
- Offline
- Official LimeSurvey Partner
10 years 2 months ago #105349
by Mazi
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
Replied by Mazi on topic Reset admin password
You need to have sufficient rights to be able to edit user settings/passwords.
Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support: survey-consulting.com
Contact: marcel.minke(at)survey-consulting.com
The topic has been locked.
- Stuart
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
10 years 1 month ago - 10 years 1 month ago #106218
by Stuart
Replied by Stuart on topic Reset admin password
This resets the password to 'password' for limesurvey 2.05. You will need to delete admin first.
Code:
INSERT INTO `lime_users` VALUES(1, 'admin', 0x35653838343839386461323830343731353164306535366638646336323932373733363033643064366161626264643632613131656637323164313534326438, 'Administrator', 0, 'en', 'youremail@address.com', 'default', 'default', 'default', '', 1,'2014-03-12', '2014-03-12');
Last edit: 10 years 1 month ago by Stuart.
The topic has been locked.
- jhilbert
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
9 years 11 months ago #108508
by jhilbert
Replied by jhilbert on topic Reset admin password
Greetings,
I have installed the most recent version of LimeSurvey on a fresh LAMP (xubuntu 14.04). During the installation, I neglected to flush privileges, so I messed up the initial admin login with default password. I tried the suggestion below (#106218) and was able to login but the admin page that appeared was stripped of all privileges; no menu, no option to change password, could not create survey, user edit had no option to change password. All I could do was logout. Seems as though something is missing in a table somewhere that provides users with privileges?
Thanks.
I have installed the most recent version of LimeSurvey on a fresh LAMP (xubuntu 14.04). During the installation, I neglected to flush privileges, so I messed up the initial admin login with default password. I tried the suggestion below (#106218) and was able to login but the admin page that appeared was stripped of all privileges; no menu, no option to change password, could not create survey, user edit had no option to change password. All I could do was logout. Seems as though something is missing in a table somewhere that provides users with privileges?
Thanks.
The topic has been locked.