# /etc/cmon-events.cnf
vault_token = hvs.A2j7ScVH2j7qC8CAQni7sJ31
vault_addr = http://127.0.0.1:8200
vault_secret_path = 4efbf326-7087-47d7-9200-6c4a135494af/cluster_0

$ apt update
$ apt purge apache2 # purge the Apache server since it's no longer required
$ apt purge clustercontrol2 # purge CCv2 web U since it is no longer required
# install clustercontrol-cc
$ apt install clustercontrol-mcc
# register the local CMON controller with cmon-proxy
$ ccmgradm init --local-cmon -p 443 -f /var/www/html/clustercontrol-mcc # serve web application on port 443
$ systemctl restart cmon-proxy
# change TLS cert if needed in /usr/share/ccmgr/ccmgr.yaml and restart cmon-proxy
$ cat /etc/share/ccmgr/ccmgr.yaml
filename: /usr/share/ccmgr/ccmgr.yaml
webapproot: /var/www
fetch_jobs_hours: 12
fetch_backups_days: 7
instances:
- xid: cqf1b1cfnetrgl51vhrg
url: 127.0.0.1:9501
name: local
use_cmon_auth: true
frontend_url: localhost
cmon_ssh_host: 127.0.0.1:9511
timeout: 30
logfile: /var/log/ccmgr.log
users:
- username: admin
passwordhash: fa31fa6e142d9d1b:6870:21790d5c340c9fe207d6a5e29fe39eaddeff200b517e90e19318dddb515a424f
frontend_path: /var/www/html/clustercontrol-mcc
port: 443
tls_cert: /usr/share/ccmgr/server.crt
tls_key: /usr/share/ccmgr/server.key
session_ttl: 1800000000000

# open ClusterControl Ops-C at https://<cmon controller ip>:443 and logon with one of your existing CC admin user
User registration form has been added when using CC Ops-C with a single local CMON controller.

$ yum clean all
$ yum install clustercontrol2
$ systemctl restart httpd
            

$ apt update
$ apt install clustercontrol2
$ systemctl restart apache2
            

2022-11-01

2022-10-24

2022-10-24

2022-10-17

2022-10-11

2022-10-07

2022-10-03

2022-09-27

ClusterControl v1.9.2

2022-04-24
clustercontrol-controller-1.9.2-5384

• 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 MS SQL Server replica to become a new primary (CCV2-323)

2022-04-14
clustercontrol-controller-1.9.2-5345

• Address an issue with the installation of the snmptrap package (CLUS-1138)
• Address an issue deploying MariaDB Galera with SSL enabled (CLUS-1208)

2022-03-28
clustercontrol-controller-1.9.2-5308

• Address an issue with MySQL 8.x when accessing DB Users and Schemes. New privileges for MySQL 8.x added to our parser. (CLUS-1154)

2022-03-21
clustercontrol-controller-1.9.2-5292
clustercontrol-1.9.2-8273

• 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)
  
  Web frontend
• Address an issue with blank ProxySQL pages for Monitoring, Users, Rules, and Variables (CLUS-1162)

2022-03-07
clustercontrol-controller-1.9.2-5242
clustercontrol-1.9.2-8244

• 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)
  
  Web frontend
• 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.
  Note: We no longer support ProxySQL v1.x since ClusterControl v1.9.0. Please upgrade to ProxySQL 2.x. (CLUS-1130)

2022-02-28
clustercontrol-controller-1.9.2-5213
clustercontrol-1.9.2-8236

• 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 QMON 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 were repeatedly mentioned  (CLUS-953).
  This fix is also in build 1.9.1-5214   
• 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
  
  Web frontend
• Address an issue with spotlight where the QMON agents’ state were shown as unknown (CLUS-782)

2022-02-18
clustercontrol-controller-1.9.2-5177
clustercontrol-1.9.2-8229

• Address an issue where MaxScale failed to be deployed due to trying to install the deprecated 'mmmon' monitor (CLUS-1068)
  
  Web frontend
• 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)

2022-02-16
clustercontrol-controller-1.9.2-5168

• Address further issues with Percona xtrabackup v8.0.27 and later versions (CLUS-1072)

2022-02-14
clustercontrol-controller-1.9.2-5160
clustercontrol-1.9.2-8225

• 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 later versions (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)
  
  Web frontend
• 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) 
• Address an issue where TimescaleDB v13 was not able to be deployed

2022-02-04
clustercontrol-controller-1.9.2-5116
clustercontrol-1.9.2-8218

• 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 MS SQL Server replication state (CLUS-1049)

• Address an issue where the MS SQL Server password was not ODBC string safe
  
  Web frontend

• 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)

2022-01-27
clustercontrol-controller-1.9.2-5090

• Address an issue where ‘read-only’ was set for the MySQL server (primary) due to differences in the hostname saved in CC at deploy/import time vs the ‘report_host’ in the my.cnf file (CLUS-919 reopened)
• Address issues with MS SQL Server
  • Improve ‘Start node’ by waiting 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)

