the web front-end for your database

Installing the Application Service

The dbFrontService is fully and automatically installed by the installer but you may need to update some settings if the installation was a bit more complex or if you would like to tweak them to better match your own environment

Command Line Options

By default the dbFrontService installs in: [C:\Program Files (x86)\dbFrontService].

The following are some command line options you can use to install or uninstall the service.

  • To install, execute: dbFrontService -install
  • To uninstall, execute: dbFrontService -uninstall
  • To run without installing, execute: dbFrontService -run
  • To start the console menu: dbFrontService

Base Setting

To update the setting you need to edit the included [dbfrontservice.exe.config] file and adjust the following settings.

This first group of settings covers the core of what is required to get dbFront running.

ServicePort: The port on which this service will listen. The default is 8080.
UserDomain: Enter the name of the current server to use the users on the local system. You can also specify the name of a domain to use the full active directory domain.
ContextType: The ContextType with automatically adjust depending upon the Server or Domain that is used to authenticate they user.  If there is a problem you can manually set it to either "Machine" if you are authenticating against the local machine, or "Domain" if you are authenticating against a network Domain.
LoginType: The LoginType is 2 (Interactive) by default which means that users need to have interactive Logon Rights.  If the LoginType is set to 3 (Network) then the users are expected to have network access privileges.
SessionExpiryMinutes: Specify how long an inactive session will remain active.
DataPath: e.g. [Data\\]
CachePath: e.g. [Cache\\]
LogPath: e.g. [Logs\\]

 

User Settings

These [dbfrontservice.exe.config] settings allow you to determine the default groups of users that will have access to dbFront.

AdminAllGroup:
  • The name of the local or domain group who's users will have the ability to add or administer all Database Connections.
  • Local and Domain Administrators will automatically have this privilage.
AdminMyGroup:
  • The name of the local or domain group who's users will have the ability to add or administer their own Database Connections.
UserGroup:
  • The group of users who have access to login to dbFront.
  • If this entry is empty then by default every authenticated user has access to dbFront.
  • Any user not listed in the group specified by this setting will NOT have access to dbFront.   This applies even if they are members of a connection specific AD group or if they are members of the groups specified by AdminAllGroup or AdminMyGroup.

To save these settings you will need to directly update the [dbfrontservice.exe.config] file.

<configuration>
  <appSettings>
    <!-- Additional Administrator Group, can administer all connections. -->
    <add key="AdminAllGroup" value="dbFront_Administrators"/>
    <!-- Can create and manage their own connections -->
    <add key="AdminMyGroup" value="dbFront_Superusers"/>
    <!-- Users who have access to login to dbFront. -->
    <add key="UserGroup" value="dbFront_Users"/>
  </appSettings>
</configuration>

On a per connection basis you can also specify two other groups, Update and Readonly.  This will allow you to limit the list of users that have access to the data within that connection.  Those two setting are setup in the connection access preferences.  For more details see: Windows Authentication

Note: All users that need access to dbFront must be contained within the group specified by the UserGroup configuration setting.

For more information on setting up the login information see: Authentication.

Troubleshooting

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

The Next Steps

Content you want the user to see goes here.
close