Changes in v1.9.2

Maintenance Release: August 8^th, 2022

• Build:
  • clustercontrol-controller- 1.9.2-5690
  • clustercontrol-notifications-1.9.2-323
• Controller:
  • Address an issue where ProxySQL deployment fails on MariaDB 10.6 (CLUS-1460).
  • Address an issue where DB user/account creation fails on MariaDB 10.6 (CLUS-1431, CLUS-1449, CLUS-1456).
  • Address an issue to include Controller/CMON and cluster name for notifications (CLUS-1416).

Maintenance Release: July 7^th, 2022

• Build:
  • clustercontrol-controller- 1.9.2-5599
• Controller:
  • Address an issue where the my.cnf file was modified after adding a MySQL (galera) node. The my.cnf is now considered immutable if the cluster has been imported (CLUS-1396).
  • Address an issue starting/stopping EOL version of PostgreSQL 9.6 (CLUS-1406).

Maintenance Release: June 24^th, 2022

• Build:
  • clustercontrol-controller- 1.9.2-5564
  • clustercontrol-1.9.2-8354
• Controller:
  • Address an issue with rebuilding replication node (MySQL) due to the format of host: port (CLUS-1370).
• Frontend (UI):
  • Address an issue with rebuild replication node (MySQL) where the primary node is not recognized to be part of the cluster. (CLUS-1360).

Maintenance Release: June 15^th, 2022

• Build:
  • clustercontrol-controller- 1.9.2-5545
  • clustercontrol-1.9.2-8344
• Controller:
  • Address further improvements to correctly handle backup retentions (CLUS-1331).
  • Address an issue where cluster de-registration cleanup is now taken care of in the backend/cmon (CLUS-1336).
• Frontend (UI):
  • Address an issue where adding an external mail notification address failed (CLUS-1339).
  • Address an issue where cluster de-registration cleanup is now taken care of in the backend/cmon (CLUS-1336).

Maintenance Release: June 8^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5530
  • clustercontrol-1.9.2-8336
• Controller:
  • Address an issue where backups and backup records were left after deleting a cluster (CLUS-1218).
  • Address an issue where CMON retries connecting to a MySQL node with insecure connection – Use new connect_heartbeat_when_faulty=30 (30s default) to block connection attempts until the correct certs are used/configured (CLUS-1278).
• Frontend (UI):
  • Address an issue when deleting a cluster to choose whether backups should be removed/deleted as well or left intact (CLUS-1218).

Maintenance Release: May 31^st, 2022

• Build:
  • clustercontrol-controller-1.9.2-5501
• Controller:
  • Address an issue where PgBackRest failed because the backup host’s port was not passed forward (CLUS-1323 | CLUS-1319).
  • Address an issue to customize the time before attempting a PostgreSQL failover. Increase the number of sampling rounds with replication_failover_wait_extra_sampling_rounds (default 0) (CLUS-523).
  • Address an issue where CMON segmentation faults during backup verification (CLUS-1321).

Maintenance Release: May 27^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5487
• Controller:
  • Address an issue where rebuilding a replication secondary (slave) failed on Galera clusters (CLUS-1303)

Maintenance Release: May 24^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5480
  • clustercontrol-1.9.2-8326
• Controller:
  • Address an issue, where MariaDB 10.5.16 and later changed xtrabackup_binlog_info. This caused a parsing error which could lead to rebuilding /staging of secondary replication nodes could fail (CLUS-1316).
  • Address an issue where importing MySQL/MariaDB systems could fail due to a parsing error of the IP/hostname address (CLUS-1315).
  • Address an issue in ProxySQL when syncing nodes could cause privileges to not be fully synced (CLUS-1289).
• Frontend (UI):
  • Address an issue with license stats when counting the number of Galera nodes (CLUS-1317).

Maintenance Release: May 13^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5450
  • clustercontrol-1.9.2-8318
• Controller:
  • Address an issue where pg_backrest created the directory /home/pgbackrest. It now uses /var/lib/pgbackrest instead (CLUS-1173).
  • Address an issue with warnings of a non-existing maxscale1.log file (CLUS-1246).
  • Address an issue with Microsoft SQL Server deployment due to the failure of creating a SA user (CCv2-281).
• Frontend (UI):
  • Address an issue with Cluster to Cluster replication where it showed duplicated clusters (CLUS-1229).