2022-01-25
clustercontrol-1.9.2-8207
clustercontrol-controller-1.9.2-5082

• Address issues with MS 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)
  
  (web frontend)
• 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)

====

2022-01-13
clustercontrol-1.9.2-8197
clustercontrol2-0.50-281
clustercontrol-controller-1.9.2-5066
clustercontrol-cloud-1.9.2-332
clustercontrol-ssh-1.9.2-118
clustercontrol-notifications-1.9.2-306

 
$ systemctl restart cmon
 
You can verify that SNMP has been enabled by:


1) Check the /var/log/cmon.log file for the following package installation outputs
 
2021-12-23T04:55:56.617Z : (INFO) Installing SNMP requirement: snmp
2021-12-23T04:56:29.649Z : (INFO) Installing SNMP requirement: snmp-mibs-downloader


2) Verify that the ClusterControl (CMON) mib file has been generated / created
 
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

This file can also be copied to the SNMP manager to be used there if needed
        

====================================================================

2021-03-16  clustercontrol-controller-1.8.1-4419

Controller:

• PostgreSQL: Improved the PostgreSQL connection error handling as it could connect to a non-existing schema.
• PostgreSQL: Fixed an issue where the database name was lowercased causing the Query Statistics tab in the frontend to fail.

2021-03-10  clustercontrol-1.8.1-7691, clustercontrol-controller-1.8.1-4400

Frontend:

• ProxySQL: Fixed an issue where the ProxySQL UI was not working correctly when creating a new query rule from top queries.
• Logs Viewer:  Fixed an issue where the log viewer (Logs->System Logs) would show an incorrect amount of logs.

Controller:

• PostgreSQL:  Fixed a bug preventing users from killing a query in the Running Queries view.

2021-03-02  clustercontrol-1.8.1-7660, clustercontrol-controller-1.8.1-4392

Frontend:

• Topology View: Added maintenance mode visualization support in the topology view.
• LDAP: Fixed an issue where the default user's timezone has changed after upgrading to ClusterControl 1.8.1.

Controller:

• MaxScale: Fixed a dependency issue with libcurl3 for older Ubuntus.
• PgBackrest:  Fixed an issue where installing PgBackrest failed with "check command requires option: pg1-path".

2021-02-23  clustercontrol-1.8.1-7639, clustercontrol-controller-1.8.1-4383

Frontend:

• Backup: Improved field validation for the cron settings.
• Jobs: A scheduled backups job displayed the current time instead of schedule time in the job title.
• MySQL: Kill connection did not function due to an issue with host ids.

Controller:

• MaxScale: Updated to version 2.5.7.
• MySQL: Kill connection did not function due to an issue with host ids.
• Percona XtraDb Cluster:  Fixed an issue preventing deployment of 8.0 on Debian 10 (Buster).
• Logging: Improved logging of dead connections.

2021-02-11  clustercontrol-1.8.1-7621, clustercontrol-controller-1.8.1-436​9

Frontend:

• Security: Fixed an issue to redirect the user to the login page when a request was blackholed after a session timeout.

Controller:

• MySQL 8.0:  Added support for new privileges added in MySQL 8.0.23.
• Systemd scripts for CMON.

2021-02-08  clustercontrol-1.8.1-7605, clustercontrol-controller-1.8.1-4362

Frontend:

• Query Monitor: Show the time on the 'Running Queries' page in a more user-friendly format.

Controller:

• MySQL 8.0: Fixed a bug when an ALTER USER command to change the db user password was issued when using the 'caching_sha2_password' plugin.
• ProxySQL:  Updating the admin user/password did not update the cluster admin/password when ProxySQL Clustering is enabled.
• Logging: Fixed a bug regarding the log message. A log message from the watchdog thread was printed out using the wrong timezone.
• PostgreSQL & HAProxy: The postgresql checker script was configured with the wrong password on the slave nodes.

2021-01-22 clustercontrol-1.8.1-7559

• Azure integration: Fixed an issue related to the selection of subnets. 
• Backup. Added an option to Skip the md5sum check for a backup job. Md5sum checks may take a long time on large backup files.
• Backup: Fixed an issue where the wrong warning was printed in the Restore Backup section when the option "Restore To Standalone Node" was selected.
• Backup Feature: Rerun failed scheduled backup jobs from the Jobs view.

2021-01-21  clustercontrol-controller-1.8.1-4343

• Backup: Make it optional to skip the md5sum check for a backup job. The m5sum may take a long time to execute on large backups. This can be configured by setting backup_create_hash in the UI (Settings -> Runtime Configuration, no restart needed), or set backup_create_hash in /etc/cmon.d/cmon_X.cnf (where X is the cluster id) and restart cmon.
• Percona XtraDb Cluster 8.0: Failed deploy on Ubuntu 20.04 and fixes to certificate creation.

