Versions Compared

Old Version 1

changes.mady.by.user Ekaterina Marchenko

Saved on

compared with

New Version 2

changes.mady.by.user Ekaterina Marchenko

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Note
title

...

Important!

...

KDS

...

has not been updated

...

since June 1, 2020

...

.

...

Please use KDS PRO.

...


The software

...

has not been suported since December 31, 2020

...

.

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 The instruction below describes 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 installed 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 and Firebird
  3. Stop Services
  4. Overwrite old files with new ones
  5. Update config files
  6. Start Services

Preparing for

...

Update

  1. Make a backup of the entire Firebird folder
  2. Stop the existing Firebird instance service: Firebird Guardian – — InstanceName
  3. Find In the file in the Windows\System32 or SysWOW64 folder dll from folder, find the GDS32.dll file 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 carefulBe careful when unpacking: the archive contains the configuration file the conf/aliases.conf or ibconfigand the user database file ibconfig configuration file and the security.fdb, admin.ib or isc4.gdbgdb user database file. If you overwrite replace your current config and database files with 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 recommended to immediately delete these files in the temporary directory where you unzipped the zip following the instructions in step 4.archive to
  6. Now you can simply copy replace the entire existing root directory of the new version over the existing server with the entire root directory of the servernew version. If the server is currently running, then of course, you won't be able to 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. confFirebird.conf 
    2. Aliases.cong
  8. Next, after rewriting the new files, update the library file update the gds32.dll/fbclient.dll library file 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 the gds32.dll.dll library
  10. Go to the new Firebird working directory and open theopen the firebird.conf 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

Database Update

Updatie Updating the Firebird SQL database.

  1. Start the FirebirdServerFirebirdInstance and FirebirdGuardianfirebirdInstance services. The service is named on according to the following principle of : FirebirdInstanceName
  2. Run a command prompt and navigate to the KDS\DB\DBUpdate folder
  3. Run the command DBUpdate.exe -db
  4. Specify the data to connect to the Firebird server. For example:
    • Server — localhost
    • Port — 3050
    • DB Alias — KDS_DB
  5. Click Update DB. The program should write Update DB Complete.
    kds.jpgImage Added
  6. Close Update DB

...

KDS Server Settings

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

To configure the KDS server:

  1. Specify the database alias in the alias parameter mapped corresponding to the address of the database file in aliases.conf.
    • allias=KDS_DB
  2. Specify the Specify the IP address and port of the Firebird server. For example:
    • SrvName=localhost
    • SrvPort=3050
    Specify the
  3. Specify the IP address and port of the XML interface of the cash register server in the appropriate corresponding parameters. For example:
    • SrvAdress=127.0.0.1
    • RK7Port=1417
  4. Fill in in the License parameter. To do this, get the license code in advance in the licensing license system. For more information about licensing, seesee KDS Licensing
  5. Specify the logging level. For example:
    • LogLevel=5
  6. Save and close the settings file.

...

KDS Client

...

Settings

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

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

  • dbServer=localhost
  • dbPort=3050
  • dbAlias=KDS_DBNEW

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

That's it! Start the KDS client.