• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Resolved Update MariaDB from 10.6 to 10.7 on Ubuntu 20.04.5 | Plesk show 10.6 after install

H

heydemar

Basic Pleskian
Hi,

i have a question.
On my Plesk Demo Instanz (Plesk Obsidian Version 18.0.48) i want to Update my MariaDB vom 10.6 to 10.7

root@vps4:~# apt-get install mariadb-server-10.7
Reading package lists... Done
Building dependency tree
Reading state information... Done
mariadb-server-10.7 is already the newest version (1:10.7.7+maria~ubu2004).
0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.

But in my Plesk Panel I see this Version:
1669647390656.png

Thank you!!!!

PS: Sorry Admin can you move ist to Plesk Obsidian?
Thanks!
 
MariaDB 10.6 is also the LTS version (Long Term Support):
endoflife.date

MariaDB

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

Screenshot 2022-11-28 at 20.28.19.png
 
I don't understand a bit - first I updated the database from version 10.3 to 10.5. Everything worked fine. Now I've tried to upgrade to version 10.6 and I can no longer run this version. When upgrading, do I have to leave the basic version 10.3 on the server?

root@ns3125328:~# apt-get install mariadb-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libpmem1 mariadb-client-10.6 mariadb-client-core-10.6 mariadb-common mariadb-server-10.6 mariadb-server-core-10.6
Suggested packages:
mariadb-test netcat-openbsd
The following packages will be REMOVED:
mariadb-client-10.5 mariadb-client-core-10.5 mariadb-server-10.5 mariadb-server-core-10.5
The following NEW packages will be installed:
libpmem1 mariadb-client-10.6 mariadb-client-core-10.6 mariadb-server-10.6 mariadb-server-core-10.6
The following packages will be upgraded:
mariadb-common mariadb-server
2 upgraded, 5 newly installed, 4 to remove and 3 not upgraded.
Need to get 13.9 MB of archives.
After this operation, 1,987 kB of additional disk space will be used.
Do you want to continue? [Y/n] Y
Get:1 Index of /debian buster/main amd64 libpmem1 amd64 1.5.1-1 [56.5 kB]
Get:2 Index of /pub/unix/database/mariadb/repo/10.6/debian buster/main amd64 mariadb-common all 1:10.6.11+maria~deb10 [4,048 B]
Get:3 Index of /pub/unix/database/mariadb/repo/10.6/debian buster/main amd64 mariadb-server all 1:10.6.11+maria~deb10 [2,832 B]
Get:4 Index of /pub/unix/database/mariadb/repo/10.6/debian buster/main amd64 mariadb-server-10.6 amd64 1:10.6.11+maria~deb10 [3,446 kB]
Get:5 Index of /pub/unix/database/mariadb/repo/10.6/debian buster/main amd64 mariadb-client-core-10.6 amd64 1:10.6.11+maria~deb10 [831 kB]
Get:6 Index of /pub/unix/database/mariadb/repo/10.6/debian buster/main amd64 mariadb-client-10.6 amd64 1:10.6.11+maria~deb10 [2,407 kB]
Get:7 Index of /pub/unix/database/mariadb/repo/10.6/debian buster/main amd64 mariadb-server-core-10.6 amd64 1:10.6.11+maria~deb10 [7,147 kB]
Fetched 13.9 MB in 1s (14.0 MB/s)
Preconfiguring packages ...
(Reading database ... 81992 files and directories currently installed.)
Preparing to unpack .../mariadb-common_1%3a10.6.11+maria~deb10_all.deb ...
Unpacking mariadb-common (1:10.6.11+maria~deb10) over (1:10.5.18+maria~deb10) ...
Preparing to unpack .../mariadb-server_1%3a10.6.11+maria~deb10_all.deb ...
Unpacking mariadb-server (1:10.6.11+maria~deb10) over (1:10.5.18+maria~deb10) ...
dpkg: mariadb-server-10.5: dependency problems, but removing anyway as you requested:
plesk-mysql-server depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mariadb-server-10.5 which provides virtual-mysql-server is to be removed.
Package mariadb-server-10.3 which provides virtual-mysql-server is not installed.
Package mysql-server is not installed.
plesk-mysql-server depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mariadb-server-10.5 which provides virtual-mysql-server is to be removed.
Package mariadb-server-10.3 which provides virtual-mysql-server is not installed.
Package mysql-server is not installed.
plesk-mysql-server depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mariadb-server-10.5 which provides virtual-mysql-server is to be removed.
Package mariadb-server-10.3 which provides virtual-mysql-server is not installed.
Package mysql-server is not installed.
plesk-mysql-server depends on virtual-mysql-server | mysql-server; however:
Package virtual-mysql-server is not installed.
Package mariadb-server-10.5 which provides virtual-mysql-server is to be removed.
Package mariadb-server-10.3 which provides virtual-mysql-server is not installed.
Package mysql-server is not installed.