2021-01-13  clustercontrol-controller-1.8.1-4327

• Fixed a bug where netcat_ports used by backup could collide with ports used by e.g Prometheus exporters and services.
• MongoDb Backup: Check free space on storage host before starting backup.
• CPU Usage Alarm: Made it configurable how long time CPU Usage should be above a Warning/Critical threshold before raising the alarm. This can be set in the cmon configuration file (host_stats_window_size) or from the CMON Settings in the frontend and S9S CLI.

2021-01-07  clustercontrol-1.8.1-7527

• MySQL root password is now correctly set when using the cloud deployment (wizard) 
• The MySQL verify backup job is now containing the entered PITR position or time
• The backups page was missing the 'backed up tables info' for MySQL partial backups with tables

2020-12-30 clustercontrol-controller-1.8.1-4314

• Percona Backup for MongoDB: The controller always reports the backup failed, but PBM says the backup completed and there are no error logs.

2020-12-28 clustercontrol-controller-1.8.1-4311

• MySQL Replication: Fixed a bug regarding package dependencies when adding a replication slave using Oracle MySQL 8.0 on CentOS/RHEL 8.

2020-12-23 clustercontrol-controller-1.8.1-4304

• MariaDB: Adding 'module_hotfixes=1' to repo files to overcome the MariaDB issue https://jira.mariadb.org/browse/MDEV-20673

2020-12-18 clustercontrol-controller-1.8.1-4299

• Verify Backup: Fixed an issue where the Verify Backup would fail on MariaDb 10.2 and later if the MariaDb version of the restore host could not be determined. The error presented itself as "/usr/bin/mariabackup: unknown option '--apply-log-only'"

2020-12-14 clustercontrol-controller-1.8.1-4294

• ProxySQL: Deployment fails because of a weak proxydemo user password. Now the proxydemo user is not created at all. 

2020-12-11  clustercontrol-controller-1.8.1-4292

• Verify Backup: The Verify Backkup job failed for MySQL based system because the Backup Verification Server was in read-only mode.
• Verify Backup: When verifying 'mysqldumps' the binary logs of the Backup Verification Server were not removed. 

2020-12-10  clustercontrol-1.8.1-7500

• Remove duplicate headers in 'Query Monitor'

2020-12-09  clustercontrol-controller-1.8.1-4285

• PostgreSQL: Can't remove PostgreSQL slave in case of co-location.
• MariaDb: Fixed a bug with Backup Verification doesn't work on MariaDB 10.2 and later (--apply-log-only is not supported any longer).
• MongoDb: mongodump logging improvement to add the last 50 lines of its output to the backup job log. 

2020-12-05   clustercontrol-1.8.1-7491

• Fix for ClusterControl user login. The login username was required to be an email address which prevented LDAP login with a plain username. 

2020-11-30   clustercontrol-controller-1.8.1-4274

• MongoDb Percona Backup: Fixed an issue when deleting a backup. The deletion was reported as successful, but it actually failed.
• MySQL Replication: Fixed a bug where the read_only setting in my.cnf could be inconsistently set on the nodes. The my.cnf file must always have read_only=ON on all nodes.
• MySQL Replication: Fixed an issue where if the auto_manage_readonly = true , then a user could set read_only = OFF on a slave. Now the read_only flag will be set to read_only = ON as soon as it is detected.
• Backups: Fixed the job title of backups executed from schedules. Before the title was set to 'Backup schedule #N'N, where NN is a number. Now the backup title is properly set to 'Create Backup'

2020-11-23   clustercontrol-1.8.1-7473

• Backup->Settings->Backup Settings: Customize/set netcat ports to use when streaming backups
• Cluster 2 Cluster: 2nd PostgreSQL slave cluster is now properly linked
• Delete Job: Add back support to delete pending jobs via the Activity Viewer
• Restore PITR backup: Correctly set/select the node to restore the backup (PITR) on  
• Import Cluster: You no longer need to specify vendor or version - it's automatically detected
• Cluster Overview: Setting the same time range sometimes resulted in showing a different range
• Misc
  • Fix incorrect backup restore confirmation messages
  • Fix modal and sidebar issues with the restore backup dialog - it now closes properly 
  • Fix broken backup scheduler icon for the jobs in the Activity Viewer
  • Fix overlapping text in the Logs->Jobs page for smaller screen resolutions  
  • Empty role is now not being created when cancelling the role creation

2020-11-18   clustercontrol-controller-1.8.1-4258

Controller:

