Select Page

Switch from MySQL 8 to MariaDB on cPanel/WHM

by | Mar 10, 2023 | Uncategorized

Apparently, the newest setup of cPanel servers comes in with MySQL8 by default. i have tried migrating a customer but there are some database incompatibilities, therefore we just put up another box with AlmaLinux 8 and here are the steps for performing a MySQL swap to MariaDB:

Now, this works on brand new servers, where maybe you forgot to setup MariaDB right in the beginning as per the cPanel tutorial here. If you have databases/users on the server and you still wish to downgrade, make sure to back them up beforehand, as we’re removing the SQL Server and the data.

  • Disable MySQL monitor in WHM >> Service Manager (we don’t want MySQL attempts to restart the service while we are working)
  • i cannot live without this: dnf install bash-completion
  • Stop MySQL: systemctl stop mysqld
  • mv /var/lib/mysql /var/lib/mysql-old
  • mv /etc/my.cnf /etc/my.cnf-old
  • Remove the MySQL rpm’s: yum remove mysql-community-client-8.0.32-1.el8.x86_64 mysql-community-common-8.0.32-1.el8.x86_64 mysql-community-libs-8.0.32-1.el8.x86_64 mysql-community-server-8.0.32-1.el8.x86_64 mysql-community-icu-data-files-8.0.32-1.el8.x86_64 mysql80-community-release-el8-4.noarch mysql-community-client-plugins-8.0.32-1.el8.x86_64
  • Add the MariaDB repo. i am adding the 10.3 – feel free to change for whatever version you need.
  • cat >> /etc/yum.repos.d/mariadb.repo << EOF
    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.3/rhel8-amd64
    module_hotfixes=1
    gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck=1
    EOF
  • Install the MariaDB Server and Client: dnf update && dnf install MariaDB-client.x86_64 MariaDB-common.x86_64 MariaDB-server.x86_64
  • WHM >> SQL Services >> MySQL Root Password – > Change the MySQL root password
  • Force cPanel/WHM upgrade: /scripts/upcp –force
  • Enable the new MariaDB installation: systemctl enable mariadb.service
  • Enable the MySQL monitor in WHM >> Service Manager

That’s it! Enjoy!

i am back!

by | Mar 10, 2023 | Uncategorized

Under a different name, and after having scrapped 512kbps.com, but it’s been a long time and i have missed this. i have missed writing. i have done a bunch of reading meanwhile, and hopefully, this all comes down to be something better.

i realized that i missed writing. i missed a spot for the daily and the stuff i wanted to say. it was always nice to just let the fingers run across the keyboard and put out whatever came through. So there it is. i probably wish i had more to say right off the bat, but i am sure things will come just fine, since i just spent most of the time setting everything up and I’m not fully done.

Looking forward to seeing a new journey and whoever decides to tag along, I’m glad to see you.

i

OpenVPN SSL Certificate Update

by | Mar 10, 2023 | Uncategorized

Here’s a quick script that will allow you to update your OpenVPN SSL Certificate, in case it expired. Please keep in mind to update the “SERVER” variable, to the actual server string that’s in your installation, located in the folder: /etc/openvpn/easy-rsa/pki/reqs/

!#/bin/bash -x
SERVER=server_Tan0QTKIV8puAS5G
echo ${SERVER}
cd /etc/openvpn/easy-rsa/
rm pki/reqs/${SERVER}.req
rm pki/private/${SERVER}.key
rm pki/issued/${SERVER}.crt
EASYRSA_CERT_EXPIRE=3650 ./easyrsa build-server-full ${SERVER} nopass
EASYRSA_CRL_DAYS=3650 ./easyrsa gen-crl
cp pki/crl.pem /etc/openvpn
cp pki/issued/${SERVER}.crt /etc/openvpn
cp pki/private/${SERVER}.key /etc/openvpn/
systemctl restart [email protected]

Pin It on Pinterest