Lost Password to Administrator Account - FogBugz Knowledge Exchange most recent 30 from http://fogbugz.stackexchange.com 2013-05-18T20:20:03Z http://fogbugz.stackexchange.com/feeds/question/439 http://www.creativecommons.org/licenses/by-nc/2.5/rdf http://fogbugz.stackexchange.com/questions/439/lost-password-to-administrator-account Lost Password to Administrator Account FogBugz KB 2009-10-20T05:36:23Z 2012-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#440 Answer by FogBugz KB for Lost Password to Administrator Account FogBugz KB 2009-10-20T05:37:36Z 2012-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>