You have an issue with your eLabFTW installation? Here are the things you should check before opening an issue on GitHub ;)
If the server is not responding at all, check the web container logs. If the application cannot connect to MySQL, check the mysql container logs.
# to check if the containers are running elabctl status # or docker ps # for the web container docker logs elabftw # for the mysql container docker logs mysql
If you get “An error occurred!” message, check the PHP logs. All errors should be logged there.
# for php errors elabctl error-logs # or docker logs elabftw 1>/dev/null
Resetting a password directly from MySQL¶
If you can’t reset a password because the mail system doesn’t work and have access to the MySQL database, you can reset it manually.
First connect to a MySQL prompt:
# docker users elabctl mysql # non-docker mysql -uelabftw -p elabftw
Find out the userid of the user you want to reset the password:
SELECT userid FROM users WHERE firstname = 'XXX';
Replace XXX with the firstname. You can of course also search with “email” or “lastname”. Now that you have the userid, we need to change the “password” and “salt” columns. The password column will be :
and the salt column will be :
UPDATE users SET password = f566..., salt = f93c... WHERE userid = X;
Replace X with the correct userid.
Once this is done, you can login with the password: “totototo”.