ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
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
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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 can manage connections from this page: prohibit or authorize connections, disconnect users, or send a message to 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/modifying a user, the user can be a superuser: users designated as "superuser" are authorized to perform all actions on the server, databases and all 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 files ("Logs" option): you can specify the directory for log files and enable certain logging options.. You also have the ability to specify the maximum size for log file.
  • System parameters ("System" option): listening port, server user account, remote debugging port, ...
  • Size of the index cache ("Caches" option).
    Note: in 32-bit mode, the size of the index cache is limited to 1GB.
  • Activity statistics ("Activity statistics" option): Activity statistics measure server load. 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: 12/06/2024

Send a report | Local help