Configuring the server application as a service under Windows
The administrator of the server hosting Office Maker or BiblioMaker must perform the following operations before installing the software:
OM_service / BM_service account
You'll need a local Administrator account to run the Office Maker server / BiblioMaker server service.
If necessary, create a local account. In this case, it is imperative to log on at least once with this account in order to create the folder hierarchy.
In the account properties, the account password must not be changed.
The service starts but stops after some seconds : how do I fix the issue ?
Full rights for certain folders
The following folders must have full rights for the OM_service / BM_service account:
- C:\Program files\[Office Maker | BiblioMaker]
- C:\ProgramData\OMFiles
The following operations are performed during software installation, usually by a Micro Consulting technician:
Data and backups folders
Folders containing data files must have a very precise naming structure to allow for fiscal year changes:
OM Business
[Folder name]\Business\OMB_[Company name]\OMB_[Company name].4DD
OM Finance
[Folder name]\Finance\OMF_[Company name]_[Period year]\OMF_[Company name]_[Period year].4DD
OM Staff
[Folder name]\Staff\OMS_[Company name]_[Period year]\OMS_[Company name]_[Period year].4DD
If the server hosts several instances of the same program (e.g. Business, Finance or Staff), the application folder file with the .4DZ extension will have to be renamed so that each Windows service has a different name.
Examples :
- C:\Program Files\Office Maker\OM Finance N\Server Database\OM Finance N.4DZ (current period)
- C:\Program Files\Office Maker\OM Finance N-1\Server Database\OM Finance N-1.4DZ (previous period)
- C:\Program Files\Office Maker\OM Business [Name of the company A]\Server Database\OM Business [Name of the company A].4DZ
- C:\Program Files\Office Maker\OM Business [Name of the company B]\Server Database\OM Business [Name of the company B].4DZ
Port numbers and ranges
Each Office Maker/BiblioMaker Server program is assigned a range of 10 TCP port numbers. These numbers are unique for each server. Here is the list of ports and their usage:
- XXXX2 (example : 19812) : SQL
- XXXX3 (example : 19813) : Client-server connection (number to be communicated to the end customer and used to connect OM Client)
- XXXX4 (example : 19814) : Port used by 4D (XXXX3 + 1)
- XXXX5 (example : 19815) : PHP Interpreter (4D ou external)
- XXXX6 (example : 19816) : Free
- XXXX7 (exemple : 19817) : Free
- XXXX8 (example : 19818) : Free
- XXXX9 (example : 19819) : Access to OM API (UDP/TCP)
- XXXX0 (example : 19820) : HTTPS port for OMB Mobile and BiblioMaker WebOPAC
- XXXX1 (example : 19821) : HTTP port for OMB Mobile and BiblioMaker WebOPAC
Launching apps
It is imperative that all applications (except when launched as a service) are launched from this OM_service/BM_service session, so that each application's lastDataPath.xml file is initialized and stored with the data access path:
- C:\Users\BM_service\AppData\Roaming\BiblioMaker\lastDataPath.xml
- C:\Users\OM_service\AppData\Roaming\OM Business\lastDataPath.xml
- C:\Users\OM_service\AppData\Roaming\OM Finance\lastDataPath.xml
- C:\Users\OM_service\AppData\Roaming\OM Staff\lastDataPath.xml
Creating a Windows service
Run Office Maker server / BiblioMaker server as Administrator to register it as a service (menu File>Register current base as service).
Setting up the firewall
The firewall must not prevent our software from connecting to our servers:
To query our license server from the client application :
https://keymaker.microconsulting.ch (TCP port 443 by default)
To download updates from our server :
- Office Maker : http://om-autoupdates.officemaker.ch (TCP port 80 by default)
- BiblioMaker : http://bm-autoupdates.bibliomaker.ch (TCP port 80 by default)
OM Staff is likely to communicate with a server hosting Swissdec (transmission of payroll data) or to download necessary files (Java, ViewGen) from the workstation.
In addition, for communication between the server and workstations, the ports mentioned above must be open.