ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / Managing HFSQL Client/Server
  • Manta server
  • Where is the Manta server installed?
  • How to install HFSQL Client/Server?
  • Setup in Linux
  • Setup via the integrated Debian system
  • Setup via the integrated system of RedHat and derived
  • Setup via Docker
  • HFSQL Control Center: Remote server administration tool
  • Files found on the server
  • Uninstalling the services from a server
  • The server services can be uninstalled
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
Manta server
The Manta server includes:
  • the MantaManager service used to communicate with the "HFSQL Control Center" application (remote management tool) and to stop and/or start the servers.
  • the Manta service.
    By default, a single Manta service is found on the server. However, several Manta services can be found on the same server. This configuration allows you to associate a WINDEV/WEBDEV application (or a small number of WINDEV/WEBDEV applications) to a Manta service for example. Therefore, if an application overloads the Manta service, only the applications associated with this service will be locked or slowed down.
    Repita esta acción para los controles "Reference" y "Bar code".
    Remark: If a failure occurs, the service is automatically restarted.In WINDEV:
In WEBDEV:
Where is the Manta server installed?

How to install HFSQL Client/Server?

The setup of HFSQL Client/Server is available:
  • In the installation package of WINDEV, WEBDEV and WINDEV Mobile.
  • In the INSTALL directory of WINDEV, WEBDEV and WINDEV Mobile.
  • via the integrated system of Debian.
  • via the integrated system of RedHat.
  • via Docker.
The HFSQL Client/Server server can be installed with your applications. All you have to do is include it when creating the setup program.
Remark: The Manta server must be installed on a computer running a server version of Windows (all versions supported by Microsoft). The Manta server can also be installed on a computer running Linux (x86 or compatible processor).

Setup in Linux

To install the HFSQL Client/Server server on a LINUX server:
  1. Copy the following files to the server:
    • manta_install
    • mantainstall.zip
    • README
      These files are located in the "HFSQL Server\Linux4" subdirectory of the installation package.
  2. Connect to the server as "root"
  3. Run the manta_install file. You can:
    • Install a new server.
    • Update an existing server.
    • Uninstall a server.
  4. Follow the instructions on screen.
Caution: You must scroll down to the end of the license agreement in order to continue.
To install the 64-bit HFSQL Client/Server server on a 64-bit LINUX server:
  1. Copy the following files to the server:
    • manta_install64
    • mantainstall.zip
    • README
      These files are located in the "HFSQL Server\Linux44_64" subdirectory of the installation package.
  2. Connect to the server as "root"
  3. Run manta_install64. You can:
    • Install a new server.
    • Update an existing server.
    • Uninstall a server.
  4. Follow the instructions on screen.
Caution: You must scroll down to the end of the license agreement in order to continue.

Setup via the integrated Debian system

To use this setup mode: Execute the following action (starting with Ubuntu 22.04 and Debian 11):
curl -sS https://package.windev.com/keys/hfsql_public.asc | \
gpg --dearmor | \
sudo tee /usr/share/keyrings/pcsoft.gpg > /dev/null

echo "deb [signed-by=/usr/share/keyrings/pcsoft.gpg] http://package.windev.com/fr/debian/ debian main" | \
sudo tee /etc/apt/sources.list.d/pcsoft.list

sudo apt update
sudo apt install hfsql
For older Linux distributions, you can execute the following action:
curl -sSL https://package.windev.com/keys/hfsql_public.asc | sudo apt-key add -
sudo echo "deb http://package.windev.com/fr/debian/ debian main"
> /etc/apt/sources.list.d/pcsoft.list
sudo apt-get update
sudo apt-get install hfsql
Caution: If you get an error in the following format: "gpg: failed to start the dirmngr" then run the following command:
sudo apt-get install dirmngr
Remark: This setup mode operates with the Debian distributions version 8 and later.

Setup via the integrated system of RedHat and derived

To use this setup mode, perform the following actions:
sudo dnf config-manager --add-repo http://package.windev.com/fr/rpm/pcsoft.repo
sudo dnf install hfsql
sudo systemctl start hfsql

Setup via Docker

To use this setup mode, use the following address:
https://hub.docker.com/r/windev/hfsql/
For more details, see HFSQL and Docker.
The Manta server can be found:
  • on the development computer:
  • on the server:
HFSQL Control Center: Remote server administration tool
The HFSQL Control Center is used to:
  • manage the different servers used.
  • manage the users and the groups of users for the databases.
  • view and/or modify the content of a database.
  • perform searches in a database.
  • run queries on a database.
  • view the current connections to a database or to a data file.
  • stop, start, install and/or uninstall a server.
  • ...
Files found on the server
By default, the files found on the server are as follows:
1Files found at the root of the server
The HFConf.ini file is used to define:
  • the path of the directory containing all the data files of different WINDEV HFSQL Client/Server applications (#2).
    The corresponding keyword is "DBRootPath".
    To specify the directory of the Manta service, use the "%%EXE%%" string.
  • the network port used. The port 4900 is used by default.
    The corresponding keyword is "AccessPort".
The Manta.exe file corresponds to the Manta service.
The MantaManager.exe file corresponds to the MantaManager service.
The WDHFSrv.dll and WDSQLSrv.dll files correspond to the WINDEV libraries required by the Manta and MantaManager services (port 4999).
2DB directory
This directory contains all the databases found on the server.
3__System directory
This directory contains the files used to define:
  • all the integrity rules between the different databases.
  • the users of the databases.
  • the groups of users for the databases.
  • the links between the users and the groups of users.
4DataApplicationA directory
This directory contains all the data files used by "ApplicationA". The name of this directory is defined when creating the connection used by the application.
5__System directory of DataApplicationA
This directory contains the files used to define all the integrity rules for "ApplicationA".
6Data files of DataApplicationA
All the data files used by "ApplicationA".
As explained in #7, these files can also be present in several subdirectories.
Remark: The same application can use data files coming from several databases.
7Data files of DataApplicationB
All the data files used by "ApplicationB", present in several subdirectories.
Remark: The same application can use data files coming from several databases.
Uninstalling the services from a server

The server services can be uninstalled

  • via the installation package of the HFSQL server module. The services to uninstall are Manta and MantaManager.
  • from the control panel of Windows ("Add/Remove programs").
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/12/2023

Send a report | Local help