Multiple databases and their licenses need to be installed on one server.
KM8: All Versions
KM8 Premium only
When you one two or more KM8 licenses and want them hosted on a single server some additional configurations are required.
Determine the databases you want and some logical names. Note in the examples the consistence between names and where the KM8 prefix is used.
e.g.
¶ Database 1
Business unit = “Watercare Services”
DatabaseName = KM8Watercare.fdb
Environment = Watercare
DatabaseAlias = KM8Watercare
¶ Database 2
Business unit = “Social Development Services”
DatabaseName = KM8SocialDevelopment.fdb
Environment = Social Development
DatabaseAlias = KM8SocialDevelopment
Open the databases.conf file in notepad.
The location of this file is:
C:\Program Files(x86)\WH Software\KM8\FB3\databases.conf
Or for 32bit Windows:
C:\Program Files\WH Software\KM8\FB3\databases.conf
Notepad must run as administrator in order to save your changes
There will be a single line
KM8=C:\ProgramData\WH Software\KM8\Database\KM8.FDB
Based on our examples above, we want to change this file to have just the following two lines:
KM8Watercare=C:\ProgramData\WH Software\KM8\Database\KM8Watercare.fdb
KM8SocialDevelopment=C:\ProgramData\WH Software\KM8\Database\KM8SocialDevelopment.fdb
This file is used by the database engine to associate a name (KM8WaterCare) with a database file (KM8Watercare.fdb)
If you wish to store the databases in a different local location this is where you define that location.
On the server (but the same changes will need to be applied to each workstation), edit the following file:
C:\ProgramData\WH Software\KM8\KM8.ini
In that file there will be two sections that look like this (likely the blank lines will be missing but you may make blank lines to make the file more readable):
[Environments]
Default=Environment-Default
[Environment-Default]
ServerName=localhost:KM8
Based on our examples above, we want to change this part if the file the following:
[Environments]
Watercare=Environment-Watercare
Social Development=Environment-SocialDevelopment
[Environment-Watercare]
ServerName=localhost:KM8Watercare
[Environment-SocialDevelopment]
ServerName=localhost:KM8SocialDevelopment
This change is making two “Environments” each of which point to another section in the same ini file, which in turn specifies the server (localhost) and database alias (as we set earlier in databases.conf)
Later, the same change needs to be made to all workstations (but possibly not all environments on each workstation), but on the workstations, the reference to
localhostwill be the name of the server on which the databases are hosted.
During the installation, the database C:\ProgramData\WH Software\KM8\Database\KM8.fdb was created. We have changed all references so they are specific to each database, so this database (it may have been a blank one or may have been your KM5 database upgraded depending on the choices you made) must be renamed.
Change its name from KM8.fdb to KM8Watercare.fdb (or whatever name you have chosen)
We now need to make the other databases (only 'Social Development' in this example as we did the other database with the initial installation)
Run the program KM8DbCfg.exe
The location of this file is:
C:\Program Files(x86)\WH Software\KM8\Bin\KM8DbCfg.exe
Or for 32bit Windows:
C:\Program Files\WH Software\KM8\Bin\KM8DbCfg.exe
Social DevelopmentRe-run KM8DbCfg.exe for any other databases that need to be created.
Still on the server, for each environment one at a time do:
Still on the server, run KM8Back.exe, click the configure button and ensure that all environments are selected for backup and ensure that the Windows Scheduled Task is created and active. See the article Overview of backups
Do not do anything that directly accesses the FDB database files such as your own backup processes or even anti-virus software. Read the documentation about this as it is very important.