Difference between revisions of "Miscellaneous redmine issues"
m |
m |
||
| Line 1: | Line 1: | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 6.x]] > [[Web based tools or applications]] > [[Redmine configuration]] > [[Miscellaneous redmine issues]] | |||
==Resetting redmine password== | ==Resetting redmine password== | ||
| Line 8: | Line 7: | ||
update users set hashed_password='353e8061f2befecb6818ba0c034c632fb0bcae1b' where login='admin'; | update users set hashed_password='353e8061f2befecb6818ba0c034c632fb0bcae1b' where login='admin'; | ||
update users set salt=NULL where login='admin'; | update users set salt=NULL where login='admin'; | ||
<pre> | </pre> | ||
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. | 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. | ||
| Line 17: | Line 16: | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 6.x]] > [[Web based tools or applications]] > [[Redmine configuration]] > [[Miscellaneous redmine issues]] | |||
Latest revision as of 18:36, 28 July 2022
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
