Reset password lime survey

Question

i have a problem with lime survey. i forgot admin password. and I tried to update via mysql with md5 encryption. but not successfully login.

update lime_users set password=md5('password');

or

update lime_users set password=sha('password');

i want to ask, how to reset password in limesurvey.

Answer 1

If you're using Limesurvey 2.0 or greater using this as the hash:

$new_pass = hash('sha256', 'newpasswordgoeshere');

Answer 2

I have access to the DB with PhpMyAdmin on a Linux server with MySQL. Found this syntax that worked for a 3.17.x version

UPDATE `yourprefix_users`
SET yourprefix_users.password = sha2('YourNewPassword',256) WHERE uid = 1

Change uid with the one you want to reset in case is not about the admin that has the uid=1.

Answer 3

In Lime Survey 3.3.1 running the following will generate a hash for a new password on the command line:

php -r "echo password_hash('new password goes here', PASSWORD_DEFAULT); echo \"\n\";"

This will print out the hashed password, which you need to copy.

Then you can update the specific user's password in whatever SQL CLI you use:

UPDATE users set password = 'paste the password hash here' 
WHERE uid=[the uid for the user you're interested in];

Answer 4

3 way and all are in manual : https://manual.limesurvey.org/General_FAQ#I_forgot_my_admin_password._How_do_I_reset_it.3F

1. With PHP Cli php application/commands/console.php resetpassword NEW_ADMIN_NAME NEW_ADMIN_PASS
2. With DB access UPDATE lime_users SET password = 0x35653838343839386461323830343731353164306535366638646336323932373733363033643064366161626264643632613131656637323164313534326438 WHERE uid =1; (here : password)
3. With only ftp access : https://gitlab.com/SondagesPro/coreAndTools/ResetPasswordController/tree/master

Answer 5

You can use php cli if you have an ssh access to the server.

 cd ./limesurvey/application/commands/
 php starter.php resetpassword newuser newpassword