Maintenance Release: April 24^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5384
• Controller:
  • Address an issue to allow adding a new slave even if log_slave_updates was not set on a master (CLUS-1254).
  • Address an issue to only install required snmp packages if snmp has been enabled (CLUS-1138).
  • Address an issue promoting a Microsoft SQL Server replica to become a new primary (CCV2-323).

Maintenance Release: April 14^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5345
• Controller:
  • Address an issue with the installation of the snmptrap package (CLUS-1138).
  • Address an issue deploying MariaDB Galera with SSL enabled (CLUS-1208).

Maintenance Release: March 28^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5308
• Controller:
  • Address an issue with MySQL 8.x when accessing DB Users and Schemas. New privileges for MySQL 8.x added to our parser. (CLUS-1154).

Maintenance Release: March 21^st, 2022

• Build:
  • clustercontrol-controller-1.9.2-5292
  • clustercontrol-1.9.2-8273
• Controller:
  • Address an issue when PgBackRest was setup to use the same host as the backup verification host (CLUS-1173).
  • Address an issue with deprecated SSL parameters that are no longer in use with MySQL 5.7.34 and 8.0.24 and newer versions (CLUS-1093).
  • Address an issue to execute snmptrap with sudo to run as root (CLUS-1138).
  • Address an issue with MS SQL Server to handle overriding existing /etc/odbcinst.ini to use the correct odbc ini file (CCV2-305).
  • Address an issue where setting disk space thresholds for Critical and Warning to 100% still sent alarms (CLUS-1144).
• Frontend (UI):
  • Address an issue with blank ProxySQL pages for Monitoring, Users, Rules, and Variables (CLUS-1162).

Maintenance Release: March 7^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5242
  • clustercontrol-1.9.2-8244
• Controller:
  • Address an issue with snmptrap installation on RHEL 8 and improve tracing for troubleshooting (CLUS-1138).
  • Address an issue with MS SQL server cluster where a node was verified twice (CCV-279).
  • Address an issue with MS SQL Server which requires that the hostname used for the nodes are identical to what the hostname command returns on the hosts. The hostname requirement will stop a deployment job much earlier (CCV-281).
  • Address an issue importing MariaDB Galera cluster where wsrep_incoming_addresses values were all AUTO (CLUS-1137).
  • Address an issue where the disk filled up without any alarms. The home, staging and backup directories are now all monitored (CLUS-1082).
• Frontend (UI):
  • Address an issue when upgrading ClusterControl with ProxySQL v1.x which has been deprecated. An upgrade message is now shown instead of a broken page (CLUS-1130).

Maintenance Release: February 28^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5214
  • clustercontrol-1.9.2-8236
• Controller:
  • Address an issue with PgBackRest installations where the rpm EPEL repo was not installed (CLUS-745).
  • Address an issue where the /etc/passwd file was used to check for existing users. This file is no longer used. (CLUS-1134).
  • Address an issue with single node MS SQL server clusters which failed to show up in the cluster and node lists (CCV2-279).
  • Address issues with the CMON agents where the status returned was “none” and storage usage of /var/lib/cmnd/.storageConnection, Default storage retention is changed from 7 days to 24h (CLUS-1112).
  • Address an issue with CC user management where the system users and groups failed to be automatically created.
  • Address an issue with log “pollution” where pulling non-existing log files was repeatedly mentioned (CLUS-953).
  • Address an issue with patch management where Installed packages were empty with PostgreSQL 14 (CLUS-1039).
  • Address an issue with MySQL recovery when the error code is either 2002 or 2003 (CLUS-1117).
  • Address an issue with license checks for MySQL and MongoDB (CLUS-791).
  • Upgrade of MySQL Oracle repository signing key.
• Frontend (UI):
  • Address an issue with spotlight where the CMON agents’ state was shown as unknown (CLUS-782).

Maintenance Release: February 18^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5177
  • clustercontrol-1.9.2-8229
• Controller:
  • Address an issue where MaxScale failed to be deployed due to trying to install the deprecated mmmon monitor (CLUS-1068).
• Frontend (UI):
  • Address an issue where MongoDB replicaset cluster failed to be converted to a sharded cluster (CLUS-903).
  • Address an issue where PostgreSQL v9.6 still could be selected for deployment (CLUS-1104).

Maintenance Release: February 16^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5168
• Controller:
  •  Address further issues with Percona xtrabackup v8.0.27 and later versions (CLUS-1072).

Maintenance Release: February 14^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5155
  • clustercontrol-1.9.2-8223
