your database frontend

Installing the Web Application

The dbFront Installer is able to fully install the website within minutes.

This section is only for people who chose to manually install the website files or for those who would like to tweak the setting to better match there own environment.

If you chose a manual install then you will need to find where you saved the website files and use IIS Manager to create a Web Application.

The webserver needs to be Microsoft IIS version 6.0 or better. For more details see: Preparing Windows to host a Dotnet 4.0 website

Manually Installing dbFrontUI on the Web Server

  1. Ensure that your Web Server has the WebServer role configured.
  2. Copy the contents of the dbFrontUI folder somewhere on your server. A reasonable default is [C:\InetPub\dbFrontUI]
  3. Open IIS Server Admin and browse into the Application Pools
  4. Add an Application Pool with the following settings:
    Name: dbFrontPool
    Framework Version: v4.0.30319
    Enable 32-Bit Applications: True (Advanced Settings)
  5. In IIS Server Admin browse into your Default Web Site
  6. Create a WebApplication (Not WebSite) with the following settings:
    Alias: dbfront
    Path: The path to the website files. e.g. [C:\InetPub\dbFrontUI]
    App Pool: Select the Application Pool you just created.
  7. Update the included [web.config] file and adjust the following settings:
    NOTE: You should have the Cache and Logs folders outside the web folder.
    ServiceHost: If the Web Server is in a DMZ this should be the IP address of the Firewall port leading into the network. Otherwise specify the Servername or IP address which is hosting the Application Service.
    ServicePort: The port used to communicate with the Application Server. The default is 42057.
    CachePath: e.g. [c:\\temp\\dbFrontCache\\]
    LogPath: e.g. [c:\\logs\\dbFrontUI\\]

Update an Existing Install

  1. Make a backup of your existing dbFrontUI folder.
  2. Update all files except the file named web.config.

Test the Install

  • On the server browse to the URL where you installed dbFront, e.g. [http://localhost/dbFrontUI/].
  • If you see a license notification then follow the directions to receive a license number for your server.

Layout Settings

The following [web.config] settings allow you to adjust how the dbFront website is rendered.

SiteHeaderHtml

[HTML]  Allows you to specify HTML that will be inserted at the top of the Page.  The HTML can include any valid HTML tags.  The site header currently support the following replaceble tags.

{%DatabaseCaption%} :Will be replaced with the caption of the current database or blank if no database is selected.
{%TableCaption%} : Will be replaced with the caption of the current table or blank if no table is selected.
{%InspirationalQuote%} : Insert an inspirational Quote.

SiteFooterHtml [HTML]  Allows you to specify HTML that will be inserted at the bottom of the Page.   The HTML can include any valid HTML tags.
SiteTheme Allows you to specify the name of the main website theme.  e.g.  [start, pepper, le-frog] 
SiteCssFile [filename] Allows you to specify the name of a custom CSS file.  e.g. "css/customSite.css"
UseHtml5NumericInput:

[true, false]  Specify if dbFront should use the Html5 numeric inputs.  Html5 numeric inputs don't handle different numeric formats as dictated by the Cultural Settings in an intuitive manner.

UseCDN: [true, false]  Specify if the user will be provided links to local resources or CDN resources.  Locally hosted resources are more reliable but they use up more bandwidth.

Login Screen Settings

The following [web.config] settings allow you to adjust the Login Screen functionality.

Notice: This represents an HTML formatted message that can be added to the head of the login screen.
RememberMe: [true, false] Indicate if dbFront offers to remember the current user on that workstation.
UsageAgreement: If set then the user will be required to indicate agreement before login.


For more details see: Login Settings

User Help Settings

The following [web.config] settings allow you to adjust the Help functionality.

HelpURL: Replace the default dbFront help as requested from the menu.
SidebarHelp: [on, off, disable]  Determine if the SideBarHelp is enabled.


For more details see: Help Settings

Troubleshooting

If you encounter any issues then please read our Troubleshooting Guide.

The Next Step

Once the website is installed then the next step is to install and configure the application server.

Content you want the user to see goes here.
close