Upgrade of Maria from 10.3 to 10.5 wipes WP passwords

R

Raymond Hayes

Member
May 6, 2019
19
6
3
United States
cPanel Access Level
Root Administrator
After completing an upgrade of MariaDB from 10.3 to 10.5 after the latest Cpanel upgrade, all database users passwords were wiped. These are specifically WordPress websites, and all sites went down with "error establishing database connection".

Luckily we did it on a smaller server, but there were close to 35 databases that I was required to go to each WordPress site, check wp-config and update the passwords...one by one.

Before we proceed to larger servers, we need to be able to understand why this happened....doing 300 to 500 databases would be an utter failure.

In looking at the upgrade log, there is nothing that seems out of the ordinary. And usually when we setup new VPSs, we upgrade from Mysql to maria10.3 with zero issues. Seems to be a maria to maria upgrade in place that is a problem.

I am willing to hear ideas of how we can preserve the passwords. As right now, we have quite a few servers that need updates...but, not with this kind of disaster.

Thanks for any help...
 
cPRex

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
13,382
2,106
363
cPanel Access Level
Root Administrator
Hey there! I haven't heard of any similar reports on this, because as you said, this would be a complete disaster.

Could you submit a ticket to our team so we can investigate what may have happened on your system? If you're able to do that, please post the number here so I can follow along and keep this thread updated.
 
K

kingsburyweb

Registered
Aug 13, 2021
4
0
1
Massachusetts
cPanel Access Level
Root Administrator
Raymond Hayes said:
After completing an upgrade of MariaDB from 10.3 to 10.5 after the latest Cpanel upgrade, all database users passwords were wiped. These are specifically WordPress websites, and all sites went down with "error establishing database connection".

Luckily we did it on a smaller server, but there were close to 35 databases that I was required to go to each WordPress site, check wp-config and update the passwords...one by one.

Before we proceed to larger servers, we need to be able to understand why this happened....doing 300 to 500 databases would be an utter failure.

In looking at the upgrade log, there is nothing that seems out of the ordinary. And usually when we setup new VPSs, we upgrade from Mysql to maria10.3 with zero issues. Seems to be a maria to maria upgrade in place that is a problem.

I am willing to hear ideas of how we can preserve the passwords. As right now, we have quite a few servers that need updates...but, not with this kind of disaster.

Thanks for any help...
Click to expand...
Hi Raymond,

We have a bunch of WHM/cPanel Servers and late last night I updated them all to v98.0.4. I noticed MariaDB upgrade to 10.5 was available, but it wasn't marked as "recommended" by cPanel. Anyhow, I upgraded our staging server MariaDB to 10.5 and I encountered the same exact problem as you did.
Error: Can't select database
Error Details: We were able to connect to the database server (which means your username and password is okay) but not able to select the ***** database.
We only have around 5 Wordpress powered websites on this particular staging server, and each and every one had that error. I turned to these forums and saw your solution, which did correct my issue (resetting each DB password).

Long story short, Raymond is right in that the DB Passwords have to be set again if you use the MariaDB Upgrade tool to 10.5. Considering how many people use WHM/cPanel, I'm going to feel bad for anyone that upgrades to 10.5 as they will likely encounter this issue.

Glad I found this post, thank you!!
 
Last edited:
cPRex

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
13,382
2,106
363
cPanel Access Level
Root Administrator
Update - MariaDB doesn't plan to have a fix until the end of October, so we're doing something on our end to resolve this.

@kingsburyweb - if there is good news, 98 is in a slow rollout plan, so even if you have that version set to happen automatically, you may not get it, so there are a limited number of users affected at this point. We're planning to have our fix out within the next week so a vast majority of users will never even know this happened.
 
R

Raymond Hayes

Member
May 6, 2019
19
6
3
United States
cPanel Access Level
Root Administrator
Thank you. I have not done any new updates yet to Maria...but, I have a server I can test this on. Is the fix in the Cpanel update or in the Maria update? Basically, what version of Cpanel / WHM should I be on to verify this is fixed.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
jimjoe MariaDB upgrade needed for Kernel update - but I must keep php 5.6 Databases 3
Sujoy Dhar SOLVED Unable to Upgrade from MariaDB 10.3 to 10.5 Databases 5
C Major Issues Lately with MariaDB Upgrades and Updates via WHM Databases 29
gdimi In Progress CPANEL-40434 - Cannot upgrade mariadb 10.0 to 10.1, repo is not found Databases 11
T Upgrading from MySQL to Maria. No MariaDB upgrade option in WHM Databases 26
Similar threads
MariaDB upgrade needed for Kernel update - but I must keep php 5.6
SOLVED Unable to Upgrade from MariaDB 10.3 to 10.5
Major Issues Lately with MariaDB Upgrades and Updates via WHM
In Progress CPANEL-40434 - Cannot upgrade mariadb 10.0 to 10.1, repo is not found
Upgrading from MySQL to Maria. No MariaDB upgrade option in WHM
Top Bottom