Resolved MariaDB 11.4 Plesk Support

[digitalinnovations]

Server operating system version

Ubuntu 22.0.4

Plesk version and microupdate number

18.0.62 Update #1

Now that MariaDB 11.4.2 is LTS, is there an ETA for support by Plesk?

 

[Maarten]

"MariaDB 11.4 is planned to be supported in Plesk version 18.0.64 (approximately mid September)"

https://support.plesk.com/hc/en-us/articles/12387689789207-Which-MariaDB-versions-are-supported-by-Plesk

 

[mariano_loo]

My Linux distro Rocky Linux 8 has already MariaDB 11.5 available to update. I have Plesk 18.0.63.

Has anyone try updating if so did you run into some errors and how did you resolve? Should we wait until Plesk support is available?

Anyone is aware if support for MariaDB 11 is still scheduled for September?

Thanks for your feedback
-M

 

[Maarten]

Plesk only supports LTS (Long Time Support) versions of MariaDB.
I advise you to wait until Plesk officially supports MariaDB 11.4.

 

[mariano_loo]

Thanks for the advice... But it looks like, this is already creating some issues in my Plesk instance. The latest Plesk 18.0.63_15417 update fails, looks like MariaDB 10 and SSL is no longer supported.

Any suggestions

see log below

===> Performing safe prep-install database actions
===> Upgrading database

Trying to start service mariadb... active
done
Trying to establish test connection... /usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
failed

ERROR while trying to establish test connection

Check the error reason (see log file: /var/log/plesk/install/plesk_18.0.63_installation.log), fix and try again
***** problem report *****
ERROR while trying to establish test connection
Bootstrapper has finished action (exec time: 11 sec.): parent_name='panel', sequence='prep', stage='execute', sequence_order='0', operation='install', exec_cmd='/usr/local/psa/bootstrapper/pp18.0.63-bootstrapper/bootstrapper.sh prep-install BASE'', m_arch='', exit code: 1, output:
**** Product prep-install started.
Create user 'psaadm' and group 'psaadm'
Group 'psaadm' already exists
Checking for the user 'psaadm'...
User 'psaadm' already exists
Create group 'swkey-data'
Group 'swkey-data' already exists
Trying to add supplementary group 'swkey-data' for user 'psaadm'... already there
Create group 'psaserv'
Group 'psaserv' already exists
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Create group 'psacln'
Group 'psacln' already exists
Trying to got legacy variables... done
config updated
===> Updated /etc/psa/psa.conf
Trying to save legacy variables... done
Checking that /usr/local/psa/bin/chrootsh registered as login shell...
/usr/local/psa/bin/chrootsh already registered as a login shell

===> Performing safe prep-install database actions


===> Upgrading database

Trying to start service mariadb... active
done
Trying to establish test connection... /usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
/usr/bin/mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
failed

ERROR while trying to establish test connection

***** problem report *****
ERROR while trying to establish test connection

[2024-08-27 00:48:56.833513] Bootstrapper has finished action (exec time: 0 sec.): parent_name='PLESK_18_0_63', sequence='prep', stage='rollback', sequence_order='1', operation='install', exec_cmd='rm -f /tmp/pp-bootstrapper-mode.flag; rm -f /var/lock/parallels-panel-maintenance-mode.flag; rm -f /var/lock/parallels-panel-upgrade-failure.flag; :'', m_arch='', exit code: 0, output: ~empty
[2024-08-27 00:48:57.179702] Bootstrapper has finished action (exec time: 1 sec.): parent_name='panel', sequence='prep', stage='rollback', sequence_order='9999', operation='install', exec_cmd='test ! -f /usr/local/psa/admin/plib/scripts/update-failure-notification.php || /usr/local/psa/admin/bin/php /usr/local/psa/admin/plib/scripts/update-failure-notification.php'', m_arch='', exit code: 0, output: ~empty
[2024-08-27 00:48:57.187659] Launching component and product checkers...
[2024-08-27 00:48:57.187698] FileFetcher: get file (~empty)/report-update
[2024-08-27 00:48:57.187861] Downloading file report-update: 0%
[2024-08-27 00:48:57.313959] Downloading file report-update: 100% was finished.
[2024-08-27 00:48:57.314347] FileFetcher: get file (~empty)/pool/PSA_18.0.63_15417/examiners/py_launcher.sh
[2024-08-27 00:48:57.314390] Downloading file pool/PSA_18.0.63_15417/examiners/py_launcher.sh: 0%
[2024-08-27 00:48:57.378400] Downloading file pool/PSA_18.0.63_15417/examiners/py_launcher.sh: 100% was finished.
[2024-08-27 00:48:58.239673] Examination executed ["/root/parallels/pool/PSA_18.0.63_15417/examiners/py_launcher.sh" "/root/parallels/report-update" --op update --rc 1 --start-flag /var/lock/plesk-report-update.flag --to=18.0.63.3 --from=18.0.63] with code 0
Output:
~empty
Error:
mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it

[2024-08-27 00:48:58.240017] Execute command /usr/local/psa/admin/bin/send-error-report install --version 18.0.63
[2024-08-27 00:48:58.261251] Error: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try to install the packages again.
Visit Plesk to search for a solution.

 

[mariano_loo]

Hi again,
Looks like the Plesk dashboard is asking MariaDB to be upgraded to 11.5

Any suggestions

 

[Maarten]

Please get in touch with Plesk Support so they can investigate the issue directly on the server.

To sign in to support please go to https://support.plesk.com

If you bought your license from a reseller, your reseller should provide support for you. If the reseller does not offer support, here is an alternative:
How to get support directly from Plesk?