your database front-end

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 42057.
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.
UserContainer: The name of the active directory container(s) for users and groups.  This is only required for non-default active directory structures.   e.g. "CN=Users,DC=corp,DC=domain,DC=com"
ContextType: The ContextType will 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.
CultureName: If not set or blank the Application Server will use the hosting servers Culture.  The server default is likely to be something like 'en-US'.  See: Culture Settings for more detail.
SetupLocked: If this key is missing or set to "true" then access to Authentication Setup is removed from the login screen.
ShowDomainName: If this key is set to false then dbFront will hide the name of the authentication source (computer name or AD name) or replace it with the name "Default"
SessionExpiryMinutes: Specifies how long an inactive session will remain active.
DataPath: e.g. [Data\\]
CachePath: e.g. [Cache\\]
LogPath: e.g. [Logs\\]

 

Culture Settings

The [dbfrontservice.exe.config] file allows you to override the Culture Settings used by the entire dbFront application and service.

The currently active Culture will be show on the [WebSite] and [Service] tabs of the Settings dialog.  To access the Settings dialog click on Help > Settings within dbFront.

By default the CultureName will be taken from the server running the Application Server and applied everywhere.   This ensures that numbers and other data types are displayed and handled consistently within the three layers of dbFront: Service, Web Application, and Client Browser.

Service and Application Restart Required for Culture Updates

To override the server default you will need to directly update the [dbfrontservice.exe.config] file.  Once the CultureName has been updated then a restart of the Service and then Application will be required.

<configuration>
  <appSettings>
    <add key="CultureName" value="
en-US"/>
  </appSettings>
</configuration>

Please see the reference to the setting [UseHtml5NumericInput] for more related information: UseHtml5NumericInput

Database Default Settings

The following [dbfrontservice.exe.config] settings allow you to adjust the Database Default settings.

NewDatabaseVisibility: [Visible, Hidden] The default visibility of any new database made available to a connection after its initial creation.
NewTableType: [Main, Child, Lookup, System]  The default visibility of any new table.
NewFieldVisibility: [AppendToForm, Hidden]  The default visibility of any new field added to a table after its initial creation.
 

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

<configuration>
  <appSettings>
    <!-- Visible, Hidden -->
    <add key="NewDatabaseVisibility" value="Hidden"/>
    <!-- Main, Child, Lookup, System -->
    <add key="NewTableType" value="System"/>
    <!-- Hidden, AppendToForm -->
    <add key="NewFieldVisibility" value="Hidden"/>
  </appSettings>
</configuration>

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