- 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
HFSQL Client/Server: Configuring the server
 Available only with this kind of connection
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 setup 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: - 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.
- Connect to the server as "root"
- Run the manta_install file. You can:
- Install a new server.
- Update an existing server.
- Uninstall a server.
- 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: - 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.
- Connect to the server as "root"
- Run manta_install64. You can:
- Install a new server.
- Update an existing server.
- Uninstall a server.
- Follow the instructions displayed on the screen.
Caution: The license must be entirely scrolled in order to display the following screens. 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/
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: | | | | 1 | Files 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). | | 2 | DB 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.
| | 4 | DataApplicationA 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". | | 6 | Data 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. | | 7 | Data 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 package of the HFSQL server module. The services to uninstall are Manta and MantaManager.
- from the control panel of Windows ("Add/Remove programs").
This page is also available for…
|
|
|
|