(Reading database ... 81991 files and directories currently installed.)
Removing mariadb-server-10.5 (1:10.5.18+maria~deb10) ...
Setting up mariadb-common (1:10.6.11+maria~deb10) ...
update-alternatives: warning: forcing reinstallation of alternative /etc/mysql/mariadb.cnf because link group my.cnf is broken
update-alternatives: warning: not replacing /etc/mysql/my.cnf with a link
Selecting previously unselected package mariadb-server-10.6.
(Reading database ... 81866 files and directories currently installed.)
Preparing to unpack .../mariadb-server-10.6_1%3a10.6.11+maria~deb10_amd64.deb ...
/var/lib/mysql: found previous version 10.5
Unpacking mariadb-server-10.6 (1:10.6.11+maria~deb10) ...
(Reading database ... 81969 files and directories currently installed.)
Removing mariadb-client-10.5 (1:10.5.18+maria~deb10) ...
Removing mariadb-client-core-10.5 (1:10.5.18+maria~deb10) ...
Removing mariadb-server-core-10.5 (1:10.5.18+maria~deb10) ...
Selecting previously unselected package mariadb-client-core-10.6.
(Reading database ... 81781 files and directories currently installed.)
Preparing to unpack .../mariadb-client-core-10.6_1%3a10.6.11+maria~deb10_amd64.deb ...
Unpacking mariadb-client-core-10.6 (1:10.6.11+maria~deb10) ...
Selecting previously unselected package mariadb-client-10.6.
Preparing to unpack .../mariadb-client-10.6_1%3a10.6.11+maria~deb10_amd64.deb ...
Unpacking mariadb-client-10.6 (1:10.6.11+maria~deb10) ...
Selecting previously unselected package libpmem1.
Preparing to unpack .../libpmem1_1.5.1-1_amd64.deb ...
Unpacking libpmem1 (1.5.1-1) ...
Selecting previously unselected package mariadb-server-core-10.6.
Preparing to unpack .../mariadb-server-core-10.6_1%3a10.6.11+maria~deb10_amd64.deb ...
Unpacking mariadb-server-core-10.6 (1:10.6.11+maria~deb10) ...
Setting up mariadb-client-core-10.6 (1:10.6.11+maria~deb10) ...
Setting up libpmem1 (1.5.1-1) ...
Setting up mariadb-client-10.6 (1:10.6.11+maria~deb10) ...
Setting up mariadb-server-core-10.6 (1:10.6.11+maria~deb10) ...
Setting up mariadb-server-10.6 (1:10.6.11+maria~deb10) ...
Installing new version of config file /etc/init.d/mariadb ...
Installing new version of config file /etc/mysql/mariadb.conf.d/50-server.cnf ...
mariadb-extra.socket is a disabled or a static unit, not starting it.
mariadb-extra.socket is a disabled or a static unit, not starting it.
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
Setting up mariadb-server (1:10.6.11+maria~deb10) ...
Processing triggers for systemd (241-7~deb10u8) ...
Processing triggers for libc-bin (2.28-10+deb10u2) ...
root@ns3125328:~# systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.
Click to expand...
 
mariadb.service - MariaDB 10.6.11 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Mon 2022-12-05 23:34:04 UTC; 19min ago
Docs: man:mariadbd(8)
systemd
Process: 17890 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 17891 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 17893 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $?
Process: 17928 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 17928 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [Note] Plugin 'FEEDBACK' is disabled.
Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [Warning] You need to use --log-bin to make --expire-logs-days or --binlog-e
Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [Note] Server socket created on IP: '127.0.0.1'.
Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 22: Invalid argu
Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [ERROR] Do you already have another server running on port: 3306 ?
Dec 05 23:34:03 ns3125328 mariadbd[17928]: 2022-12-05 23:34:03 0 [ERROR] Aborting
Dec 05 23:34:04 ns3125328 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 05 23:34:04 ns3125328 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Dec 05 23:34:04 ns3125328 systemd[1]: Failed to start MariaDB 10.6.11 database server.
Click to expand...

Dec 05 23:54:45 ns3125328 sshd[18049]: Failed password for root from 1.235.216.34 port 48946 ssh2
Dec 05 23:54:48 ns3125328 sshd[18049]: Received disconnect from 1.235.216.34 port 48946:11: Bye Bye [preauth]
Dec 05 23:54:48 ns3125328 sshd[18049]: Disconnected from authenticating user root 1.235.216.34 port 48946 [preauth]
Dec 05 23:55:47 ns3125328 sshd[18053]: Invalid user ws from 211.221.173.228 port 55014
Dec 05 23:55:47 ns3125328 sshd[18053]: pam_unix(sshd:auth): check pass; user unknown
Dec 05 23:55:47 ns3125328 sshd[18053]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=211.221.173.22
Dec 05 23:55:47 ns3125328 sshd[18053]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/run/mysq
Dec 05 23:55:49 ns3125328 sshd[18053]: Failed password for invalid user ws from 211.221.173.228 port 55014 ssh2
Dec 05 23:55:50 ns3125328 sshd[18053]: Received disconnect from 211.221.173.228 port 55014:11: Bye Bye [preauth]
Dec 05 23:55:50 ns3125328 sshd[18053]: Disconnected from invalid user ws 211.221.173.228 port 55014 [preauth]
Click to expand...
 
What does the bind-address look like in my.cnf?

For MariaDB 10.6 it should be:
bind-address = ::
or
bind-address = 127.0.0.1
 
[client-server]

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
[mysqld]
sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
bind-address = ::ffff:127.0.0.1
local-infile=0
Click to expand...

I install everything from scratch.
I installed a ready-made installation of Debian + Plesk before.
I will try to install a clean version of Debian and finally manually install Plesk. Just wondering which version is better 10 or 11?
 
I managed to run 10.6. I can log in to Mysql, but only as root. When I try to run Plesk, I get a message
ERROR 1698 (28000): Access denied for user 'admin'@'localhost'
 
You must log in or register to reply here.

Similar threads

T
Question update MariaDB from 10.3.35 to 10.6 or 10.10 or 10.11
Replies
7
Views
5K
Peter Debik
P
Kulturmensch
Resolved Best procedure to update MariaDB 10.6 to 10.11
Replies
6
Views
6K
Peter Debik
P
S
Issue Getting 404 Not Found NGINX error, not able to access plesk and website went down after update
Replies
2
Views
805
Dave W
Dave W
F
Question Mariadb down after update Plesk /var 100% full
Replies
8
Views
315
flieg4bei
F
I
Issue maria DB update plesk 18.0.50
Replies
10
Views
3K
Maarten.
M
Back
Top