Miscellaneous redmine issues

<yambe:breadcrumb>Redmine_configuration|Redmine configuration</yambe:breadcrumb>

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




<yambe:breadcrumb>Redmine_configuration|Redmine configuration</yambe:breadcrumb>