ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Control Centers / HFSQL Control Center / HFSQL Client/Server
  • Overview
  • Implementation
  • How to?
  • Custom update server
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
automatic update of the HFSQL Client/Server server
HFSQL Client/ServerAvailable only with this kind of connection
Overview
The HFSQL Control Center is used to implement the automatic update of the HFSQL server..
If this option is enabled, the HFSQL server can be automatically updated as soon as a new version is available:
  • on the PC SOFT server.
  • on a custom server.
Implementation

How to?

To implement the automatic server update:
  • In the dashboard of HFSQL Control Center, in the "Version" widget, click "Configure the updates". The window for server configuration is displayed, click "Version".
  • From the ribbon for server characteristics, in the "Parameters" group, click "Server configuration" and display the version options.
The Control Center indicates whether the server is updated or whether an update is available. In this case, the HFSQL server can be immediately updated via the "Update server" button.
You also have the ability to configure an automatic update. In this case, the update will be automatically performed as soon as a server update is detected.
When "Enable automatic update" is selected:
  • a wizard starts. This wizard proposes to use:
    • the PC SOFT update server: This server contains the last updates of the HFSQL server validated by our Quality Department.
    • a custom server. In this case, the URL of the custom update server must be specified (see next paragraph).
  • the wizard proposes to schedule the check of the update server (once a month for example).
    Remark: If a new version is available during the check, the HFSQL server will be stopped and the users will be disconnected during the entire update.

Custom update server

You can use a custom update server for the HFSQL server. This allows you to control the HFSQL server updates of the users. You can for example validate the use of a new version before releasing it.
To create a custom update server for HFSQL servers, you must:
  1. Install a Web server (IIS or Apache) on the selected computer.
  2. Create the following MIME types on the Web server if they do not exist:
    • .json -> application/json
    • .sign -> application/byte-stream
    • .zip -> application/x-compress
  3. Create a directory at the root of the Web server. This directory will contain the update packages. Example: C:\inetpub\wwwroot\hfsql_packs
    This directory must contain:
    • A json file containing the names of the packages to be used according to the versions (see below). The name of this file must be "hfsql_updateinfo.json".
    • The update packages (".zip" files).
    • The signature files corresponding to the packages (".sign" extension).
    These packages and their signatures are available at: http://package.windev.com/hfsql/.
For example:
  • Web server for updates: srvupd
  • UNC directory containing the updates: \\srvupd\hfsql_packs\
  • URL for updates: http://srvupd/hfsql_packs/
Example of Json file:
{
"pack": [
{
"major_version": 22,
"language"     : "F",
"version"      : "220099",
"min_version"  : "220036",

"pack": [
{
"platform": "win32",
"data"     : "srv_hfsql_win32_90F220099z"
},
{
"platform": "win64",
"data"     : "srv_hfsql_win64_90F220099z"
},
{
"platform": "linux32",
"data"     : "srv_hfsql_linux32_90F220099z"
},
{
"platform": "linux64",
"data"     : "srv_hfsql_linux64_90F220099z"
}
]
}
]
}
where:
  • major_version: corresponds to the major version of the package (22, 23, etc.). Only the HFSQL servers corresponding to this version will be updated.
  • language: corresponds to the server language (E for English, F for French, etc.).
  • version: corresponds to the HFSQL server version in the package.
  • min_version: corresponds to the minimum version from which the package can be applied.
  • pack: used to specify the characteristics of the packages.
  • platform: platform corresponding to the package:
    • win32: 32-bit Windows
    • win64: 64-bit Windows
    • linux32: 32-bit Linux
    • linux64: 64-bit Linux
  • data: corresponds to the name of the package (without extension).
Remark: A single package may be referenced according to the platform used by the HFSQL servers.
Minimum version required
  • Version 22
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 04/24/2024

Send a report | Local help