Miscellaneous redmine issues

Home > CentOS > CentOS 6.x > Web based tools or applications > Redmine configuration > Miscellaneous redmine issues

Resetting redmine password

To reset redmine user or admin password connect to mysql database and update user table. For setting a particular users password to 'password' (without quotes) set value of hashed_password to '353e8061f2befecb6818ba0c034c632fb0bcae1b' and set salt to NULL. Username can be matched with login column. Thus to reset admin users password use:

update users set hashed_password='353e8061f2befecb6818ba0c034c632fb0bcae1b' where login='admin';
update users set salt=NULL where login='admin';

Also note that if LDAP authentication is used then auth_source_id will have non-null value. In such cases above method wont work for an LDAP user unless users 'auth_source_id' is also set to NULL indicating that user is a local user.

Steps learned from http://www.redmine.org/boards/2/topics/32429?r=39642

Home > CentOS > CentOS 6.x > Web based tools or applications > Redmine configuration > Miscellaneous redmine issues