<!doctypehtml><html class=client-nojs dir=ltr lang=en><meta charset=utf-8><title>
   RecoverRootPassword - Request Tracker Wiki
  </title><script>document.documentElement.className="client-js";RLCONF={"wgBreakFrames":!1,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""],"wgDefaultDateFormat":"dmy","wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgRequestId":"YPmQZRTr68FnQeQF_vEXeAAAAos","wgCSPNonce":!1,"wgCanonicalNamespace":"","wgCanonicalSpecialPageName":!1,"wgNamespaceNumber":0,"wgPageName":"RecoverRootPassword","wgTitle":"RecoverRootPassword","wgCurRevisionId":26492,"wgRevisionId":26492,"wgArticleId":637,"wgIsArticle":!0,"wgIsRedirect":!1,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":[],"wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"RecoverRootPassword","wgRelevantArticleId":637,"wgIsProbablyEditable":!1,"wgRelevantPageIsProbablyEditable":!1,"wgRestrictionEdit":[],"wgRestrictionMove":[]};RLSTATE={"site.styles":"ready","noscript":"ready",
"user.styles":"ready","user":"ready","user.options":"loading","skins.vector.styles.legacy":"ready","mediawiki.toc.styles":"ready"};RLPAGEMODULES=["site","mediawiki.page.startup","mediawiki.page.ready","mediawiki.toc","skins.vector.legacy.js"];</script><script>(RLQ=window.RLQ||[]).push(function(){mw.loader.implement("user.options@1hzgi",function($,jQuery,require,module){/*@nomin*/mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"});
});});</script><link href=/load.php?lang=en&modules=mediawiki.toc.styles%7Cskins.vector.styles.legacy&only=styles&skin=vector rel=stylesheet><script async src=/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector></script><meta content="MediaWiki 1.35.1"name=generator><link rel="shortcut icon"href=https://static.bestpractical.com/favicon.ico><link title="Request Tracker Wiki (en)
"href=/opensearch_desc.php rel=search type=application/opensearchdescription+xml><link href=https://rt-wiki.bestpractical.com/api.php?action=rsd rel=EditURI type=application/rsd+xml><link href=/wiki/BPS_Licensing rel=license><link title="Request Tracker Wiki Atom feed"href=/index.php?title=Special:RecentChanges&feed=atom rel=alternate type=application/atom+xml><body class="mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject page-RecoverRootPassword rootpage-RecoverRootPassword skin-vector action-view skin-vector-legacy"><div class=noprint id=mw-page-base></div><div class=noprint id=mw-head-base></div><div class=mw-body id=content role=main><a id=top> </a><div class=mw-body-content id=siteNotice></div><div class="mw-indicators mw-body-content"></div><h1 class=firstHeading id=firstHeading lang=en>RecoverRootPassword</h1><div class=mw-body-content id=bodyContent><div class=noprint id=siteSub>From Request Tracker Wiki</div><div id=contentSub></div><div id=contentSub2></div><div id=jump-to-nav></div><a class=mw-jump-link href=#mw-head> Jump to navigation </a><a class=mw-jump-link href=#searchInput> Jump to search </a><div class=mw-content-ltr dir=ltr id=mw-content-text lang=en><div class=mw-parser-output><p>The topic of recovering root password comes up frequently in the <a href=/wiki/MailingLists title=MailingLists> MailingLists </a> .<p>Here are some answers.<p>The original (default) <b> RT root user </b> password is "password", not the password you set in RT_SiteConfig.pm (which is your DBMS root user password), nor the password of your <b> Unix </b> root user.<p>If you over-write, corrupt, or lose the root password, there are a few ways to recover it.<div aria-labelledby=mw-toc-heading class=toc id=toc role=navigation><input class=toctogglecheckbox id=toctogglecheckbox role=button style=display:none type=checkbox><div class=toctitle dir=ltr lang=en><h2 id=mw-toc-heading>Contents</h2><span class=toctogglespan> <label class=toctogglelabel for=toctogglecheckbox></label> </span></div><ul><li class="toclevel-1 tocsection-1"><a href=#Easiest_way> <span class=tocnumber> 1 </span> <span class=toctext> Easiest way </span> </a><li class="toclevel-1 tocsection-2"><a href=#Use_another_known_password> <span class=tocnumber> 2 </span> <span class=toctext> Use another known password </span> </a><li class="toclevel-1 tocsection-3"><a href=#Generate_a_new_password> <span class=tocnumber> 3 </span> <span class=toctext> Generate a new password </span> </a> <ul><li class="toclevel-2 tocsection-4"><a href=#SQL> <span class=tocnumber> 3.1 </span> <span class=toctext> SQL </span> </a></ul><li class="toclevel-1 tocsection-5"><a href=#Enable_root_user> <span class=tocnumber> 4 </span> <span class=toctext> Enable root user </span> </a><li class="toclevel-1 tocsection-6"><a href=#See_also> <span class=tocnumber> 5 </span> <span class=toctext> See also </span> </a></ul></div><h2><span class=mw-headline id=Easiest_way> Easiest way </span></h2><p>Q: I lost the root password how can I reset it?<p>A:<pre>   perl -I/opt/rt4/local/lib -I/opt/rt4/lib \
    -MRT -MRT::User \
    -e'RT::LoadConfig(); RT::Init(); my $u = RT::User->new($RT::SystemUser); $u->Load("root"); $u->SetPassword("secret")'
