Lost Password to Administrator Account - FogBugz Knowledge Exchange most recent 30 from http://fogbugz.stackexchange.com2013-05-18T20:20:03Zhttp://fogbugz.stackexchange.com/feeds/question/439http://www.creativecommons.org/licenses/by-nc/2.5/rdfhttp://fogbugz.stackexchange.com/questions/439/lost-password-to-administrator-accountLost Password to Administrator AccountFogBugz KB2009-10-20T05:36:23Z2012-09-07T17:20:47Z
<p>Oh no! I've lost the password to the administrator account in FogBugz. What can I do?</p>
http://fogbugz.stackexchange.com/questions/439/lost-password-to-administrator-account/440#440Answer by FogBugz KB for Lost Password to Administrator AccountFogBugz KB2009-10-20T05:37:36Z2012-09-07T17:20:47Z<p><strong>If you are using FogBugz On Demand, disregard this guide and <a href="http://contact.fogcreek.com/" rel="nofollow">contact us</a>. This article is meant for Licensed FogBugz.</strong></p>
<p>You will need direct database access to follow these instructions. In <strong>Windows</strong>, you can find the location of your FogBugz database by using <strong>regedit</strong> and looking at the value for <strong>sConnectionString</strong> in the registry under <code>HKEY_LOCAL_MACHINE\Software\Fog Creek Software\FogBugz\[path to your install]</code>. In <strong>Linux/Unix</strong>, find the key in your <code>opt/fogbugz/Accessories/application.data</code> file.</p>
<p>If you have lost the password to all the administrator accounts in FogBugz, follow these instructions to reset one of the passwords. Note: these instructions are for FogBugz Authentication. If you use Active Directory or LDAP auth, please contact us for help.</p>
<ol>
<li>Run the following query in the FogBugz database:<br>
<code>UPDATE Setting SET sValue = '0' WHERE sKey = 'fPasswordEnable'</code><br><br>
<strong>At this point FogBugz will allow anyone to log on without a password.</strong><br><br></li>
<li>Using a web browser, log on to your FogBugz administrator account</li>
<li>Back in the database, change the <strong>sValue</strong> column for <strong>fPasswordEnable</strong> back to <strong>1</strong>.<br>
<code>UPDATE Setting SET sValue = '1' WHERE sKey = 'fPasswordEnable'</code></li>
<li>In your web browser, change the administrator password.</li>
</ol>