ZendHQ 2.1.0

February 4, 2025

Added export and import commands to the zendhqctl database module that can be used to export and import the ZendHQ database.
Added jobqueue module to the zendhqctl command line tool that can be used to manage Job Queue queues and jobs.
Added monitoring event severity and name filters to the zendhqctl monitoring watch command.
Added support for PDO::connect() and PDO sub-classes in PHP 8.4 to the Z-Ray SQL queries handler.
ZendHQ daemon and tools now enable color output by default if the standard output is a terminal. If the standard output is not a terminal, then color output is disabled.
- ZendHQ daemon and tools now support NO_COLOR and FORCE_COLOR environment variable that can be used to disable or force color output.
- If the NO_COLOR environment variable is present and not an empty string, then color output is disabled even if the standard output is a terminal.
- If the FORCE_COLOR environment variable is present and not an empty string, then color output is forced even if the standard output is not a terminal.

The ZendHQ daemon now has a default configuration file that is loaded if no configuration file is provided with the --config-file command-line argument. The ZENDHQ_CONFIG_FILE environment variable can be used change the default configuration file path.
The zendhqctl database import and zendhqctl database migrate commands now have the --retain-id-values option that can be used to retain the original ID values when importing or migrating some of the tables (users, groups and job queue queues). Without this option, the ID values are re-generated.
Added the database.unix_socket directive to the ZendHQ daemon's MariaDB/MySQL configuration file that can be used to set the path to the local UNIX socket file used to connect to the database server running on localhost.
The jq.get_job_history JsonRPC method now supports multiple status values in the filter parameter as a JSON array. Single status values can still be provided as a string.
Database columns that might store long strings are now defined with the MEDIUMTEXT data type in the MariaDB/MySQL database schema. Existing databases are upgraded during the ZendHQ daemon initialization.
Improved performance of getting current process and thread ID values. The change affects mostly logging functionality.

Fixed a bug in the ZendHQ daemon that caused the daemon to lock up if a PHP node sent an invalid 0MQ message.
Fixed a database error that prevented ZendHQ daemon to modify Job Queue jobs when adding query, body or header parameters to a job that did not have them before.
Fixed a bug that caused Job Queue queue starvation if a job was scheduled to run in the past, but there was a higher priority job in the queue.
Fixed a bug that caused some string fields to be stored as binary data when using the PostgreSQL database. Added a workaround to convert binary data to text when reading data from the PostgreSQL database.
Fixed an invalid index in the Z-Ray database that slowed down the Z-Ray SQL queries handler.
Fixed a bug in the zendhqctl access group remove command that did not remove group permissions when a group was removed causing a new group with the same ID value to inherit deleted permissions. The bug affected ZendHQ installations with the SQLite database, which resets the auto-increment counter when a row is deleted.
Packaging changes
- Improved SElinux module for RHEL compatible operating systems to fix log and cache files access in web server environment.
- Changed default directory permissions for log and cache files to fix PHP extension functionalities.