Using FogBugz On Demand? We've recently rolled out a new sidebar as part of taking FogBugz forward. Please see this article for details on what's new, what's changed, and where you can find all your favorite things.

Introduction

To install FogBugz On Site, you have two options:

  1. Our Professional Services team can install it for you.
    1. Our On Site technician will require temporary remote access to your environment and access to the FogBugz On Site ISO. Our preferred remote assistance software is GoToMeeting. On the day of your scheduled installation, we’ll make available a GoToMeeting session to connect to your environment. If you have a different remote assistance software you’d like us to use, please let us know ahead of time.
  2. You may install it yourself following the On Site Installation instructions.

Before your scheduled installation, please complete the FogBugz On Site Pre-Installation Checklist. The pre-installation checklist helps ensure your environment satisfies prerequisites for installing FogBugz On Site.

Download details for the FogBugz On Site ISO will be provided when scheduling your installation. The FogBugz On Site ISO can be burned to physical media or mounted on your web server where you’ll be installing FogBugz On Site. Windows Server 2012 R2 includes the ability to mount ISO images.

System Requirements

Please see On Site System Requirements.

Configuration

To configure your installation, our technician will execute a PowerShell installation script from the FogBugz On Site ISO. This script accepts a number of parameters, which our technician will work with a technical contact on your end to configure:

  • Installation Directory: The location on disk where FogBugz On Site will be installed.
  • Service Username: The username for the user under which your FogBugz On Site application pools will run. This user needs to be a Local Administrator.
  • Service Password: The password for the user under which your FogBugz On Site application pools will run.
  • SQL Server Instance: The SQL Server instance where your FogBugz On Site databases will be hosted.
  • SQL Server Username: (Optional) If using SQL authentication, the username for the SQL authentication account which will be used to create and access your FogBugz On Site databases.
  • SQL Server Password: (Optional) If using SQL authentication, the password for the SQL authentication account which will be used to create and access your FogBugz On Site databases.
  • Fully Qualified Domain Name (FQDN): The FQDN where you plan to access FogBugz (e.g. fogbugz.yourdomain.com).
  • Administrator Email: The email address for the initial site administrator account created during your FogBugz On Site installation.
  • SMTP Server: (Optional) The host for the SMTP server FogBugz will use to send email.
  • SMTP Port: (Optional) The port over which FogBugz will connect to your SMTP server.
  • SMTP User: (Optional) The SMTP user FogBugz will use to access your SMTP server.
  • SMTP Password: (Optional) The password for the SMTP user.
  • SMTP SSL: (Optional) Whether or not FogBugz should use SSL when connecting to your SMTP server.

Your FogBugz On Site Fully Qualified Domain Name (FQDN)

Your FogBugz On Site FQDN consists of a Site Identifier and a Host in the form of:

http://{site identifier}.{host}

This FQDN must be configured on your DNS server to resolve to your FogBugz On Site web server. Example FQDNs that fit this pattern are:

  • fogbugz.yourdomain.com
  • fogbugz.yourserver

Additionally:

  • localhost:80 must be bound to your FogBugz On Site web site in IIS on your FogBugz On Site web server.

Installing FogBugz On Site

Once configured, our technician will work with you to run the FogBugz On Site installation script from a PowerShell prompt Run as Administrator. The Windows account executing the script needs to be a Local Administrator. If using Windows authentication to connect to your FogBugz On Site databases, a SQL user for the Windows account executing the script must be created in advance and must be granted the dbcreator* role on your target SQL Server instance. If using SQL authentication to connect to your FogBugz On Site databases, the SQL authentication user must be created in advance and must be granted the dbcreator* role.

* While the dbcreator role is required during your FogBugz On Site installation, permission for the account used by FogBugz On Site to access your SQL Server instance can be reduced once the installation is complete. Post-installation, FogBugz On Site requires db_owner on your FogBugz On Site databases.

Installation Script Tasks

The FogBugz On Site installation script will perform a number of tasks to provision your FogBugz On Site web server and install FogBugz On Site and its databases. The following is an overview of these tasks:

  • Installs 7-Zip
  • Enables the IIS-ASPNET feature if not already enabled
  • Enables the IIS-ASPNET45 feature if not already enabled (Windows Server 2012 / R2 only)
  • Enables the IIS-ASP feature if not already enabled (Windows Server 2012 / R2 only)
  • Enables the IIS-HttpCompressionDynamic feature if not already enabled (Windows Server 2012 / R2 only)
  • Enables the IIS-StaticContent feature if not already enabled
  • Installs SQL Server tools to provide the Invoke-SqlCmd Powershell cmdlet if not already available
  • Temporarily disables IE Enhanced Security Configuration (this is re-enabled as part of the installation process)
  • Installs the ASP.NET MVC 3 framework
  • Ensures .NET 4.0 is available
  • Installs Puppet to Program Files (x86)\Puppet Labs
  • Installs the Java JDK 7.80 to Program Files\Java\jdk1.7.0_80
  • Installs Redis Server for Windows to Program Files\Redis
  • Installs FogBugz On Site to the configured installation directory (default: C:\FBOnsite)
  • Creates 3 databases on the configured SQL Server instance:
    • fbhosted
    • FBODExportQueue
    • trial1
  • Disables the Default Web Site in IIS, if it exists
  • Creates and starts 2 IIS websites:
    • FB GEN ALL
    • FB GEN {version number}
  • Creates and starts 3 Windows services:
    • FogBugz ElasticSearch
    • FogBugz Heartbeat Pinger
    • FogBugz Queuing Service

Maintenance and Backups

We are happy to work with you to review the recovery model configured for your FogBugz On Site databases and to provide general recommendations for configuring maintenance and backup plans. Developing a disaster recovery plan and configuring maintenance and backup plans are beyond the scope of a standard On Site installation. If you don’t have a DBA on staff or would otherwise like us to assist you in developing a disaster recovery plan and configuring maintenance and backup plans for your FogBugz On Site data, please contact your account executive to discuss our professional services offerings.