Question

Oh no! I've lost the password to the administrator account in FogBugz. What can I do?

Answer 1

If you are using FogBugz On Demand, disregard this guide and contact us. This article is meant for Licensed FogBugz.

You will need direct database access to follow these instructions. In Windows, you can find the location of your FogBugz database by using regedit and looking at the value for sConnectionString in the registry under HKEY_LOCAL_MACHINE\Software\Fog Creek Software\FogBugz\[path to your install]. In Linux/Unix, find the key in your opt/fogbugz/Accessories/application.data file.

If you have lost the password to all the administrator accounts in FogBugz, follow these instructions to reset one of the passwords.

1. Run the following query in the FogBugz database:
   UPDATE Setting SET sValue = '0' WHERE sKey = 'fPasswordEnable'
   
   At this point FogBugz will allow anyone to log on without a password.
   
   
2. Using a web browser, log on to your FogBugz administrator account
3. Back in the database, change the sValue column for fPasswordEnable back to 1.
   UPDATE Setting SET sValue = '1' WHERE sKey = 'fPasswordEnable'
4. In your web browser, change the administrator password.