Author Topic: Update MariaDB-server and phpMyAdmin  (Read 30438 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Update MariaDB-server and phpMyAdmin
« 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.

Offline
*
Re: Update MariaDB-server and phpMyAdmin
« Reply #1 on: September 02, 2020, 09:58:54 PM »
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!

Offline
*
Re: Update MariaDB-server and phpMyAdmin
« Reply #2 on: September 02, 2020, 10:00:10 PM »
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,

Offline
*****
Re: Update MariaDB-server and phpMyAdmin
« Reply #3 on: September 11, 2020, 10:16:28 AM »
Hi, @BBS
Make the SQL databases backup, log in to SSH and try next things:
1. Delete MariaDB-server
Code: [Select]
yum remove MariaDB-server2. Install the new one
Code: [Select]
yum -y install MariaDB-server3. Update your databases:
Code: [Select]
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.
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: Update MariaDB-server and phpMyAdmin
« Reply #4 on: September 20, 2020, 12:37:37 AM »
Hi, @BBS
Make the SQL databases backup, log in to SSH and try next things:
1. Delete MariaDB-server
Code: [Select]
yum remove MariaDB-server2. Install the new one
Code: [Select]
yum -y install MariaDB-server3. Update your databases:
Code: [Select]
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.

Code: [Select]
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. ~$

Offline
*****
Re: Update MariaDB-server and phpMyAdmin
« Reply #5 on: September 20, 2020, 10:44:38 PM »
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.
« Last Edit: September 20, 2020, 10:48:18 PM by Starburst »

Offline
*****
Re: Update MariaDB-server and phpMyAdmin
« Reply #6 on: September 21, 2020, 01:02:42 PM »
@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 ;)
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*****
Re: Update MariaDB-server and phpMyAdmin
« Reply #7 on: January 16, 2021, 02:26:43 PM »
updated and released