New in CWP Edge-LatestFree with every CWPpro licenceWebsites up to 300x faster

CWP now includes LSPHP, LSAPI-Cache and CWP Cage at no extra cost with all CWPpro licences. The LSAPI-Cache plugin is integrated into our WordPress and other script installers, and CWP Cage gives every user complete isolation. Available now in the CWP Edge-Latest version.

Get CWPpro ›

New MariaDB 11.0.x version gives error

Started by Starburst, June 11, 2023, 10:11:08 PM

Previous topic - Next topic

Starburst

Tried to upgrade to 11.0.2 using https://wiki.centos-webpanel.com/mariadb-upgrade-to-new-version as a guide.

After upgrading the dashboard didn't show any version info, and then gave the following error:

danger
MySQL - BAD CONFIGURATION DETECTED
MySQL bad configuration detected, check from the console by using mysql command !!!

overseer

Oh man, if YOU can't figure it out, we're all lost. I'm on 10.6.14 long term release, so I'll stay put until the frontrunners figure it out!

Starburst

Being facetious?

All our servers are at 10.11.x

Other problem (not with CWP), is that the symlink for mysql_upgrade is broken, and you have to run the main binary mariadb-upgrade instead.

valueautomation

Did the upgrade to 11 finally work, or stay on 10.6 ?

Starburst

I haven't had time to try again on our test box.
It's on my list of things to do.

The latest MariaDB LTS version 10.11.x (Currently 10.11.5) upgraded to and works fine.
As long as you follow the Wiki when upgrading.


Starburst

#6
So it looks like it worked, sorta.





Version showing is incorrect, unless this is a bug in 11.1.x when CWP is querying the version.

This MariaDB version 11.1.2 added 2 additional files:
MariaDB-server-compat
MariaDB-client-compat

@overseer, what do you think?
BTW If you want to login to the test box I can send you the info.

Starburst

So according to MariaDB this is correct.

Looks like CWP is querying the client version, not server version.

# mariadb --version
mariadb from 11.1.2-MariaDB, client 15.2 for Linux (x86_64) using readline 5.1

overseer

Sorry, late to the party as usual. I'll give my lesser server a test go and see how I make out.

xga

HEllo,

i want to upgrade tfrom 10.4 to 10.11, do it is safe all good if i follow your link below ?

tks



Quote from: Starburst on September 25, 2023, 05:41:10 PM
I haven't had time to try again on our test box.
It's on my list of things to do.

The latest MariaDB LTS version 10.11.x (Currently 10.11.5) upgraded to and works fine.
As long as you follow the Wiki when upgrading.

Starburst

You should be fine following the CWP Wiki page.

But as always you should make a backup/image before making any major change.

Painkiller88

hi

i can confirm the update to MariaDB 11.2.1 is working without problems.

I have it running for about 2 Weeks now without any problems.

CWP is still showing the wrong version, it is still using the client version but i can live with it as i know what version i installed :)


Starburst

Yes, that is what the other thread showed also.

But MariaDB 10.11.x is the latest LTS.

11.0.x and 11.1.x are 1 year support.

No one seems to know why CWP is querying the client version, instead of the server version.