</pre><h2><span class=mw-headline id=Use_another_known_password> Use another known password </span></h2><p>Use SQL to copy the known password from some other user into the root password.<h2><span class=mw-headline id=Generate_a_new_password> Generate a new password </span></h2><h3><span class=mw-headline id=SQL> SQL </span></h3><p>Use base64 encoded MD5 of the word 'password'. This should work with all recent RT versions. Before you set the password you must switch to the RT Database.<pre>mysql> UPDATE Users SET Password='X03MO1qnZdYdgyfeuILPmQ' WHERE Name='root';
</pre><p>For RT4 use the default enry (root/password):<pre>mysql> UPDATE Users SET Password='!bcrypt!10!xijhhtbzipG6.EsQwgic7.D1mUs2tC0yN4iNjOWS9Za8gAtKTzTlW' WHERE Name='root';
</pre><p>Or...<pre>mysql> UPDATE Users SET Password=md5('password') WHERE Name='root';
</pre><p>Or very old crypt variant.<pre>mysql> UPDATE Users SET Password=ENCRYPT('password','SA') WHERE Name='root';
</pre><h2><span class=mw-headline id=Enable_root_user> Enable root user </span></h2><p>Q: Passwort is reset, but i still can not log in. My log says:<p>Disabled user root tried to log in<p>A: You have to (re-)enable the root user:<p>Find out the id of root (usually it's 12):<pre>mysql> SELECT * FROM Users WHERE Name='root';
</pre><p>Check if root is disabled:<pre>mysql> SELECT * FROM Principals WHERE id=12;
</pre><p>Enable root:<pre>mysql> UPDATE Principals SET Disabled=0 WHERE id=12;
</pre><h2><span class=mw-headline id=See_also> See also </span></h2><p><a href=/wiki/PasswordsInDB title=PasswordsInDB> PasswordsInDB </a></div></div><div class=printfooter>Retrieved from " <a dir=ltr href=https://rt-wiki.bestpractical.com/index.php?title=RecoverRootPassword&oldid=26492> https://rt-wiki.bestpractical.com/index.php?title=RecoverRootPassword&oldid=26492 </a> "</div><div class="catlinks catlinks-allhidden"data-mw=interface id=catlinks></div></div></div><div id=mw-navigation><h2>Navigation menu</h2><div id=mw-head><nav aria-labelledby=p-personal-label class=vector-menu id=p-personal role=navigation><h3 id=p-personal-label><span> Personal tools </span></h3><div class="body vector-menu-content"><ul class=vector-menu-content-list><li id=pt-login><a title="You are encouraged to log in; however, it is not mandatory [o]"accesskey=o href=/index.php?title=Special:UserLogin&returnto=RecoverRootPassword> Log in </a><li id=pt-createaccount><a title="You are encouraged to create an account and log in; however, it is not mandatory"href=/wiki/Special:RequestAccount> Request account </a></ul></div></nav><div id=left-navigation><nav class="vector-menu vector-menu-tabs vectorTabs"aria-labelledby=p-namespaces-label id=p-namespaces role=navigation><h3 id=p-namespaces-label><span> Namespaces </span></h3><div class="body vector-menu-content"><ul class=vector-menu-content-list><li class=selected id=ca-nstab-main><a title="View the content page [c]"accesskey=c href=/wiki/RecoverRootPassword> Page </a><li class=new id=ca-talk><a title="Discussion about the content page (page does not exist) [t]"accesskey=t href=/index.php?title=Talk:RecoverRootPassword&action=edit&redlink=1 rel=discussion> Discussion </a></ul></div></nav><nav class="vector-menu-empty emptyPortlet vector-menu vector-menu-dropdown vectorMenu"aria-labelledby=p-variants-label id=p-variants role=navigation><input class="vector-menu-checkbox vectorMenuCheckbox"aria-labelledby=p-variants-label type=checkbox><h3 id=p-variants-label><span> Variants </span></h3><div class="body vector-menu-content"><ul class="menu vector-menu-content-list"></ul></div></nav></div><div id=right-navigation><nav class="vector-menu vector-menu-tabs vectorTabs"aria-labelledby=p-views-label id=p-views role=navigation><h3 id=p-views-label><span> Views </span></h3><div class="body vector-menu-content"><ul class=vector-menu-content-list><li class="collapsible selected"id=ca-view><a href=/wiki/RecoverRootPassword> Read </a><li class=collapsible id=ca-viewsource><a title="This page is protected.
You can view its source [e]"accesskey=e href=/index.php?title=RecoverRootPassword&action=edit> View source </a><li class=collapsible id=ca-history><a title="Past revisions of this page [h]"accesskey=h href=/index.php?title=RecoverRootPassword&action=history> View history </a></ul></div></nav><nav class="vector-menu-empty emptyPortlet vector-menu vector-menu-dropdown vectorMenu"aria-labelledby=p-cactions-label id=p-cactions role=navigation><input class="vector-menu-checkbox vectorMenuCheckbox"aria-labelledby=p-cactions-label type=checkbox><h3 id=p-cactions-label><span> More </span></h3><div class="body vector-menu-content"><ul class="menu vector-menu-content-list"></ul></div></nav><div id=p-search role=search><h3><label for=searchInput>Search</label></h3><form action=/index.php id=searchform><div id=simpleSearch><input placeholder="Search Request Tracker Wiki
"title="Search Request Tracker Wiki
 [f]"accesskey=f id=searchInput name=search type=search><input name=title type=hidden value=Special:Search><input class="searchButton mw-fallbackSearchButton"title="Search the pages for this text"id=mw-searchButton name=fulltext type=submit value=Search><input title="Go to a page with this exact name if it exists"class=searchButton id=searchButton name=go type=submit value=Go></div></form></div></div></div><div id=mw-panel><div id=p-logo role=banner><a title="Visit the main page"class=mw-wiki-logo href=/wiki/Main_Page> </a></div><nav class="vector-menu vector-menu-portal portal portal-first"aria-labelledby=p-navigation-label id=p-navigation role=navigation><h3 id=p-navigation-label><span> Navigation </span></h3><div class="body vector-menu-content"><ul class=vector-menu-content-list><li id=n-mainpage-description><a title="Visit the main page [z]"accesskey=z href=/wiki/Main_Page> Main page </a><li id=n-recentchanges><a title="A list of recent changes in the wiki [r]"accesskey=r href=/wiki/Special:RecentChanges> Recent changes </a><li id=n-randompage><a title="Load a random page [x]"accesskey=x href=/wiki/Special:Random> Random page </a><li id=n-help-mediawiki><a href=https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents> Help about MediaWiki </a></ul></div></nav><nav class="vector-menu vector-menu-portal portal"aria-labelledby=p-tb-label id=p-tb role=navigation><h3 id=p-tb-label><span> Tools </span></h3><div class="body vector-menu-content"><ul class=vector-menu-content-list><li id=t-whatlinkshere><a title="A list of all wiki pages that link here [j]"accesskey=j href=/wiki/Special:WhatLinksHere/RecoverRootPassword> What links here </a><li id=t-recentchangeslinked><a title="Recent changes in pages linked from this page [k]"accesskey=k href=/wiki/Special:RecentChangesLinked/RecoverRootPassword rel=nofollow> Related changes </a><li id=t-specialpages><a title="A list of all special pages [q]"accesskey=q href=/wiki/Special:SpecialPages> Special pages </a><li id=t-print><a title="Printable version of this page [p]"accesskey=p href=javascript:print(); rel=alternate> Printable version </a><li id=t-permalink><a title="Permanent link to this revision of the page"href=/index.php?title=RecoverRootPassword&oldid=26492> Permanent link </a><li id=t-info><a title="More information about this page"href=/index.php?title=RecoverRootPassword&action=info> Page information </a></ul></div></nav></div></div><footer class=mw-footer id=footer role=contentinfo><ul id=footer-info><li id=footer-info-lastmod>This page was last edited on 1 March 2017, at 14:19.<li id=footer-info-copyright>Content is available under <a title="BPS Licensing"href=/wiki/BPS_Licensing> Creative Commons Attribution-ShareAlike 3.0 Unported </a> unless otherwise noted.</ul><ul id=footer-places><li id=footer-places-privacy><a title="Request Tracker Wiki:Privacy policy"href=/wiki/Request_Tracker_Wiki:Privacy_policy> Privacy policy </a><li id=footer-places-about><a title="Request Tracker Wiki:About"href=/wiki/Request_Tracker_Wiki:About> About Request Tracker Wiki </a><li id=footer-places-disclaimer><a title="Request Tracker Wiki:General disclaimer"href=/wiki/Request_Tracker_Wiki:General_disclaimer> Disclaimers </a></ul><ul class=noprint id=footer-icons><li id=footer-copyrightico><a href=https://creativecommons.org/licenses/by-sa/3.0/> <img alt="Creative Commons Attribution-ShareAlike 3.0 Unported"height=31 loading=lazy src=https://licensebuttons.net/l/by-sa/3.0/88x31.png width=88> </a><li id=footer-poweredbyico><a href=https://www.mediawiki.org/> <img alt="Powered by MediaWiki"srcset="/resources/assets/poweredby_mediawiki_132x47.png 1.5x, /resources/assets/poweredby_mediawiki_176x62.png 2x"height=31 loading=lazy src=/resources/assets/poweredby_mediawiki_88x31.png width=88> </a></ul><div style="clear: both;"></div></footer><script>(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgPageParseReport":{"limitreport":{"cputime":"0.024","walltime":"0.032","ppvisitednodes":{"value":19,"limit":1000000},"postexpandincludesize":{"value":0,"limit":2097152},"templateargumentsize":{"value":0,"limit":2097152},"expansiondepth":{"value":2,"limit":40},"expensivefunctioncount":{"value":0,"limit":100},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":0,"limit":5000000},"timingprofile":["100.00%    0.000      1 -total"]},"cachereport":{"timestamp":"20210722131625","ttl":86400,"transientcontent":false}}});mw.config.set({"wgBackendResponseTime":309});});</script>