ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WEBDEV administrator / Remote HFSQL administrator
  • Overview
  • Details of available options
  • Databases
  • Connections
  • Transactions
  • Users
  • Groups
  • Rights
  • System information
  • Server configuration
  • Logs
  • Backups
  • Scheduled tasks
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
Overview
During the connection to the remote HFSQL administrator, you must specify the HFSQL server that will be taken into account. Then, the different options available on the selected server are listed.
Details of available options

Databases

This option is used to select one of the databases found on the server. This gives you the ability to access all the options for managing the database.

Connections

This option lists the different users connected to the different databases found on the server.
The list of active connections contains the following information:
  • the database name,
  • the username,
  • the computer name,
  • the name of the application that accesses the database, ...
You have the ability to manage the connections from this page: allow or forbid the connections, disconnect the users or send a message to the users.

Transactions

This option is used to manage the current transactions or the interrupted transactions on the server.

Users

This option is used to find out and manage the users of the server. You have the ability to create, modify or delete a user.
When creating or modifying a user, the user can be a superuser: users defined as "superusers" are allowed to perform all actions on the server, databases and data files.

Groups

This option is used to find out and manage the groups of users of the server. You have the ability to create, modify or delete a group of users.
You also have the ability to associate users with a group.

Rights

This option is used to manage the rights on the server for the selected user or group.

System information

This option is used to find out:
  • the server platform.
  • the platform version.
  • the architecture of the engine.
  • the server processor.
  • the available memory.
  • the version of the elements on the server.

Server configuration

This option is used to configure the server. The following elements are taken into account:
  • Location of databases on the server ("General" option)
  • Directory of logs and backups ("Logs" option)
  • Log file ("Logs" option): you have the ability to specify the directory of the log files and to enable some backup options. You also have the ability to specify the maximum size for log file.
  • System parameters ("System" option): listening port, user account of the server, port for remote debugging, ...
  • Size of the index cache ("Caches" option).
    Remark: in 32 bits, the size of index cache is limited to 1GB.
  • Activity statistics ("Activity stat." option): The activity statistics are used to measure the server workload. You have the ability to enable the activity statistics ans to specify the backup directory.

Logs

This option is used to view the server logs directly. This option is available only if the logs are enabled on the server.
You also have the ability to import the logs.

Backups

This option is used to perform and restore backups of the server and/or databases. For more details, see Performing backups with the remote HFSQL administrator.

Scheduled tasks

This option is used to create, modify and deleted the scheduled tasks found on the server. For more details, see Managing the scheduled tasks with the remote HFSQL administrator.
Minimum version required
  • Version 16
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 09/07/2023

Send a report | Local help