Control Web Panel
WebPanel => Updates => Topic started by: BBS on September 02, 2020, 01:34:05 AM
-
Hello, when i go to /admin/index.php?Module=yum_manager the MariaDB-server and phpMyAdmin don't update automatically
Hire the log:
$ yum update -y
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
2/9/2020 Web Console
https://backend..../admin/console.php 4/36
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-server.x86_64 0:10.1.45-1.el7.centos will be updated
---> Package MariaDB-server.x86_64 0:10.2.33-1.el7.centos will be an update
--> Processing Dependency: galera for package: MariaDB-server-10.2.33-1.el7.centos.x86_64
--> Running transaction check
---> Package galera.x86_64 0:25.3.29-1.rhel7.el7.centos will be installed
--> Processing Conflict: galera-4-26.4.5-1.el7.centos.x86_64 conflicts galera
Removing galera.x86_64 0:25.3.29-1.rhel7.el7.centos - u due to obsoletes from installed galera-4-26.4.5-1.el7.centos.x8
6_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package galera.x86_64 0:25.3.29-1.rhel7.el7.centos will be installed
--> Processing Dependency: galera for package: MariaDB-server-10.2.33-1.el7.centos.x86_64
--> Running transaction check
---> Package galera.x86_64 0:25.3.28-1.rhel7.el7.centos will be installed
--> Processing Conflict: galera-4-26.4.5-1.el7.centos.x86_64 conflicts galera
Removing galera.x86_64 0:25.3.28-1.rhel7.el7.centos - u due to obsoletes from installed galera-4-26.4.5-1.el7.centos.x8
6_64
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package galera.x86_64 0:25.3.28-1.rhel7.el7.centos will be installed
--> Processing Dependency: galera for package: MariaDB-server-10.2.33-1.el7.centos.x86_64
--> Finished Dependency Resolution
Error: galera-4 conflicts with galera-25.3.28-1.rhel7.el7.centos.x86_64
Error: Package: MariaDB-server-10.2.33-1.el7.centos.x86_64 (mariadb)
Requires: galera
Error: galera-4 conflicts with galera-25.3.29-1.rhel7.el7.centos.x86_64
You could try using --skip-broken to work around the problem
** Found 1 pre-existing rpmdb problem(s), 'yum check' output follows:
MariaDB-server-10.1.45-1.el7.centos.x86_64 has missing requires of galera
.....
I look in forums and hire http://forum.centos-webpanel.com/index.php?topic=9471.msg33152#msg33152 and https://www.mysterydata.com/upgrade-mariadb-5-5-to-mariadb-10-2-on-centos-7-vesta-cp/ to follow the steps, but not work.
......
my phpMyAdmin
Version information: 4.7.9, latest stable version: 4.9.5
Thanks for all.
-
MariaDB-server.x86_64
Package updated successfully.
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-server.x86_64 0:10.1.45-1.el7.centos will be updated
---> Package MariaDB-server.x86_64 0:10.4.14-1.el7.centos will be an update
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Updating:
MariaDB-server x86_64 10.4.14-1.el7.centos mariadb 26 M
Transaction Summary
================================================================================
Upgrade 1 Package
Total download size: 26 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.1.45-1.el7.centos.x86_64) is installed.
Upgrading directly from MySQL 10.1 to MariaDB 10.4 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.4.14-1.el7.centos.x86_64) scriptlet failed, exit status 1
Verifying : MariaDB-server-10.1.45-1.el7.centos.x86_64 1/2
Verifying : MariaDB-server-10.4.14-1.el7.centos.x86_64 2/2
Failed:
MariaDB-server.x86_64 0:10.1.45-1.el7.centos
MariaDB-server.x86_64 0:10.4.14-1.el7.centos
Complete!
-
Response from support
Test what is the cwp PHP version and if it is updated to 7.2
/usr/local/cwp/php71/bin/php -v
PHP 7.2.30
if PHP was not updated to 7.2 then try manually
yum update cwpphp --enablerepo=cwp
Manual update CentOS 7 (ignore if you have CentOS 6)
chattr -i -R /usr/local/cwpsrv/htdocs
cd /usr/local/cwpsrv/htdocs
wget static.cdn-cwp.com/files/cwp/el7/cwp-el7-0.9.8.964.zip
unzip -o -q cwp-el7-0.9.8.964.zip
rm -f cwp-el7-0.9.8.964.zip
Manual update CentOS 6 (ignore if you have CentOS 7)
chattr -i -R /usr/local/cwpsrv/htdocs
cd /usr/local/cwpsrv/htdocs
wget dl1.centos-webpanel.com/files/cwp/cwp2-0.9.8.768.zip
unzip -o cwp2-0.9.8.768.zip
rm -f cwp2-0.9.8.768.zip
Manual update for services (This steep must be done for CentOS 6 and 7)
cd /usr/local/cwpsrv/var/services/
wget static.cdn-cwp.com/files/cwp/el7/cwp-services.zip
unzip -o -q cwp-services.zip
rm -f cwp-services.zip
Test if all is ok, it should run update without errors
sh /scripts/update_cwp
If you get error like:
Cannot load the ionCube PHP Loader - it was built with configuration API320151012,NTS, whereas running engine is API320170718,NTS
then run this:
sed -i "s/ioncube_loader_lin_7.0/ioncube_loader_lin_7.2/g" /usr/local/cwp/php71/php.ini
sh /scripts/restart_cwpsrv
Regards,
-
Hi, @BBS
Make the SQL databases backup, log in to SSH and try next things:
1. Delete MariaDB-server
yum remove MariaDB-server
2. Install the new one
yum -y install MariaDB-server
3. Update your databases:
systemctl restart mariadb
mysql_upgrade
If you unable to start the MariaDB server you will have to talk to a system administrator of your server.
-
Hi, @BBS
Make the SQL databases backup, log in to SSH and try next things:
1. Delete MariaDB-server
yum remove MariaDB-server
2. Install the new one
yum -y install MariaDB-server
3. Update your databases:
systemctl restart mariadb
mysql_upgrade
If you unable to start the MariaDB server you will have to talk to a system administrator of your server.
user@backend. $ yum remove MariaDB-server
Loaded plugins: fastestmirror
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-server.x86_64 0:10.1.45-1.el7.centos will be erased
--> Processing Dependency: mysql-server for package: cluebringer-v2.1.x-201310261831.noarch
--> Processing Dependency: mysql-server for package: cluebringer-v2.1.x-201310261831.noarch
--> Running transaction check
---> Package cluebringer.noarch 0:v2.1.x-201310261831 will be erased
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Removing:
MariaDB-server x86_64 10.1.45-1.el7.centos @mariadb 117 M
Removing for dependencies:
cluebringer noarch v2.1.x-201310261831 installed 906 k
Transaction Summary
================================================================================
Remove 1 Package (+1 Dependent package)
Installed size: 118 M
Is this ok [y/N]: Exiting on user command
Your transaction was saved, rerun it with:
yum load-transaction /tmp/yum_save_tx.2020-09-20.02-30.gaUEYZ.yumtx
user@backend. ~$ yum -y install MariaDB-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: asi-fs-n.contabo.net
Excluding mirror: mirror.fra10.de.leaseweb.net
* extras: centos.schlundtech.de
* updates: asi-fs-n.contabo.net
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-server.x86_64 0:10.1.45-1.el7.centos will be updated
20/9/2020 Web Console
https://backend.:2087/cwp_9eb1aecf6afe32f654562d22ad59170/admin/console.php 2/2
---> Package MariaDB-server.x86_64 0:10.4.14-1.el7.centos will be an update
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository Size
================================================================================
Updating:
MariaDB-server x86_64 10.4.14-1.el7.centos mariadb 26 M
Transaction Summary
================================================================================
Upgrade 1 Package
Total download size: 26 M
Downloading packages:
No Presto metadata available for mariadb
http://yum.mariadb.org/10.2.33/centos7-amd64/rpms/MariaDB-server-10.4.14-1.el7.centos.x86_64.rpm
: [Errno 14] HTTP Error 404 - Not Found
Trying other mirror.
To address this issue please refer to the below wiki article
https://wiki.centos.org/yum-errors
If above article doesn't help to resolve this issue please use https://bugs.centos.org/.
Error downloading packages:
MariaDB-server-10.4.14-1.el7.centos.x86_64: [Errno 256] No more mirrors to try.
user@backend ~$ systemctl restart mariadb
user@backend. ~$ mysql_upgrade
Warning: mysql_upgrade: unknown variable 'loose-local-infile=1'
mysql_upgrade: unknown variable 'local-infile=0'
user@backend. ~$
-
I've use this guide to upgrade from the stock 10.1 to 10.4 without problems on CWP CentOS 7 servers.
https://www.mysterydata.com/update-upgrade-to-mariadb-10-4-on-vestacp-cwp-centos-7/
I'm not sure how it will work, since you've already tried to upgrade though.
-
@BBS, it seems like you have no ideas what exactly command I've sent do. You must not try to install/delete anything yourself, just ask a competent sysadmin or use the CWP support service.
You can try to change the MariaDB repo and then install it. But I would suggest to ask a sysadmin ;)
-
updated and released