Issue error updating to Plesk 18.0.43

[Cristtiah]

getting an error updating my Plesk Linux below. Does anyone knows how to fix this? Thanks I appreciate it

Failed to install {'release': '1centos.7.220316.1402', 'version': '7.4.28', 'arch': 'x86_64', 'name': 'plesk-php74'}:
Error while downloading packages metainfo: failure: repodata/repomd.xml from mariadb: [Errno 256] No more mirrors to try.
http://yum.mariadb.org/10.1/centos7-amd64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found. Trying again.
http://yum.mariadb.org/10.1/centos7-amd64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found

 

[Maarten]

Hi,

MariaDB 10.1 is end of life and no longer supported by Plesk, that's why you get the "Not Found" error:

MariaDB

Check end-of-life, release policy and support schedule for MariaDB.

endoflife.date

https://support.plesk.com/hc/en-us/articles/360013751840-Which-MariaDB-versions-are-supported-by-Plesk-

You need to upgrade to a newer version of MariaDB.

 

[Cristtiah]

I have CentOS 7.9 and MariaDB 10.1.48 how do I upgrade to 10.7(latest)? Thanks

 

[Kaspar]

MariaDB 10.7 isn't supported (yet). But for any other MariaDB you can use: https://support.plesk.com/hc/en-us/...5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux-

 

[Cristtiah]

I just upgraded to MariaDB 10.6 followed the instructions from here https://support.plesk.com/hc/en-us/...-MariaDB-5-5-to-10-0-10-1-10-2-10-3-on-Linux- now I cant start MariDB.

Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details

Pls help cant even access my Plesk Control panel

 

[Cristtiah]

service mysql status

Redirecting to /bin/systemctl status mysql.service

● mariadb.service - MariaDB 10.6.7 database server

Loaded: loaded (/usr/lib/systemd/system/./mariadb.service; disabled; vendor preset: disabled)

Drop-In: /etc/systemd/system/mariadb.service.d

└─migrated-from-my.cnf-settings.conf

Active: failed (Result: exit-code) since Tue 2022-04-19 06:08:05 EDT; 4s ago

Docs: man:mariadbd(8)

systemd

Process: 32239 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)

Process: 32207 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)

Process: 32204 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)

Main PID: 32239 (code=exited, status=1/FAILURE)

Status: "MariaDB server is down"



Apr 19 06:08:05 cp.aggelous.net mariadbd[32239]: 2022-04-19 6:08:05 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

Apr 19 06:08:05 cp.aggelous.net mariadbd[32239]: 2022-04-19 6:08:05 0 [Note] Plugin 'FEEDBACK' is disabled.

Apr 19 06:08:05 cp.aggelous.net mariadbd[32239]: 2022-04-19 6:08:05 0 [Note] Server socket created on IP: '127.0.0.1'.

Apr 19 06:08:05 cp.aggelous.net mariadbd[32239]: 2022-04-19 6:08:05 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 22: Invalid argument

Apr 19 06:08:05 cp.aggelous.net mariadbd[32239]: 2022-04-19 6:08:05 0 [ERROR] Do you already have another server running on port: 3306 ?

Apr 19 06:08:05 cp.aggelous.net mariadbd[32239]: 2022-04-19 6:08:05 0 [ERROR] Aborting

Apr 19 06:08:05 cp.aggelous.net systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE

Apr 19 06:08:05 cp.aggelous.net systemd[1]: Failed to start MariaDB 10.6.7 database server.

Apr 19 06:08:05 cp.aggelous.net systemd[1]: Unit mariadb.service entered failed state.

Apr 19 06:08:05 cp.aggelous.net systemd[1]: mariadb.service failed.

 

[Maarten]

Is there an other process using port 3306?

# lsof -i TCP:3306

 

[Cristtiah]

none

 

[mizar]

Hello,

MariaDB since 10.6 doesn't allows to bind both ::1 and 127.0.0.1 by setting bind-address = ::ffff:127.0.0.1 in my.cnf. If your upgrade from previous version, you should replace bind-address to 127.0.0.1, otherwise MariaDB won't start (or plesk sbin mysqlmng --bind-address local do it for you)