• MongoDB: Installing PBM on mongodb.org release v4.2 failed.
• MaxScale: Due to an SSH environment problem a node transitioned between Offline/Online. Now there is better logging in this area.
• Scheduled backups: Fixed a bug where the scheduled backup printed out the same ID number (#0) for all backups. Note: It is only a printout/formatting issue.

ClusterControl v1.8.0

2020-11-04   clustercontrol-controller-1.8.0-4223

Controller:

• Prometheus: Fixed an issue where the port used by a Prometheus exporter was incremented and could be different on each node. This made it problematic to maintain e.g firewalls.

2020-11-03   clustercontrol-controller-1.8.0-4218

Controller:

• PostgreSQL: Add missing quoting of PostgreSQL passwords in cmon configuration file.
• Deployment fails for MariaDB 10.4 on CentOS 8.
• Deployment fails for MariaDB 10.3 on CentOS 8.

2020-10-29   clustercontrol-controller-1.8.0-4210

Controller:

• Prometheus: Fixed an issue where the port used by a Prometheus exporter was incremented and could be different on each node. This made it problematic to maintain e.g firewalls.
• Notifications: Improvements to the Memory/RAM usage alarm.

2020-10-26   clustercontrol-controller-1.8.0-4202

Controller:

• Alarms: Improved reporting on the memory-/RAM-usage alarms to include the actual bytes used and total bytes available.
• General: Optimized and reduced the CPU usage of the controller when using Prometheus.
• Keepalived: Fixed a bug when uninstalling Keepalived where the controller tried to copy a non-existing config file.

2020-10-16   clustercontrol-controller-1.8.0-4195

Controller:

• General: Fix some high CPU usage about Prometheus sampling with many clusters.
• Cloud Deployment: Use private/internal IPs to communicate with DB nodes when 'use_private_network' option is set.
• Deployment: Fixed an issue with Percona installation on Debian/Ubuntu. It was pulling -dbg packages and it prolonged the installation time.

2020-10-14    clustercontrol-1.8.0-7331  clustercontrol-controller-1.8.0-4190

Frontend

• Alarms: Refactored the alarms page to make it more space-efficient.

Controller:

• MariaDb Cluster 10.4 failed to deploy on Centos 8. As a side-effect, due to dependency issues, percona-toolkit can not be installed.

2020-10-13  clustercontrol-controller-1.8.0-4188

Controller:

• PostgreSQL: Change the owner of a pre-created datadir owned by another user than 'postgres'.
• Query Monitor: 'Last seen' was set to 'now' and not the actual 'last seen'.

2020-10-07   clustercontrol-1.8.0-7312  clustercontrol-controller-1.8.0-4181

Frontend

• Cloud Deploy: Added an option to use private IP address only when creating the VMs. 

Controller:

• HAProxy: Failed to Enable/Disable HAProxy because node_address was not taken into account.
• Deployment: Improved logic to determine the AppStream repository name for CentOS/RHEL/Oracle.
• MySQL Cluster: include ndb_mgm -e show in the error-report.

2020-09-29   clustercontrol-controller-1.8.0-4166

Controller:

• MySQL Cluster: Fixed an issue when handling status replies of MySQL Clusters containing many nodes.

2020-09-29   clustercontrol-controller-1.8.0-4165 

Controller:

• Improved error handling & logging (including error-reporting) for MySQL NDB Clusters.
• ProxySQL Galera: Fix for crash for when updating ProxySQL in case the host group does not exist or is not defined.
• PostgreSQL: Fixed an issue when deploying on CentOS/RedHat using the option "Do Not Setup Vendor Repositories" as it wrongly adding --repo=pgdg to the yum install command.

2020-09-23  clustercontrol-1.8.0-7277 clustercontrol-controller-1.8.0-4156 clustercontrol-cloud-1.8.0-254

Frontend

• ProxySQL: Top Queries page shows super-long non-truncated digest text.
• Cloud Deployment: Fixed an issue where the wrong unit (MB) was passed to the cmon-cloud service. GB was expected.

Controller:

• HAProxy: Fixed an issue to refresh/sample HAProxy on certain actions.
• MySQL Replication: Fixed an issue to allow removing down/failed master(s) in case when there is more than one node in the cluster.
• APT repository mirroring fixes (updated aptly and fixed gpg handling on newer systems) for Ubuntu 18.04.

Cloud:

• Azure: Fixed a timeout issue where it was not possible to get the status of a VM within 10m (Could not get VM statuses in 10m0s.)
  
  

2020-09-16
clustercontrol-1.8.0-7250 
clustercontrol-controller-1.8.0-4145
clustercontrol-notifications-1.8.0-257
clustercontrol-cloud-1.8.0-252  
clustercontrol-ssh-1.8.0-96

ClusterControl v1.7.6 

2020-09-10  clustercontrol-1.7.6-7237

Frontend

• OpsGenie: Fixed a bug where the Integration could not be created due to '"Failed to parse request body:...'
• OpsGenie: Updated instructions. The API Key must be the API Key of the Team may be used: https://docs.opsgenie.com/docs/api-key-management .
• HAProxy: Fixed a bug where disable HAProxy failed because UI didn't send the hostname parameter to the job.
• MariaBackup: Fixed an issue with partial backups. It was not possible to specify databases/tables.

2020-09-08  clustercontrol-controller-1.7.6-4130

Controller:

• Oracle/MySQL 8.0 compatibility & testing fixes.

2020-09-02  clustercontrol-1.7.6-7207 clustercontrol-controller-1.7.6-4120 

Frontend

• Topology VIew: Fixed and issue to avoid flickering on cluster update.
• Topology View: Fixed an issue showing the topology for 3 or more multi-masters.
• ProxySQL: The IP/Hostname Address was truncated in ProxySQL Processlist.

Controller:

• MongoDb: Node menu does not appear for MongoDB Replicaset due to an internal error.
• MongoDb:  Fixed a bug causing Mongo shard recovery to fail and Mongos are started last.
• Prometheus: Upgraded node_exporter to 1.0.1 (no incompatible changes) + some typo fixes.
• Prometheus:Bump Prometheus version to 2.20.1
• [improvement] OS Support: Updated compatibility matrix to support Ubuntu 20.04.

2020-08-27   clustercontrol-controller-1.7.6-4108

Controller:

• OS Detection: Fixed an error to be more tolerant to extra lines introduced by ssh login to a host. This caused an issue when detecting the operating system.
• Cmon Db Schema: Fixed an issue with the cmon_log_entries table that has an invalid Foreign Key.
• ProxySQL: deploy fails on Debian 10 in combination with Percona or Oracle/MySQL 8.0
• Fixed an issue on MySQL based system where the rebuild replication slave  would fail when using uppercased hostnames.

2020-08-17   clustercontrol-1.7.6-7158 clustercontrol-controller-1.7.6-4083

Frontend

• Dashboards: Fixed an issue in the Replication dashboard where the Master Server ID was presented as a decimal value and not an integer.

Controller:

• ProxySQL: Fixed a bug with logs getting flooded with SAVE MYSQL SERVERS TO DISK /LOAD MYSQL... commands if there was a MySQL server not present in the ProxySQL Server's mysql_servers table.
• Alarms: Fixed a timezone problem between the reported date in the Alarm Digest email and the triggered Alarm. Now the datetime has the same Timezone in both cases.

2020-08-11   clustercontrol-1.7.6-7146 clustercontrol-controller-1.7.6-4077

Frontend

• Fixed an issue with retrieving roles where a non super-admin LDAP users always end up at the first cluster in the list.
• Fixed an issue editing an OpsGenie integration which prompted the user to enter information in a field, but it was not possible.

Controller:

• HAProxy: Fixed an issue using non-default ports as a user-specified value would be set to the default.
• Mariabackup: A fix to support Mariabackup 10.4.14 which has dropped support for some options.
• Deploy: Fixed a bug deploying Percona on CentOS 8.

2020-08-04   clustercontrol-1.7.6-7124 clustercontrol-notifications-1.7.6-254

Frontend

• Galera: Fixed an issue which made it impossible to activate Galera SSL Encryption when SSL Encryption was enabled
• Galera: Server Load graphs were not properly initialized when there was no data to graph (e.g, because a server was down for a period of time).
• ServiceNow integration:  Fixed a layout issue, and improved the usability by adding an  'All Clusters' to simplify when having many clusters. This fix also includes two new fields: 'Service' and 'Configuration Item'
  

Notifications service:

• ServiceNow: Added support for 'Service' and 'Configuration Item'.

2020-08-03   clustercontrol-controller-1.7.6-4068

Controller

•   Fixing a bug deploying Percona Server and XtraDb Cluster on CentOS 8.

2020-08-03   clustercontrol-controller-1.7.6-4066

Controller

• PostgreSQL: Fixed an issue with PgBackRest using user-defined stanzas to prevent default configuration options defined by the controller from being set as command-line options. Thus, only the options set in the user-defined stanza will be used and nothing else.

2020-07-27   clustercontrol-1.7.6-7082 clustercontrol-controller-1.7.6-4059

Frontend

• Cloud Deployment: Fixed an issue where the wrong disk size unit (GB) was sent in the job instead of MB.
• Backup/Restore (MySQL based): Fixed a couple of UX issues. Restoring a backup using Point in-time recovery (PITR) may only be executed on the cluster nodes where the backup was created. All other options are now disabled (Restore on standalone/create cluster from backup).
• Import MySQL Replication: The option 'Import as a standalone node' has been removed as it did not have any purpose.

Controller

• MySQL 8.0: Fixed an issue with parsing privileges in a GRANT statement (INNODB_REDO_LOG_ENABLE privilege was missing)
• Replication: Fixed an issue retrieving/creating user account information in case there was one server in the setup and it was not configured as a master. The error manifested itself as 'Server not found while trying to create an account'
• Replication: Improved the behavior by not raising an alarm and disabling auto-recovery If the setting auto_manage_readonly=false is specified and the cluster has multiple writable masters.
• Replication:Enable/Disable read-only job: Failed to run if auto_manage_readonly=false
• ProxySQL: Failed to sync instance in ProxySQL (GRANT option).

2020-07-20   clustercontrol-1.7.6-7059 clustercontrol-controller-1.7.6-4047

Frontend

• Integrations: Fixed a bug when adding cluster on integration channel if cluster name only 2 characters.
• PostgreSQL: Enable timescaledb for PostgreSQL 12.
• User mgmt: Fixed an issue preventing a SuperAdmin used logged in from LDAP to change a cluster team.

Controller

• PostgreSQL: Fixed an issue where the controller failed to parse pg_hba.conf when a line ends up with empty space before a new line.
• PostgreSQL: Ensure that directories created for PostgreSQL have the correct rights and even the newly created parent directories, such as /etc/postgres.
• General: Extended OS compatibility matrix with Ubuntu 'focal' / 20.04.

2020-07-10  clustercontrol-controller-1.7.6-4036

Controller

• A fix for a race condition when the SSH connection is lost for a moment when sampling processes. This could lead to the process (e.g HAProxy, Garbd, ProxySQL) to have the wrong state for a short period of time.
• MongoDb: Consistent backup failed because the Storage Host was not set.

2020-07-05    clustercontrol-controller-1.7.6-4026

Controller

• Galera: Improved Cluster Split detection. Now, the cluster_size is measured over a three-second period, and the cluster will enter failed state if the cluster_size is not the same on all nodes after this period of time.
• PostgreSQL:  Rebuilding a PostgreSQL node as a slave could make it appear with the role set to master (but non-writable, and streaming from the writable master).
• ProxySQL: Removed unnecessary log messages when installing ProxySQL.

2020-06-28 clustercontrol-1.7.6-6996 clustercontrol-controller-1.7.6-4013

Frontend

• Query Monitor: Running Queries did only appear on the last page when filtering on hosts.
• User Management: The number of visible Teams/LDAP groups was limited and more than 33 groups could not be shown in the UI.

Controller

• Query Monitor: Purge Query Monitor for MySQL did not purge the performance_schema events_statements_summary_by_digest.
• Ping time was set incorrectly (to a big value) when blocked by firewall or ICMP disabled in conf. Now it is set to -1 if blocked by the firewall or disabled.
• HAProxy: It was possible to import an non-existing HAProxy.
• ProxySQL: Fixed a bug syncing instances error when a database name contains backslash.
• ProxySQL: Fixed an issue with MariaDB when importing users with a role in ProxySQL.
• ProxySQL: Fixed an issue Installing ProxySQL 1.x failed on CentOS7.
• ProxySQL: Could not install version 1 to two nodes in the same job.
• ProxySQL: Failed to stop the ProxySQL service while removing and uninstalling the node.

2020-06-20 clustercontrol-1.7.6-6976 clustercontrol-controller-1.7.6-3996

Frontend

• Query Monitor: Fixed a bug when purging data in the Query Monitor. 

Controller

• SSL Certificates: Fixed a bug that prevented self-signed certificates to be imported. The error manifested itself as: "Error 'CA certificate: Empty PEM string'".
• MaxScale: The MaxScale nodes could in some situation appears as "not available"/"offline", but the process was actually running.
• Backups: Fixed a bug where a backup could end up in the wrong backup directory if the backup was re-executed too soon after a failed backup.

2020-06-16 clustercontrol-1.7.6-6959 clustercontrol-controller-1.7.6-3985

Frontend

• MongoDB: Dashboards metrics updated to support new mongodb_exporter. A re-install of the MongoDB Exporter is needed, which is done from the Dashboards action menu.
• Schema Analyzer: showed no data for community edition.
• Stop Node action must always be visible. Even if the node is down/unknown.
• Backup Scheduling: An issue specifying the time when using advanced settings.
• User management: A User with 'Admin' role cannot open the mail notifications page
• User management: Users are shown in the wrong group (fixed 'All users' logic).
• User management: LDAP users can't see alarms or jobs.

Controller

• Monitoring/disk: A fix was added to avoid monitoring the NFS filesystem.
• PostgreSQL: In case of an inconsistent view (master down, but LB or slave reports it is up) then double-check using SSH.
• PostgreSQL:  Log the replication failure alarm reason and server disconnected reason in the alarm text.

2020-06-08 clustercontrol-controller-1.7.6-3972

Controller

• ProxySQL: Supporting MariaDb roles when importing users to ProxySql
• MongoDB: Upgraded mongodb_exporter to v0.11.0 to support newer MongoDB versions.
• HAProxy: Fixed an issue where the node appears as Online but the VM is not even running.
• Galera: Failed to create slave cluster from backup for Galera.
• PostgreSQL: Cluster-to-Cluster replication shows Cluster Failure in the slave cluster.
• PostgreSQL: Failed to Create Slave Cluster on TimescaleDB.
• Notifications:  Extended the fallback email address query with, dcps.users with company_id=0, and the RPCv2 owner user of the cluster. This ensures that an admin that can see all clusters will get notifications from all clusters.

2020-05-15 clustercontrol-1.7.6-6868 clustercontrol-controller-1.7.6-3940

Frontend

• CC Teams and Users management issue (removed the strict linking on company for SuperAdmin)

Controller

• PostgreSQL: Slave rebuild doesn't work for PostgreSQL.
• PostgreSQL: Failed create PostgreSQL cluster from pg_basebackup.
• PostgreSQL: Remove slave (recovery|standby) signal files after restoring pg_basebackup.
• Galera:  Automatic failover is not working on MariaDB Cluster with slave nodes.
• Galera: Create Galera Cluster From Backup Fails
• Galera: Creating a Slave Cluster using PXC 5.6 failed. See note above.
• Galera recovery fails repeatedly if automatic recovery is enabled (huge dataset) b/c of a systemd script timeout. Now CMON will patch the vendors' broken systemd script.
• Galera: PXC 5.7 failed to deploy on Centos 8.
• ProxySQL: Fix for wildcard handling in MySQL grants (fixes a ProxySQL import users issue...).
• MySQL/Galera: Added parser support for new MySQL 8.0 privileges.
• MongoDb:  Deployment fails and fixed by preventing /var/run & /run from any owner/access changes, it makes the SSH connections failing.

2020-05-06 clustercontrol-1.7.6-6854 clustercontrol-controller-1.7.6-3910

Frontend

• HAProxy: Auto-filling HAProxy socket, port, and credentials fields are not working in the import section (fixed template).

Controller

• PostgreSQL: Fix a pg_hba parsing error (whitespace in empty lines).
• PostgreSQL:  Bugfix for duplicated pg_hba entries.
• PostgreSQL: Bugfix for repetitive CREATE ROLE calls following a failover.
• MongoDb: Backups created by s9s CLI did not contain the node name in the backup file.
• MaxScale: Remove/Register fixes
• MySQL: A strong root password is now auto-created if not specified explicitly by the job.
• MySQL: Refresh variables after restarting a node so the node is up to date in the UI.
• Prometheus: make sure tar and gzip is installed to be able to deploy the packages.
• cmon_upgrade.log: add timestamp & filenames

2020-05-03 clustercontrol-1.7.6-6846

Frontend

• HAProxy:  Import error, fixed the job spec.
• Redundant nodes when Select Stream from Master in 'Create Slave Cluster' dialog.
• Backup: Got error 'Cannot set unknown key encrypt_backup on RecordType' in the UI when configuring backup with verifying backup (added property to Verification model and fixed unit tests).
• CSS Fixes.

2020-04-27  clustercontrol-controller-1.7.6-3892

Controller

• s9s_error_reporter is not working for Cluster ID 0 (fixed error-report fallback path).
• PostgreSQL: Include the pgdg common repo (for pgbackrest on centos/rhel).
• PostgreSQL: Fixes to failover in case of deleting/erasing the master's datadir.
• PostgreSQL: Ping lets do a disconnect first, so we can detect if no new connection can be made to the PostgreSQL server.
• MySQL: Bugfix for parsing the role syntax of a MySQL Db user, which could lead to the frontend failing to handle the request to show database users in Manage->Schema and Users.

2020-04-22  clustercontrol-1.7.6-6830 clustercontrol-controller-1.7.6-3880

Frontend

• Backup Schedule: When changing a backup method (from none-PgBackRest) to PgBackRest it could cause the UI to become stuck.
• Overview graph: The Cluster Overview graph was truncated in some cases to 30 minutes instead of 1 hour.

Controller

• Verify Backup: A user will be notified by email if the verification fails.
• PostgreSQL:  Backup Verification made a backup of datadir before restoring the backup, which was unnecessary.
• PostgreSQL: Fixed an issue with replication lag calculation and alarming.
• PostgreSQL: Skip nodes from failover whose lagging more than MAX_REPLICATION_LAG setting.
• MySQL Replication: A fix for rebuilding replication slave where there was a race condition checking if MySQL is down.
• Galera: Fixed an issue when manipulating my.cnf files that could manifest itself as "Got error Could not read 'wsrep_provider_options'" when enabling Galera SSL Encryption.
• Galera:  Add a Replication Slave in PXC 5.7 overwrote the my.cnf if it was a symlink.
• Password Escaping: Fix a password escaping issue in cmon configuration, that could lead to e.g the Prometheus database exporters to fail to connect to the database.
• LibSSH: Fixes to prevent zombie/defunct ssh proxy commands (such as sssd_ssh_known_hosts_proxy ) processes due to a missing waitpid in libssh.

2020-04-10 
clustercontrol-1.7.6-6815 
clustercontrol-controller-1.7.6-3854
clustercontrol-notifications-1.7.6-251 
clustercontrol-cloud-1.7.6-241  
clustercontrol-ssh-1.7.6-92

• Deploy a database stack containing your favorite SQL database and HAProxy load balancer.

• Snapshot MySQL process list before cluster failure. 

• CMON Upgrade operations are logged in a log file.
• Many improvements and fixes for PostgreSQL Backup, Restore, and Verify Backup. 
• A number of legacy ExtJS pages have been migrated to AngularJS.

In this release we are introducing cluster-wide maintenance mode, taking snapshots of the MySQL database status and processlist before a cluster failure, and support for new versions of PostgreSQL, MongoDB, Centos and Debian.

We have previously supported maintenance mode for one node at a time, however more often than not you want to put all cluster nodes into maintenance.
Cluster-wide maintenance mode enables you to set a maintenance period for all the database nodes / cluster at once.

To assist in finding the root cause of failed database nodes we are now taking snapshots of the MySQL status and processlist which will show you the state of the database node around the time where it failed. Cluster incidents can then be inspected in an operational report or from the s9s command line tool.
Finally we have worked on adding support for Centos/RedHat 8, Debian 10, and deploying/importing MongoDB v4.2 and Percona MongoDB v4.0.

• Enable/disable cluster-wide maintenace mode with cron based schedule.
• Enable/disable recurring jobs such as cluster or node recovery with automatic maintenance mode.

• Snapshot MySQL status before cluster failure.
• Snapshot MySQL process list before cluster failure (coming soon).
• Inspect cluster incidents in operational reports or from the s9s command line tool.

• Synchronize time range selection between the Overview and Node pages.
• Improvements to the nodes status updates to be more accurate and with less delay.
• Enable/disable Cluster and Node recovery are now regular CMON jobs.
• Topology view with cluster to cluster replication.

In this release we now support cluster to cluster replication for MySQL Galera and PostgreSQL clusters.
One primary use case is for disaster recovery by having a hot standby site/cluster which can take over when the main site/cluster has failed.
We also added support for MariaDB 10.4/Galera 4.x, ProxySQL 2.0 and managing database users for PostgreSQL clusters.

• Asynchronous MySQL replication between MySQL Galera clusters.
• Streaming replication between PostgreSQL clusters.
• Clusters can be rebuilt with a backup or by streaming from a master cluster.

• MariaDB 10.4/Galera 4.x support.
• ProxySQL 2.0 support.
• Database User Management for PostgreSQL clusters.

=========================================================================

We are proud to announce an expansion of the databases we support to include TimescaleDB, a revolutionary new time-series that leverages the stability, maturity and power of PostgreSQL. TimescaleDB can ingest large amounts of data and then measure how it changes over time. This ability is crucial to analyzing any data-intensive, time-series data. 
For ClusterControl, this marks the first time for supporting time-series data; strengthening our mission to provide complete life cycle support for the best open source databases and expanding our ability to support applications like IoT, Fintech and smart technology. 

In this release you can now deploy a TimescaleDB and also turn an existing PostgreSQL server to a TimescaleDB server. PostgreSQL clusters also support a new backup method pgBackRest, database growth charts and improvements to manage your configuration files. 

MySQL users can start to deploy and import MySQL 8.0 servers with Percona and Oracle MySQL and our new Spotlight search helps you navigate through pages, find nodes and perform actions faster. 

Finally, we are also providing a beta version to setup CMON / Controller High Availability using several ClusterControl instances wired with a consensus protocol (raft) between them. 

• Deploy a TimescaleDB server with PostgreSQL (v9.6, v10.x and v11.x).
• Turn an existing PostgresQL server (v9.6, v10.x and v11.x) into a TimescaleDB server.

• Database growth graphs. Track the dataset growth on your databases.
• Support for pgBackRest as a backup tool:
• Create full, differential and incremental backups.
• Restore full, differential, incremental backups.
• PITR - Point In Time Recovery is supported.
• Enable compression and specify compression level.

• Cluster deployment and import of 'replication' type clusters available with:
• Percona Server for MySQL 8.0
• Oracle MySQL 8.0 Server
• Support for 'caching_sha2_password'.

• Use our new spotlight search to quickly open pages, find nodes/hosts and perform cluster and node actions.
• Click on the search icon or use the keyboard shortcut CTRL+SPACE to bring up the spotlight.

• CMON HA is using a consensus protocol (raft) to provide a high availability setup with more than one cmon process.
• Setup a 'leader' CMON process and a set of 'followers' which share storage and state using a MySQL Galera cluster.

• Support the use of private IPs when you deploy a cluster to AWS.
  • MaxScale - improved support for v 2.2 and later using maxctrl.
• Automatic vendor/version detection for importing MariaDb/MySQL based clusters.

============================================================