Difference between revisions of "Miscellaneous redmine issues"

From Notes_Wiki
(Created page with "<yambe:breadcrumb>Redmine_configuration|Redmine configuration</yambe:breadcrumb> =Miscellaneous redmine issues= ==Resetting redmine password== To reset redmine user or admin...")
 
m
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
<yambe:breadcrumb>Redmine_configuration|Redmine configuration</yambe:breadcrumb>
[[Main Page|Home]] > [[CentOS]] > [[CentOS 6.x]] > [[Web based tools or applications]] > [[Redmine configuration]] > [[Miscellaneous redmine issues]]
=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.   


Steps learned from http://www.redmine.org/boards/2/topics/32429?r=39642
Steps learned from http://www.redmine.org/boards/2/topics/32429?r=39642
[[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