Changing FogBugz On-Premises Domain/Subdomain

Overview

A fully-qualified domain name that FogBugz On-Premises is hosted on requires two components, the domain, and the subdomain. For example, if your site is hosted at http://mu.example.com:

• The domain is example.com. 
• The subdomain is mu.

This article shares information about changing the domain or the subdomain for FogBugz On-Premises.

Information

There are separate steps to change the domain and the subdomain of your site. These steps can be performed independently or together, depending upon if you have made changes to the DNS settings of your FogBugz installation. 

Process

Refer to the following sections for the steps to change the domain, subdomain, and finalize the domain changes. 

1. Changing the Domain
2. Changing the Subdomain
3. Final Implementation

Changing the Domain

The steps given below describe the process using the example of changing the domain from mu.example.com to mu.myexamplesite.com:

1. Using 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 your new domain: myexamplesite.com
3. Restart IIS (Internet Information Services).
4. (Optionally) change the subdomain.
5. Finalize the changes using the steps in the final implementation section.

Changing the Subdomain

The steps given below describe the process using the example of changing the subdomain from mu.example.com to fogbugz.example.com:

1. Run the following SQL script to change the subdomain setting in your database for the hosted site. In this example, the value of <your-new-site-name> would be fogbugz.
   
   

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

   Note: Please note that if you are running multiple sites on the same FogBugz installation, you may need to specify the correct value for ixFogBugzTrial.

    

2. Run the following SQL script to trigger your site to use the new subdomain. 
   
   

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

   Note: FogBugz uses the naming convention of trialN for the databases, where N corresponds to the number of each site.

    

3. Finalize the changes using the steps in the final implementation section.

Final Implementation

After making the change,s run the following SQL script as the final step. If you are running more than one FogBugz site on this server, you will need to run this for each database using trialN, where N corresponds to the number of each site you are running.

For example, if both the domain and subdomain were changed as per the steps in the previous sections the value of http://<your-fqdn> would be http://fogbugz.myexamplesite.com.

USE trial1;

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

Note: You may need to use https instead of http if your site is configured to enforce https connections.

Confirmation

After a few minutes, your site begins responding to the newly configured domain and subdomain. 

Back to top