Note: before changing the domain name of your FogBugz site, make sure that any required DNS records and IIS hostname bindings have been updated to reflect the changes. If either of these have not been updated to reflect your new domain, you will be unable to access your FogBugz On Site installation after making these changes.

There are two components to the fully-qualified domain name that FogBugz On Site is hosted on. These are the domain and the subdomain.

For example, if your site is hosted at http://fb.example.com, the domain is example.com and the subdomain is fb.

There are separate steps to change the domain and the subdomain of your site, which can be performed independently or together if you have made changes to your DNS settings that point to your FogBugz On Site installation. Which steps you’ll need to perform depend on if you have changed the domain, the subdomain, or both.

Changing the Domain

Example: changing fb.example.com to fb.myexamplesite.com

  1. In your Registry Editor, open the key located at HKEY_LOCAL_MACHINE\SOFTWARE\Fog Creek Software\FogBugz\<your install directory>
  2. Edit the value of sFogBugzDomain to be your new domain. For the above example, this would be set to myexamplesite.com
  3. Restart IIS.
  4. Complete the “Final Steps” below, unless you are also changing the Subdomain first (Final Steps will be performed after that).

 

Changing the Subdomain

Example: changing fb.example.com to fogbugz.example.com

The following SQL will change the subdomain setting in your database for the site hosted using the “trial1” database (please note that if you are running multiple FogBugz sites on the same FogBugz On Site installation, you may need to specify the correct value for ixFogBugTrial):

---BEGIN SQL---

USE fbhosted;

UPDATE tblFogBugzTrial 
SET sUniqueSiteName = <your-new-site-name> 
WHERE ixFogBugzTrial = 1;

---END SQL---

For this example, the value of <your-new-site-name> would be ‘fogbugz’

Next, the following SQL will trigger your site to use the subdomain we specified above:

---BEGIN SQL---

USE trial1;

UPDATE Setting 
SET sValue='1' 
WHERE sKey='fTrialRename';

---END SQL---

Now complete the “Final Steps” below. After a few minutes, your site should begin responding on the new subdomain.

Final Steps

Whenever you make a change to either the domain or subdomain, you should make sure you run the following SQL as a final step. If you are running more than one FogBugz On Site site on this server, you’ll need to run this for each “trialN” database (which corresponds to each site you are running).

---BEGIN SQL---

USE trial1;

UPDATE Setting
SET sValue = 'http://<your-fqdn>'
WHERE skey = 'sURLPrefixEmail';

---END SQL---

For example, the value of  ‘http://<your-fqdn>’ would be ‘http://fogbugz.example.com’ (you may need to use https instead of http if your site is configured to enforce https connections).