PC SOFT

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • 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 management tool of server
  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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.
    To use this configuration, each Manta service must use a different network port and a different path of database directory.
    Remark: If a failure occurs, the service is automatically restarted.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
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 setup package of WINDEV, WEBDEV and WINDEV Mobile.
  • In the INSTALL directory of WINDEV, WEBDEV and WINDEV Mobile.
  • Versions 22 and later
    via the integrated system of Debian.
    New in version 22
    via the integrated system of Debian.
    via the integrated system of Debian.
  • Versions 22 and later
    via the integrated system of RedHat.
    New in version 22
    via the integrated system of RedHat.
    via the integrated system of RedHat.
  • Versions 22 and later
    via Docker.
    New in version 22
    via Docker.
    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 setup 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 displayed on the screen.
Caution: The license must be entirely scrolled in order to display the following screens.
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 setup package.
  2. Connect to the server as "root"
  3. Run the manta_install64 file. You can:
    • Install a new server.
    • Update an existing server.
    • Uninstall a server.
  4. Follow the instructions displayed on the screen.
Caution: The license must be entirely scrolled in order to display the following screens.
Versions 22 and later

Setup via the integrated Debian system

To use this setup mode:
  1. Run the following action:
    sudo apt-key adv --keyserver hkp://pool.sks-keyservers.net --recv-keys 3a2b08fb11ba9bca

    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
  2. Then run the following actions::
    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
Remark: This setup mode operates with the Debian distributions version 8 and later.
New in version 22

Setup via the integrated Debian system

To use this setup mode:
  1. Run the following action:
    sudo apt-key adv --keyserver hkp://pool.sks-keyservers.net --recv-keys 3a2b08fb11ba9bca

    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
  2. Then run the following actions::
    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
Remark: This setup mode operates with the Debian distributions version 8 and later.

Setup via the integrated Debian system

To use this setup mode:
  1. Run the following action:
    sudo apt-key adv --keyserver hkp://pool.sks-keyservers.net --recv-keys 3a2b08fb11ba9bca

    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
  2. Then run the following actions::
    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
Remark: This setup mode operates with the Debian distributions version 8 and later.
Versions 22 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
New in version 22

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 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
Versions 22 and later

Setup via Docker

To use this setup mode, use the following address:
https://hub.docker.com/r/windev/hfsql/
See HFSQL and Docker for more details.
New in version 22

Setup via Docker

To use this setup mode, use the following address:
https://hub.docker.com/r/windev/hfsql/
See HFSQL and Docker for more details.

Setup via Docker

To use this setup mode, use the following address:
https://hub.docker.com/r/windev/hfsql/
See HFSQL and Docker for more details.
The Manta server can be found:
  • on the development computer:
  • on the server:
HFSQL Control Center: Remote management tool of server
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 found in several sub-directories.
Remark: The same application can use data files coming from several databases.
7Data files of DataApplicationB
All the data files used by "ApplicationB", found in several sub-directories.
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 setup DVD of the HFSQL server module. The services to uninstall are Manta and MantaManager.
  • from the control panel of Windows ("Add/Remove programs").
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
HFSQL - Linux Installation Ubuntu 19
Hello,

Ci-dessous une vidéo pas à pas su l'installation Ubuntu 19 inclus la résolution du problème "Error opening terminal: xterm-256color" par l'exécution de la commande export TERM=xterm

https://youtu.be/Nh1D3yG0FxA

Bon développement.
Bernard Vésy
Bernard
16 Apr. 2020
Como Resolvi um Problema
Ocorreu um erro em um cliente
o banco de dados nao acessava mais
dava o seguinte erro: Unable to access the specified server
Entrar em servicos
MantaManager
Como resolvi..
nao existia mais o diretorio

// Blog com Video e Exemplo

http://windevdesenvolvimento.blogspot.com.br/2016/11/aula-970-windev-hyperfile-24-erro.html

https://www.youtube.com/watch?v=YpcWFhRGhfU


De matos
04 Dec. 2016