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.