• Controller:
  • Address an issue where a failed authentication response is missing an error message (CLUS-1067).
  • Address an issue where ProxySQL credentials were exposed in the job log (CLUS-1079).
  • Address an issue to support Percona xtrabackup v8.0.27 and newer (CLUS-1072).
  • Address an issue where stopping and (re)starting a MySQL Replication node failed due to the node not being part of the topology (CLUS-1091).
• Frontend (UI):
  • Address a potential php API vulnerability where code could be executed through the endpoint (CLUS-1033).
  • Address an issue with the PostgresQL import wizard where the basedir is not needed (CLUS-1035).
  • Address an issue where adding a MongoDB shard fails due to a wrong configuration template in the job spec (CLUS-826).

Maintenance Release: February 4^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5116
  • clustercontrol-1.9.2-8218
• Controller:
  • Address an issue where failed MongoDB import job log entries were missing in the CMON logs (CLUS-1066).
  • Address an issue were the CMON logs were spammed with CMON Cloud refresh log entries (CLUS-1065).
  • Address an issue with CMON crashing when importing a MongoDB cluster (CLUS-1061).
  • Address an issue where restarting CMON would change a secondary Microsoft SQL Server replication state (CLUS-1049).
  • Address an issue where the Microsoft SQL Server password was not ODBC string safe.
• Frontend (UI):
  • Address an issue where a ProxySQL node could not be installed on an arbitrary host (CLUS-945 take 2).
  • Address an issue where the created timestamp for failed backups were missing in the alarms log/view (CLUS-733).
  • Address an issue where the Keepalived deployment deployment button was broken (CLUS-1040).

Maintenance Release: January 27^th, 2022

• Build:
  • clustercontrol-controller-1.9.2-5090
• Controller:
  • Address an issue where read-only was set for the MySQL server (primary) due to differences in the hostname saved in ClusterControl at deploy/import time vs the report_host in the my.cnf file (CLUS-919 reopened).
  • Address issues with Microsoft SQL Server:
    • Improve Start node by waiting for 30s (default) to check if the SQL Server has been started and is accepting queries after a start service has been requested (CLUS-1042).
    • CREATE MASTER KEY was created twice (CLUS-1038).
  • Address an issue where the CMON log file contains cmon-cloud entries when there are no cloud integrations configured (CLUS-992).

Maintenance Release: January 25^th, 2022

• Build:
  • clustercontrol-1.9.2-8197
  • clustercontrol-controller-1.9.2-5066
• Frontend (UI):
  • Address an issue with shell_exec (PHP) where a user could inject and run potential malicious code (CLUS-1033).
  • Address an issue with broken documentation links on the deployment/import wizard (CLUS-995).
  • Address an issue with inconsistent timestamp on failed backup alarms for the web frontend (CLUS-733).
• Controller:
  • Address issues with Microsoft SQL Server:
    • Create a default DB admindb’ for AlwaysOn Availability Group (CLUS-1005).
    • Promote Secondary with force=false did not work properly (CLUS-1017).
    • The monitor user and certs for backups were only created on the primary and not for all nodes (CLUS-1042).
  • Address issues with imperative scripts (CLUS-1011):
    • validate_sst_auth.js – not applicable on PXC 8.0.
    • grant_no_password.js – mysql.pxc.sst.role does not have a password so that is ok.
    • unused_indexes.js – do not inspect p_s schema.
  • Address an issue with HAProxy and PostgreSQL where RW and RO ports (rw_splitting) were not handled properly (CLUS-1031).

Initial Release: January 13^th, 2022

• Build:
  • clustercontrol-1.9.2-8197
  • clustercontrol-controller-1.9.2-5066
  • clustercontrol-cloud-1.9.2-332
  • clustercontrol-ssh-1.9.2-118
  • clustercontrol-notifications-1.9.2-306

snmp_trap_target_host={SNMP monitoring host} # The SNMP monitoring host/target (required).
snmp_trap_target_port=162                    # The default SNMP port to use (optional).
snmp_community_str='private'                 # Default SNMP trap community string (optional).

$ systemctl restart cmon

2021-12-23T04:55:56.617Z : (INFO) Installing SNMP requirement: snmp
2021-12-23T04:56:29.649Z : (INFO) Installing SNMP requirement: snmp-mibs-downloader

$ ls -l /usr/share/snmp/mibs/SEVERALNINES-CLUSTERCONTROL-MIB.txt
-rw-r--r-- 1 root root 47012 Dec 23 04:57 /usr/share/snmp/mibs/SEVERALNINES-CLUSTERCONTROL-MIB.txt