KDS Update

Important!

The KDS product will not updated from June 1, 2020, onwards. Use KDS PRO. Users get a 70% discount for switching. 
The software will not be supported from December 31, 2020, onwards.

Introduction

This article describes the process of updating KDS and SQL Firebird.

In some cases, SQL Firebird unnecessarily loads the processor. In this case, updating to the latest version helps. Then we will talk about how to do it correctly.
Please note that we are only talking about an update within the 2.5 branch-since KDS does not support Firebird 3.

It is assumed that you already have Firebird installed and the KDS and r_keeper_7 systems. If Firebird is not installed, download and install it in the x86 SuperServer configuration.

Detailed instructions for updating on the official website: http://www.ibase.ru/inst_manual/#update

The Firebird update must be done on both computers: with the KDS server and with the KDS client.
It will be based on the current distribution version 1.3.5.4. For previous and subsequent versions, the process may be slightly different.

Brief description

  1. Make a backup of your files
  2. Download new versions of KDS and with Firebird
  3. Stop Services
  4. Overwrite old files with new ones
  5. Update config files
  6. Start Services

Preparing for the update

  1. Make a backup of the entire Firebird folder
  2. Stop existing Firebird instance service: Firebird Guardian – InstanceName
  3. Find the file in the Windows\System32 or SysWOW64 folder dll from the previous installed version of Firebird. If there is a file, make a copy of it. If there is no file, you do not need to back it up.
  4. Download the ZIP archive with the Firebird 2.5 installation files. x86 version — https://firebirdsql.org/en/firebird-2-5/#Win32
  5. Unzip the files to a temporary folder. When unpacking, be careful: the archive contains the configuration file conf/aliases.conf or ibconfigand the user database file security.fdb, admin.ib or isc4.gdb. If you overwrite these files on top of your current ones, you will lose not only the settings you have made, but also the list of server users. Therefore, it is advisable to immediately delete these files in the temporary directory where you unzipped the zip following the instructions in step 4.
  6. Now you can simply copy the entire root directory of the new version over the existing root directory of the server. If the server is currently running, then of course, rewrite ibserver.exe, fbserver.exe, firebird.exe or fb_inet_server.exe it won't work.
  7. Return the config files to their old places:
    1. conf
    2. cong
  8. Next, after rewriting the new files, update the library file dll/fbclient.dll in Windows\System32 or SysWOW64, so that the client part exactly matches the server version.
  9. If you are updating to the latest version, read the instructions about the utility instclient.exe, you may need to update the library gds32.dll.
  10. Go to the new Firebird working directory and open theconf file
  11. Uncomment the RemoteServicePort parameter by removing the sign before it#
  12. Specify a free port which this Firebird instance will run on: RemoteServicePort = 3050
  13. Start the Firebird service

Updating the database

Updating the Firebird SQL database.

  1. Start the FirebirdServerFirebirdInstance and FirebirdGuardianfirebirdInstance services. The service is named on the principle of FirebirdInstanceName
  2. Run a command prompt and navigate to the KDS\DB\DBUpdate folder
  3. Run the command exe -db
  4. Specify the data to connect to the Firebird server. For example:
  5. Click Update DB. The program should write Update DB Complete.
  6. Close Update DB

Configuring the KDS Server

The process is not much different from the usual configuration of the KDS server.

To configure the KDS server:

  1. Specify the database alias in the alias parameter mapped to the address of the database file in  conf.
  2. Specify the IP address and port of the Firebird server. For example:
  3. Specify the IP address and port of the XML interface of the cash register server in the appropriate parameters. For example:
  4. Fill in License To do this, get the license code in advance in the licensing system. For more information about licensing, seeKDS Licensing
  5. Specify the logging level. For example:
  6. Save and close the settings file.

Configuring the KDS Client

It remains to configure the KDS client.

A Firebird instance must be installed on the computer running the KDS client.

Open kdsclient.ini file and fill in the parameters similar to the KDS server:

Optionally, adjust the size and position of the window using the parameters left, top, width, height.

That's it! Start KDS client.