Careful when migrating from 6 to 8 (Serious complications)

Steini Petur

• March 14, 2022 07:54

Hey guys, I just wanted to write this friendly reminder because of the errors that we went through, we were migrating from Cloudlinux 6 to Cloudlinux 8.5, the previous version of SQL was MariaDB and by default, and here is the thing, the default MySQL is 8! on the new cPanel you can avoid this with this mkdir /root/cpanel_profile nano /root/cpanel_profile/cpanel.config and set this line mysql-version=10.3 Whatever version you had on your server before because if you do not, you will be in so much trouble!, we had to do endless tinkering with the my.cnf of MySQL 8 to allow this, allow that, to name a few sql-mode="NO_ENGINE_SUBSTITUTION" default-authentication-plugin=mysql_native_password validate_password = OFF plugin-load-add=validate_password.so validate_password_policy=LOW log_bin_trust_function_creators = 1 default-character-set=utf8 This is just so far, to at least alleviate some of the symptoms. We had to help a few clients where restoring them didn't pan out because MySQL doesn't allow TEXT to be DEFAULT etc.. Endless pain, we're not sure if this was related but restorations of Addon domains did not go as planned out, we ended with all Main domains, all subdomains but Addon records in /var/cpanel/userdata/*/main of everyuser was empty pretty much The physical files were still there, so we knew it was still a chance to resolve this, not 1 by 1, went back to our old server took a copy of /var/cpanel/userdata, and moved it over, and followed this:

• 

  cPRex Jurassic Moderator

  • March 14, 2022 13:25

  Thanks for posting that!

  0
• 

  Steini Petur

  • March 15, 2022 09:04

  @cPRex I currently have an open ticket with cPanel support, because even after doing the updateuserdata, and everything looks okay on it's face, for some odd reason even after checking vhost records in the httpd.conf etc, all the addon domain records exist now, all connection looks great, but for some odd reason they ALL redirect to the primary domain only, not sure why, not sure how, but hoping cPanel can help me and if they do help me and figure it out, I will submit that in here as well so not to leave anyone else in the future that googles and comes onto this forum is left hanging.

  0
• 

  Steini Petur

  • March 15, 2022 10:48

  @cPRex we rolled back to 6.0 server, the complications that arose from this migration were to horrendous, back to the drawing board with a clear picture, best not export any configs from whmapi1 just write down the details that need changing the exim IPs etc everything just do it by hand, to avoid this, and make sure the MySQL is MariaDB 10.03, the MySQL 8.0 part was the biggest trainwreck I have ever run into.

  0
• 

  cPRex Jurassic Moderator

  • March 15, 2022 13:09

  I'm sorry you ran into issues with the migration. Moving from an older system can be a challenge, but was our team able to provide you with any details to help make the next migration easier?

  0
• 

  Steini Petur

  • March 15, 2022 15:58

  They did not but It's okay I told them to drop it because the issue is mostly in the MySQL 8.0 and just anything else that followed, I would have done this without pkgacct and restorepkg if i didn't run into a boring issue with the Transfer Tool which I explained here : - This is why i went to PKGACCT and RESTOREPKG because the transfer tool is buggy about some username issues, that have nothing to do with MySQL versions, just annoying.. But the way we're doing this is different, we've mapped out me and a colleague how we're approaching this situation now, we're going to spin up the new machine on a secondary IP, this will LATER become the final IP, just live transfer slow and steady with a little heads-up post pointing to Network Issue page to follow the updates

  0
• 

  kernow

  • October 15, 2022 20:01

  mkdir /root/cpanel_profile nano /root/cpanel_profile/cpanel.config and set this line mysql-version=10.3

  
  If CloudLinux 8.5 has already been installed, what will adding the above achieve? will it help with account transfers or is the above only to be done on a new server during a cpanel install?

  0
• 

  ffeingol

  • October 15, 2022 23:54

  @kernow It has to be done before cPanel is installed. The installer will ready that and install the version of MySQL/MariaDB that you request instead of the default. The only caveat is that that version has to exist on the new distro. If not, the installer will simply error out.

  0
• 

  kernow

  • October 16, 2022 07:24

  Curses! OK thanks for letting us know.

  0

Please sign in to leave a comment.