Enhance 12.22.0 - PostgreSQL support - Enhance Control Panel

Enhance 12.22.0 - PostgreSQL support

Adam

https://enhance.com/support/release-notes

Added

It is now possible to optionally install the PostgreSQL role to servers within your cluster and to provide PostgreSQL hosting to your customers.
pgsql and pdo_pgsql PHP modules are enabled automatically if a PostgreSQL database is created by the customer.

Enhanced

Increased email transfer RPC timeout.
Additional prompt for resellers to set a control panel domain when creating a customer, if no control panel domain has been set.
phpMyAdmin button added to database listing.
In the file manager, document roots are now highlighted by a ‘globe’ icon.
Connection guidance added to database management page for end users.
MariaDB LTS initial installation now explicitly sets utf8mb4 server character set in my.cnf.
Efficiency and performance improvements to internal APIs.
dump.rdb (Redis persistent data store) now automaticallyt excluded from website cloning.
Improvements to backup transfer guard logic when attempting new website backups.
Roundcube version bumped to 1.6.16.
Removing all database privileges for a user means the user is no longer listed under the database.
Improved error messages for remote MySQL connection failure.
Added database size to backup listing.
Container IP now automatically allowed for new MySQL users where the application and database roles are on the same server.
Plesk importer now handles backups with missing ‘directories’ param.
MySQL databases now listed on the package subscription card where the resource is set to unlimited.

Fixed

Removed onclick and ‘manage’ dropdown option for preview aliases which cannot be managed.
UI for resellers no longer attempts to set deprecated ‘processes’ resource.
WordPress username update via WordPress toolkit now functional.
Corrected chowning logic for Litespeed (commercial) virtual host config files.
SMTP SASL auth now correctly disabled when configuring a smart host with no credentials.

AdamM

Adam thanks Enhance team!

ecomlabs

Congrats team!!

slimx

another beautiful update

Major7

In the list of packages the Postgres symbol for 0 is unlimited, but should be 0 (MySQL shows it right).

Adam

Major7

We are looking into this.

slimx

umm... WordPress SSO is broken? after update

Adam

The postinst script for the ecp-core package updates composer, wp-cli, etc. It's possible one of those downloads failed on your server.

On the web server, run:

dpkg-reconfigure ecp-core

Then restart the php container for the affected website(s).

If it still fails please send a support ticket.

slimx

I cannot seem to restart PHP containers either. I have opened a support ticket. Plz check asap (Cluster wide)

Adam

You might also find when running apt upgrade that your system installs a new version of rsync from Ubuntu's repo. This version has backported security patches which trigger some kind of regression which is causing issues with the transfer of the backup role between servers. We will report it upstream but we're also looking into ways we might be able to mitigate this in Enhance itself.

rgazetta

How does the client choose PostgreSQL? It's enabled in the package, but when creating the database, it doesn't give the option to choose between MySQL or PostgreSQL.

Adam

rgazetta

Did you install the PostgreSQL role on your servers and map the existing websites using the "move server" tool?

rgazetta

Adam I didn't know I had to do that, but now everything worked out.

Kosta

rgazetta 😂