How to configure Mariadb 10.3 from Mariadb 5.5 on SVM On-premise Server

How to configure Mariadb 10.3 from Mariadb 5.5 on SVM On-premise Server

Summary

This article will help our SVM on-premise customer to configure MariaDB 10.3 from Mariadb 5.5 on SVM On-premise Server.

Important: 

Make sure you have the latest DB backup ( /usr/local/Secunia/csi/backup) and config.ini ( /usr/local/Secunia/config.ini ) backup before running the below procedure. 

Steps 

List the MariaDB packages. 

rpm -qa | grep MariaDB

Please check the package's name according to the above command output and execute the below commands. 

rpm -e --nodeps "mariadb-server-5.5.65-1.el7.x86_64"
rpm -e --nodeps "mariadb-libs-5.5.65-1.el7.x86_64"
rpm -e --nodeps "mariadb-5.5.65-1.el7.x86_64"

Create a file at the following location: /etc/yum.repos.d/MariaDB.repo  and add the below lines in there. 

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.3/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Run the below command to install the MariaDB 10.3.

  • yum install MariaDB-server
  • nano /etc/my.cnf  and set the SQL mode  ( sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' )
  • service mariadb start
  • mysql_upgrade
  • run the installation script  /usr/local/Secunia/csi/install/installationProcess.sh
  • Try to login at the SVM console from IE 
  • MySQL --version to check mariadb version. 
Was this article helpful? Yes No
No ratings
Version history
Revision #:
4 of 4
Last update:
‎Mar 03, 2021 03:56 AM
Updated by:
 
Contributors