Control Web Panel
WebPanel => MySQL => Topic started by: srisree on August 23, 2020, 07:21:13 AM
-
upgraded mariadb with the following instructions which i found from this forum
https://www.mysterydata.com/upgrade-mariadb-5-5-to-mariadb-10-2-on-centos-7-vesta-cp/
and later i found update CWP i clicked update all
after download and update
CWP displayed following message and showing failed
please guide me what to do
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-server.x86_64 0:10.1.46-1.el7.centos will be updated
---> Package MariaDB-server.x86_64 0:10.2.33-1.el7.centos will be an update
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Updating:
MariaDB-server x86_64 10.2.33-1.el7.centos mariadb 24 M
Transaction Summary
================================================================================
Upgrade 1 Package
Total size: 24 M
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.1.46-1.el7.centos.x86_64) is installed.
Upgrading directly from MySQL 10.1 to MariaDB 10.2 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.
A manual upgrade is required.
- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'
You may choose to use 'rpm --nodeps -ev ' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program
This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %pre(MariaDB-server-10.2.33-1.el7.centos.x86_64) scriptlet failed, exit status 1
Verifying : MariaDB-server-10.2.33-1.el7.centos.x86_64 1/2
Verifying : MariaDB-server-10.1.46-1.el7.centos.x86_64 2/2
Failed:
MariaDB-server.x86_64 0:10.1.46-1.el7.centos
MariaDB-server.x86_64 0:10.2.33-1.el7.centos
Complete!
and in dashboard showing the following
Apache version: Apache/2.4.39
PHP version: 7.4.9
MySQL version: 10.2.33-MariaDB
FTP version: 1.0.47
SSH Port: 22
MySql Port: 3306
Web Servers: apache-only
from putty mysql-v
its showing
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 32801
Server version: 10.1.46-MariaDB MariaDB Server
-
helllo
first you need to remove any old version of mariadb 10.1 packages and then install 10.2
-
hello can you guide me how to do that
i followed this url
https://www.mysterydata.com/upgrade-mariadb-5-5-to-mariadb-10-2-on-centos-7-vesta-cp/
unable to remove old version
thanks
-
i tried to stop mariadb for upgrade
https://www.systemmen.com/web-server/vestacp/how-to-update-vestacp-to-mariadb-10-3-285.html
displayed following error
[root@vps ~]# service mariadb stop
Redirecting to /bin/systemctl stop mariadb.service
** (pkttyagent:559): WARNING **: 03:12:38.769: Unable to register authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject
Error registering authentication agent: GDBus.Error:org.freedesktop.PolicyKit1.Error.Failed: Cannot determine user of subject (polkit-error-quark, 0)
[root@vps ~]# sudo yum update mysql-server
-
systemctl stop mysql mysqld
yum remove MariaDB-server MariaDB-client
then follow the guide
https://www.mysterydata.com/upgrade-mariadb-5-5-to-mariadb-10-2-on-centos-7-vesta-cp/
-
thank you
upgraded without error